public ActionResult Edit(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
//DataContext db = new DataContext(@"D:\KPI\Технології створення програмних продуктів\AviaMvcApp\DB\AviaDB.mdf");
var db = new DataAirportDataContext();
var airport = db.Airport.SingleOrDefault(a => a.Id == id);
if (collection["Name"] == "")
{
return(RedirectToAction("Index"));
}
airport.Name = collection["Name"];
airport.Adress = collection["Adress"];
db.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
var db = new DataAirportDataContext();
var airport = db.Airport.SingleOrDefault(a => a.Id == id);
airport.Name = collection["Name"];
airport.Adress = collection["Adress"];
db.Airport.DeleteOnSubmit(airport);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
var db = new DataAirportDataContext();
Airport airport = new Airport();
/*var airport = db.Airport.SingleOrDefault(a => a.Id == collection["Id"]);*/
airport.Id = db.Airport.Count() + 1;
airport.Name = collection["Name"];
airport.Adress = collection["Adress"];
db.Airport.InsertOnSubmit(airport);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}