public void cmbStatus_Change()
{
X.Msg.Alert("Info", cmbStatus.SelectedItem.Value).Show();
if (cmbStatus.SelectedItems.Count <= 0)
{
return;
}
if (string.IsNullOrEmpty(cmbStatus.SelectedItem.Value))
{
return;
}
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
t.InnerJoin(tD).On(t.TaskID == tD.TaskID);
t.InnerJoin(u).On(t.RequesterUserID == u.UserID);
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.InnerJoin(tD).On(t.TaskID == tD.TaskID);
t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.Where(t.Status == cmbStatus.SelectedItem.Value.Trim());
//t.Where(t.Status == value);
DataTable dTask = t.LoadDataTable();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
public void storeNeedApproval_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);
t.Where(t.Status == "Resolved", t.ApprovedByRequestorID.IsNull());
//RequesterEmail = Service unit peminta
//RequesterPhone = Service unit tujuan
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
//if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
//{
t.Where(t.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID);
//}
}
t.es.Distinct = true;
DataTable dTask = t.LoadDataTable();
storeNeedApproval.DataSource = dTask;
storeNeedApproval.DataBind();
}
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 btnNew_Click()
{
ADefHelpDeskTasksQuery tq = new ADefHelpDeskTasksQuery("tq");
ADefHelpDeskTasksCollection tc = new ADefHelpDeskTasksCollection();
tq.SelectAll().Where(tq.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID, tq.Status == "Resolved", tq.ApprovedByRequestorID.IsNull());
tc.Load(tq);
if (tc.Count > 2)
{
X.Msg.Alert("Approve needed", "You have finished tasks that required your approval").Show();
return;
}
Window winNew = new Window
{
ID = "winNew",
Title = "Add New",
Height = 400,
Width = 700,
BodyPadding = 5,
Modal = true,
Closable = true,
CloseAction = CloseAction.Hide,
AutoShow = false
};
winNew.Loader = new ComponentLoader
{
Url = "~/Task/TaskAdd.aspx?isnew=1",
Mode = LoadMode.Frame
};
winNew.Render(this.Form);
//winNew.Show();
}
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();
}
public void btnConfirmAlls_Click()
{
string messagesuccess = string.Empty;
if (AppSession.UserLogin.UserID == 36)
{
messagesuccess = "Her Majesty Santi Dwiyanti S.Si, Apt, the pride of RSCM Kencana, has successfully confirms all tasks as finished completely ";
}
else
{
messagesuccess = "PIC successfully confirms all tasks as finished completely";
}
ADefHelpDeskTasksQuery tQ = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTasksCollection tC = new ADefHelpDeskTasksCollection();
tQ.SelectAll().Where(tQ.ApprovedByRequestorID.IsNull(), tQ.ApprovedByRequestorDateTime.IsNull(), tQ.Status == "Resolved");
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
tQ.Where(tQ.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID);
}
tC.Load(tQ);
if (tC.Count > 0)
{
foreach (var t in tC)
{
ADefHelpDeskTasks at = new ADefHelpDeskTasks();
if (at.LoadByPrimaryKey((int)t.TaskID))
{
at.ApprovedByRequestorID = AppSession.UserLogin.UserID;
at.ApprovedByRequestorDateTime = DateTime.Now;
at.Save();
X.Msg.Notify("Success", messagesuccess).Show();
//Refresh GridPanel
MessageBus.Default.Publish("grdTask_Refresh");
}
}
}
}
