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"); }
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 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(); }