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); }