public ActionResult CreateTable([Bind(Include = "FieldNumber, tableName, FieldTypes, FieldNames")] TableStructionDto table)
{
if (table.FieldNames is null)
{
return(View(_service.CheckNewTable(table)));
}
_service.AddTable(table);
return(RedirectToAction("Index", "Home"));
}
//Checks if new table name is valid or not.
public TableStructionDto CheckNewTable(TableStructionDto table)
{
var names = _unitOfWork.TableCreating.GetAllTableName();
//Checks if the given name is repetitive or not.
if (names.Where(w => w.Contains(table.tableName)).Any())
{
table.Message = Message.RepetitiveTableName();
table.FieldNumber = 0;
return(table);
}
table.Message = Message.AcceptableName();
return(table);
}
//Add new Table into data base.
public void AddTable(TableStructionDto table)
{
_unitOfWork.TableCreating.AddTable(table.tableName, table.FieldNames, TypeConvert.TypeExtraction(table.FieldTypes));
}
