private static string CreateOrUpdate(ReportXReportCategoryDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.ReportXReportCategoryInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.ReportXReportCategoryUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId) +
", " + ToSQLParameter(data, ReportXReportCategoryDataModel.DataColumns.ReportCategoryId) +
", " + ToSQLParameter(data, ReportXReportCategoryDataModel.DataColumns.ReportId);
return(sql);
}
public static void Delete(ReportXReportCategoryDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReportXReportCategoryDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId);
DBDML.RunSQL("ReportXReportCategory.Delete", sql, DataStoreKey);
}
public static DataTable GetDetails(ReportXReportCategoryDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReportXReportCategorySearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId);
var oDT = new DBDataTable("ReportXReportCategory.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static List <ReportXReportCategoryDataModel> GetEntityDetails(ReportXReportCategoryDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.ReportXReportCategorySearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, ReportXReportCategoryId = dataQuery.ReportXReportCategoryId
, ReportCategoryId = dataQuery.ReportCategoryId
, ReportId = dataQuery.ReportId
};
List <ReportXReportCategoryDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <ReportXReportCategoryDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static string ToSQLParameter(ReportXReportCategoryDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId:
if (data.ReportXReportCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId, data.ReportXReportCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId);
}
break;
case ReportXReportCategoryDataModel.DataColumns.ReportId:
if (data.ReportId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportId, data.ReportId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportId);
}
break;
case ReportXReportCategoryDataModel.DataColumns.ReportCategoryId:
if (data.ReportCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportCategoryId, data.ReportCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportCategoryId);
}
break;
case ReportXReportCategoryDataModel.DataColumns.Report:
if (!string.IsNullOrEmpty(data.Report))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportXReportCategoryDataModel.DataColumns.Report, data.Report);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.Report);
}
break;
case ReportXReportCategoryDataModel.DataColumns.ReportCategory:
if (!string.IsNullOrEmpty(data.ReportCategory))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportXReportCategoryDataModel.DataColumns.ReportCategory, data.ReportCategory);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportCategory);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(ReportXReportCategoryDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("ReportXReportCategory.Update", sql, DataStoreKey);
}
public static ReportXReportCategoryDataModel GetDetails(ReportXReportCategoryDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
