コード例 #1
0
        public async Task <ActionResult> CreateJson(
            string option_id,
            string option_name,
            string username,
            List <OptionDetailsModel> jsonString)
        {
            OptionsModel model = new OptionsModel(db);

            //COPR16_OPTIONVAL_MSTR cOPR16_OPTIONVAL_MSTR = await db.COPR16_OPTIONVAL_MSTR.FindAsync(option_id);

            COPR16_OPTIONVAL_MSTR cOPR16_OPTIONVAL_MSTR = new COPR16_OPTIONVAL_MSTR();

            cOPR16_OPTIONVAL_MSTR.CRE_BY      = username;
            cOPR16_OPTIONVAL_MSTR.ADATE       = today;
            cOPR16_OPTIONVAL_MSTR.OPTION_ID   = option_id;
            cOPR16_OPTIONVAL_MSTR.OPTION_NAME = option_name;

            model.cOPR16_OPTIONVAL_MSTR = new COPR16_OPTIONVAL_MSTR();
            model.option_id             = option_id;
            model.option_name           = option_name;
            model.jsonString            = jsonString;


            foreach (OptionDetailsModel item in jsonString)
            {
                COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR = db.COPR16_OPTDTVALUE_MSTR.Where(row => row.OPTION_ID.Contains(option_id) && row.OPTDT_ID.Contains(item.OPTDT_ID)).FirstOrDefault();
                if (cOPR16_OPTDTVALUE_MSTR == null)
                {
                    COPR16_OPTDTVALUE_MSTR dtdt = new COPR16_OPTDTVALUE_MSTR();
                    dtdt.OPTION_ID   = option_id;
                    dtdt.OPTDT_ID    = item.OPTDT_ID;
                    dtdt.OPTDT_VALUE = item.OPTDT_VALUE;
                    dtdt.FLGDEF      = item.FLGDEF.ToLower() == "true" ? true : false;
                    dtdt.CRE_BY      = username;
                    dtdt.FLGACT      = true;
                    dtdt.DESC        = item.DESC;
                    dtdt.ADATE       = today;
                    db.COPR16_OPTDTVALUE_MSTR.Add(dtdt);
                    await db.SaveChangesAsync();
                }
                else
                {
                    cOPR16_OPTDTVALUE_MSTR.OPTION_ID       = option_id;
                    cOPR16_OPTDTVALUE_MSTR.OPTDT_VALUE     = item.OPTDT_VALUE;
                    cOPR16_OPTDTVALUE_MSTR.FLGDEF          = item.FLGDEF == "true" ? true : false;
                    cOPR16_OPTDTVALUE_MSTR.MOD_BY          = username;
                    cOPR16_OPTDTVALUE_MSTR.FLGACT          = true;
                    cOPR16_OPTDTVALUE_MSTR.DESC            = item.DESC;
                    cOPR16_OPTDTVALUE_MSTR.MOD_DATE        = today;
                    db.Entry(cOPR16_OPTDTVALUE_MSTR).State = EntityState.Modified;
                    await db.SaveChangesAsync();
                }
            }

            db.COPR16_OPTIONVAL_MSTR.Add(cOPR16_OPTIONVAL_MSTR);
            await db.SaveChangesAsync();

            return(View());
        }
コード例 #2
0
        public async Task <ActionResult> DeleteConfirmed(string id)
        {
            COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR = await db.COPR16_OPTDTVALUE_MSTR.FindAsync(id);

            db.COPR16_OPTDTVALUE_MSTR.Remove(cOPR16_OPTDTVALUE_MSTR);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
コード例 #3
0
        public async Task <ActionResult> Edit([Bind(Include = "OPTDT_ID,OPTION_ID,OPTDT_VALUE,DESC,FLGDEF,FLGACT,ADATE,CRE_BY,MOD_DATE,MOD_BY")] COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR)
        {
            if (ModelState.IsValid)
            {
                db.Entry(cOPR16_OPTDTVALUE_MSTR).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            return(View(cOPR16_OPTDTVALUE_MSTR));
        }
コード例 #4
0
        // GET: COPR16_OPTDTVALUE_MSTR/Delete/5
        public async Task <ActionResult> Delete(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR = await db.COPR16_OPTDTVALUE_MSTR.FindAsync(id);

            if (cOPR16_OPTDTVALUE_MSTR == null)
            {
                return(HttpNotFound());
            }
            return(View(cOPR16_OPTDTVALUE_MSTR));
        }
コード例 #5
0
        public async Task <ActionResult> SaveJson(
            string option_id,
            string option_name,
            string username,
            List <OptionDetailsModel> jsonString)
        {
            OptionsModel model = new OptionsModel(db);

            //IEnumerable<OptionDetailsModel> lineitems = Deserialise<IEnumerable<OptionDetailsModel>>(jsonString);

            COPR16_OPTIONVAL_MSTR cOPR16_OPTIONVAL_MSTR = await db.COPR16_OPTIONVAL_MSTR.FindAsync(option_id);

            if (cOPR16_OPTIONVAL_MSTR == null)
            {
                return(HttpNotFound());
            }

            //cOPR16_OPTIONVAL_MSTR.MOD_BY = System.Security.Principal.WindowsIdentity.GetCurrent().Name;

            cOPR16_OPTIONVAL_MSTR.MOD_BY      = username;
            cOPR16_OPTIONVAL_MSTR.MOD_DATE    = today;
            cOPR16_OPTIONVAL_MSTR.OPTION_ID   = option_id;
            cOPR16_OPTIONVAL_MSTR.OPTION_NAME = option_name;

            model.cOPR16_OPTIONVAL_MSTR = new COPR16_OPTIONVAL_MSTR();
            model.option_id             = option_id;
            model.option_name           = option_name;
            model.jsonString            = jsonString;
            foreach (OptionDetailsModel item in jsonString)
            {
                COPR16_OPTDTVALUE_MSTR cOPR16_OPTDTVALUE_MSTR = db.COPR16_OPTDTVALUE_MSTR.Where(row => row.OPTION_ID.Contains(option_id) && row.OPTDT_ID.Contains(item.OPTDT_ID)).FirstOrDefault();
                if (cOPR16_OPTDTVALUE_MSTR == null)
                {
                    COPR16_OPTDTVALUE_MSTR dtdt = new COPR16_OPTDTVALUE_MSTR();
                    dtdt.OPTION_ID   = option_id;
                    dtdt.OPTDT_ID    = item.OPTDT_ID;
                    dtdt.OPTDT_VALUE = item.OPTDT_VALUE;
                    dtdt.FLGDEF      = item.FLGDEF.ToLower() == "true" ? true : false;
                    dtdt.CRE_BY      = username;
                    dtdt.FLGACT      = true;
                    dtdt.DESC        = item.DESC;
                    dtdt.ADATE       = today;
                    db.COPR16_OPTDTVALUE_MSTR.Add(dtdt);
                    await db.SaveChangesAsync();
                }
                else
                {
                    cOPR16_OPTDTVALUE_MSTR.OPTION_ID = option_id;
                    //cOPR16_OPTDTVALUE_MSTR.OPTDT_ID = item.OPTDT_ID;
                    cOPR16_OPTDTVALUE_MSTR.OPTDT_VALUE     = item.OPTDT_VALUE;
                    cOPR16_OPTDTVALUE_MSTR.FLGDEF          = item.FLGDEF == "true" ? true : false;
                    cOPR16_OPTDTVALUE_MSTR.MOD_BY          = username;
                    cOPR16_OPTDTVALUE_MSTR.FLGACT          = true;
                    cOPR16_OPTDTVALUE_MSTR.DESC            = item.DESC;
                    cOPR16_OPTDTVALUE_MSTR.MOD_DATE        = today;
                    db.Entry(cOPR16_OPTDTVALUE_MSTR).State = EntityState.Modified;
                    await db.SaveChangesAsync();
                }
            }


            db.Entry(cOPR16_OPTIONVAL_MSTR).State = EntityState.Modified;
            await db.SaveChangesAsync();

            return(View(model));
        }