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