} //End public void Update public void Delete(int?id) { try { this.oModel = this.db.Maritals.Find(id); this.db.Maritals.Remove(this.oModel); //this.db.SaveChanges(); //this.ID = this.oModel.ID; } //End try catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Delete" + e.Message; } //End catch } //End public void Delete
} //End public void Update public void Delete(int?id) { try { using (var db = new DBMAINContext()) { Marital oModel = db.Maritals.Find(id); db.Maritals.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
} //End public void Create public void Update(MaritalVM poViewModel) { try { this.oModel = this.db.Maritals.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID); //Map Form Data this.oModel.InjectFrom(poViewModel); //Set Field Header this.oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE); //Set DTA_STS this.oModel.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE; //Process CRUD this.db.Entry(this.oModel).State = EntityState.Modified; //this.db.SaveChanges(); //this.ID = this.oModel.ID; } //End try catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch } //End public void Update
} //End public MaritalCRUD() public void Create(MaritalVM poViewModel) { try { this.oModel = new Marital(); //Map Form Data this.oModel.InjectFrom(poViewModel); //Set Field Header this.oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE); //Set DTA_STS this.oModel.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE; //Process CRUD this.db.Maritals.Add(this.oModel); //this.db.SaveChanges(); //this.ID = this.oModel.ID; } //End try catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch } //End public void Create
} //End public void Create public void Update(MaritaldetailVM poViewModel) { try { using (var db = new DBMAINContext()) { Marital oModel = db.Maritals.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID); //Map Form Data oModel.InjectFrom(poViewModel); //Set Field Header oModel.setFIELD_HEADER(hlpFlags_CRUDOption.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
} //End public MaritalCRUD() public void Create(MaritaldetailVM poViewModel) { try { using (var db = new DBMAINContext()) { Marital oModel = new Marital(); //Map Form Data oModel.InjectFrom(poViewModel); //Set Field Header oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE); //Process CRUD db.Maritals.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