protected override void ShowData(int systemEntityTypeId) { oDetailButtonPanel.SetId = SetId; var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = systemEntityTypeId; var items = Framework.Components.Core.SystemEntityTypeDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString(); lblEntityName.Text = item.EntityName.ToString(); lblEntityDescription.Text = item.EntityDescription.ToString(); lblNextValue.Text = item.NextValue.ToString(); lblCreatedDate.Text = item.CreatedDate.ToString(); lblPrimaryDatabase.Text = item.PrimaryDatabase.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, systemEntityTypeId, "SystemEntityType"); } else { lblSystemEntityTypeId.Text = String.Empty; lblEntityName.Text = String.Empty; lblEntityDescription.Text = String.Empty; lblNextValue.Text = String.Empty; lblCreatedDate.Text = String.Empty; lblPrimaryDatabase.Text = String.Empty; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var appData = Framework.Components.ApplicationUser.ApplicationDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(appData, ddlApplication, DataModel.Framework.AuthenticationAndAuthorization.ApplicationDataModel.DataColumns.Name, DataModel.Framework.AuthenticationAndAuthorization.ApplicationDataModel.DataColumns.ApplicationId); ddlApplication.Items.Insert(0, new ListItem("All", "-1")); var data = new SystemEntityTypeDataModel(); if (Convert.ToInt32(ddlApplication.SelectedValue.ToString()) != -1) { data.ApplicationId = Convert.ToInt32(ddlApplication.SelectedValue.ToString()); } else { data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; } var dt = Framework.Components.Core.SystemEntityTypeDataManager.Search(data, SessionVariables.RequestProfile); UIHelper.LoadDropDown(dt, drpSystemEntity, SystemEntityTypeDataModel.DataColumns.EntityName, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); drpSystemEntity.Items.Insert(0, new ListItem("All", "-1")); var dbData = Framework.Components.DataAccess.SetupConfiguration.GetListConnectionKeyName(SessionVariables.RequestProfile.AuditId); UIHelper.LoadDropDown(dbData, drpDbName, "ConnectionKeyName", "ConnectionKeyName"); } }
protected void ddlApplication_SelectedIndexChanged(object sender, EventArgs e) { drpSystemEntity.Items.Clear(); TestAndAuditGrid.DataSource = null; TestAndAuditGrid.DataBind(); string strApplication = string.Empty; strApplication = ddlApplication.SelectedValue; //if (ddlApplication.SelectedIndex != 0) //{ var data = new SystemEntityTypeDataModel(); if (Convert.ToInt32(ddlApplication.SelectedValue.ToString()) != -1) { data.ApplicationId = Convert.ToInt32(ddlApplication.SelectedValue.ToString()); } else { data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; } var dt = Framework.Components.Core.SystemEntityTypeDataManager.Search(data, SessionVariables.RequestProfile); UIHelper.LoadDropDown(dt, drpSystemEntity, SystemEntityTypeDataModel.DataColumns.EntityName, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); drpSystemEntity.Items.Insert(0, new ListItem("All", "-1")); //} }
public IEnumerable <SystemEntityTypeDataModel> ListEntities() { var data = new SystemEntityTypeDataModel(); var listEntities = SystemEntityTypeDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo); return(listEntities); }
private void ShowSelectedRecords(StringCollection sc, Command cmd) { string _tableFolder = Convert.ToString(ViewState["TableFolder"]); string _tableName = Convert.ToString(ViewState["TableName"]); string redirecturl = ""; string _tablePath = String.Empty; if (string.IsNullOrEmpty(_tableFolder.Trim())) { _tablePath = "~/" + _tableName; } else { _tablePath = "~/" + _tableFolder + "/" + _tableName; } if (sc.Count > 1) { if (cmd.Equals(Command.Delete)) { redirecturl = _tablePath + "/Delete.aspx?SuperKey="; } else if (cmd.Equals(Command.Details)) { redirecturl = _tablePath + "/Details.aspx?SuperKey="; } else { redirecturl = _tablePath + "/Update.aspx?SuperKey="; } int superKeyId = 0; var sData = new SystemEntityTypeDataModel(); sData.EntityName = Convert.ToString(ViewState["TableName"]); var sDt = Framework.Components.Core.SystemEntityTypeDataManager.Search(sData, SessionVariables.RequestProfile); if (sDt.Rows.Count > 0) { var systemEntityTypeId = Convert.ToInt32(sDt.Rows[0][SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId]); superKeyId = ApplicationCommon.GenerateSuperKey(sc, systemEntityTypeId); } redirecturl += superKeyId; } else if (sc.Count == 1) { if (cmd.Equals(Command.Delete)) { redirecturl = _tablePath + "/Delete.aspx"; } else if (cmd.Equals(Command.Details)) { redirecturl = _tablePath + "/Details.aspx"; } else { redirecturl = _tablePath + "/Update.aspx"; } redirecturl += "?SetId=" + sc[0]; } Response.Redirect(redirecturl, false); }
public override int?Save(string action) { var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = SystemEntityTypeId; data.EntityDescription = EntityDescription; data.EntityName = EntityName; data.NextValue = NextValue; data.PrimaryDatabase = PrimaryDatabase; data.CreatedDate = CreatedDate; if (action == "Insert") { var dtScheduleQuestion = Framework.Components.Core.SystemEntityTypeDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtScheduleQuestion.Rows.Count == 0) { Framework.Components.Core.SystemEntityTypeDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { Framework.Components.Core.SystemEntityTypeDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ScheduleID ? return(SystemEntityTypeId); }
private static string Save(SystemEntityTypeDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.SystemEntityTypeInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); //" " + BaseColumns.ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId); break; case "Update": sql += "dbo.SystemEntityTypeUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); //" " + BaseColumns.ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.EntityName) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.EntityDescription) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.NextValue) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.PrimaryDatabase) + ", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.CreatedDate); //", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.CreatedDate); //", " + ToSQLParameter(data, DataModel.Framework.Core.SystemEntityType.DataColumns.IncreaseBy); return(sql); }
public static DataTable Search(SystemEntityTypeDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static DataTable DoesExist(SystemEntityTypeDataModel data, RequestProfile requestProfile) { var doesExistRequest = new SystemEntityTypeDataModel(); doesExistRequest.EntityName = data.EntityName; return(Search(doesExistRequest, requestProfile)); }
private void ShowSelectedRecords(StringCollection sc, string tablename) { string _tableFolder = Convert.ToString(ViewState["TableFolder"]); if (tablename.Equals("Schedule") || tablename.StartsWith("Schedule")) { _tableFolder = "Scheduling"; } else if (tablename.Equals("Risk") || tablename.Equals("Reward")) { _tableFolder = "RiskAndReward"; } else if (tablename.Equals("TaskRun") || tablename.StartsWith("TaskEntity") || tablename.StartsWith("TaskSchedule")) { _tableFolder = "TasksAndWorkflow"; } else if (tablename.Equals("Activity") || tablename.StartsWith("TaskEntity") || tablename.StartsWith("TaskSchedule")) { _tableFolder = "WBS"; } string _tableName = tablename; string redirecturl = ""; string _tablePath = String.Empty; if (string.IsNullOrEmpty(_tableFolder.Trim())) { _tablePath = "~/" + _tableName; } else { _tablePath = "~/" + _tableFolder + "/" + _tableName; } if (sc.Count > 1) { redirecturl = _tablePath + "/Details.aspx?SuperKey="; int superKeyId = 0; var sData = new SystemEntityTypeDataModel(); sData.EntityName = Convert.ToString(ViewState["TableName"]); var sDt = Framework.Components.Core.SystemEntityTypeDataManager.Search(sData, SessionVariables.AuditId); if (sDt.Rows.Count > 0) { var systemEntityTypeId = Convert.ToInt32(sDt.Rows[0][SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId]); superKeyId = ApplicationCommon.GenerateSuperKey(sc, systemEntityTypeId); } redirecturl += superKeyId; } else if (sc.Count == 1) { redirecturl = _tablePath + "/Details.aspx"; redirecturl += "?SetId=" + sc[0]; } Response.Redirect(redirecturl, false); }
private System.Data.DataTable GetData() { var data = new SystemEntityTypeDataModel(); data.EntityName = Request.QueryString["SearchCondition"]; var dt = Framework.Components.Core.SystemEntityTypeDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
public static string GetFullName(int systemEntityTypeId, RequestProfile requestProfile) { var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = systemEntityTypeId; var dr = GetDetails(data, requestProfile).Rows[0]; var value = dr["EntityName"].ToString() + " " + dr["EntityDescription"].ToString(); return(value); }
public static string GetFullName(int systemEntityTypeId, RequestProfile requestProfile) { var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = systemEntityTypeId; var item = GetDetails(data, requestProfile); var value = item.EntityName + " " + item.EntityDescription; return(value); }
public static bool DoesExist(SystemEntityTypeDataModel data, RequestProfile requestProfile) { var doesExistRequest = new SystemEntityTypeDataModel(); doesExistRequest.EntityName = data.EntityName; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected override void Clear() { base.Clear(); var data = new SystemEntityTypeDataModel(); SystemEntityTypeId = data.SystemEntityTypeId; EntityName = data.EntityName; EntityDescription = data.EntityDescription; NextValue = data.NextValue; CreatedDate = data.CreatedDate; PrimaryDatabase = data.PrimaryDatabase; }
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); }
public static void Delete(SystemEntityTypeDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.SystemEntityTypeDelete "; var parameters = new { AuditId = requestProfile.AuditId , SystemEntityTypeId = dataQuery.SystemEntityTypeId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static int GetNextSequenceId(string entityName, int systemEntityTypeId, RequestProfile requestProfile) { var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = systemEntityTypeId; data.EntityName = entityName; var sql = "EXEC dbo.SystemEntityTypeGetNextSequence " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.EntityName) + ", " + ToSQLParameter(data, SystemEntityTypeDataModel.DataColumns.NextValue); var newId = new DBDataTable("SystemEntityTypeGetNextSequence", sql, DataStoreKey); //var newId = int.Parse(DBDML.RunScalarSQL("SystemEntityTypeGetNextSequence", sql, DataStoreKey).ToString()); return(int.Parse(newId.DBTable.Rows[0][0].ToString())); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = int.Parse(index); Framework.Components.Core.SystemEntityTypeDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.SystemEntityType, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("SystemEntityTypeEntityRoute", new { Action = "Default", SetId = true }), false); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int systemEntityTypeId, bool showId) { // clear UI Clear(); // set up parameters var data = new SystemEntityTypeDataModel(); data.SystemEntityTypeId = systemEntityTypeId; // get data var items = Framework.Components.Core.SystemEntityTypeDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; EntityDescription = item.EntityDescription; EntityName = item.EntityName; NextValue = item.NextValue; PrimaryDatabase = item.PrimaryDatabase; CreatedDate = item.CreatedDate; if (!showId) { txtSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, systemEntityTypeId, PrimaryEntityKey); } else { txtSystemEntityTypeId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
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 { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var data = new SystemEntityTypeDataModel(); data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; var dt = Framework.Components.Core.SystemEntityTypeDataManager.Search(data, SessionVariables.RequestProfile); UIHelper.LoadDropDown(dt, drpSystemEntity, SystemEntityTypeDataModel.DataColumns.EntityName, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); //drpSystemEntity.Items.Insert(0, new ListItem("All", "-1")); } //oList.Setup("AuditHistory", " ", "AuditHistoryId", true, GetData, GetColumns, string.Empty); // myExportMenu.Setup("RecordsWithMissingHistory", String.Empty, GetData, GetColumns, String.Empty); //if (Request.QueryString["Added"] != null) // oList.SetSession(Request.QueryString["Added"]); //else if (Request.QueryString["Deleted"] != null) // oList.SetSession(Request.QueryString["Deleted"]); //else // oList.SetSession("true"); //oSearchFilter.OnSearch += oSearchFilter_OnSearch; Label lblStatus = ((Label)Master.FindControl("lblStatus")); var isTesting = SessionVariables.IsTesting; if (lblStatus != null && !(isTesting)) { lblStatus.Visible = false; } }
public static List <SystemEntityTypeDataModel> GetEntityDetails(SystemEntityTypeDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.SystemEntityTypeSearch "; var parameters = new { AuditId = requestProfile.AuditId , SystemEntityTypeId = dataQuery.SystemEntityTypeId , ApplicationMode = requestProfile.ApplicationModeId , EntityName = dataQuery.EntityName , CreatedDate = dataQuery.CreatedDate , ReturnAuditInfo = returnAuditInfo }; List <SystemEntityTypeDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <SystemEntityTypeDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static void Update(SystemEntityTypeDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("SystemEntityType.Update", sql, DataStoreKey); }
public static SystemEntityTypeDataModel GetDetails(SystemEntityTypeDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }
private Table BuildReport(int[] entities, int[] functionalities) { var edata = new SystemEntityTypeDataModel(); var edt = new DataTable(); var fdata = new FunctionalityDataModel(); var fdt = new DataTable(); var fesdata = new FunctionalityEntityStatusDataModel(); var fesdt = new DataTable(); var table = new Table(); table.CssClass = "entityreport"; table.GridLines = GridLines.Both; table.BorderColor = System.Drawing.Color.Blue; table.BorderWidth = 2; table.BorderStyle = BorderStyle.Groove; var tablerow = new TableRow(); var tablecell = new TableCell(); tablecell.Text = "Functionality/Entity"; //tablecell.Style.Add("font-weight", "bold"); //tablecell.Style.Add("width", "150px"); tablerow.Cells.Add(tablecell); for (var i = 0; i < entities.Length; i++) { edata.SystemEntityTypeId = entities[i]; edt = Framework.Components.Core.SystemEntityTypeDataManager.Search(edata, SessionVariables.RequestProfile); tablecell = new TableCell(); if (edt.Rows.Count >= 1) { tablecell.Text = edt.Rows[0][SystemEntityTypeDataModel.DataColumns.EntityName].ToString(); //tablecell.Style.Add("font-weight", "bold"); //tablecell.Style.Add("width", "150px"); tablerow.Cells.Add(tablecell); } } table.Rows.Add(tablerow); tablerow = new TableRow(); for (int j = 0; j < functionalities.Length; j++) { fdata.FunctionalityId = functionalities[j]; fdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(fdata, SessionVariables.RequestProfile); tablerow = new TableRow(); tablecell = new TableCell(); if (fdt.Rows.Count >= 1) { tablecell.Text = fdt.Rows[0][StandardDataModel.StandardDataColumns.Name].ToString(); //tablecell.Style.Add("font-weight", "bold"); //tablecell.Style.Add("width", "150px"); tablerow.Cells.Add(tablecell); } tablerow.Cells.Add(tablecell); for (int i = 1; i < table.Rows[0].Cells.Count; i++) { tablerow.Cells.Add(new TableCell()); } table.Rows.Add(tablerow); } var entity = ""; var functionality = ""; for (var i = 0; i < functionalities.Length; i++) { for (var j = 0; j < entities.Length; j++) { fesdata.SystemEntityTypeId = entities[j]; fesdata.FunctionalityId = functionalities[i]; fesdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(fesdata, SessionVariables.RequestProfile); if (fesdt.Rows.Count == 1) { fdata.FunctionalityId = functionalities[i]; fdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(fdata, SessionVariables.RequestProfile); if (fdt.Rows.Count >= 1) { functionality = fdt.Rows[0][StandardDataModel.StandardDataColumns.Name].ToString(); } edata.SystemEntityTypeId = entities[j]; edt = Framework.Components.Core.SystemEntityTypeDataManager.Search(edata, SessionVariables.RequestProfile); if (edt.Rows.Count >= 1) { entity = edt.Rows[0][SystemEntityTypeDataModel.DataColumns.EntityName].ToString(); } for (var k = 1; k < table.Rows.Count; k++) { for (int l = 1; l < table.Rows[0].Cells.Count; l++) { if (table.Rows[k].Cells[0].Text.Equals(functionality) && table.Rows[0].Cells[l].Text.Equals(entity)) { table.Rows[k].Cells[l].Text = fesdt.Rows[0][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatus].ToString(); break; } } } } } } TableReportContent.Controls.Add(table); return(table); }
public static string ToSQLParameter(SystemEntityTypeDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); } break; case SystemEntityTypeDataModel.DataColumns.EntityName: if (!string.IsNullOrEmpty(data.EntityName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemEntityTypeDataModel.DataColumns.EntityName, data.EntityName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.EntityName); } break; case SystemEntityTypeDataModel.DataColumns.EntityDescription: if (!string.IsNullOrEmpty(data.EntityDescription)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemEntityTypeDataModel.DataColumns.EntityDescription, data.EntityDescription.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.EntityDescription); } break; case SystemEntityTypeDataModel.DataColumns.PrimaryDatabase: if (!string.IsNullOrEmpty(data.PrimaryDatabase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemEntityTypeDataModel.DataColumns.PrimaryDatabase, data.PrimaryDatabase.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.PrimaryDatabase); } break; case SystemEntityTypeDataModel.DataColumns.NextValue: if (data.NextValue != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityTypeDataModel.DataColumns.NextValue, data.NextValue); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.NextValue); } break; case SystemEntityTypeDataModel.DataColumns.IncreaseBy: if (data.IncreaseBy != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityTypeDataModel.DataColumns.IncreaseBy, data.IncreaseBy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityTypeDataModel.DataColumns.IncreaseBy); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }