private static string CreateOrUpdate(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.SystemEntityXSystemEntityCategoryInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.SystemEntityXSystemEntityCategoryUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategoryId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityId); return(sql); }
public static void Delete(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.SystemEntityXSystemEntityCategoryDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId); DBDML.RunSQL("SystemEntityXSystemEntityCategory.Delete", sql, DataStoreKey); }
public static DataTable GetDetails(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.SystemEntityXSystemEntityCategorySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, ReturnAuditInfoOnDetails) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId); var oDT = new DBDataTable("SystemEntityXSystemEntityCategory.Details", sql, DataStoreKey); return(oDT.DBTable); }
public static DataTable Search(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.SystemEntityXSystemEntityCategorySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityId) + ", " + ToSQLParameter(data, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategoryId); var oDT = new DBDataTable("SystemEntityXSystemEntityCategory.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static void Update(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("SystemEntityXSystemEntityCategory.Update", sql, DataStoreKey); }
public static string ToSQLParameter(SystemEntityXSystemEntityCategoryDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId: if (data.SystemEntityXSystemEntityCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId, data.SystemEntityXSystemEntityCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityXSystemEntityCategoryId); } break; case SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityId: if (data.SystemEntityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityId, data.SystemEntityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityId); } break; case SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategoryId: if (data.SystemEntityCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategoryId, data.SystemEntityCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategoryId); } break; case SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntity: if (!string.IsNullOrEmpty(data.SystemEntity)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntity, data.SystemEntity); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntity); } break; case SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategory: if (!string.IsNullOrEmpty(data.SystemEntityCategory)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategory, data.SystemEntityCategory); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemEntityXSystemEntityCategoryDataModel.DataColumns.SystemEntityCategory); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static List <SystemEntityXSystemEntityCategoryDataModel> GetEntityDetails(SystemEntityXSystemEntityCategoryDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.SystemEntityXSystemEntityCategorySearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , SystemEntityXSystemEntityCategoryId = dataQuery.SystemEntityXSystemEntityCategoryId , SystemEntityCategoryId = dataQuery.SystemEntityCategoryId , SystemEntityId = dataQuery.SystemEntityId }; List <SystemEntityXSystemEntityCategoryDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <SystemEntityXSystemEntityCategoryDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static SystemEntityXSystemEntityCategoryDataModel GetDetails(SystemEntityXSystemEntityCategoryDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }