} //End public void Create public void Update(TrintypedetailVM poViewModel) { try { using (var db = new DBMAINContext()) { Trintype oModel = db.Trintypes.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
} //End public TrintypeCRUD() public void Create(TrintypedetailVM poViewModel) { try { using (var db = new DBMAINContext()) { Trintype oModel = new Trintype(); //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.Trintypes.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
} //End public void executeReport_TUNGGAKAN() //METHOD-CALC private Reportin_tunggakanVM calcTUNGGAKAN (Reportin_tunggakanVM poTUNGGAKAN, StudentdetailVM poSTUDENT, ClassleveldetailVM poCLASSLEVEL, TrintypedetailVM poTRINTYPES) { Boolean isCheck = true; Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = poTUNGGAKAN; Installment_indetailVM oINST = this.INSTALLMENTS_TUNGGAKAN. Where(fld => fld.INST_TYPEID == poTRINTYPES.ID && fld.STUDENT_ID == poSTUDENT.ID).SingleOrDefault(); //SPP if ((poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_SPP) && (isCheck)) { isCheck = false; //Map Tunggakan vReturn = mapMONTHLY_SPP(poTUNGGAKAN, poCLASSLEVEL, oINST); } //End if (poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_SPP) //EKSKUL if ((poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_EKSKUL) && (isCheck)) { isCheck = false; //Map Tunggakan vReturn = mapMONTHLY_EKSKUL(poTUNGGAKAN, oINST); } //End if (poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_EKSKUL) //SCLUB if ((poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_SCLUB) && (isCheck)) { isCheck = false; //Map Tunggakan vReturn = mapMONTHLY_SCLUB(poTUNGGAKAN, oINST); } //End if (poTRINTYPES.ID == valFLAG.FLAG_TRINTYPE_SCLUB) //OTHER if (isCheck) { isCheck = false; //Map Tunggakan vReturn = mapMONTHLY_OTHER(poTUNGGAKAN, oINST); } //End if (isCheck) return(vReturn); } //End private Reportin_tunggakanVM calcTUNGGAKAN(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES)
} //End private Reportin_tunggakanVM mapMONTHLY_OTHER(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST) //METHOD-MAP-OTHER private Reportin_tunggakanVM mapOTHER(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = null; return(vReturn); } //End private Reportin_tunggakanVM mapOTHER(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST)