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