private static string Save(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.ApplicationModeXRunTimeFeatureInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.ApplicationModeXRunTimeFeatureUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId);
return(sql);
}
public static void Delete(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationModeXRunTimeFeatureDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId);
DBDML.RunSQL("ApplicationModeXRunTimeFeature.Delete", sql, DataStoreKey);
}
public static DataTable Search(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ApplicationModeXRunTimeFeatureSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId) +
", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId);
var oDT = new DBDataTable("ApplicationModeXRunTimeFeature.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
private DataTable GetRunTimeFeatureData(int applicationModeId)
{
var data = new ApplicationModeXRunTimeFeatureDataModel();
data.ApplicationModeId = applicationModeId;
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.ApplicationModeXRunTimeFeatureDataManager.Search(data, SessionVariables.RequestProfile);
var runTimeFeaturedt = TaskTimeTracker.Components.BusinessLayer.Feature.RunTimeFeatureDataManager.GetList(SessionVariables.RequestProfile);
var resultdt = runTimeFeaturedt.Clone();
var runTimeIdColumn = RunTimeFeatureDataModel.DataColumns.RunTimeFeatureId;
foreach (DataRow row in dt.Rows)
{
var rows = runTimeFeaturedt.Select(runTimeIdColumn + " = " + row[runTimeIdColumn]);
resultdt.ImportRow(rows[0]);
}
return(resultdt);
}
public static void Update(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("ApplicationModeXRunTimeFeature.Update", sql, DataStoreKey);
}
public static string ToSQLParameter(ApplicationModeXRunTimeFeatureDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId:
if (data.ApplicationModeXRunTimeFeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId, data.ApplicationModeXRunTimeFeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId);
}
break;
case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId:
if (data.ApplicationModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId, data.ApplicationModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId);
}
break;
case ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId:
if (data.RunTimeFeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId, data.RunTimeFeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId);
}
break;
case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode:
if (!string.IsNullOrEmpty(data.ApplicationMode))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode, data.ApplicationMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode);
}
break;
case ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature:
if (!string.IsNullOrEmpty(data.RunTimeFeature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature, data.RunTimeFeature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature);
}
break;
}
return(returnValue);
}
public static List <ApplicationModeXRunTimeFeatureDataModel> GetEntityDetails(ApplicationModeXRunTimeFeatureDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.ApplicationModeXRunTimeFeatureSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, ApplicationModeXRunTimeFeatureId = dataQuery.ApplicationModeXRunTimeFeatureId
, ApplicationModeId = dataQuery.ApplicationModeId
, RunTimeFeatureId = dataQuery.RunTimeFeatureId
};
List <ApplicationModeXRunTimeFeatureDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <ApplicationModeXRunTimeFeatureDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static ApplicationModeXRunTimeFeatureDataModel GetDetails(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
