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