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 List <GetAllItemList> BaseItemwise(int Id, string AcType)
{
var result = (from p in db.tblItems
join q in db.tblBasePriceItems
on p.ItemId equals q.ItemId into record
from q in record.DefaultIfEmpty()
where (p.CategoryId == Id)
select new
{
ItemId = p.ItemId,
Name = p.Name,
//Vat = (q.AcType == null) ? 0 : (q.AcType == "AC") ? 18 : 12 , //(q.Vat == null) ? 0 : q.Vat,
FullPrice = (q.FullPrice == null) ? 0 : q.FullPrice,
//HalfPrice = (q.HalfPrice == null) ? 0 : q.HalfPrice,
AcType = (q.Type == null) ? "" : q.Type,
});
List <GetAllItemList> lst = new List <GetAllItemList>();
foreach (var item in result)
{
if (item.AcType == "" || item.AcType == AcType)
{
GetAllItemList model = new GetAllItemList();
model.FullPrice = item.FullPrice;
//model.HalfPrice = item.HalfPrice;
model.ItemId = item.ItemId;
model.ItemName = item.Name;
//model.Vat = Convert.ToDecimal(item.Vat);
lst.Add(model);
}
}
return(lst);
}
