public async Task <ActionResult> DeleteConfirmed(string id) { COPR16_RETURNTYPE_MSTR cOPR16_RETURNTYPE_MSTR = await db.COPR16_RETURNTYPE_MSTR.FindAsync(id); db.COPR16_RETURNTYPE_MSTR.Remove(cOPR16_RETURNTYPE_MSTR); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Create([Bind(Include = "RTYPE_ID,RTYPE_NAME,ADATE,CRE_BY,MOD_BY,MOD_DATE,MSTYPE_ID")] COPR16_RETURNTYPE_MSTR cOPR16_RETURNTYPE_MSTR) { if (ModelState.IsValid) { db.COPR16_RETURNTYPE_MSTR.Add(cOPR16_RETURNTYPE_MSTR); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(cOPR16_RETURNTYPE_MSTR)); }
// GET: COPR16_RETURNTYPE_MSTR/Details/5 public async Task <ActionResult> Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } COPR16_RETURNTYPE_MSTR cOPR16_RETURNTYPE_MSTR = await db.COPR16_RETURNTYPE_MSTR.FindAsync(id); if (cOPR16_RETURNTYPE_MSTR == null) { return(HttpNotFound()); } return(View(cOPR16_RETURNTYPE_MSTR)); }
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)); }