public ActionResult Accessories()
{
int PracticeID = Convert.ToInt32(Session["sespracticeid"]);
IEnumerable<EquipmentAccessories> model;
var EquipID = 0;
if (Session["EQUIPID"] != null)
{
EquipID = Convert.ToInt32(Session["EQUIPID"]);
model = (from p in objDbContext.EquipmentAccessorys
where p.StatusID == 1 && p.equip.PracticeID == PracticeID && p.EquipID == EquipID
select p).ToList();
if (EquipID == 4)
model = (from p in objDbContext.EquipmentAccessorys
where p.StatusID == 1 && p.equip.PracticeID == PracticeID
select p).ToList();
}
else
{
model = (from p in objDbContext.EquipmentAccessorys
where p.StatusID == 1 && p.equip.PracticeID == PracticeID
select p).ToList();
}
var objEquip1 = (from v in objDbContext.Equipments
where v.StatusID == 1 && v.PracticeID == PracticeID
select v).ToList();
ViewBag.EquipID = new SelectList(objEquip1, "EquipID", "Equip_Name", objDbContext.Equipments.First());
Equipment eq = new Equipment();
eq.EquipID = 4;
eq.Equip_Name = "Select All";
var objEquip = (from v in objDbContext.Equipments
where v.StatusID == 1 && v.PracticeID == PracticeID
select v).ToList();
//ViewBag.EquipID = new SelectList(objEquip, "EquipID", "Equip_Name", objDbContext.Equipments.First());
objEquip.Insert(0, eq);
if (Session["EQUIPID"] == null)
ViewBag.EquipID1 = new SelectList(objEquip, "EquipID", "Equip_Name", objDbContext.Equipments.First());
else
ViewBag.EquipID1 = new SelectList(objEquip, "EquipID", "Equip_Name", EquipID);
return View(model);
}
/////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
public JsonResult GetPracticeEquipments(Equipment objEquip)
{
var objParcticeEquipments = (from p in objDBContext.Equipments
where p.PracticeID == objEquip.PracticeID
select p).ToList();
return Json(objParcticeEquipments, JsonRequestBehavior.AllowGet);
}
public JsonResult GetEquipmentAccessories(Equipment objEquip)
{
var objEquipAccessories = (from p in objDBContext.vwEquipmentAccessoriesList
where p.EquipID == objEquip.EquipID
select p).ToList();
return Json(objEquipAccessories,JsonRequestBehavior.AllowGet);
}
public ActionResult CreateEquipent(Equipment objEquip)
{
Equipment objNewEquip = new Equipment();
objNewEquip.Equip_Name = objEquip.Equip_Name;
objNewEquip.Manufacturer = objEquip.Manufacturer;
objNewEquip.Model = objEquip.Model;
objNewEquip.Quantity = objEquip.Quantity;
objNewEquip.QuantityonHand = objEquip.QuantityonHand;
objNewEquip.PracticeID = Convert.ToInt32(Session["sespracticeid"]);
objNewEquip.StatusID = 1;
objDbContext.Equipments.Add(objNewEquip);
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult GetEquipentData(Equipment objEquip)
{
var EquipmentsList = (from p in objDbContext.Equipments
where p.EquipID == objEquip.EquipID
select p).ToList();
return Json(EquipmentsList);
}
public ActionResult EditEquipent(Equipment objEquip)
{
Equipment EquipmentsList = (from p in objDbContext.Equipments
where p.EquipID == objEquip.EquipID
select p).FirstOrDefault();
EquipmentsList.Equip_Name = objEquip.Equip_Name;
EquipmentsList.Manufacturer = objEquip.Manufacturer;
EquipmentsList.Model = objEquip.Model;
EquipmentsList.Quantity = objEquip.Quantity;
EquipmentsList.QuantityonHand = objEquip.QuantityonHand;
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult DeleteEquipent(Equipment objEquip)
{
Equipment EquipmentsList = (from p in objDbContext.Equipments
where p.EquipID == objEquip.EquipID
select p).FirstOrDefault();
EquipmentsList.StatusID = 2;
IEnumerable<EquipmentAccessories> equipAcc = (from v in objDbContext.EquipmentAccessorys
where v.EquipID == objEquip.EquipID
select v).ToList();
foreach (var acc in equipAcc)
{
acc.StatusID = 2;
}
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}