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(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int taskID = 0; if (Request.QueryString["isedit"] == null & Request.QueryString["TaskID"] == null) { Response.Redirect("~/404.aspx"); } if (!int.TryParse(Request.QueryString["TaskID"].ToString(), out taskID)) { taskID = 0; } Session["taskid"] = taskID; ADefHelpDeskTasks t = new ADefHelpDeskTasks(); if (!t.LoadByPrimaryKey(taskID)) { Response.Redirect("~/404.aspx"); } ADefHelpDeskTaskDetailsQuery tQ = new ADefHelpDeskTaskDetailsQuery("a"); ADefHelpDeskTaskDetailsCollection tC = new ADefHelpDeskTaskDetailsCollection(); tQ.SelectAll().Where(tQ.TaskID == taskID && tQ.DetailType == "Details"); tQ.es.Top = 1; tC.Load(tQ); //Fill the Form txtTitle.Text = t.Description; if (tC.Count > 0) { foreach (ADefHelpDeskTaskDetails aT in tC) { txtDesc.Text = aT.Description; } } } }
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 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; } } } }
public void btnSave_Click() { int taskID = 0; if (Session["taskid"] != null) { taskID = (int)Session["taskid"]; } else { Response.Redirect("~/404.aspx"); } ADefHelpDeskTasks t = new ADefHelpDeskTasks(); ADefHelpDeskTaskDetails td = new ADefHelpDeskTaskDetails(); ADefHelpDeskTaskDetailsQuery tdQ = new ADefHelpDeskTaskDetailsQuery("a"); ADefHelpDeskTaskDetailsCollection tdC = new ADefHelpDeskTaskDetailsCollection(); if (t.LoadByPrimaryKey(taskID)) { t.Description = txtTitle.Text; tdQ.SelectAll().Where(tdQ.TaskID == taskID, tdQ.DetailType == "Details"); tdQ.es.Top = 1; tdC.Load(tdQ); if (tdC.Count > 0) { foreach (ADefHelpDeskTaskDetails ttt in tdC) { if (td.LoadByPrimaryKey((int)ttt.DetailID)) { td.Description = txtDesc.Text; td.Save(); } } } t.Save(); } //t.PortalID = 0; //t.Description = txtDesc.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 //Guid g = new Guid(); //t.TicketPassword = Guid.NewGuid().ToString(); //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(); MessageBus.Default.Publish("grdTask_Refresh"); //X.Js.Call("onWinClose"); }