Пример #1
0
        }                                                                                    //End public void Update

        public void Delete(int?id)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Mainconfig oModel = db.Mainconfigs.Find(id);
                    db.Mainconfigs.Remove(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Delete" + e.Message; } //End catch
        }                                                                                    //End public void Delete
Пример #2
0
 //METHODS
 public void Create(MainconfigdetailVM poViewModel)
 {
     try
     {
         using (var db = new DBMAINContext())
         {
             Mainconfig oModel = new Mainconfig();
             //Map Form Data
             oModel.InjectFrom(poViewModel);
             //Set Field Header
             oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
             //Set DTA_STS
             oModel.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE;
             //Process CRUD
             db.Mainconfigs.Add(oModel);
             db.SaveChanges();
             this.ID = oModel.ID;
         }                                                                              //End using
     }                                                                                  //End try
     catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
 }                                                                                      //End public void Create
Пример #3
0
        }                                                                                      //End public void Create

        public void Update(MainconfigdetailVM poViewModel)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Mainconfig oModel = db.Mainconfigs.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
                    //Map Form Data
                    oModel.InjectFrom(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                    //Set DTA_STS
                    oModel.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE;
                    //Process CRUD
                    db.Entry(oModel).State = EntityState.Modified;
                    db.SaveChanges();
                    this.ID = oModel.ID;
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
        }                                                                                    //End public void Update
Пример #4
0
        }                                                                                    //End public void Delete

        public void Rollup_RECEIPTNO()
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Mainconfig oModel = db.Mainconfigs.AsNoTracking().FirstOrDefault();
                    if (oModel.RECEIPT_NO == null)
                    {
                        oModel.RECEIPT_NO = 1;
                    }
                    else
                    {
                        oModel.RECEIPT_NO = oModel.RECEIPT_NO + 1;
                    }
                    //Process CRUD
                    db.Entry(oModel).State = EntityState.Modified;
                    db.SaveChanges();
                    this.ID         = oModel.ID;
                    this.RECEIPT_NO = oModel.RECEIPT_NO;
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
        }                                                                                    //End public void Update