public IEnumerable <SystemEntityTypeDataModel> ListEntities() { var data = new SystemEntityTypeDataModel(); var listEntities = SystemEntityTypeDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo); return(listEntities); }
public override void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl) { base.LoadDropDownListSources(fieldName, dropDownListControl); if (fieldName.Equals("Application")) { var applicationData = ApplicationDataManager.GetList(SessionVariables.RequestProfile); var dv = applicationData.DefaultView; dv.Sort = "Name ASC"; UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl, StandardDataModel.StandardDataColumns.Name, BaseDataModel.BaseDataColumns.ApplicationId); dropDownListControl.SelectedValue = SessionVariables.RequestProfile.ApplicationId.ToString(); } else if (fieldName.Equals("systemEntityType")) { var systemEntityData = FunctionalityEntityStatusDataManager.GetUniqueIdList( "systemEntityType", SessionVariables.RequestProfile); var systemEntityDataList = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); var filteredsystemEntityData = GetFilteredList("systemEntityType", systemEntityData, systemEntityDataList); filteredsystemEntityData.DefaultView.Sort = SystemEntityTypeDataModel.DataColumns.EntityName + " ASC"; var sorteddt = filteredsystemEntityData.DefaultView.ToTable(); UIHelper.LoadDropDown(sorteddt, dropDownListControl, SystemEntityTypeDataModel.DataColumns.EntityName, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); } else if (fieldName.Equals("Functionality")) { var functionalityData = FunctionalityEntityStatusDataManager.GetUniqueIdList( "Functionality", SessionVariables.RequestProfile); var functionalityDataList = FunctionalityDataManager.GetList(SessionVariables.RequestProfile); var filteredfunctionalityData = GetFilteredList("Functionality", functionalityData, functionalityDataList); UIHelper.LoadDropDown(filteredfunctionalityData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityDataModel.DataColumns.FunctionalityId); } else if (fieldName.Equals("FunctionalityPriority")) { var functionalityPriorityData = FunctionalityPriorityDataManager.GetList(SessionVariables.RequestProfile); var dv = functionalityPriorityData.DefaultView; dv.Sort = "Name ASC"; UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityPriorityDataModel.DataColumns.FunctionalityPriorityId); } else if (fieldName.Equals("FunctionalityActiveStatus")) { var functionalityActiveStatusData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile); var dv = functionalityActiveStatusData.DefaultView; dv.Sort = "Name ASC"; UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId); } dropDownListControl.SelectedIndex = 0; }
protected void btnCreate_Click(object sender, EventArgs e) { var dataFES = new FunctionalityEntityStatusDataModel(); dataFES.FunctionalityId = FunctionalityId; var fesData = FunctionalityEntityStatusDataManager.Search(dataFES, SessionVariables.RequestProfile); if (fesData.Rows.Count == 0) { var dtMenu = MenuDataManager.GetList(SessionVariables.RequestProfile); var entitydt = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); //get data based on Entity Name from Menu and SystemEntity table to get the Primary Developer value var assignedTo = from tblMenu in dtMenu.AsEnumerable() join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName) select tblEntity; //get data from SystemEntity table which doesnt have matching entries in Menu table var assignedToAdmin = from tblEntity in entitydt.AsEnumerable() where !assignedTo.Contains(tblEntity) select tblEntity; string assignedToValue = string.Empty; //data inserted to FES with AssignedTo value as PrimaryDeveloper value for (int i = 0; i < assignedTo.Count(); i++) { var primaryDeveloper = from tblMenu in dtMenu.AsEnumerable() join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName) where tblMenu.Field <string>(MenuDataModel.DataColumns.Name) == assignedTo.CopyToDataTable().Rows[i][SystemEntityTypeDataModel.DataColumns.EntityName].ToString() select tblMenu[MenuDataModel.DataColumns.PrimaryDeveloper]; assignedToValue = primaryDeveloper.First().ToString(); Insert(assignedTo.CopyToDataTable().Rows[i], assignedToValue); } //data inserted to FES with AssignedTo value as "Admin" for (int j = 0; j < assignedToAdmin.Count(); j++) { assignedToValue = "Admin"; Insert(assignedToAdmin.CopyToDataTable().Rows[j], assignedToValue); } } }
private void SetupSystemEntityDropdown() { drpSystemEntity.Items.Clear(); var dt = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { drpSystemEntity.Items.Add(Convert.ToString(dr["EntityName"])); } } }
private int GetSystemEntityTypeId() { var data = new SystemEntityTypeDataModel(); var auditId = SessionVariables.RequestProfile.AuditId; var entityName = ViewState["TableName"].ToString(); data.EntityName = entityName; var dtEntityRow = SystemEntityTypeDataManager.Search(data, SessionVariables.RequestProfile).Rows[0]; var entityId = int.Parse(dtEntityRow[SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId].ToString()); return(entityId); }
private static void FormatNumericalData(FieldConfigurationDataModel data, RequestProfile requestProfile) { Type type = null; var dataSE = new SystemEntityTypeDataModel(); dataSE.SystemEntityTypeId = data.SystemEntityTypeId; var dt = SystemEntityTypeDataManager.GetEntityDetails(dataSE, requestProfile); var entityModel = dt[0].EntityName + "DataModel"; var currentAssembly = Assembly.GetExecutingAssembly(); var assemblyNames = currentAssembly.GetReferencedAssemblies(); foreach (var aName in assemblyNames) { try { var assembly = Assembly.Load(aName); type = assembly.GetTypes().First(t => t.Name == entityModel); var objInstance = Activator.CreateInstance(type); var objType = objInstance.GetType(); var objProps = objType.GetProperties(); foreach (var propInfo in objProps) { if (propInfo.Name.Equals(data.Name)) { if (propInfo.PropertyType == typeof(int?) || propInfo.PropertyType == typeof(DateTime)) { data.HorizontalAlignment = "Right"; } } } } catch { } } }
private void SetupDropdown() { var isTesting = SessionVariables.IsTesting; var systemEntityTypeData = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(systemEntityTypeData, drpSystemEntityTypeList, SystemEntityTypeDataModel.DataColumns.EntityName, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); var functionalityData = FunctionalityDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(functionalityData, drpFunctionalityList, StandardDataModel.StandardDataColumns.Name, FunctionalityDataModel.DataColumns.FunctionalityId); var functionalityStatusData = FunctionalityStatusDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(functionalityStatusData, drpFunctionalityStatusList, StandardDataModel.StandardDataColumns.Name, FunctionalityStatusDataModel.DataColumns.FunctionalityStatusId); var functionalityPriorityData = FunctionalityPriorityDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(functionalityPriorityData, drpFunctionalityPriorityList, StandardDataModel.StandardDataColumns.Name, FunctionalityPriorityDataModel.DataColumns.FunctionalityPriorityId); if (isTesting) { drpSystemEntityTypeList.AutoPostBack = true; drpFunctionalityList.AutoPostBack = true; drpFunctionalityStatusList.AutoPostBack = true; drpFunctionalityPriorityList.AutoPostBack = true; if (drpSystemEntityTypeList.Items.Count > 0) { if (!string.IsNullOrEmpty(txtSystemEntityTypeId.Text.Trim())) { drpSystemEntityTypeList.SelectedValue = txtSystemEntityTypeId.Text; } else { txtSystemEntityTypeId.Text = drpSystemEntityTypeList.SelectedItem.Value; } } if (drpFunctionalityList.Items.Count > 0) { if (!string.IsNullOrEmpty(txtFunctionalityId.Text.Trim())) { drpFunctionalityList.SelectedValue = txtFunctionalityId.Text; } else { txtFunctionalityId.Text = drpFunctionalityList.SelectedItem.Value; } } if (drpFunctionalityStatusList.Items.Count > 0) { if (!string.IsNullOrEmpty(txtFunctionalityStatusId.Text.Trim())) { drpFunctionalityStatusList.SelectedValue = txtFunctionalityStatusId.Text; } else { txtFunctionalityStatusId.Text = drpFunctionalityStatusList.SelectedItem.Value; } } if (drpFunctionalityPriorityList.Items.Count > 0) { if (!string.IsNullOrEmpty(txtFunctionalityPriorityId.Text.Trim())) { drpFunctionalityPriorityList.SelectedValue = txtFunctionalityPriorityId.Text; } else { txtFunctionalityPriorityId.Text = drpFunctionalityPriorityList.SelectedItem.Value; } } txtSystemEntityTypeId.Visible = true; txtFunctionalityId.Visible = true; txtFunctionalityStatusId.Visible = true; txtFunctionalityPriorityId.Visible = true; } else { if (!string.IsNullOrEmpty(txtSystemEntityTypeId.Text.Trim())) { drpSystemEntityTypeList.SelectedValue = txtSystemEntityTypeId.Text; } if (!string.IsNullOrEmpty(txtFunctionalityId.Text.Trim())) { drpFunctionalityList.SelectedValue = txtFunctionalityId.Text; } if (!string.IsNullOrEmpty(txtFunctionalityStatusId.Text.Trim())) { drpFunctionalityStatusList.SelectedValue = txtFunctionalityStatusId.Text; } if (!string.IsNullOrEmpty(txtFunctionalityPriorityId.Text.Trim())) { drpFunctionalityPriorityList.SelectedValue = txtFunctionalityPriorityId.Text; } txtSystemEntityTypeId.Visible = false; txtFunctionalityId.Visible = false; txtFunctionalityStatusId.Visible = false; txtFunctionalityPriorityId.Visible = false; } }
protected override void OnInit(EventArgs e) { try { var superKey = ""; var newId = SystemEntityTypeDataManager.GetNextSequence("TaskAlgorithmItem", (int)SystemEntity.TaskAlgorithmItem, SessionVariables.RequestProfile); var TaskAlgorithmItemdata = new TaskAlgorithmItemDataModel(); 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"].ToString(); var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(superKey); data.SystemEntityTypeId = (int)SystemEntity.TaskAlgorithmItem; 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]); TaskAlgorithmItemdata.TaskAlgorithmItemId = key; var TaskAlgorithmItemdt = TaskAlgorithmItemDataManager.GetDetails(TaskAlgorithmItemdata, SessionVariables.RequestProfile); if (TaskAlgorithmItemdt.Rows.Count == 1) { var row = TaskAlgorithmItemdt.Rows[0]; if (Request.QueryString["Mode"].ToString().Equals("Test")) { TaskAlgorithmItemdata.TaskAlgorithmItemId = GetNextValidId(rangefrom); } TaskAlgorithmItemdata.ActivityId = Convert.ToInt32(row[TaskAlgorithmItemDataModel.DataColumns.ActivityId]); TaskAlgorithmItemdata.Description = Convert.ToString(row[TaskAlgorithmItemDataModel.DataColumns.Description]); TaskAlgorithmItemdata.SortOrder = Convert.ToInt32(row[TaskAlgorithmItemDataModel.DataColumns.SortOrder]); TaskAlgorithmItemDataManager.Create(TaskAlgorithmItemdata, SessionVariables.RequestProfile); } } } } else if (Request.QueryString["SetId"] != null) { var key = int.Parse(Request.QueryString["SetId"]); TaskAlgorithmItemdata.TaskAlgorithmItemId = key; var TaskAlgorithmItemdt = TaskAlgorithmItemDataManager.GetDetails(TaskAlgorithmItemdata, SessionVariables.RequestProfile); if (TaskAlgorithmItemdt.Rows.Count == 1) { var row = TaskAlgorithmItemdt.Rows[0]; var newTaskAlgorithmItemdata = new TaskAlgorithmItemDataModel(); if (Request.QueryString["Mode"].ToString().Equals("Test")) { newTaskAlgorithmItemdata.TaskAlgorithmItemId = newId = (int)GetNextValidId(rangefrom); } newTaskAlgorithmItemdata.ActivityId = Convert.ToInt32(row[TaskAlgorithmItemDataModel.DataColumns.ActivityId]); newTaskAlgorithmItemdata.Description = Convert.ToString(row[TaskAlgorithmItemDataModel.DataColumns.Description]); newTaskAlgorithmItemdata.SortOrder = Convert.ToInt32(row[TaskAlgorithmItemDataModel.DataColumns.SortOrder]); UpdatedFKDepenedencies(key, newId); TaskAlgorithmItemDataManager.Delete(TaskAlgorithmItemdata, SessionVariables.RequestProfile); TaskAlgorithmItemDataManager.Create(newTaskAlgorithmItemdata, SessionVariables.RequestProfile); } } else if (Request.QueryString["Mode"].ToString().Equals("Renumber")) { var seed = int.Parse(Request.QueryString["Seed"].ToString()); //ApplicationVariables.Seed; var increment = int.Parse(Request.QueryString["Increment"].ToString()); //ApplicationVariables.Increment; TaskAlgorithmItemDataManager.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) { 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); } }