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