} //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()
