protected void InitializeGridRoles() { //int userid = Convert.ToInt32(Session["UserId"]); GetMyAccessRights(); Roles role = new Roles(); if (role.GetRolesWithoutDepartmentAccess().Count > 0 && myAccessRights.CanAdd == true) linkBtnAdd.Visible = true; else linkBtnAdd.Visible = false; var roleList = role.GetRolesWithDepartmentAccess(); //Converter model = new Converter(); //DataTable table = model.ConvertToDataTable(roleList); gridViewRoles.DataSource = roleList; gridViewRoles.DataBind(); }
protected void gridViewRole_Command(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { GetMyAccessRights(); modalLabelError.Text = ""; modalLabelError.Visible = false; modalBtnSubmit.Visible = Convert.ToBoolean(myAccessRights.CanUpdate); int index = Convert.ToInt32(e.CommandArgument); int roleid = Convert.ToInt32(((Label)gridViewRole.Rows[index].FindControl("labelRoleId")).Text); modalBtnSubmit.CommandArgument = "Update"; Roles role = new Roles(); role = role.GetRole(roleid); modalLabelRoleId.Text = role.Id.ToString(); modalTxtBoxDescription.Text = role.Description; this.programmaticModalPopup.Show(); } }
protected void InitializeGridViewRole() { GetMyAccessRights(); if (myAccessRights.CanAdd == true) linkBtnAdd.Visible = true; else linkBtnAdd.Visible = false; Roles role = new Roles(); List<Roles> rolelist = new List<Roles>(); rolelist = role.GetRoleList(); if (rolelist.Count > 0) { if (rolelist[0].Description == "All") rolelist.RemoveAt(0); } gridViewRole.DataSource = rolelist; gridViewRole.DataBind(); }
protected void InitializeModalDropDownRoles(int roleid = 0) { Roles role = new Roles(); List<Roles> datalist = new List<Roles>(); if (roleid == 0) //Add { datalist = role.GetRolesWithoutDepartmentAccess(); modalDropDownRoles.Enabled = true; } else //Update { role = role.GetRole(roleid); datalist.Add(role); modalDropDownRoles.Enabled = false; } modalDropDownRoles.DataSource = datalist; modalDropDownRoles.DataTextField = "Description"; modalDropDownRoles.DataValueField = "Id"; modalDropDownRoles.DataBind(); }
protected void InitializeModalDropDownRole(string value = "") { Roles role = new Roles(); var roles = role.GetRoleList(); modalDropDownRole.DataSource = roles; modalDropDownRole.DataTextField = "Description"; modalDropDownRole.DataValueField = "Id"; modalDropDownRole.DataBind(); if (value != null && value.Trim() != "") { foreach (ListItem i in modalDropDownRole.Items) { if (value.Trim() == i.Value.ToString().Trim()) { i.Selected = true; break; } } } }
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e) { if (modalLabelError.Visible == true) this.programmaticModalPopup.Show(); else { int userid = Convert.ToInt32(Session["UserId"]); Roles role = new Roles(); if (modalLabelRoleId.Text.Trim() != "") { role = role.GetRole(Convert.ToInt32(modalLabelRoleId.Text)); } role.Description = modalTxtBoxDescription.Text.Trim(); role.LastUpdateDate = DateTime.Now; role.LastUpdatedBy = userid; if (e.CommandArgument.ToString() == "Add") { role.CreateDate = DateTime.Now; role.CreatedBy = userid; role.Insert(role); } else if (e.CommandArgument.ToString() == "Update") { role.Update(role); } InitializeGridViewRole(); this.programmaticModalPopup.Hide(); } }
private void UpdateParse(T_Roles t_role, Roles role) { t_role.Description = role.Description; t_role.Rank = role.Rank; t_role.LastUpdateDate = role.LastUpdateDate; t_role.LastUpdatedBy = role.LastUpdatedBy; t_role.IsSupervisor = role.IsSupervisor; }
private T_Roles InsertParse(Roles role) { T_Roles t_role = new T_Roles(); t_role.Description = role.Description; t_role.Rank = role.Rank; t_role.CreateDate = role.CreateDate; t_role.LastUpdateDate = role.LastUpdateDate; t_role.CreatedBy = role.CreatedBy; t_role.LastUpdatedBy = role.LastUpdatedBy; t_role.IsSupervisor = role.IsSupervisor; return t_role; }
public void Update(Roles role) { using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { T_Roles t_role = db.T_Roles.FirstOrDefault(p => p.Id == role.Id); UpdateParse(t_role, role); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }
//public List<Roles> GetRolesWithSupervisors() //{ // TimeTrackerEntities db = new TimeTrackerEntities(); // var data = (from r in db.T_Roles // join s in db.T_RolesSupervisor // on r.Id equals s.RoleId // select new Roles() // { // Id = r.Id, // Description = r.Description, // Rank = r.Rank, // CreateDate = r.CreateDate, // LastUpdateDate = r.LastUpdateDate, // CreatedBy = r.CreatedBy, // LastUpdatedBy = r.LastUpdatedBy, // IsSupervisor = r.IsSupervisor // }).Distinct().ToList(); // db.Dispose(); // return data; //} //public List<Roles> GetRolesWithoutSupervisor() //{ // TimeTrackerEntities db = new TimeTrackerEntities(); // var data = (from r in db.T_Roles // join s in db.T_RolesSupervisor // on r.Id equals s.RoleId // orderby r.Id // select new Roles() // { // Id = r.Id, // Description = r.Description, // Rank = r.Rank, // CreateDate = r.CreateDate, // LastUpdateDate = r.LastUpdateDate, // CreatedBy = r.CreatedBy, // LastUpdatedBy = r.LastUpdatedBy, // IsSupervisor = r.IsSupervisor // }).Distinct().ToList(); // db.Dispose(); // var list = GetRoleList(); // for (int i = 0; i < data.Count; i++) // { // for (int j = 0; j < list.Count; j++) // { // if (data[i].Id == list[j].Id) // { // list.RemoveAt(j); // break; // } // } // } // return list; //} public void Insert(Roles role) { T_Roles t_role = InsertParse(role); using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { db.T_Roles.Add(t_role); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }