private void LoadData(string TenIDOverride = "0") { var ds = new DataSet(); var dt = new DataTable(); var aTenID = (TenIDOverride == "0" ? TenID.SelectedValue : TenIDOverride); Session["ATENID"] = aTenID; if (aTenID != "0") { dt = SRPGroup.FetchAllAsDataTable(int.Parse(aTenID)); } ds.Tables.Add(dt); if (_mStrSortExp != "") { dt.DefaultView.Sort = _mStrSortExp + (_mSortDirection == SortDirection.Descending ? " DESC" : ""); var ds2 = new DataSet(); ds2.Tables.Add(dt.DefaultView.ToTable()); ds = ds2; } gv.DataSource = ds; gv.DataBind(); }
protected void GvRowCommand(object sender, GridViewCommandEventArgs e) { string editpage = "~/ControlRoom/Modules/Security/GroupsAddEdit.aspx"; if (e.CommandName.ToLower() == "addrecord") { Session["GID"] = string.Empty; Response.Redirect(editpage); } if (e.CommandName.ToLower() == "editrecord") { int key = Convert.ToInt32(e.CommandArgument); Session["GID"] = key; Response.Redirect(editpage); } if (e.CommandName.ToLower() == "deleterecord") { int key = Convert.ToInt32(e.CommandArgument); try { var obj = new SRPGroup(key); if (obj.IsValid(BusinessRulesValidationMode.DELETE)) { SRPGroup.Delete(key); LoadData(); var masterPage = (IControlRoomMaster)Master; if (masterPage != null) { masterPage.PageMessage = SRPResources.DeleteOK; } } else { var masterPage = (IControlRoomMaster)Master; string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); if (masterPage != null) { masterPage.PageError = message; } } } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; if (masterPage != null) { masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } } }
private void LoadData() { var ds = new DataSet(); var dt = SRPGroup.FetchAllAsDataTable(); ds.Tables.Add(dt); if (!string.IsNullOrEmpty(_mStrSortExp)) { dt.DefaultView.Sort = _mStrSortExp + (_mSortDirection == SortDirection.Descending ? " DESC" : ""); var ds2 = new DataSet(); ds2.Tables.Add(dt.DefaultView.ToTable()); ds = ds2; } gv.DataSource = ds; gv.DataBind(); }
protected void SavePermissions(DetailsView dv, SRPGroup obj) { GridView gv = (GridView)dv.FindControl("gvGroupPermissions"); string groupPermissions = string.Empty; foreach (GridViewRow row in gv.Rows) { if (((CheckBox)row.FindControl("isChecked")).Checked) { groupPermissions = string.Format("{0},{1}", groupPermissions, ((Label)row.FindControl("PermissionID")).Text); } } if (groupPermissions.Length > 0) { groupPermissions = groupPermissions.Substring(1, groupPermissions.Length - 1); } SRPGroup.UpdatePermissions(obj.GID, groupPermissions, ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username); }
protected void SaveUsers(DetailsView dv, SRPGroup obj) { GridView gv = (GridView)dv.FindControl("gvGroupUsers"); string memberUsers = string.Empty; foreach (GridViewRow row in gv.Rows) { if (((CheckBox)row.FindControl("isMember")).Checked) { memberUsers = string.Format("{0},{1}", memberUsers, ((Label)row.FindControl("UID")).Text); } } if (memberUsers.Length > 0) { memberUsers = memberUsers.Substring(1, memberUsers.Length - 1); } SRPGroup.UpdateMemberUsers(obj.GID, memberUsers, ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username); }
protected void DvItemCommand(object sender, DetailsViewCommandEventArgs e) { string returnURL = "~/ControlRoom/Modules/Security/GroupsList.aspx"; if (e.CommandName.ToLower() == "back") { Response.Redirect(returnURL); } if (e.CommandName.ToLower() == "refresh") { try { odsSRPGroups.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); MasterPage.PageMessage = SRPResources.RefreshOK; } catch (Exception ex) { MasterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } if (e.CommandName.ToLower() == "add" || e.CommandName.ToLower() == "addandback") { try { SRPGroup obj = new SRPGroup(); //obj.GID = int.Parse( ((Label)((DetailsView)sender).FindControl(".GID")).Text ); obj.GroupName = ((TextBox)((DetailsView)sender).FindControl("GroupName")).Text; obj.GroupDescription = ((TextBox)((DetailsView)sender).FindControl("GroupDescription")).Text; obj.AddedDate = DateTime.Now; obj.AddedUser = ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username; //"N/A"; // Get from session obj.LastModDate = obj.AddedDate; obj.LastModUser = obj.AddedUser; obj.TenID = (int)CRTenantID; if (obj.IsValid(BusinessRulesValidationMode.INSERT)) { obj.Insert(); if (e.CommandName.ToLower() == "addandback") { Response.Redirect(returnURL); } lblGID.Text = obj.GID.ToString(); odsSRPGroups.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); MasterPage.PageMessage = SRPResources.AddedOK; } else { string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); MasterPage.PageError = message; } } catch (Exception ex) { MasterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } if (e.CommandName.ToLower() == "save" || e.CommandName.ToLower() == "saveandback") { try { SRPGroup obj = new SRPGroup(); int pk = int.Parse(((DetailsView)sender).Rows[0].Cells[1].Text); obj = SRPGroup.Fetch(pk); obj.GroupName = ((TextBox)((DetailsView)sender).FindControl("GroupName")).Text; obj.GroupDescription = ((TextBox)((DetailsView)sender).FindControl("GroupDescription")).Text; obj.LastModDate = DateTime.Now; obj.LastModUser = ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username; //"N/A"; // Get from session if (obj.IsValid(BusinessRulesValidationMode.UPDATE)) { obj.Update(); SaveUsers((DetailsView)sender, obj); SavePermissions((DetailsView)sender, obj); if (e.CommandName.ToLower() == "saveandback") { Response.Redirect(returnURL); } odsSRPGroups.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); MasterPage.PageMessage = SRPResources.SaveOK; MasterPage.PageMessage = SRPResources.AddedOK; } else { string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); MasterPage.PageError = message; } } catch (Exception ex) { MasterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } }