public static int Create(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = Save(data, auditId, "Create");
var id = DataAccess.DBDML.RunScalarSQL("UserPreferenceCategory.Insert", sql, DataStoreKey);
return(Convert.ToInt32(id));
}
public static int?DoesExist(DomainModel.UserPreferenceCategory data, int auditId)
{
var key = auditId + ", " + data.ToURLQuery();
if (UserPreferenceCategoryCache.ContainsKey(key))
{
return(UserPreferenceCategoryCache[key]);
}
var sql = "EXEC dbo.UserPreferenceCategoryDoesExist " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.Name) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
var oDT = new DataAccess.DBDataTable("UserPreferenceCategory.DoesExist", sql, DataStoreKey);
var dt = oDT.DBTable;
if (dt != null && dt.Rows.Count > 0)
{
var id = (int)dt.Rows[0][DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId];
UserPreferenceCategoryCache.Add(key, id);
return(id);
}
return(null);
}
public static List <DomainModel.UserPreferenceCategory> GetEntityDetails(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceCategoryDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
var result = new List <DomainModel.UserPreferenceCategory>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new DomainModel.UserPreferenceCategory();
dataItem.UserPreferenceCategoryId = (int)dbReader[DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId];
dataItem.Name = dbReader[DomainModel.UserPreferenceCategory.DataColumns.Name].ToString();
dataItem.Description = dbReader[DomainModel.UserPreferenceCategory.DataColumns.Description].ToString();
dataItem.SortOrder = (int)dbReader[DomainModel.UserPreferenceCategory.DataColumns.SortOrder];
SetBaseInfo(dataItem, dbReader);
result.Add(dataItem);
}
}
return(result);
}
private static string Save(DomainModel.UserPreferenceCategory data, int auditId, string sqlcmd)
{
var sql = "EXEC ";
switch (sqlcmd)
{
case "Create":
sql += "dbo.UserPreferenceCategoryInsert " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
break;
case "Update":
sql += "dbo.UserPreferenceCategoryUpdate " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.Name) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.Description) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.SortOrder);
return(sql);
}
public static void Delete(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceCategoryDelete " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
DataAccess.DBDML.RunSQL("UserPreferenceCategory.Delete", sql, DataStoreKey);
}
public static DataTable GetDetails(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceCategoryDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
var oDT = new DataAccess.DBDataTable("UserPreferenceCategory.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
private static DataSet GetChildren(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceCategoryChildrenGet " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataTable Search(DomainModel.UserPreferenceCategory data, int auditId)
{
// formulate SQL
var sql = "EXEC dbo.UserPreferenceCategorySearch " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.Name);
var oDT = new DataAccess.DBDataTable("UserPreferenceCategory.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static bool IsDeletable(DomainModel.UserPreferenceCategory 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.UserPreferenceCategory data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId:
if (data.UserPreferenceCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId, data.UserPreferenceCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
}
break;
default:
returnValue = StandardClass.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(DomainModel.UserPreferenceCategory data, int auditId)
{
var sql = Save(data, auditId, "Update");
DataAccess.DBDML.RunSQL("UserPreferenceCategory.Update", sql, DataStoreKey);
}
