public void InsertRehabCenters(RehabCenters rehabCentersToInsert)
{
{
_conn.Execute("INSERT INTO RehabCenters (ID, NAME, ADDRESS, PHONENUMBER, WEBSITE, SPECIALTY, SPECIALTYID) VALUES (@id, @name, @address, @phonenumber, @website, @specialty, @specialtyID);",
new { name = rehabCentersToInsert.Name, address = rehabCentersToInsert.Address,
ID = rehabCentersToInsert.ID, phoneNumber = rehabCentersToInsert.PhoneNumber,
website = rehabCentersToInsert.Website, specialty = rehabCentersToInsert.Specialty,
specialtyID = rehabCentersToInsert.SpecialtyID });
}
;
}
public IActionResult UpdateProduct(int id)
{
RehabCenters rehab = repo.GetRehabCenters(id);
repo.UpdateRehabCenters(rehab);
if (rehab == null)
{
return(View("ProductNotFound"));
}
return(View(rehab));
}
public IActionResult DeleteRehabCenters(RehabCenters rehabCenters)
{
repo.DeleteRehabCenters(rehabCenters);
return(RedirectToAction("Index"));
}
public IActionResult InsertRehabCentersToDatabase(RehabCenters rehabCentersToInsert)
{
repo.InsertRehabCenters(rehabCentersToInsert);
return(RedirectToAction("Index"));
}
public IActionResult InsertRehabCenters()
{
var rehab = new RehabCenters();
return(View(rehab));
}
public IActionResult UpdateRehabCentersToDatabase(RehabCenters rehabCenters)
{
repo.UpdateRehabCenters(rehabCenters);
return(RedirectToAction("ViewRehabCenters", new { id = rehabCenters.ID }));
}
public void DeleteRehabCenters(RehabCenters rehabCenters)
{
_conn.Execute("DELETE FROM RehabCenters WHERE ID = @id;",
new { id = rehabCenters.ID });
}
//public IEnumerable<Category> GetCategories(string specialtyID)
//{
// return _conn.Query<Category>("SELECT * FROM RehabCenters WHERE SpecialtyID = @specialtyID;");
//}
//public RehabCenters AssignCategory()
//{
// var categoryList = GetCategories();
// var rehabCenters = new RehabCenters();
// rehabCenters.Categories = categoryList;
// return rehabCenters;
//}
public void UpdateRehabCenters(RehabCenters rehabCenters)
{
_conn.Execute("UPDATE RehabCenters SET Name = @name WHERE ID = @id",
new { name = rehabCenters.Name, website = rehabCenters.Website, id = rehabCenters.ID });
}
