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