public ActionResult Create(AllModel model, HttpPostedFileBase[] inputfile) { if (model.tblStockCodArray != null) { var stoclF = new stockcod { CodeLanguage = model.tblStockCodArray[0].CodeLanguage.ToLower(), STOCKNAME = model.tblStockCodArray[0].STOCKNAME, STOCKCODE = model.tblStockCodArray[0].STOCKCODE, CREATED = DateTime.Now, LASTCHANGE = DateTime.Now }; db.stockcods.Add(stoclF); db.SaveChanges(); var updateItem = db.stockcods.Find(stoclF.STOCKNO); updateItem.IdCurrentItem = stoclF.STOCKNO; db.Entry(updateItem).State = EntityState.Modified; db.SaveChanges(); foreach (var item in model.tblStockCodArray.Skip(1).ToList()) { var tblStore = new stockcod { CodeLanguage = item.CodeLanguage.ToLower(), IdCurrentItem = stoclF.IdCurrentItem, STOCKNAME = item.STOCKNAME, STOCKCODE = item.STOCKCODE, CREATED = stoclF.CREATED, LASTCHANGE = stoclF.LASTCHANGE }; db.stockcods.Add(tblStore); } db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Edit(int code) { var proMaster = db.stockcods.FirstOrDefault(x => x.STOCKNO == code); var list = db.countries.Where(x => x.status == 1 && x.islanguage == 1).ToList(); ViewBag.ListCountry = list; foreach (var itemLang in list) { var pro = db.stockcods.FirstOrDefault(x => x.IdCurrentItem == code && x.CodeLanguage == itemLang.language.ToLower()); if (pro == null) { if (proMaster != null) { var tblItem = new stockcod { CREATED = proMaster.CREATED, LASTCHANGE = proMaster.LASTCHANGE, STOCKCODE = proMaster.STOCKCODE, STOCKNAME = proMaster.STOCKNAME, IdCurrentItem = proMaster.IdCurrentItem, CodeLanguage = itemLang.language.ToLower() }; db.stockcods.Add(tblItem); } } } db.SaveChanges(); var item = db.stockcods.ToList().Where(x => x.IdCurrentItem == code).ToList(); return(View(new AllModel { listStockCod = item, tblStockCod = proMaster })); }