public void storeTask_ReadData(object sender, StoreReadDataEventArgs e)
{
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone);
//tD.DetailID,tD.DetailType,tD.UserID,tD.InsertDate,tD.Description.As("Comment"),tD.StartTime,tD.StopTime,u.Username);
//t.RightJoin(tD).On(t.TaskID == tD.TaskID);
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
{
t.Where(t.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID | t.RequesterPhone == AppSession.ServiceUnit.UserServiceUnitID);
}
if (!X.IsAjaxRequest)
{
t.Where(t.Status == "New");
}
}
//t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.es.Distinct = true;
//t.OrderBy(t.TaskID.Ascending);
DataTable dTask = t.LoadDataTable();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
public void btnSave_Click()
{
if (string.IsNullOrEmpty(txtTitle.Text) && string.IsNullOrEmpty(txtDesc.Text) && string.IsNullOrEmpty(cmbServiceUnit.SelectedItem.Value))
{
return;
}
ADefHelpDeskTasks t = new ADefHelpDeskTasks();
ADefHelpDeskTasksQuery tQ = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTasksCollection tC = new ADefHelpDeskTasksCollection();
ADefHelpDeskTaskDetails tD = new ADefHelpDeskTaskDetails();
t.PortalID = 0;
t.Description = txtTitle.Text;
t.Status = "New";
t.Priority = "High";
t.CreatedDate = DateTime.Now;
t.EstimatedStart = DateTime.Now;
t.EstimatedCompletion = DateTime.Now.AddDays(7);
t.DueDate = DateTime.Now.AddDays(14);
t.AssignedRoleID = 1;
//Password Ticket
string tikPass = Guid.NewGuid().ToString();
t.TicketPassword = tikPass;
t.RequesterEmail = AppSession.ServiceUnit.UserServiceUnitID; //RequesterEmail = the requestor service unit
t.RequesterPhone = cmbServiceUnit.SelectedItem.Value; //RequesterPhone = the service unit which take charge of the request
//Get username ID
ADefHelpDeskUsersQuery uq = new ADefHelpDeskUsersQuery("a");
ADefHelpDeskUsersCollection uc = new ADefHelpDeskUsersCollection();
uq.SelectAll().Where(uq.Username == HttpContext.Current.User.Identity.Name.ToString().Trim());
uq.es.Top = 1;
uc.Load(uq);
if (uc.Count > 0)
{
foreach (ADefHelpDeskUsers u in uc)
{
t.RequesterUserID = u.UserID;
t.RequesterName = u.FirstName;
}
}
t.Save();
tQ.SelectAll().Where(tQ.TicketPassword == tikPass);
tQ.es.Top = 1;
tC.Load(tQ);
if (tC.Count > 0)
{
foreach (ADefHelpDeskTasks tt in tC)
{
tD.TaskID = tt.TaskID;
tD.DetailType = "Details";
tD.InsertDate = tt.CreatedDate;
tD.Description = txtDesc.Text;
tD.UserID = tt.RequesterUserID;
tD.Save();
}
}
MessageBus.Default.Publish("grdTask_Refresh");
//X.Js.Call("onWinClose");
}
public void btnSearch_Click()
{
if (string.IsNullOrEmpty(cmbStatus.SelectedItem.Value))
{
return;
}
if (AppSession.ServiceUnit.UserServiceUnitID == null)
{
return;
}
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
//RequesterEmail == Requestor Service Unit
//RequesterPhone == Destination Service Unit
//t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, u.Username);
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone);
//t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%") && (t.RequesterEmail == Session["ServiceUnit"].ToString() || t.RequesterPhone == Session["ServiceUnit"].ToString()));
//t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%"));
if (!string.IsNullOrEmpty(txtSearch.Text.Trim()))
{
t.Where(t.Description.Like("%" + txtSearch.Text + "%"));
}
//|| t.Description.Like("%" + txtSearch.Text + "%") || (t.RequesterEmail == Session["ServiceUnit"].ToString() | t.RequesterPhone == Session["ServiceUnit"].ToString()));
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
{
t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%") && t.Description.Like("%" + txtSearch.Text + "%") && (t.RequesterEmail == Session["ServiceUnitID"].ToString() | t.RequesterPhone == AppSession.ServiceUnit.UserServiceUnitID));
}
else
{
t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%"));
}
}
else
{
Session.Abandon();
Session.RemoveAll();
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
}
//t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.es.Distinct = true;
DataTable dTask = t.LoadDataTable();
this.grdTask.Store.Primary.DataSource = dTask;
this.grdTask.Store.Primary.DataBind();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string username = HttpContext.Current.User.Identity.Name;
ADefHelpDeskUsersQuery uu = new ADefHelpDeskUsersQuery();
ADefHelpDeskUsersCollection uuC = new ADefHelpDeskUsersCollection();
uu.SelectAll().Where(uu.Username == username);
uu.es.Top = 1;
uuC.Load(uu);
//foreach (ADefHelpDeskUsers uuu in uuC)
//{
// Session["UserID"] = uuu.UserID;
// Session["ServiceUnitID"] = string.Empty;
// ADefHelpDeskUserUserGroupQuery ug = new ADefHelpDeskUserUserGroupQuery("a");
// ADefHelpDeskUserUserGroupCollection ugC = new ADefHelpDeskUserUserGroupCollection();
// ug.SelectAll().Where(ug.UserID == username);
// ug.es.Top = 1;
// ugC.Load(ug);
// if (ugC.Count > 0)
// {
// foreach (ADefHelpDeskUserUserGroup uug in ugC)
// {
// Session["ServiceUnitID"] = uug.UserServiceUnitID;
// }
// }
//}
if (!X.IsAjaxRequest)
{
this.storeStatus.DataSource = new object[]
{
new object[] { "New", "New" },
new object[] { "Resolved", "Resolved" },
new object[] { "Cancelled", "Cancelled" },
new object[] { "On Hold", "On Hold" }
};
this.storeStatus.DataBind();
this.cmbStatus.SetRawValue("New");
StoreReadDataEventArgs ee = new StoreReadDataEventArgs();
storeTask_ReadData(sender, ee);
storeNeedApproval_ReadData(sender, ee);
}
}
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();
}
}
}
}
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();
}
