PCar Stuff......................!

SPSite site = new SPSite(SiteURL);

SPWeb web = site.OpenWeb();
web.AllowUnsafeUpdates = true;

SPList poolCarRequest = web.Lists["Pool Car Request"];

SPQuery query = new SPQuery();

//This below Query will return will return todays previous reuquested car.
query.Query = "" + date.Year + "-" + date.Month + "-" + date.Day + "";

//st.WriteLine("1 "+lip["Pool Car Name"].ToString());
SPListItemCollection lic = poolCarRequest.GetItems(query);

if (lic.Count == 0)
{
return true;
}
else if (lic[0]["Car Name"].ToString() == "Pool Car 1")
{
return false;
}
else
{
return true;
}

--------------------------------------------------------------------------------

public DataSet GetDriverDetails(string carName)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
DataColumn dc = new DataColumn("Driver Name");
dt.Columns.Add(dc);
dc = new DataColumn("Driver Mobile No");
dt.Columns.Add(dc);
dc = new DataColumn("Vehicle No");
dt.Columns.Add(dc);
if (carName != null && carName != "")
{

SPSecurity.RunWithElevatedPrivileges(delegate()
{
SPSite site = new SPSite(SiteURL);
SPWeb web = site.OpenWeb();

web.AllowUnsafeUpdates = true;

SPList poolCar = web.Lists["Pool Cars"];

SPQuery query = new SPQuery();
query.Query = "" + carName + "";

//st.WriteLine("1 "+lip["Pool Car Name"].ToString());
SPListItemCollection lic = poolCar.GetItems(query);
if (lic.Count != 0)
{
dr = dt.NewRow();
dr["Driver Name"] = lic[0]["Driver Name"].ToString();
dr["Driver Mobile No"] = lic[0]["Driver Mobile No"].ToString();
dr["Vehicle No"] = lic[0]["Vehicle No"].ToString();
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr["Driver Name"] = "";
dr["Driver Mobile No"] = "";
dr["Vehicle No"] = "";
dt.Rows.Add(dr);
}
});
}
else
{
dr = dt.NewRow();
dr["Driver Name"] = "";
dr["Driver Mobile No"] = "";
dr["Vehicle No"] = "";
dt.Rows.Add(dr);
}
ds.Tables.Add(dt);
return ds;
}


--------------------------------------------------


SPSite site = new SPSite(SiteURL);

SPWeb web = site.OpenWeb();

SPList liApprovers = web.Lists["Admin Approvers"];
SPQuery query = new SPQuery();
query.Query = "Pool Car Request Approver";
SPListItemCollection lic = liApprovers.GetItems(query);

Name = lic[0]["Approver"].ToString().Substring(lic[0]["Approver"].ToString().IndexOf("#") + 1);

-------------------------------------------------------------------------------------