public ActionResult DeleteAvlblKit(tbl_eqpmt_kits_avlbl avlblKitDelete)
{
tbl_eqpmt_kits_avlbl tbl_eqpmt_kits_avlbl = db.tbl_eqpmt_kits_avlbl.Find(avlblKitDelete.id);
db.tbl_eqpmt_kits_avlbl.Remove(tbl_eqpmt_kits_avlbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddAvlblKit(tbl_eqpmt_kits_avlbl avlblKitAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_eqpmt_kits_avlbl.Add(new tbl_eqpmt_kits_avlbl()
{
eqpmtType = avlblKitAdd.eqpmtType,
kitID = avlblKitAdd.kitID
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateAvlblKit(tbl_eqpmt_kits_avlbl avlblKitUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_eqpmt_kits_avlbl updatedAvlblKit = (from c in entities.tbl_eqpmt_kits_avlbl
where c.id == avlblKitUpdate.id
select c).FirstOrDefault();
updatedAvlblKit.eqpmtType = avlblKitUpdate.eqpmtType;
updatedAvlblKit.kitID = avlblKitUpdate.kitID;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateAvlblKit(tbl_eqpmt_kits_avlbl avlblKitUpdate)
{
db.Database.ExecuteSqlCommand("UPDATE cmps411.tbl_eqpmt_kits_avlbl SET eqpmtType={0},model={1},kitID={2} WHERE id={3}",
avlblKitUpdate.eqpmtType, avlblKitUpdate.model, avlblKitUpdate.kitID, avlblKitUpdate.id);
return(new EmptyResult());
}
public ActionResult DeleteAvlblKit(tbl_eqpmt_kits_avlbl avlblKitDelete)
{
db.Database.ExecuteSqlCommand("DELETE FROM cmps411.tbl_eqpmt_kits_avlbl WHERE id=({0})", avlblKitDelete.id);
return(RedirectToAction("Index"));
}
public ActionResult AddAvlblKit(tbl_eqpmt_kits_avlbl avlblKitAdd)
{
db.Database.ExecuteSqlCommand("Insert into cmps411.tbl_eqpmt_kits_avlbl Values({0},{1},{2})",
avlblKitAdd.eqpmtType, avlblKitAdd.model, avlblKitAdd.kitID);
return(RedirectToAction("Index"));
}
