public static void Delete(NeedXFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.NeedXFeatureDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, NeedXFeatureDataModel.DataColumns.NeedXFeatureId);
DBDML.RunSQL("NeedXFeature.Delete", sql, DataStoreKey);
}
public static DataTable GetDetails(NeedXFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.NeedXFeatureSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, NeedXFeatureDataModel.DataColumns.NeedXFeatureId);
var oDT = new DBDataTable("NeedXFeature.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable Search(NeedXFeatureDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.NeedXFeatureSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, NeedXFeatureDataModel.DataColumns.NeedXFeatureId) +
", " + ToSQLParameter(data, NeedXFeatureDataModel.DataColumns.NeedId) +
", " + ToSQLParameter(data, NeedXFeatureDataModel.DataColumns.FeatureId);
var oDT = new DBDataTable("NeedXFeature.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
static public List <NeedXFeatureDataModel> GetEntityDetails(NeedXFeatureDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.NeedXFeatureSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ApplicationMode = requestProfile.ApplicationModeId
, NeedXFeatureId = dataQuery.NeedXFeatureId
, NeedId = dataQuery.NeedId
, FeatureId = dataQuery.FeatureId
};
List <NeedXFeatureDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <NeedXFeatureDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static string ToSQLParameter(NeedXFeatureDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case NeedXFeatureDataModel.DataColumns.NeedXFeatureId:
if (data.NeedXFeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NeedXFeatureDataModel.DataColumns.NeedXFeatureId, data.NeedXFeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NeedXFeatureDataModel.DataColumns.NeedXFeatureId);
}
break;
case NeedXFeatureDataModel.DataColumns.NeedId:
if (data.NeedId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NeedXFeatureDataModel.DataColumns.NeedId, data.NeedId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NeedXFeatureDataModel.DataColumns.NeedId);
}
break;
case NeedXFeatureDataModel.DataColumns.FeatureId:
if (data.FeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NeedXFeatureDataModel.DataColumns.FeatureId, data.FeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NeedXFeatureDataModel.DataColumns.FeatureId);
}
break;
case NeedXFeatureDataModel.DataColumns.Need:
if (!string.IsNullOrEmpty(data.Need))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, NeedXFeatureDataModel.DataColumns.Need, data.Need);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NeedXFeatureDataModel.DataColumns.Need);
}
break;
case NeedXFeatureDataModel.DataColumns.Feature:
if (!string.IsNullOrEmpty(data.Feature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, NeedXFeatureDataModel.DataColumns.Feature, data.Feature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NeedXFeatureDataModel.DataColumns.Feature);
}
break;
}
return(returnValue);
}
public static NeedXFeatureDataModel GetDetails(NeedXFeatureDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
return(list.FirstOrDefault());
}
