public ActionResult ItemMasterHeaderSaveChanges(ItemMasterHeaderDetail obj) { TBITEMMASTERHEADER objTBITEMMASTERHEADER = new TBITEMMASTERHEADER(); TBITEMMASTERDETAIL objTBITEMMASTERDETAIL = new TBITEMMASTERDETAIL(); if (obj.ITEMID > 0) { objTBITEMMASTERHEADER = dbContext.TBITEMMASTERHEADERs.Where(x => x.ITEMID == obj.ITEMID).FirstOrDefault(); objTBITEMMASTERHEADER.ITEMNAME = obj.ITEMNAME; objTBITEMMASTERHEADER.BRANDID = obj.BRANDID; objTBITEMMASTERHEADER.ITEMGROUPID = obj.ITEMGROUPID; objTBITEMMASTERHEADER.PURTAXID = obj.PURTAXID; objTBITEMMASTERHEADER.SALETAXID = obj.SALETAXID; dbContext.SaveChanges(); } else { objTBITEMMASTERHEADER.ITEMNAME = obj.ITEMNAME; objTBITEMMASTERHEADER.BRANDID = obj.BRANDID; objTBITEMMASTERHEADER.ITEMGROUPID = obj.ITEMGROUPID; objTBITEMMASTERHEADER.PURTAXID = obj.PURTAXID; objTBITEMMASTERHEADER.SALETAXID = obj.SALETAXID; dbContext.TBITEMMASTERHEADERs.Add(objTBITEMMASTERHEADER); dbContext.SaveChanges(); var ids = dbContext.TBITEMMASTERHEADERs.OrderByDescending(p => p.ITEMID).FirstOrDefault(); if (ids.ITEMID > 0) { foreach (var item in obj.tbiitemdeatil) { objTBITEMMASTERDETAIL.ITEMID = ids.ITEMID; objTBITEMMASTERDETAIL.SIZEID = item.SIZEID; objTBITEMMASTERDETAIL.PURRATE = item.PURRATE; objTBITEMMASTERDETAIL.MRP = item.MRP; objTBITEMMASTERDETAIL.SALERATE = item.SALERATE; objTBITEMMASTERDETAIL.BARCODE = item.BARCODE; objTBITEMMASTERDETAIL.BASICRATE = item.BASICRATE; dbContext.TBITEMMASTERDETAILs.Add(objTBITEMMASTERDETAIL); dbContext.SaveChanges(); } } } // dbContext.SaveChanges(); return(RedirectToAction("ItemMasterHeader")); }
public ActionResult ItemMasterHeader() { ViewBag.BrandIdList = GetBrandId(); ViewBag.ItemGrpIdList = GetItemGrupId(); ViewBag.ItemidList = GetItemId(); ViewBag.SizeidList = GetSizeId(); ViewBag.ItemMasterList = dbContext.TBITEMMASTERDETAILs.ToList(); ViewBag.ItemHeaderList = dbContext.TBITEMMASTERHEADERs.ToList(); List <TBITEMMASTERDETAIL> ci = new List <TBITEMMASTERDETAIL> { new TBITEMMASTERDETAIL { ITEMID = 0, SIZEID = 0, BARCODE = "", BASICRATE = 0, PURRATE = 0, SALERATE = 0, MRP = 0 } }; ItemMasterHeaderDetail ItemMasterHeaderDetail = new ItemMasterHeaderDetail(); ItemMasterHeaderDetail.tbiitemdeatil = ci; ViewBag.PurchaseTax = GetPurchaseTax(); ViewBag.SaleTax = GetSaleTax(); return(View(ItemMasterHeaderDetail)); }