protected bool UserLogin(string userName, string password)
{
_user.es.Connection.Name = "KENCANA";
//_user.es.Connection.Name = "LOCAL_HIS";
if (_user.LoadByPrimaryKey(userName))
{
if (_user.Password.Equals(Crypto.Encrypt(password)))
{
ADefHelpDeskUsersQuery q = new ADefHelpDeskUsersQuery();
q.SelectAll().Where(q.Username == userName);
ADefHelpDeskUsersCollection c = new ADefHelpDeskUsersCollection();
c.Load(q);
ADefHelpDeskUsers a = new ADefHelpDeskUsers();
if (c.Count == 0)
{
a.Username = userName;
a.Password = _user.Password;
a.FirstName = _user.UserName;
a.LastName = ".";
a.IsSuperUser = false;
a.Email = userName + "@rscmkencana.com";
a.Save();
ADefHelpDeskUsersQuery aa = new ADefHelpDeskUsersQuery();
ADefHelpDeskUsersCollection ac = new ADefHelpDeskUsersCollection();
aa.SelectAll().Where(aa.Username == userName);
ac.Load(aa);
foreach (ADefHelpDeskUsers U in ac)
{
ADefHelpDeskUsers _u = new ADefHelpDeskUsers();
_u.UserID = (int)U.UserID;
_u.Username = userName;
_u.FirstName = _user.UserName;
AppSession.UserLogin = _u;
}
}
if (c.Count == 1)
{
foreach (ADefHelpDeskUsers U in c)
{
if (a.LoadByPrimaryKey((int)U.UserID))
{
ADefHelpDeskUsers _u = new ADefHelpDeskUsers();
_u.UserID = (int)U.UserID;
_u.Username = userName;
_u.FirstName = _user.UserName;
AppSession.UserLogin = _u;
a.Username = userName;
a.Password = _user.Password;
a.FirstName = _user.UserName;
a.LastName = ".";
a.IsSuperUser = false;
a.Email = userName + "@rscmkencana.com";
a.Save();
}
}
}
//Get user service unit
ADefHelpDeskUserUserGroupQuery ugQ = new ADefHelpDeskUserUserGroupQuery("a");
ADefHelpDeskUserUserGroupCollection ugC = new ADefHelpDeskUserUserGroupCollection();
ugQ.SelectAll().Where(ugQ.UserID == userName).es.Top = 1;
ugC.Load(ugQ);
if (ugC.Count == 1)
{
foreach (ADefHelpDeskUserUserGroup ug in ugC)
{
Session["ServiceUnitID"] = ug.UserServiceUnitID;
AppSession.ServiceUnit = ug;
}
}
else
{
X.Msg.Notify("Error", "This user has not been registered to any service unit").Show();
return(false);
}
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public void grdServiceUnit_Select()
{
string ServiceUnitID = string.Empty;
RowSelectionModel rmSU = this.grdServiceUnit.GetSelectionModel() as RowSelectionModel;
if (rmSU.SelectedRows.Count > 0)
{
ServiceUnitID = rmSU.SelectedRow.RecordID;
Session["ServiceUnitID"] = ServiceUnitID;
}
MessageBus.Default.Publish("grdServiceUnit_Select", ServiceUnitID);
//Select all user that still unassigned
ADefHelpDeskUserUserGroupQuery userGroupC = new ADefHelpDeskUserUserGroupQuery("ug");
ADefHelpDeskUserRolesCollection userGroupCol = new ADefHelpDeskUserRolesCollection();
userGroupC.Select(userGroupC.UserID);
//userGroupC.Where(userGroupC.UserServiceUnitID == Session["ServiceUnitID"].ToString().Trim());
ADefHelpDeskUsersQuery userQ = new ADefHelpDeskUsersQuery("u");
ADefHelpDeskUsersCollection userC = new ADefHelpDeskUsersCollection();
userQ.Select(userQ.Username.As("UserID"), userQ.FirstName.As("UserName")).Where(userQ.Username.NotIn(userGroupC)).OrderBy(userQ.FirstName.Ascending);
DataTable dtU = new DataTable();
dtU = userQ.LoadDataTable();
string UserID = string.Empty;
foreach (DataRow dr in dtU.Rows)
{
UserID = dr["UserID"].ToString();
ADefHelpDeskUserUserGroupQuery uQ = new ADefHelpDeskUserUserGroupQuery("a");
ADefHelpDeskUserUserGroupCollection uC = new ADefHelpDeskUserUserGroupCollection();
uQ.SelectAll().Where(uQ.UserID == UserID);
uC.Load(uQ);
if (uC.Count > 0)
{
dr.Delete();
}
}
dtU.AcceptChanges();
storeUser.DataSource = dtU;
storeUser.DataBind();
//Select all user that belong to selected service unit
ADefHelpDeskUsersQuery user = new ADefHelpDeskUsersQuery("uu");
ADefHelpDeskUserUserGroupQuery usergroup = new ADefHelpDeskUserUserGroupQuery("uugg");
usergroup.Select(usergroup.UserID, usergroup.UserServiceUnitID, user.FirstName.As("UserName"))
.Where(usergroup.UserServiceUnitID == ServiceUnitID)
.InnerJoin(user).On(usergroup.UserID == user.Username);
//ADefHelpDeskUserUserGroupCollection userSelectedSU = new ADefHelpDeskUserUserGroupCollection();
//userSelectedSU.Query.SelectAll().Where(userSelectedSU.Query.UserServiceUnitID == ServiceUnitID);
//DataTable dtUSU = userSelectedSU.Query.LoadDataTable();
DataTable dtUSU = usergroup.LoadDataTable();
//foreach (DataRow dr in dtUSU.Rows)
//{
//}
storeUserOfServiceUnit.DataSource = dtUSU;
storeUserOfServiceUnit.DataBind();
}