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