public void Validate(Enums.ValidationTypes validationType) { AjaxService.ASPdatabaseService.GetSetVal(); if (String.IsNullOrEmpty(this.Schema)) { throw new Exception("Schema is empty."); } if (String.IsNullOrEmpty(this.TableName)) { throw new Exception("TableName is empty."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.TableName, true); if (validationType == Enums.ValidationTypes.NotSet || validationType == Enums.ValidationTypes.Select || validationType == Enums.ValidationTypes.Create) { if (this.Columns == null || this.Columns.Length < 1) { throw new Exception("No columns specified."); } } if (validationType == Enums.ValidationTypes.Update || validationType == Enums.ValidationTypes.Drop) { if (String.IsNullOrEmpty(this.IndexName)) { throw new Exception("IndexName value not provided."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.IndexName, true); } }
public void Validate(Enums.ValidationTypes validationType) { AjaxService.ASPdatabaseService.GetSetVal(); this.ColumnName = this.ColumnName.Trim(); this.DataType = this.DataType.Trim(); if (this.DefaultValue != null) { this.DefaultValue = this.DefaultValue.Trim(); } }
public void Validate(Enums.ValidationTypes validationType) { AjaxService.ASPdatabaseService.GetSetVal(); if (validationType == Enums.ValidationTypes.Create) { if (String.IsNullOrEmpty(this.ForeignKey_Schema)) { throw new Exception("ForeignKey_Schema is empty."); } if (String.IsNullOrEmpty(this.ForeignKey_TableName)) { throw new Exception("ForeignKey_TableName is empty."); } if (String.IsNullOrEmpty(this.PrimaryKey_Schema)) { throw new Exception("PrimaryKey_Schema is empty."); } if (String.IsNullOrEmpty(this.PrimaryKey_TableName)) { throw new Exception("PrimaryKey_TableName is empty."); } if (this.Columns == null || this.Columns.Length < 1) { throw new Exception("No columns specified."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.ForeignKey_Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.ForeignKey_TableName, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.PrimaryKey_Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.PrimaryKey_TableName, true); } else if (validationType == Enums.ValidationTypes.Drop) { if (String.IsNullOrEmpty(this.ForeignKey_Schema)) { throw new Exception("ForeignKey_Schema is empty."); } if (String.IsNullOrEmpty(this.ForeignKey_TableName)) { throw new Exception("ForeignKey_TableName is empty."); } if (String.IsNullOrEmpty(this.ConstraintName)) { throw new Exception("ForeignKey value not provided."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.ForeignKey_Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.ForeignKey_TableName, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.ConstraintName, true); } }
public void Validate(Enums.ValidationTypes validationType) { if (validationType == Enums.ValidationTypes.Create) { if (String.IsNullOrEmpty(this.Schema)) { throw new Exception("Schema is empty."); } if (String.IsNullOrEmpty(this.TableName)) { throw new Exception("TableName is empty."); } if (this.Columns == null || this.Columns.Length < 1) { throw new Exception("No columns specified."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.TableName, true); } else if (validationType == Enums.ValidationTypes.Drop) { if (String.IsNullOrEmpty(this.Schema)) { throw new Exception("Schema value not provided."); } if (String.IsNullOrEmpty(this.TableName)) { throw new Exception("TableName value not provided."); } if (String.IsNullOrEmpty(this.ConstraintName)) { throw new Exception("ConstraintName value not provided."); } ASPdb.Framework.Validation.ValidateTextForSql1(this.Schema, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.TableName, true); ASPdb.Framework.Validation.ValidateTextForSql1(this.ConstraintName, true); } }
public void Validate(Enums.ValidationTypes validationType) { }