public ReturnTypeModel(COPR16Entities dbModel) { db = dbModel; this.MSTYPE_LIST = new List <SelectListItem>(); this.cOPR16_RTDT_MSTR = new COPR16_RTDT_MSTR(); foreach (var row in db.COPR16_MEASURETYPE_MSTR.Where(l => l.FLGACT == true)) { MSTYPE_LIST.Add(new SelectListItem { Text = row.MSTYPE_NAME, Value = row.MSTYPE_ID }); } }
public async Task <ActionResult> RemoveRDTD(string id, string rtdtid, string username) { //COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR = await db.COPR16_OPTDTVALUE_MSTR.FindAsync(id); //List<COPR16_MEASURETYPE_MSTR> cOPR16_MEASURETYPE_MSTR = await db.COPR16_MEASURETYPE_MSTR.Where(l => l.MSTYPE_ID.Contains(id)).ToListAsync(); COPR16_RTDT_MSTR dtdt = db.COPR16_RTDT_MSTR.Where(row => row.RTTYPE_ID.Contains(id) && row.RTDT_ID.Contains(rtdtid) && row.FLGACT.Value == true).FirstOrDefault(); if (dtdt != null) { dtdt.MOD_BY = username; dtdt.MOD_DATE = AppPropModel.today; dtdt.FLGACT = false; db.Entry(dtdt).State = EntityState.Modified; await db.SaveChangesAsync(); } return(View()); }
public async Task <ActionResult> CreateJson( string rt_id, string rt_name, string rt_desc, string flgact, string username, List <ReturnDetial> jsonString) { COPR16_RETURNTYPE_MSTR cOPR16_RETURNTYPE_MSTR = new COPR16_RETURNTYPE_MSTR(); cOPR16_RETURNTYPE_MSTR.CRE_BY = username; cOPR16_RETURNTYPE_MSTR.ADATE = AppPropModel.today; cOPR16_RETURNTYPE_MSTR.DESC = rt_desc; cOPR16_RETURNTYPE_MSTR.RTYPE_ID = rt_id; cOPR16_RETURNTYPE_MSTR.RTYPE_NAME = rt_name; cOPR16_RETURNTYPE_MSTR.FLGACT = flgact.ToLower() == "true" ? true:false; foreach (ReturnDetial item in jsonString) { COPR16_RTDT_MSTR dtdt = new COPR16_RTDT_MSTR(); dtdt.RTTYPE_ID = rt_id; dtdt.RTDT_ID = item.RTDT_ID; dtdt.RTDT_NAME = item.RTDT_NAME; dtdt.MSTYPE_ID = item.MSTYPE_ID; dtdt.REF_ID = item.REF_ID; dtdt.CRE_BY = username; dtdt.FLGACT = true; dtdt.ADATE = AppPropModel.today; db.COPR16_RTDT_MSTR.Add(dtdt); await db.SaveChangesAsync(); } db.COPR16_RETURNTYPE_MSTR.Add(cOPR16_RETURNTYPE_MSTR); await db.SaveChangesAsync(); return(View()); }
public async Task <ActionResult> SaveJson( string rt_id, string rt_name, string rt_desc, string flgact, string username, List <ReturnDetial> jsonString) { COPR16_RETURNTYPE_MSTR cOPR16_RETURNTYPE_MSTR = await db.COPR16_RETURNTYPE_MSTR.FindAsync(rt_id); cOPR16_RETURNTYPE_MSTR.MOD_BY = username; cOPR16_RETURNTYPE_MSTR.MOD_DATE = AppPropModel.today; cOPR16_RETURNTYPE_MSTR.DESC = rt_desc; cOPR16_RETURNTYPE_MSTR.RTYPE_ID = rt_id; cOPR16_RETURNTYPE_MSTR.RTYPE_NAME = rt_name; cOPR16_RETURNTYPE_MSTR.FLGACT = flgact.ToLower() == "true" ? true : false; foreach (ReturnDetial item in jsonString) { bool addNew = false; //COPR16_RTDT_MSTR dtdt = new COPR16_RTDT_MSTR(); COPR16_RTDT_MSTR dtdt = db.COPR16_RTDT_MSTR.Where( row => row.RTTYPE_ID.Equals(rt_id) && row.RTDT_ID.Equals(item.RTDT_ID) && row.FLGACT.Value == true).FirstOrDefault(); if (dtdt == null) { dtdt = new COPR16_RTDT_MSTR(); addNew = true; } else { addNew = false; } dtdt.RTTYPE_ID = rt_id; dtdt.RTDT_NAME = item.RTDT_NAME; dtdt.REF_ID = item.REF_ID; dtdt.MSTYPE_ID = item.MSTYPE_ID; dtdt.FLGACT = true; if (addNew) { dtdt.RTDT_ID = item.RTDT_ID; dtdt.CRE_BY = username; dtdt.ADATE = AppPropModel.today; db.COPR16_RTDT_MSTR.Add(dtdt); try { await db.SaveChangesAsync(); }catch (Exception e) { cOPR16_RETURNTYPE_MSTR.DESC = "Error : " + e.Message + "<br> RTDT_ID: " + dtdt.RTDT_ID + ", RTTYPE_ID:" + rt_id; return(View(cOPR16_RETURNTYPE_MSTR)); } } else { dtdt.MOD_BY = username; dtdt.MOD_DATE = AppPropModel.today; db.Entry(dtdt).State = EntityState.Modified; await db.SaveChangesAsync(); } } //db.COPR16_RETURNTYPE_MSTR.Add(cOPR16_RETURNTYPE_MSTR); db.Entry(cOPR16_RETURNTYPE_MSTR).State = EntityState.Modified; await db.SaveChangesAsync(); return(View(cOPR16_RETURNTYPE_MSTR)); }