public ActionResult Edit(TennatModel t) { if (ModelState.IsValid) { TennatModel newTennat = new TennatModel { ID = t.ID, FullName = t.FullName, HasKids = t.HasKids, HasPets = t.HasPets, Payment = t.Payment }; //string sql = $"UPDATE dbo.Bills SET Name = '{newTennat.Name}', " + // $"Amount= {newTennat.Amount}, " + // $"DueDate= '{newTennat.DueDate.ToShortDateString()}' " + // $"WHERE ID = {newTennat.ID}"; string sql = $"UPDATE dbo.Tennats SET FullName = '{newTennat.FullName}'," + $"HasKids = '{newTennat.HasKids}', HasPets = '{newTennat.HasPets}'," + $"Payment = {newTennat.Payment}" + $"WHERE ID = { newTennat.ID }"; SqlDataAccess.SaveData(sql, newTennat); return(RedirectToAction("LoadTennats")); } return(View()); }
public ActionResult Create(TennatModel t) { if (ModelState.IsValid) { DataProcessor.CreateTennat(t.FullName, t.HasKids, t.HasPets, t.Payment); return(RedirectToAction("LoadTennats")); } return(View()); }
public ActionResult Delete(TennatModel t) { //TODO Why does this have to be declared explicitly in the view, but Bill Does not??? if (ModelState.IsValid) { //? I think this can be simplified since we already have the full name (Same for the bill) TennatModel tennatToDelete = new TennatModel { ID = t.ID, FullName = t.FullName, HasKids = t.HasKids, HasPets = t.HasPets, Payment = t.Payment }; //TODO all this is redundant??? or do we need it for the save data function? string sql = $"DELETE FROM dbo.Tennats WHERE FullName = '{tennatToDelete.FullName}'"; SqlDataAccess.SaveData(sql, tennatToDelete); return(RedirectToAction("LoadTennats")); } return(View()); }