private DataTable GetTaskData(int featureId)
{
var data = new FeatureXTaskDataModel();
data.FeatureId = featureId;
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXTaskDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static DataTable Search(FeatureXTaskDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FeatureXTaskSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FeatureXTaskDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, FeatureXTaskDataModel.DataColumns.TaskId);
var oDT = new DBDataTable("FeatureXTask.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByFeature(int featureId, int auditId)
{
FeatureXTaskDataModel data = new FeatureXTaskDataModel();
data.FeatureId = featureId;
//var sql = "EXEC FeatureXTaskSearch @FeatureId =" + featureId + ", " +
// "@AuditId =" + auditId;
var sql = "EXEC dbo.FeatureXTaskSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, FeatureXTaskDataModel.DataColumns.FeatureId);
var oDT = new DBDataTable("FeatureXTask.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static string ToSQLParameter(FeatureXTaskDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FeatureXTaskDataModel.DataColumns.FeatureXTaskId:
if (data.FeatureXTaskId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXTaskDataModel.DataColumns.FeatureXTaskId, data.FeatureXTaskId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXTaskDataModel.DataColumns.FeatureXTaskId);
}
break;
case FeatureXTaskDataModel.DataColumns.TaskId:
if (data.TaskId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXTaskDataModel.DataColumns.TaskId, data.TaskId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXTaskDataModel.DataColumns.TaskId);
}
break;
case FeatureXTaskDataModel.DataColumns.FeatureId:
if (data.FeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXTaskDataModel.DataColumns.FeatureId, data.FeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXTaskDataModel.DataColumns.FeatureId);
}
break;
case FeatureXTaskDataModel.DataColumns.Task:
if (!string.IsNullOrEmpty(data.Task))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FeatureXTaskDataModel.DataColumns.Task, data.Task);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXTaskDataModel.DataColumns.Task);
}
break;
case FeatureXTaskDataModel.DataColumns.Feature:
if (!string.IsNullOrEmpty(data.Feature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FeatureXTaskDataModel.DataColumns.Feature, data.Feature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXTaskDataModel.DataColumns.Feature);
}
break;
}
return(returnValue);
}
