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"));
}
}
