public static int Create(DomainModel.FieldConfiguration data, int auditId)
{
var sql = Save(data, auditId, "Create");
var fieldConfigurationId = DataAccess.DBDML.RunScalarSQL("FieldConfiguration.Insert", sql, DataStoreKey);
return(Convert.ToInt32(fieldConfigurationId));
}
public static void Delete(DomainModel.FieldConfiguration data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationDelete " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId);
DataAccess.DBDML.RunSQL("FieldConfiguration.Delete", sql, DataStoreKey);
}
private static DataSet GetChildren(DomainModel.FieldConfiguration data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationChildrenGet " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataTable GetDetails(DomainModel.FieldConfiguration data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId);
var oDT = new DataAccess.DBDataTable("FieldConfiguration.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetGridViewColumns(DomainModel.FieldConfiguration data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationGetGridViewColumns " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId);
var oDT = new DataAccess.DBDataTable("FieldConfiguration.GetGridViewColumns", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable Search(DomainModel.FieldConfiguration data, int applicationId, int auditId)
{
// formulate SQL
var sql = "EXEC dbo.FieldConfigurationSearch " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, applicationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.Name);
var oDT = new DataAccess.DBDataTable("FieldConfiguration.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static bool IsDeletable(DomainModel.FieldConfiguration data, int auditId)
{
var isDeletable = true;
var ds = GetChildren(data, auditId);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count > 0)
{
isDeletable = false;
break;
}
}
}
return(isDeletable);
}
public static string ToSQLParameter(DomainModel.FieldConfiguration data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId:
if (data.FieldConfigurationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId, data.FieldConfigurationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId);
}
break;
case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId:
if (data.FieldConfigurationModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId);
}
break;
case DomainModel.FieldConfiguration.DataColumns.Name:
if (!string.IsNullOrEmpty(data.Name))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Name, data.Name);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Name);
}
break;
case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName:
if (!string.IsNullOrEmpty(data.FieldConfigurationDisplayName))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName, data.FieldConfigurationDisplayName);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName);
}
break;
case DomainModel.FieldConfiguration.DataColumns.Value:
if (!string.IsNullOrEmpty(data.Value))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Value, data.Value);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Value);
}
break;
case DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId);
}
break;
case DomainModel.FieldConfiguration.DataColumns.Width:
if (!string.IsNullOrEmpty(data.Value))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Width, data.Width);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Width);
}
break;
case DomainModel.FieldConfiguration.DataColumns.Formatting:
if (!string.IsNullOrEmpty(data.Formatting))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Formatting, data.Formatting);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Formatting, data.Formatting);
}
break;
case DomainModel.FieldConfiguration.DataColumns.ControlType:
if (!string.IsNullOrEmpty(data.ControlType))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.ControlType, data.ControlType);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.ControlType);
}
break;
case DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment:
if (!string.IsNullOrEmpty(data.Value))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment, data.HorizontalAlignment);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment);
}
break;
case DomainModel.FieldConfiguration.DataColumns.GridViewPriority:
if (data.GridViewPriority != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.GridViewPriority, data.GridViewPriority);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.GridViewPriority);
}
break;
case DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority:
if (data.DetailsViewPriority != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority, data.DetailsViewPriority);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority);
}
break;
}
return(returnValue);
}
public static void Update(DomainModel.FieldConfiguration data, int auditId)
{
var sql = Save(data, auditId, "Update");
DataAccess.DBDML.RunSQL("FieldConfiguration.Update", sql, DataStoreKey);
}
