public void grdTask_Select()
{
int taskID = 0;
RowSelectionModel rm = this.grdTask.GetSelectionModel() as RowSelectionModel;
if (rm.SelectedRows.Count > 0)
{
if (!int.TryParse(rm.SelectedRow.RecordID, out taskID))
{
taskID = 0;
}
if (taskID <= 0)
{
return;
}
Session["TaskID"] = taskID;
ADefHelpDeskTasks t = new ADefHelpDeskTasks();
if (t.LoadByPrimaryKey(taskID))
{
ADefHelpDeskTaskDetailsQuery tQ = new ADefHelpDeskTaskDetailsQuery("a");
ADefHelpDeskTaskDetailsCollection tC = new ADefHelpDeskTaskDetailsCollection();
tQ.SelectAll().Where(tQ.TaskID == taskID);
tC.Load(tQ);
if (tC.Count > 0)
{
string detail = string.Empty;
foreach (ADefHelpDeskTaskDetails tD in tC)
{
ADefHelpDeskUsers u = new ADefHelpDeskUsers();
detail += tD.Description;
if (u.LoadByPrimaryKey((int)tD.UserID))
{
detail += "<br><br><b>User : </b>" + u.FirstName;
//detail += "<b>User : </b>" + u.FirstName + ", <b>Insert Date : </b>" + tD.InsertDate.ToString();
//detail += "<br><br><br>";
}
detail += ", <b>Insert Date : </b>" + tD.InsertDate.ToString() + "<br>---------------------------------------------------------<br>";
lblHtml.Html = detail;
}
}
else
{
lblHtml.Html = string.Empty;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["ServiceUnitID"] == null)
{
return;
}
}
AppUserCollection userColl = new AppUserCollection();
userColl.es.Connection.Name = "KENCANA";
AppUserQuery userQ = new AppUserQuery("a");
userQ.es2.Connection.Name = "KENCANA";
userQ.SelectAll();
userColl.Load(userQ);
if (userColl.Count >= 1)
{
foreach (AppUser au in userColl)
{
ADefHelpDeskUsersQuery hlpUserQ = new ADefHelpDeskUsersQuery("uQ");
hlpUserQ.es2.Connection.Name = "HELPDESK";
hlpUserQ.SelectAll().Where(hlpUserQ.Username == au.UserID);
DataTable dtU = hlpUserQ.LoadDataTable();
if (dtU.Rows.Count == 0)
{
ADefHelpDeskUsers hlpUser = new ADefHelpDeskUsers();
hlpUser.es.Connection.Name = "HELPDESK";
hlpUser.Username = au.UserID;
hlpUser.FirstName = au.UserName;
hlpUser.LastName = ".";
hlpUser.IsSuperUser = false;
hlpUser.Email = au.UserID + "@rscmkencana.com";
hlpUser.Password = au.Password;
hlpUser.Save();
}
}
}
}
public void btnComment_Click()
{
if (string.IsNullOrEmpty(txtComment.Text.Trim()))
{
X.Msg.Notify("Empty comment disallowed", "Comment must not empty").Show();
return;
}
if (Session["TaskID"] == null)
{
X.Msg.Notify("Select at least one task", "You must select a task above first").Show();
return;
}
if (AppSession.UserLogin == null)
{
X.Msg.Notify("Session timeout", "Your Session has expired, Please do some re-login first").Show();
Session.Abandon();
Session.RemoveAll();
FormsAuthentication.SignOut();
return;
}
ADefHelpDeskUsers u = (ADefHelpDeskUsers)AppSession.UserLogin;
int UserID = (int)u.UserID;
int TaskID = (int)Session["TaskID"];
//int UserID = (int)Session["UserID"];
ADefHelpDeskTaskDetails td = new ADefHelpDeskTaskDetails();
td.TaskID = TaskID;
td.DetailType = "Comment-Visible";
td.InsertDate = DateTime.Now;
//td.UserID = (int)Session["UserID"];
td.UserID = (int)u.UserID;
td.Description = txtComment.Text.Trim();
td.Save();
X.Msg.Notify("Excelent. You, as the RSCM Kencana best employee", "Just made the greatest and the wisest comment in the human history").Show();
txtComment.Text = string.Empty;
grdTask_Select();
}
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);
}
}