} //End private Reportin_tunggakanVM mapMONTHLY(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST) //METHOD-MAP-MONTHLY private decimal?mapMONTHLY_CALC(Installment_indetailVM poINST, decimal?pnTRN_QTY, decimal?pnTRN_PRICE) { decimal?vReturn = 0; //Init Calc Variable decimal?nTRN_QTY = pnTRN_QTY; decimal?nTRN_PRICE = pnTRN_PRICE; Byte? nCURRENT_MONTH = this.SYSINFO.SYSMONTH_SEQNO; //poINST if (poINST != null) { //TRN_QTY if (poINST.INST_QTY != null) { decimal?nMONTH_TUNGGAKAN = (decimal?)(nCURRENT_MONTH - 1) - poINST.INST_QTY; if (nMONTH_TUNGGAKAN > 0) { nTRN_QTY = nMONTH_TUNGGAKAN; } } //End if (oINST.INST_QTY != null) //TRN_PRICE if (poINST.INST_PRICEBASE != null) { nTRN_PRICE = poINST.INST_PRICEBASE; } } //End if (oINST != null) //CALC QTY X PRICE vReturn = nTRN_QTY * nTRN_PRICE; return(vReturn); } //End private decimal? mapMONTHLY_CALC(Installment_indetailVM poINST, decimal? pnTRN_QTY, decimal? pnTRN_PRICE)
} //End private Reportin_tunggakanVM mapMONTHLY_SPP(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST) private Reportin_tunggakanVM mapMONTHLY(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = poTUNGGAKAN; //Init Calc Variable decimal?nTRN_QTY = 0; decimal?nTRN_PRICE = 0; decimal?nTRN_AMOUNT = mapMONTHLY_CALC(poINST, nTRN_QTY, nTRN_PRICE); vReturn.TRN_AMOUNT_SPP = nTRN_AMOUNT; return(vReturn); } //End private Reportin_tunggakanVM mapMONTHLY(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST)
} //End public void Create public void Update(Installment_indetailVM poViewModel) { try { this.oModel = this.db.Installment_ins.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 Constructor 2 public void Create(Installment_indetailVM poViewModel) { try { this.oModel = new Installment_in(); //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.Installment_ins.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 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 public void setTRINTYPES_TUNGGAKAN() public void setINSTALLMENTS_TUNGGAKAN() { Installment_inDS oDS = new Installment_inDS(); Installment_indetailVM oFilter = new Installment_indetailVM(); //Init Filter oFilter.CACHE_YEAR_FROM = this.YEAR_FROM; oFilter.CACHE_YEAR_TO = this.YEAR_TO; if (this.CLASSTYPE_ID != null) { oFilter.CLASSTYPE_ID = (Byte?)this.CLASSTYPE_ID; } if (this.CLASSLEVEL_ID != null) { oFilter.CLASSLEVEL_ID = (Byte?)this.CLASSLEVEL_ID; } if (this.NIS != null) { oFilter.STUDENT_ID = this.STUDENT_ID; } //Set Students this.INSTALLMENTS_TUNGGAKAN = oDS.getDatalist_report(oFilter); } //End public void setINSTALLMENTS_TUNGGAKAN()
} //End public void setMONTHS_TUNGGAKAN() private Reportin_tunggakanVM mapMONTHLY_SPP_BACKUP(Reportin_tunggakanVM poTUNGGAKAN, ClassleveldetailVM poCLASSLEVEL, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = poTUNGGAKAN; //Init Calc Variable decimal?nTRN_QTY = 12; decimal?nTRN_PRICE = poCLASSLEVEL.CLASSLEVEL_SPP; decimal?nTRN_AMOUNT = 0; Byte? nCURRENT_MONTH = this.SYSINFO.SYSMONTH_SEQNO; if (poINST != null) { //QTY if (poINST.INST_QTY != null) { decimal?nMONTH_TUNGGAKAN = (decimal?)(nCURRENT_MONTH - 1) - poINST.INST_QTY; if (nMONTH_TUNGGAKAN > 0) { nTRN_QTY = nMONTH_TUNGGAKAN; } } //End if (oINST.INST_QTY != null) //PRICE if (poINST.INST_PRICEBASE != null) { nTRN_PRICE = poINST.INST_PRICEBASE; } } //End if (oINST != null) //CALC QTY X PRICE nTRN_AMOUNT = nTRN_QTY * nTRN_PRICE; vReturn.TRN_AMOUNT_SPP = nTRN_AMOUNT; return(vReturn); } //End private Reportin_tunggakanVM mapMONTHLY_SPP(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST)
} //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)
} //End private Reportin_tunggakanVM mapMONTHLY_SCLUB(Reportin_tunggakanVM poTUNGGAKAN, StudentdetailVM poSTUDENT, ClassleveldetailVM poCLASSLEVEL, TrintypedetailVM poTRINTYPES) private Reportin_tunggakanVM mapMONTHLY_OTHER(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = mapMONTHLY(poTUNGGAKAN, poINST); return(vReturn); } //End private Reportin_tunggakanVM mapMONTHLY_OTHER(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST)
} //End private Reportin_tunggakanVM mapMONTHLY_EKSKUL(Reportin_tunggakanVM poTUNGGAKAN, StudentdetailVM poSTUDENT, ClassleveldetailVM poCLASSLEVEL, TrintypedetailVM poTRINTYPES) private Reportin_tunggakanVM mapMONTHLY_SCLUB(Reportin_tunggakanVM poTUNGGAKAN, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = mapMONTHLY(poTUNGGAKAN, poINST); return(vReturn); } //End private Reportin_tunggakanVM mapMONTHLY_SCLUB(Reportin_tunggakanVM poTUNGGAKAN, StudentdetailVM poSTUDENT, ClassleveldetailVM poCLASSLEVEL, TrintypedetailVM poTRINTYPES)
} //End private decimal? mapMONTHLY_CALC(Installment_indetailVM poINST, decimal? pnTRN_QTY, decimal? pnTRN_PRICE) private Reportin_tunggakanVM mapMONTHLY_SPP(Reportin_tunggakanVM poTUNGGAKAN, ClassleveldetailVM poCLASSLEVEL, Installment_indetailVM poINST) { Reportin_tunggakanVM vReturn = new Reportin_tunggakanVM(); vReturn = poTUNGGAKAN; //Init Calc Variable decimal?nTRN_QTY = 12; decimal?nTRN_PRICE = poCLASSLEVEL.CLASSLEVEL_SPP; decimal?nTRN_AMOUNT = mapMONTHLY_CALC(poINST, nTRN_QTY, nTRN_PRICE); vReturn.TRN_AMOUNT_SPP = nTRN_AMOUNT; return(vReturn); } //End private Reportin_tunggakanVM mapMONTHLY_SPP(StudentdetailVM poSTUDENT, TrintypedetailVM poTRINTYPES, Installment_indetailVM poINST)
} //End public Installment_indetailVM getData(int? id = null) public List <Installment_indetailVM> getDatalist_report(Installment_indetailVM poViewModel = null) { List <Installment_indetailVM> vReturn; var oQRY = from tb in this.db.Installment_in_infos select new Installment_indetailVM { ID = tb.ID, DTA_STS = tb.DTA_STS, BRANCH_ID = tb.BRANCH_ID, YEAR_ID = tb.YEAR_ID, SEMESTER_ID = tb.SEMESTER_ID, CLASSTYPE_ID = tb.CLASSTYPE_ID, //CLASSLEVEL_ID = tb.CLASSLEVEL_ID, CLASSROOM_ID = tb.CLASSROOM_ID, //CLASSMAJOR_ID = tb.CLASSMAJOR_ID, INST_DT = tb.INST_DT, INST_STS = tb.INST_STS, INST_STARTDT = tb.INST_STARTDT, INST_ENDDT = tb.INST_ENDDT, INST_TYPEID = tb.INST_TYPEID, INST_SUBTYPEID = tb.INST_SUBTYPEID, INST_QTYBASE = tb.INST_QTYBASE, INST_PRICEBASE = tb.INST_PRICEBASE, INST_AMOUNTBASE = tb.INST_AMOUNTBASE, INST_QTY = tb.INST_QTY, INST_AMOUNT = tb.INST_AMOUNT, INST_DESC = tb.INST_DESC, STUDENT_ID = tb.STUDENT_ID, INSTD_ID = tb.INSTD_ID, CACHE_YEAR_CODE = tb.CACHE_YEAR_CODE, CACHE_YEAR_SHORTDESC = tb.CACHE_YEAR_SHORTDESC, CACHE_YEAR_DESC = tb.CACHE_YEAR_DESC, CACHE_YEAR_FROM = tb.CACHE_YEAR_FROM, CACHE_YEAR_TO = tb.CACHE_YEAR_TO, BRANCH_TYPE = tb.BRANCH_TYPE, //BRANCH_CODE = tb.BRANCH_CODE, //BRANCH_SHORTDESC = tb.BRANCH_SHORTDESC, BRANCH_DESC = tb.BRANCH_DESC, //YEAR_CODE = tb.YEAR_CODE, //YEAR_SHORTDESC = tb.YEAR_SHORTDESC, YEAR_DESC = tb.YEAR_DESC, YEAR_FROM = tb.YEAR_FROM, YEAR_TO = tb.YEAR_TO, //SEMESTER_CODE = tb.SEMESTER_CODE, //SEMESTER_SHORTDESC = tb.SEMESTER_SHORTDESC, SEMESTER_DESC = tb.SEMESTER_DESC, SEMESTER_NUM = tb.SEMESTER_NUM, //CLASSTYPE_CODE = tb.CLASSTYPE_CODE, //CLASSTYPE_SHORTDESC = tb.CLASSTYPE_SHORTDESC, CLASSTYPE_DESC = tb.CLASSTYPE_DESC, //CLASSTYPE_NUM = tb.CLASSTYPE_NUM, //CLASSLEVEL_CODE = tb.CLASSLEVEL_CODE, //CLASSLEVEL_SHORTDESC = tb.CLASSLEVEL_SHORTDESC, //CLASSLEVEL_DESC = tb.CLASSLEVEL_DESC, //CLASSLEVEL_NUM = tb.CLASSLEVEL_NUM, //CLASSLEVEL_SEQNO = tb.CLASSLEVEL_SEQNO, //CLASSROOM_CODE = tb.CLASSROOM_CODE, //CLASSROOM_SHORTDESC = tb.CLASSROOM_SHORTDESC, CLASSROOM_DESC = tb.CLASSROOM_DESC, //CLASSROOM_SEQNO = tb.CLASSROOM_SEQNO, //CLASSMAJOR_CODE = tb.CLASSMAJOR_CODE, //CLASSMAJOR_SHORTDESC = tb.CLASSMAJOR_SHORTDESC, //CLASSMAJOR_DESC = tb.CLASSMAJOR_DESC, //CLASSMAJOR_NUM = tb.CLASSMAJOR_NUM, //CLASSMAJOR_SEQNO = tb.CLASSMAJOR_SEQNO, INSTD_STS = tb.INSTD_STS, INSTD_STARTDT = tb.INSTD_STARTDT, INSTD_ENDDT = tb.INSTD_ENDDT, INSTD_PAYDT = tb.INSTD_PAYDT, INSTD_TYPEID = tb.INSTD_TYPEID, INSTD_SUBTYPEID = tb.INSTD_SUBTYPEID, INSTD_AMOUNTBASE = tb.INSTD_AMOUNTBASE, INSTD_AMOUNT = tb.INSTD_AMOUNT, INSTD_DESC = tb.INSTD_DESC, INSTD_SEQNO = tb.INSTD_SEQNO, }; //YEAR if ((poViewModel.YEAR_FROM != null) && (poViewModel.YEAR_TO != null)) { oQRY = oQRY.Where(fld => fld.CACHE_YEAR_FROM == poViewModel.YEAR_FROM && fld.CACHE_YEAR_TO == poViewModel.YEAR_TO); } //End YEAR //STUDENT_ID if (poViewModel.STUDENT_ID != null) { oQRY = oQRY.Where(fld => fld.STUDENT_ID == poViewModel.STUDENT_ID); } //End STUDENT_ID //CLASSTYPE_ID if (poViewModel.CLASSTYPE_ID != null) { oQRY = oQRY.Where(fld => fld.CLASSTYPE_ID == poViewModel.CLASSTYPE_ID); } //End CLASSTYPE_ID //CLASSLEVEL_ID if (poViewModel.CLASSLEVEL_ID != null) { oQRY = oQRY.Where(fld => fld.CLASSLEVEL_ID == poViewModel.CLASSLEVEL_ID); } //End CLASSLEVEL_ID //CLASSROOM_ID if (poViewModel.CLASSROOM_ID != null) { oQRY = oQRY.Where(fld => fld.CLASSROOM_ID == poViewModel.CLASSROOM_ID); } //End CLASSROOM_ID //CLASSMAJOR_ID if (poViewModel.CLASSMAJOR_ID != null) { oQRY = oQRY.Where(fld => fld.CLASSMAJOR_ID == poViewModel.CLASSMAJOR_ID); } //End CLASSMAJOR_ID vReturn = oQRY.ToList(); return(vReturn); } //End public List<Installment_inlistVM> getDatalist()