Saturday, July 24, 2010

User Ctrl PPL Picker....!

selectionset="User" showcreatebuttoninactivedirectoryaccountcreationmode="false"
showentitydisplaytextintextbox="true" validatorenabled="true">




protected void AddUserBtn_Click(object sender, EventArgs e)
{
try
{
if (userPPE.ResolvedEntities.Count > 0)
{
PickerEntity tempEntity = ((PickerEntity)userPPE.ResolvedEntities[0]);
string userID = tempEntity.Key;
string userEmailID = string.Empty;
string userName = string.Empty;

if (tempEntity.EntityData["Email"] != null)
{
userEmailID = tempEntity.EntityData["Email"].ToString();
}

if (tempEntity.EntityData["Name"] != null)
{
userName = tempEntity.EntityData["Name"].ToString();
}

SPSecurity.RunWithElevatedPrivileges(delegate()
{
SPWeb web = SPContext.Current.Web;
web.Groups["UsersGroup"].AddUser(userID, userEmailID, userName, "");
msgLbl.Text = "User added successfully to the UsersGroups....";
});
}
}
catch (Exception ex)
{
msgLbl.Text = ExceptionMsg;
LogException.WriteToFile(System.DateTime.Now.ToString() + ex.Message + ex.Source.ToString() + ex.StackTrace.ToString());
}
}
------------------------------------------------------

Fill Users Group in DropDown


SPUserCollection grpMgrUsers = hulWeb.Groups["AO"].Users;
if (grpMgrUsers != null)
{
if (grpMgrUsers.Count > 0)
{
foreach (SPUser usr in grpMgrUsers)
{
if (string.Compare(usr.Name, "System Account", true) != 0)
{
basisProjMgrDDL.Items.Add(new ListItem(usr.Name, usr.LoginName));
}
}
}
-----------------------------------------------------

Redirect URL (Cancel)


public string RedirectURL()
{
if (Context.Request.QueryString["Source"] != "")
{
return Context.Request.QueryString["Source"];
}
return "/";
}

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








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

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);

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