public ActionResult Index()
{
var itemsKOT = (from p in dbKOT.PriceListEntries
join a in dbKOT.AccountMs on p.AccountM_UID equals a.UID
join i in dbKOT.AccountMItems on p.AccountMItems_UID equals i.AccountM_UID
select new {
i.ItemCode,
i.ItemName,
p.Price,
a.Description
}
).ToList();
var itemsCount = (from p in db.tblBasePriceItems select p).ToList().Count;
if (itemsKOT.Count > itemsCount)
{
foreach (var item in itemsKOT)
{
var items = (from p in db.tblItems where p.Name == item.ItemName && p.ItemCode == item.ItemCode select p).FirstOrDefault();
var itemcheck = (from p in db.tblBasePriceItems where p.ItemId == items.ItemId && p.CategoryId == items.CategoryId && p.Type == item.Description select p).SingleOrDefault();
if (itemcheck == null)
{
tblBasePriceItem tb = new tblBasePriceItem();
tb.CategoryId = items.CategoryId;
tb.ItemId = items.ItemId;
tb.FullPrice = item.Price;
tb.Type = item.Description;
if (item.Description == "Ac Hall")
{
tb.Vat = 18;
}
else
{
tb.Vat = 12;
}
db.tblBasePriceItems.Add(tb);
db.SaveChanges();
}
}
}
var BaseData = (from p in db.tblBasePriceItems select p).ToList();
List <BasePriceModel> list = new List <BasePriceModel>();
foreach (var item in BaseData)
{
BasePriceModel model = new BasePriceModel();
model.CategoryIds = item.CategoryId;
model.ItemId = item.ItemId;
model.FullPrice = item.FullPrice;
//model.HalfPrice = item.HalfPrice;
model.BasePriceId = item.BasePriceId;
model.Vat = item.Vat;
list.Add(model);
}
return(View(list));
}
public JsonResult EditBasePrice(string Id)
{
if (Id != null && Id != "")
{
string[] str = Id.Split('-');
for (var i = 0; i < str.Length; i++)
{
string[] arr = str[i].Split('_');
int id = Convert.ToInt32(arr[0]);
tblBasePriceItem tbl = db.tblBasePriceItems.Where(a => a.BasePriceId == id).FirstOrDefault();
tbl.FullPrice = Convert.ToDecimal(arr[1].Replace('^', '.'));
// tbl.HalfPrice = Convert.ToDecimal(arr[2].Replace('^', '.'));
db.SaveChanges();
}
TempData["perror"] = "Edit Successfully !!";
return(Json("Update Succefully", JsonRequestBehavior.AllowGet));
}
return(Json("Not Update", JsonRequestBehavior.AllowGet));
}
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"));
}
}
