public ActionResult Create(int Id = 0, string AcType = "") { IEnumerable <SelectListItem> list = new SelectList(new[] { new { Value = "Ac Hall", Text = "Ac Hall" }, new { Value = "Dine In Hall", Text = "Dine In Hall" }, new { Value = "Door Delivery Hall", Text = "Door Delivery Hall" }, new { Value = "Take Away Hall", Text = "Take Away Hall" }, new { Value = "Door Delivery Hall", Text = "Door Delivery Hall" }, new { Value = "Counter Hall", Text = "Counter Hall" }, }, "Value", "Text", "Ac Hall"); ViewBag.AcType = new SelectList(list, "Value", "Text"); IEnumerable <SelectListItem> Categorylist = (from q in db.tblCategories where q.Active == true select q).AsEnumerable().Select(q => new SelectListItem() { Text = q.Name, Value = q.CategoryId.ToString() }); ViewBag.Categorylists = new SelectList(Categorylist, "Value", "Text"); BasePriceEditModel model = new BasePriceEditModel(); if (Id != 0 && AcType != null) { model.CategoryId = Id; model.Type = AcType; List <GetAllItemList> lst = dis.BaseItemwise(Id, AcType); model.getAllItemList = lst; } return(View(model)); }
public ActionResult Edit(int id = 0) { var Editdata = (from p in db.tblBasePriceItems where p.CategoryId == id select p).ToList(); var Category = (from p in db.tblCategories where p.CategoryId == id select new { CategoryId = p.CategoryId, CategoryName = p.Name }).SingleOrDefault(); BasePriceEditModel model = new BasePriceEditModel(); model.CategoryId = Category.CategoryId; model.CategoryName = Category.CategoryName; List <GetAllItemList> lst = new List <GetAllItemList>(); foreach (var item in Editdata) { GetAllItemList list = new GetAllItemList(); list.FullPrice = item.FullPrice; //list.HalfPrice = item.HalfPrice; list.ItemId = item.ItemId; list.ItemName = item.tblItem.Name; lst.Add(list); } model.getAllItemList = lst; return(View(model)); }
public ActionResult EditBasePrice(BasePriceEditModel model) { try { for (int i = 0; i < model.EditItemId.Length; i++) { int obj = model.EditItemId[i]; tblBasePriceItem tb = (from p in db.tblBasePriceItems where p.ItemId == obj && p.CategoryId == model.CategoryId select p).SingleOrDefault(); tb.FullPrice = model.EditFullPrice[i]; //tb.HalfPrice = model.EditHalfPrice[i]; db.SaveChanges(); TempData["perror"] = "Record Updated Successfully....."; } } catch (Exception ex) { TempData["perror"] = ex.Message; } return(RedirectToAction("Index", "BasePrice")); }
public ActionResult Create(BasePriceEditModel model) { try { for (int i = 0; i < model.EditItemId.Length; i++) { int ItemId = model.EditItemId[i]; var tb = (from p in db.tblBasePriceItems where p.ItemId == ItemId && p.CategoryId == model.CategoryId && p.Type == model.Type select p).SingleOrDefault(); if (tb == null) { if (model.Type == "Ac Hall") { tblBasePriceItem tbl = new tblBasePriceItem(); tbl.ItemId = model.EditItemId[i]; tbl.FullPrice = model.EditFullPrice[i]; //tbl.HalfPrice = model.EditHalfPrice[i]; tbl.Vat = 18;//Convert.ToDecimal(model.EditVat[i]); tbl.CategoryId = model.CategoryId; tbl.Type = model.Type; db.tblBasePriceItems.Add(tbl); db.SaveChanges(); } else { tblBasePriceItem tblnon = new tblBasePriceItem(); tblnon.ItemId = model.EditItemId[i]; tblnon.FullPrice = model.EditFullPrice[i]; //tblnon.HalfPrice = model.EditHalfPrice[i]; tblnon.Vat = 12;//Convert.ToDecimal(model.EditVat[i]); tblnon.CategoryId = model.CategoryId; tblnon.Type = model.Type; db.tblBasePriceItems.Add(tblnon); db.SaveChanges(); } } else { if (model.Type == "Ac Hall") { var tbAC = (from p in db.tblBasePriceItems where p.ItemId == ItemId && p.CategoryId == model.CategoryId && p.Type == model.Type select p).SingleOrDefault(); tbAC.Type = model.Type; tbAC.FullPrice = model.EditFullPrice[i]; //tbAC.HalfPrice = model.EditHalfPrice[i]; tbAC.Vat = 18;//Convert.ToDecimal(model.EditVat[i]); db.SaveChanges(); } else { var tbNonAC = (from p in db.tblBasePriceItems where p.ItemId == ItemId && p.CategoryId == model.CategoryId && p.Type == model.Type select p).SingleOrDefault(); tbNonAC.Type = model.Type; tbNonAC.FullPrice = model.EditFullPrice[i]; //tbNonAC.HalfPrice = model.EditHalfPrice[i]; tbNonAC.Vat = 12;//Convert.ToDecimal(model.EditVat[i]); db.SaveChanges(); } } } TempData["perror"] = "Record Saved Successfully..."; return(RedirectToAction("Index", "BasePrice")); } catch (Exception ex) { TempData["Berror"] = ex.Message; return(RedirectToAction("Create", "BasePrice")); } }