public ActionResult Create(AddLivingSpaceview collection) { TempData["err"] = ""; try { AddNewLivingSpace(collection); return(RedirectToAction("Index")); } catch (Exception death) { TempData["err"] = death.Message; return(RedirectToAction("Index")); } }
public bool AddNewLivingSpace(AddLivingSpaceview LivingSpaceView) { string connStr = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(connStr); string sqlQuery = "INSERT INTO livingspace (`adress`, `roomNumber`, `maxCapacity`) VALUES (?adress, ?roomnumber, ?maxcapacity)"; MySqlCommand mySqlCommand = new MySqlCommand(sqlQuery, mySqlConnection); mySqlCommand.Parameters.Add("?adress", MySqlDbType.VarChar).Value = LivingSpaceView.adress; mySqlCommand.Parameters.Add("?roomnumber", MySqlDbType.Int32).Value = LivingSpaceView.roomNumber; mySqlCommand.Parameters.Add("?maxcapacity", MySqlDbType.Int32).Value = LivingSpaceView.maxCapacity; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); return(true); }
public void AddNewLivingSpace(AddLivingSpaceview collection) { int numberOfLivingSpaces = collection.roomNumber; List <LivingSpaceListView> LivingSpaceList = LivingSpaceRepos.GetLivingSpaces(); foreach (var LS in LivingSpaceList) { if (collection.adress == LS.adress) { TempData["err"] = "Address already exists."; } } if (numberOfLivingSpaces == 1) { if (collection.adress == null || collection.roomNumber == 0 || collection.maxCapacity == 0) { TempData["err"] = "Missing data."; return; } LivingSpaceRepos.AddNewLivingSpace(collection); } else { for (int i = 1; i <= numberOfLivingSpaces; i++) { if (collection.adress == null || collection.roomNumber == 0 || collection.maxCapacity == 0) { TempData["err"] = "Missing data."; return; } collection.roomNumber = i; LivingSpaceRepos.AddNewLivingSpace(collection); } } }
public ActionResult Create() { AddLivingSpaceview LivingSpaceView = new AddLivingSpaceview(); return(View(LivingSpaceView)); }