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