public ActionResult delete(int id)
{
using (var db = new xyzContext())
{
tbl_order order1 = db.tbl_order.Find(id);
db.tbl_order.Remove(order1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
// GET: Order
public ActionResult Index()
{
try
{
xyzContext db = new xyzContext();
//List<tbl_order> lista = db.tbl_order.ToList();
return(View(db.tbl_order.ToList()));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult edit(int id)
{
try
{
using (var db = new xyzContext())
{
//tbl_order order = db.tbl_order.Where(o => o.id == id).FirstOrDefault();
tbl_order order1 = db.tbl_order.Find(id);
return(View(order1));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult add(tbl_order order)
{
Rule rules = new Rule(order.day, order.request, order.typeVehicle, order.quantity);
if (!ModelState.IsValid)
{
return(View());
}
try
{
using (var db = new xyzContext())
{
db.tbl_order.Add(order);
db.SaveChanges();
}
using (var db1 = new xyzContext())
{
tbl_order order1 = new tbl_order();
rules.order();
order.day = rules.AssignedDay;
order.quantity = rules.QuantityAvalible;
order.request = rules.Request;
order.typeVehicle = rules.TypeVehicle;
order1 = order;
db1.tbl_order.Add(order1);
db1.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError("Error al crear", ex.Message);
return(View());
}
}
public ActionResult edit(tbl_order order)
{
try
{
using (var db = new xyzContext())
{
tbl_order order1 = db.tbl_order.Find(order.id);
order1.day = order.day;
order1.request = order.request;
order1.typeVehicle = order.typeVehicle;
order1.quantity = order.quantity;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
throw;
}
}