protected override void OnInit(EventArgs e) { try { var superKey = ""; var newId = Framework.Components.Core.SystemEntityTypeDataManager.GetNextSequence("Layer", (int)Framework.Components.DataAccess.SystemEntity.SkillLevel, SessionVariables.RequestProfile); var SkillLeveldata = new SkillLevelDataModel(); var systemdevdata = new SystemDevNumbersDataModel(); systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId; var dtnumbers = Framework.Components.Core.SystemDevNumbersDataManager.Search(systemdevdata, SessionVariables.RequestProfile); var rangefrom = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString()); var rangeto = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString()); if (Request.QueryString["SuperKey"] != null) { superKey = Request.QueryString["SuperKey"]; var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(superKey); data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.SkillLevel; var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (System.Data.DataRow dr in dt.Rows) { var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); SkillLeveldata.SkillLevelId = key; var SkillLeveldt = SkillLevelDataManager.GetDetails(SkillLeveldata, SessionVariables.RequestProfile); if (SkillLeveldt.Rows.Count == 1) { var row = SkillLeveldt.Rows[0]; if (Request.QueryString["Mode"].Equals("Test")) { SkillLeveldata.SkillLevelId = GetNextValidId(rangefrom); } SkillLeveldata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); SkillLeveldata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); SkillLeveldata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]); SkillLevelDataManager.Create(SkillLeveldata, SessionVariables.RequestProfile); } } } } else if (Request.QueryString["SetId"] != null) { var key = int.Parse(Request.QueryString["SetId"]); SkillLeveldata.SkillLevelId = key; var SkillLeveldt = SkillLevelDataManager.GetDetails(SkillLeveldata, SessionVariables.RequestProfile); if (SkillLeveldt.Rows.Count == 1) { var row = SkillLeveldt.Rows[0]; var newSkillLeveldata = new SkillLevelDataModel(); if (Request.QueryString["Mode"].Equals("Test")) { newSkillLeveldata.SkillLevelId = newId = (int)GetNextValidId(rangefrom); } newSkillLeveldata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); newSkillLeveldata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); newSkillLeveldata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]); UpdatedFKDepenedencies(key, newId); SkillLevelDataManager.Delete(SkillLeveldata, SessionVariables.RequestProfile); SkillLevelDataManager.Create(newSkillLeveldata, SessionVariables.RequestProfile); } } else if (Request.QueryString["Mode"].Equals("Renumber")) { var seed = int.Parse(Request.QueryString["Seed"]); //ApplicationVariables.Seed; var increment = int.Parse(Request.QueryString["Increment"]); //ApplicationVariables.Increment; SkillLevelDataManager.Renumber(seed, increment, SessionVariables.RequestProfile); } base.OnInit(e); Response.Redirect("Default.aspx?Added=true", false); } catch (Exception ex) { Response.Write(ex.Message); } }
protected override void OnInit(EventArgs e) { base.OnInit(e); try { var detailsControlPath = "~/ClientXProject/Controls/Details.ascx"; var superKey = ApplicationCommon.GetSuperKey(); var setId = ApplicationCommon.GetSetId(); if (!string.IsNullOrEmpty(superKey)) { var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(superKey); // Change System Entity Type data.SystemEntityTypeId = (int)SystemEntity.ClientXProject; var dt = SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); if (string.IsNullOrEmpty(DeleteIds)) { DeleteIds = key.ToString(); } else { DeleteIds += "," + key.ToString(); } var detailsControl = (Controls.Details)Page.LoadControl(detailsControlPath); detailsControl.SetId = key; detailsControl.BorderClass = ApplicationCommon.DetailsBorderClassName; plcDetailsList.Controls.Add(detailsControl); plcDetailsList.Controls.Add(new LiteralControl("<br />")); //chkVisible.Checked = detailsControl.IsHistoryVisible; } } } else { var key = setId; DeleteIds = setId.ToString(); var detailsControl = (Controls.Details)Page.LoadControl(detailsControlPath); detailsControl.SetId = key; plcDetailsList.Controls.Add(detailsControl); } ShowAuditHistory(true); } catch (Exception ex) { Response.Write(ex.Message); } }
protected override void OnInit(EventArgs e) { try { base.OnInit(e); var path = "~/Shared/Admin/SystemIntegrity/SystemDevNumbers/Controls/Details.ascx"; var genericcontrolpath = "~/Shared/Admin/SystemIntegrity/SystemDevNumbers/Controls/Generic.ascx"; SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); if (!string.IsNullOrEmpty(SuperKey)) { btnCancel.Visible = true; btnUpdate.Visible = true; showMultipleUpdateView = true; } else if (Request.QueryString["SetId"] != null) { setId = int.Parse(Request.QueryString["SetId"]); btnUpdate.Visible = true; btnCancel.Visible = true; } if (showMultipleUpdateView) { var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(SuperKey); // Change System Entity Type data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.SystemDevNumbers; var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (System.Data.DataRow dr in dt.Rows) { var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); var SystemDevNumbersupdateControl = (Controls.Generic)Page.LoadControl(genericcontrolpath); SystemDevNumbersupdateControl.SetId(key, false); plcUpdateList.Controls.Add(SystemDevNumbersupdateControl); if (dt.Rows.Count > 1) { SystemDevNumbersupdateControl.BorderClass = ApplicationCommon.DetailsBorderClassName; SystemDevNumbersupdateControl.Controls.Add(new LiteralControl("<br />")); } chkVisible.Checked = SystemDevNumbersupdateControl.IsHistoryVisible; } } } else if (SetId != 0) { var SystemDevNumbersupdateControl = (Controls.Generic)Page.LoadControl(genericcontrolpath); SystemDevNumbersupdateControl.SetId(SetId, false); plcUpdateList.Controls.Add(SystemDevNumbersupdateControl); chkVisible.Checked = SystemDevNumbersupdateControl.IsHistoryVisible; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); //throw } }
protected override void OnInit(EventArgs e) { try { var superKey = string.Empty; var newId = SystemEntityTypeDataManager.GetNextSequence("Client", (int)SystemEntity.Client, SessionVariables.RequestProfile); var clientData = new ClientDataModel(); var systemDevData = new SystemDevNumbersDataModel(); systemDevData.ApplicationUserId = SessionVariables.RequestProfile.AuditId; var dtnumbers = SystemDevNumbersDataManager.Search(systemDevData, SessionVariables.RequestProfile); var rangefrom = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString()); var rangeto = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString()); if (Request.QueryString["SuperKey"] != null) { superKey = Request.QueryString["SuperKey"]; var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(superKey); data.SystemEntityTypeId = (int)SystemEntity.Client; var dt = SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var key = (int)(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); clientData.ClientId = key; var clientdt = ClientDataManager.GetDetails(clientData, SessionVariables.RequestProfile); if (clientdt.Rows.Count == 1) { var row = clientdt.Rows[0]; if (Request.QueryString["Mode"].Equals("Test")) { clientData.ClientId = GetNextValidId(rangefrom); } clientData.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); clientData.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); clientData.SortOrder = (int)(row[StandardDataModel.StandardDataColumns.SortOrder]); ClientDataManager.Create(clientData, SessionVariables.RequestProfile); } } } } else if (Request.QueryString["SetId"] != null) { var key = int.Parse(Request.QueryString["SetId"]); clientData.ClientId = key; var clientdt = ClientDataManager.GetDetails(clientData, SessionVariables.RequestProfile); if (clientdt.Rows.Count == 1) { var row = clientdt.Rows[0]; var newclientdata = new ClientDataModel(); if (Request.QueryString["Mode"].Equals("Test")) { newclientdata.ClientId = newId = GetNextValidId(rangefrom); } newclientdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); newclientdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); newclientdata.SortOrder = (int)(row[StandardDataModel.StandardDataColumns.SortOrder]); UpdatedFKDepenedencies(key, newId); ClientDataManager.Delete(clientData, SessionVariables.RequestProfile); ClientDataManager.Create(newclientdata, SessionVariables.RequestProfile); } } else if (Request.QueryString["Mode"].Equals("Renumber")) { var seed = int.Parse(Request.QueryString["Seed"]); //ApplicationVariables.Seed; var increment = int.Parse(Request.QueryString["Increment"]); //ApplicationVariables.Increment; ClientDataManager.Renumber(seed, increment, SessionVariables.RequestProfile); } base.OnInit(e); Response.Redirect(Page.GetRouteUrl("ClientEntityRoute", new { Action = "Default", SetId = true }), false); } catch (Exception ex) { Response.Write(ex.Message); } }
public static void Update(SuperKeyDetailDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("SuperKeyDetail.Update", sql, DataStoreKey); }
public static SuperKeyDetailDataModel GetDetails(SuperKeyDetailDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }