public static int Create(DomainModel.FieldConfiguration data, int auditId) { var sql = Save(data, auditId, "Create"); var fieldConfigurationId = DataAccess.DBDML.RunScalarSQL("FieldConfiguration.Insert", sql, DataStoreKey); return(Convert.ToInt32(fieldConfigurationId)); }
public static void Delete(DomainModel.FieldConfiguration data, int auditId) { var sql = "EXEC dbo.FieldConfigurationDelete " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId); DataAccess.DBDML.RunSQL("FieldConfiguration.Delete", sql, DataStoreKey); }
private static DataSet GetChildren(DomainModel.FieldConfiguration data, int auditId) { var sql = "EXEC dbo.FieldConfigurationChildrenGet " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId); var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }
public static DataTable GetDetails(DomainModel.FieldConfiguration data, int auditId) { var sql = "EXEC dbo.FieldConfigurationDetails " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId); var oDT = new DataAccess.DBDataTable("FieldConfiguration.Details", sql, DataStoreKey); return(oDT.DBTable); }
public static DataTable GetGridViewColumns(DomainModel.FieldConfiguration data, int auditId) { var sql = "EXEC dbo.FieldConfigurationGetGridViewColumns " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId); var oDT = new DataAccess.DBDataTable("FieldConfiguration.GetGridViewColumns", sql, DataStoreKey); return(oDT.DBTable); }
public static DataTable Search(DomainModel.FieldConfiguration data, int applicationId, int auditId) { // formulate SQL var sql = "EXEC dbo.FieldConfigurationSearch " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, applicationId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.Name); var oDT = new DataAccess.DBDataTable("FieldConfiguration.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static bool IsDeletable(DomainModel.FieldConfiguration data, int auditId) { var isDeletable = true; var ds = GetChildren(data, auditId); if (ds != null && ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { isDeletable = false; break; } } } return(isDeletable); }
public static string ToSQLParameter(DomainModel.FieldConfiguration data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId: if (data.FieldConfigurationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId, data.FieldConfigurationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationId); } break; case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId: if (data.FieldConfigurationModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationModeId); } break; case DomainModel.FieldConfiguration.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Name); } break; case DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName: if (!string.IsNullOrEmpty(data.FieldConfigurationDisplayName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName, data.FieldConfigurationDisplayName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.FieldConfigurationDisplayName); } break; case DomainModel.FieldConfiguration.DataColumns.Value: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Value, data.Value); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Value); } break; case DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId); } break; case DomainModel.FieldConfiguration.DataColumns.Width: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Width, data.Width); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.Width); } break; case DomainModel.FieldConfiguration.DataColumns.Formatting: if (!string.IsNullOrEmpty(data.Formatting)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Formatting, data.Formatting); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.Formatting, data.Formatting); } break; case DomainModel.FieldConfiguration.DataColumns.ControlType: if (!string.IsNullOrEmpty(data.ControlType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.ControlType, data.ControlType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.ControlType); } break; case DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment, data.HorizontalAlignment); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.HorizontalAlignment); } break; case DomainModel.FieldConfiguration.DataColumns.GridViewPriority: if (data.GridViewPriority != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.GridViewPriority, data.GridViewPriority); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.GridViewPriority); } break; case DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority: if (data.DetailsViewPriority != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority, data.DetailsViewPriority); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfiguration.DataColumns.DetailsViewPriority); } break; } return(returnValue); }
public static void Update(DomainModel.FieldConfiguration data, int auditId) { var sql = Save(data, auditId, "Update"); DataAccess.DBDML.RunSQL("FieldConfiguration.Update", sql, DataStoreKey); }