//HEADER
private Transaction_indetailVM CREATEInitOTHER_ViewModel(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = this.CREATEInit_ViewModel(poViewModel);
return(oViewModel);
} //End private Transaction_indetailVM CREATEInitOTHER_ViewModel(Transaction_indetailVM poViewModel)
} //End private Transaction_indetailVM addDetail(Transaction_indetailVM poViewModel, MonthsppVM poItem)
private Transaction_indetailVM addDetail_SCLUBfirst(Transaction_indetailVM poViewModel, MonthsppVM poItem)
{
Transaction_indetailVM oViewModel = poViewModel;
MonthsppVM item = poItem;
Byte?nMONTH1 = oViewModel.MONTHSPP2;
Byte?nMONTH2 = oViewModel.MONTHSPP3;
Byte?nMONTH2b = (Byte?)((nMONTH1 + nMONTH2) - 1);
nMONTH2 = nMONTH2b;
if (nMONTH2 > 12)
{
nMONTH2 = 12;
}
if ((item.MONTHSPP_SEQNO >= nMONTH1) &&
(item.MONTHSPP_SEQNO <= nMONTH2))
{
//Add Transaction Detail
oViewModel = this.addDetail_SCLUB(oViewModel, item);
} //End if ((item.MONTHSPP_SEQNO >= oViewModel.MONTHSPP1.MONTHSPP_SEQNO) &&
return(oViewModel);
} //End private Transaction_indetailVM addDetail_first(Transaction_indetailVM poViewModel, MonthsppVM poItem)
//MAP
//Init
protected virtual void initConstructor(DBMAINContext poDB)
{
//DBContext
this.db = poDB;
//VM
this.oViewModel = new Transaction_indetailVM();
//DATA
this.oData = new Transaction_indetailVM();
this.oData_list = new List <Transaction_indetailVM>();
this.oDatastudent = new StudentVM();
this.oDatastudent.DETAIL = new StudentdetailVM();
//DS
this.oDS = new Transaction_inDS(this.db);
this.oDSDetail = new Transaction_indDS(this.db);
this.oDS_inst = new Installment_inDS(this.db);
this.oDSStudent = new StudentDS(this.db);
this.oDSClasstype = new ClasstypeDS(this.db);
this.oDSClassroom = new ClassroomDS(this.db);
this.oDSYear = new YearDS(db);
this.oDSMonth = new MonthsppDS();
//CRUD
this.oCRUD = new Transaction_inCRUD(this.db);
this.oCRUD_detail = new Transaction_indCRUD(this.db);
this.oCRUD_inst = new Installment_inCRUD(this.db);
//BL
oBL = new Transaction_inBL();
//MAP
//VIEWBAG
ViewBag.Controllername = "";
ViewBag.Viewlocation = "~/Views/Transaction_in/";
ViewBag.Viewextention = ".cshtml";
} //End initConstructor
public ActionResult CreateSPP(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = (Transaction_indetailVM)Session[hlpConfig.SessionInfo.getTransaction_inID()];
oViewModel.ActionID = poViewModel.ActionID;
oViewModel.TRND_DESC = poViewModel.TRND_DESC;
//oViewModel.TRND_AMOUNT = poViewModel.TRND_AMOUNT;
oViewModel.TRND_AMOUNT = hlpConvertionAndFormating.ConvertStringToDecimal(poViewModel.TRND_AMOUNT_S);
if (oViewModel.MONTHLY_INST_SPP.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oViewModel.TRND_AMOUNTBASE = hlpConvertionAndFormating.ConvertStringToDecimal(poViewModel.TRND_AMOUNTBASE_S);
} //End if (oViewModel.INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
oViewModel = this.CREATEMapspp_ViewModel(oViewModel, poViewModel);
oViewModel = this.CREATEMapspp_ViewModelINST(oViewModel);
//Update session
//Session[hlpConfig.SessionInfo.getTransaction_inID()] = oViewModel;
this.updateSESSIOAN_Transaction(oViewModel);
return(RedirectToAction("Create"));
} //End public ActionResult CreateSPP(Transaction_indetailVM poViewModel)
private Transaction_indetailVM CREATEInitsppdenda_ViewModel(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//Get INST MONTHLY
if (oViewModel.MONTHLY_INST == null)
{
oViewModel.MONTHLY_INST = this.getINST_SPP(oViewModel);
oViewModel.MONTHLY_INST_SPP = oViewModel.MONTHLY_INST;
} //End if (oViewModel.MONTHLY_INST == null)
if (oViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
//EXTRA CUSTOM-TRANSACTIONDETAIL BASE
oViewModel.TRND_PRICEBASE = (oDSClasslevel.TRND_PRICEBASE_DENDA / 100) * oViewModel.MONTHLY_INST.INST_PRICEBASE;
oViewModel.TRND_AMOUNTBASE = (oDSClasslevel.TRND_PRICEBASE_DENDA / 100) * oViewModel.MONTHLY_INST.INST_PRICEBASE;
//EXTRA CUSTOM-TRANSACTIONDETAIL
oViewModel.TRND_AMOUNT = (oDSClasslevel.TRND_PRICEBASE_DENDA / 100) * oViewModel.MONTHLY_INST.INST_PRICEBASE;
} //End if (oViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Detail MONTHS
oViewModel.MONTHLY_MONTHS = new List <MonthsppVM>();
oViewModel.MONTHS = oDSMonthspp.getDatalist_lookup();
oViewModel.MONTHLY_MONTHS = oViewModel.MONTHS;
return(oViewModel);
} //End private Transaction_indetailVM CREATEInitsppdenda_ViewModel(Transaction_indetailVM poViewModel)
public ActionResult Create(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = (Transaction_indetailVM)Session[hlpConfig.SessionInfo.getTransaction_inID()];
oViewModel.ActionID = poViewModel.ActionID;
oViewModel.RECEIPT_PAIDBY = poViewModel.RECEIPT_PAIDBY;
//Fill TRINTYPE
var oDataTrinttype = oDSTrintype.getData(poViewModel.TRINTYPE_ID);
if (oDataTrinttype != null)
{
oViewModel.TRINTYPE_ID = poViewModel.TRINTYPE_ID;
oViewModel.TRINTYPE_CODE = oDataTrinttype.TRINTYPE_CODE;
oViewModel.TRINTYPE_SHORTDESC = oDataTrinttype.TRINTYPE_SHORTDESC;
oViewModel.TRINTYPE_DESC = oDataTrinttype.TRINTYPE_DESC;
oViewModel.TRINMETHOD_ID = oDataTrinttype.TRINMETHOD_ID;
} //End if (oDataTrinttype != null)
//Update session
Session[hlpConfig.SessionInfo.getTransaction_inID()] = oViewModel;
//Run Action
return(this.gotoAction(oViewModel));
oVAL = new Transaction_in_Validation(poViewModel);
oVAL.Validate_Create();
return(View(oViewModel));
}
} //End private Transaction_inddetailVM getItem_SPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
private Transaction_inddetailVM getItem_DendaSPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
{
Transaction_inddetailVM vReturn = null;
Transaction_indetailVM oViewModel = poViewModel;
//Fill TRINTYPE
var oDataTrinttype = oDSTrintype.getData(valFLAG.FLAG_TRINTYPE_SPPDENDA);
vReturn = new Transaction_inddetailVM();
//Add Transaction Detail
vReturn.TRINTYPE_ID = oViewModel.TRINTYPE_ID;
vReturn.TRND_METHODID = oDataTrinttype.TRINMETHOD_ID;
vReturn.TRND_TYPEID = oDataTrinttype.ID;
vReturn.TRINTYPE_CODE = oDataTrinttype.TRINTYPE_CODE;
vReturn.TRINTYPE_SHORTDESC = oDataTrinttype.TRINTYPE_SHORTDESC;
vReturn.TRINTYPE_DESC = oDataTrinttype.TRINTYPE_DESC;
vReturn.TRND_QTY = 1;
vReturn.TRND_PRICE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_AMOUNT = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_PRICEBASE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_QTYBASE = 1;
vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_DESC = "Denda SPP Bulan " + poMonthitem.MONTHSPP_SHORTDESC + " " + oViewModel.YEAR_SHORTDESC;
vReturn.INSTD_SEQNO = poMonthitem.MONTHSPP_SEQNO;
return(vReturn);
} //End private Transaction_inddetailVM getItem_DendaSPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
} //End private Transaction_indetailVM addDetail_SPPdenda_next(Transaction_indetailVM poViewModel, MonthsppVM poItem)
private Installment_indetailVM getINST_SPP(Transaction_indetailVM poViewModel)
{
//Installment_indetailVM vReturn = oDSInstallment.getData(poViewModel.STUDENT_ID, poViewModel.TRINTYPE_ID, poViewModel.CACHE_YEAR_FROM, poViewModel.CACHE_YEAR_TO);
//Installment_indetailVM vReturn = oDSInstallment.getData(poViewModel.STUDENT_ID, poViewModel.TRINTYPE_ID, poViewModel.YEAR_FROM, poViewModel.YEAR_TO);
Installment_indetailVM vReturn = oDSInstallment.getData(poViewModel.STUDENT_ID, 1, poViewModel.YEAR_FROM, poViewModel.YEAR_TO);
if (vReturn == null)
{
vReturn = new Installment_indetailVM();
vReturn.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE;
}
else
{
vReturn.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE;
}
vReturn.INST_QTYBASE = 12;
if (vReturn.INST_QTY == null)
{
vReturn.INST_QTY = 1;
}
else
{
vReturn.INST_QTY = vReturn.INST_QTY + 1;
}
return(vReturn);
} //End private Installment_indetailVM getINST_SPP(Transaction_indetailVM poViewModel)
} //End private Installment_indetailVM getINST_SPP(Transaction_indetailVM poViewModel)
private Transaction_inddetailVM getItem_SPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
{
Transaction_inddetailVM vReturn = new Transaction_inddetailVM();
Transaction_indetailVM oViewModel = poViewModel;
//Add Transaction Detail
vReturn.TRINTYPE_ID = oViewModel.TRINTYPE_ID;
vReturn.TRND_METHODID = oViewModel.TRINMETHOD_ID;
vReturn.TRND_TYPEID = oViewModel.TRINTYPE_ID;
vReturn.TRINTYPE_CODE = oViewModel.TRINTYPE_CODE;
vReturn.TRINTYPE_SHORTDESC = oViewModel.TRINTYPE_SHORTDESC;
vReturn.TRINTYPE_DESC = oViewModel.TRINTYPE_DESC;
vReturn.TRND_QTY = 1;
vReturn.TRND_PRICE = oViewModel.TRND_AMOUNT;
vReturn.TRND_AMOUNT = oViewModel.TRND_AMOUNT;
//vReturn.TRND_PRICEBASE = oViewModel.TRND_AMOUNT;
//vReturn.TRND_QTYBASE = 1;
//vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNT;
vReturn.TRND_PRICEBASE = oViewModel.TRND_AMOUNTBASE;
vReturn.TRND_QTYBASE = 1;
vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNTBASE;
vReturn.TRND_DESC = "SPP Bulan " + poMonthitem.MONTHSPP_SHORTDESC + " " + oViewModel.YEAR_SHORTDESC;
vReturn.INSTD_SEQNO = poMonthitem.MONTHSPP_SEQNO;
return(vReturn);
} //End private Transaction_inddetailVM getItem_SPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
public override ActionResult Edit(Transaction_indetailVM poViewModel)
{
ViewBag.AC_MENU_ID = valMENU.KEUANGAN_SPP_EDIT;
this.oViewModel = poViewModel;
this.oData = this.oDS.getData(this.oViewModel.ID);
this.oData.DETAIL = this.oDSDetail.getDatalist_detail(this.oData.ID);
if (this.oData.DETAIL != null)
{
if (this.oData.DETAIL.Count > 0)
{
this.oDatadetail = this.oData.DETAIL.FirstOrDefault();
//Process Header
this.oViewModel = this.oSERVICE_worker.setMonthRange(this.oViewModel);
this.oViewModel = this.oSERVICE_mapper.Update_mapper(this.oViewModel, this.oData);
this.oCRUD.Update(this.oViewModel);
//Process Detail
this.oDatadetail = this.oSERVICE_worker_detail.setMonthRange(this.oViewModel, this.oDatadetail);
this.oDatadetail = this.oSERVICE_mapper_detail.Update_mapper(this.oViewModel, this.oDatadetail);
this.oCRUD_detail.Update(this.oDatadetail);
} //end if
} //end if
if (oCRUD.isERR)
{
TempData["ERRMSG"] = oCRUD.ERRMSG;
return(RedirectToAction("ErrorSYS", "Error"));
} //End if (!oCRUD.isERR) {
TempData["CRUDSavedOrDelete"] = valFLAG.FLAG_TRUE;
TempData["CRUDAction"] = "_PartialConfirmDeleted";
return(RedirectToAction("Create", new { id = this.oDatadetail.STUDENT_ID, id2 = this.oDatadetail.YEAR_ID }));
}
} //End private Transaction_indetailVM addDetail_SPPdenda_first_BAKSTOPIFLUNAS(Transaction_indetailVM poViewModel, MonthsppVM poItem)
private Transaction_indetailVM addDetail_SPPdenda_next_BAKSTOPIFLUNAS(Transaction_indetailVM poViewModel, MonthsppVM poItem)
{
Transaction_indetailVM oViewModel = poViewModel;
MonthsppVM item = poItem;
Byte?nMONTH1 = oViewModel.MONTHSPP2;
Byte?nMONTH2 = oViewModel.MONTHSPP3;
Byte?nMONTH2b = (Byte?)((nMONTH1 + nMONTH2) - 1);
nMONTH2 = nMONTH2b;
if (nMONTH2 > 12)
{
nMONTH2 = 12;
}
if (oViewModel.IGNOREDENDA != 1)
{
if ((item.MONTHSPP_SEQNO >= nMONTH1) &&
(item.MONTHSPP_SEQNO <= nMONTH2))
{
//Add Transaction Detail-DENDA
oViewModel = this.addDetail_SPPdenda(oViewModel, item);
} //End if ((item.MONTHSPP_SEQNO >= oViewModel.MONTHSPP1.MONTHSPP_SEQNO) &&
} //End if (oViewModel.IGNOREDENDA == 1)
return(oViewModel);
} //End private Transaction_indetailVM addDetail_SPPdenda_next_BAKSTOPIFLUNAS(Transaction_indetailVM poViewModel, MonthsppVM poItem)
} //End method
//ITEM
private Transaction_inddetailVM getItem_CANINSTALL(Transaction_indetailVM poViewModel)
{
Transaction_inddetailVM vReturn = new Transaction_inddetailVM();
Transaction_indetailVM oViewModel = poViewModel;
//Add Transaction Detail
vReturn.TRINTYPE_ID = oViewModel.TRINTYPE_ID;
vReturn.TRND_METHODID = oViewModel.TRINMETHOD_ID;
vReturn.TRND_TYPEID = oViewModel.TRINTYPE_ID;
vReturn.TRINTYPE_CODE = oViewModel.TRINTYPE_CODE;
vReturn.TRINTYPE_SHORTDESC = oViewModel.TRINTYPE_SHORTDESC;
vReturn.TRINTYPE_DESC = oViewModel.TRINTYPE_DESC;
vReturn.TRND_QTY = 1;
vReturn.TRND_PRICE = 1;
vReturn.TRND_AMOUNT = oViewModel.TRND_AMOUNT;
vReturn.TRND_PRICEBASE = oViewModel.TRND_PRICEBASE;
vReturn.TRND_QTYBASE = 1;
vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNTBASE;
vReturn.TRND_DESC = oViewModel.TRND_DESC;
return(vReturn);
} //End private Transaction_inddetailVM getItem_CANINSTALL(Transaction_indetailVM poViewModel)
} //End private Transaction_indetailVM addDetail_SPPdenda_next_BAKSTOPIFLUNAS(Transaction_indetailVM poViewModel, MonthsppVM poItem)
//-issue#1, issue#2
private Transaction_indetailVM CREATEInitspp_ViewModel_BACKUP(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//Get INST MONTHLY
oViewModel.MONTHLY_INST = this.getINST_SPP(oViewModel);
oViewModel.MONTHLY_INST_SPP = oViewModel.MONTHLY_INST;
if (oViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
//EXTRA CUSTOM-TRANSACTIONDETAIL BASE
oViewModel.TRND_PRICEBASE = oViewModel.MONTHLY_INST.INST_PRICEBASE;
oViewModel.TRND_AMOUNTBASE = oViewModel.MONTHLY_INST.INST_PRICEBASE;
} //End if
//Detail MONTHS
oViewModel.MONTHLY_MONTHS = new List <MonthsppVM>();
if (oViewModel.MONTHLY_INST.INST_QTY <= 12)
{
oViewModel.MONTHS = oDSMonthspp.getDatalist_lookup();
oViewModel.MONTHSPP1 = oViewModel.MONTHS.Where(fld => fld.MONTHSPP_SEQNO == (Byte?)oViewModel.MONTHLY_INST.INST_QTY).FirstOrDefault();
foreach (var item in oViewModel.MONTHS)
{
if (item.MONTHSPP_SEQNO >= oViewModel.MONTHSPP1.MONTHSPP_SEQNO)
{
MonthsppVM oVM = new MonthsppVM();
oVM = item;
oViewModel.MONTHLY_MONTHS.Add(item);
} //End if (item.MONTHSPP_SEQNO == oViewModel.MONTHSPP1.MONTHSPP_SEQNO)
} //End foreach (var item in oSPP)
} //End if (oViewModel.MONTHLY_INST.INST_QTY <= 12)
return(oViewModel);
} //End private Transaction_indetailVM CREATEInitspp_ViewModel(Transaction_indetailVM poViewModel)
} //End private Installment_indetailVM getINST_RANDOM(Transaction_indetailVM poViewModel)
private Transaction_inddetailVM getItem_RANDOM(Transaction_indetailVM poViewModel)
{
Transaction_inddetailVM vReturn = new Transaction_inddetailVM();
Transaction_indetailVM oViewModel = poViewModel;
//Add Transaction Detail
vReturn.TRINTYPE_ID = oViewModel.TRINTYPE_ID;
vReturn.TRND_METHODID = oViewModel.TRINMETHOD_ID;
vReturn.TRND_TYPEID = oViewModel.TRINTYPE_ID;
vReturn.TRINTYPE_CODE = oViewModel.TRINTYPE_CODE;
vReturn.TRINTYPE_SHORTDESC = oViewModel.TRINTYPE_SHORTDESC;
vReturn.TRINTYPE_DESC = oViewModel.TRINTYPE_DESC;
vReturn.TRND_QTY = 1;
vReturn.TRND_PRICE = oViewModel.TRND_AMOUNT;
vReturn.TRND_AMOUNT = oViewModel.TRND_AMOUNT;
vReturn.TRND_PRICEBASE = oViewModel.TRND_AMOUNT;
vReturn.TRND_QTYBASE = 1;
vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNT;
vReturn.INSTD_SEQNO = (int?)oViewModel.INST.INST_QTY;
if (vReturn.INST_AMOUNT < vReturn.INST_AMOUNTBASE)
{
vReturn.TRND_DESC = "Cicilan " + oViewModel.TRINTYPE_SHORTDESC + " ke " +
oViewModel.INST.INST_QTY.ToString() + " " +
oViewModel.YEAR_SHORTDESC;
}
else
{
vReturn.TRND_DESC = "Pelunasan " + oViewModel.TRINTYPE_SHORTDESC +
oViewModel.YEAR_SHORTDESC;
}
return(vReturn);
} //End private Transaction_inddetailVM getItem_RANDOM(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
} //End private Transaction_inddetailVM getItem_DendaSPP(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
private Transaction_inddetailVM getItem_DendaSPP_BAKSTOPIFLUNAS(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
{
Transaction_inddetailVM vReturn = null;
Transaction_indetailVM oViewModel = poViewModel;
//Fill TRINTYPE
var oDataTrinttype = oDSTrintype.getData(valFLAG.FLAG_TRINTYPE_SPPDENDA);
Byte?nMonth = poMonthitem.MONTHSPP_SEQNO;
Byte?nSysmonth = oViewModel.MONTHS.Where(fld => fld.MONTHSPP_NUM == oViewModel.SYSDATE.Value.Month).FirstOrDefault().MONTHSPP_SEQNO;
if (nMonth < nSysmonth)
{
vReturn = new Transaction_inddetailVM();
//Add Transaction Detail
vReturn.TRINTYPE_ID = oViewModel.TRINTYPE_ID;
vReturn.TRND_METHODID = oDataTrinttype.TRINMETHOD_ID;
vReturn.TRND_TYPEID = oDataTrinttype.ID;
vReturn.TRINTYPE_CODE = oDataTrinttype.TRINTYPE_CODE;
vReturn.TRINTYPE_SHORTDESC = oDataTrinttype.TRINTYPE_SHORTDESC;
vReturn.TRINTYPE_DESC = oDataTrinttype.TRINTYPE_DESC;
vReturn.TRND_QTY = 1;
vReturn.TRND_PRICE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_AMOUNT = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_PRICEBASE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
vReturn.TRND_QTYBASE = 1;
vReturn.TRND_AMOUNTBASE = oViewModel.TRND_AMOUNT; //oViewModel.TRND_AMOUNT_DENDA;
//vReturn.TRND_DESC = "Denda SPP Bulan " + poMonthitem.MONTHSPP_SHORTDESC + " " + oViewModel.YEAR_SHORTDESC;
vReturn.TRND_DESC = "Denda SPP Bulan " + poMonthitem.MONTHSPP_SHORTDESC + " " + oViewModel.YEAR_SHORTDESC;
vReturn.INSTD_SEQNO = nMonth;
} //End if (nMonth < nSysmonth)
return(vReturn);
} //End private Transaction_inddetailVM getItem_DendaSPP_BAKSTOPIFLUNAS(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
public ActionResult Rekap(Transaction_indetailVM poViewModel)
{
//ViewBag.AC_MENU_ID = valMENU.MODULE_INDEX;
this.oData = poViewModel;
if (this.oData == null)
{
this.oData = new Transaction_indetailVM();
this.oData.YEAR_ID = this.oDSYear.getData_currentYearID();
}
var oData_year = this.oDSYear.getData(this.oData.YEAR_ID);
this.oData.YEAR_DESC = oData_year.YEAR_DESC;
this.oData.YEAR_FROM = oData_year.YEAR_FROM;
this.oData.YEAR_TO = oData_year.YEAR_TO;
this.oData.DETAIL = oDSDetail.getDatalist_report(
1, //SPP (1)
this.oData.YEAR_ID, this.oData.TRN_DT,
this.oData.CLASSTYPE_ID, this.oData.CLASSROOM_ID);
this.oData.TRN_AMOUNT = 0;
if (this.oData.DETAIL != null)
{
this.oData.TRN_AMOUNT = this.oData.DETAIL.Sum(fld => fld.TRND_AMOUNT);
}
this.prepareLookupFilter();
return(View(oData));
}
public ActionResult Indexbackdate(Transaction_indetailVM poViewModel)
{
//Set ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//Retreave Data requirement
YeardetailVM oDatayear = oDSYear.getData_byPeriod(oDSSysinfo.getData().SYSDATE);
StudentdetailVM oDatastudent = oDSStudent.getData(poViewModel.STUDENT_ID);
//Mapp data properti
oViewModel.InjectFrom(oDatastudent);
oViewModel.InjectFromStudentVM(oDatastudent);
oViewModel.InjectFromYearVM(oDatayear);
oViewModel.InjectReceipt();
oViewModel.setSYSDATE();
if ((oViewModel.TRN_DT >= oViewModel.YEAR_FROM) && (oViewModel.TRN_DT <= oViewModel.YEAR_TO))
{
Session[hlpConfig.SessionInfo.getTransaction_methodID()] = hlpConfig.SessionInfo.getTransaction_methodbackdate();
Session[hlpConfig.SessionInfo.getTransaction_inID()] = oViewModel;
Session[hlpConfig.SessionInfo.sSESSIONID_ISBACKDATE] = "YES";
return(RedirectToAction("Create"));
} //End if ((oViewModel.TRN_DT >= oViewModel.YEAR_FROM) && (oViewModel.TRN_DT <= oViewModel.YEAR_TO))
return(View(oViewModel));
}
public ActionResult Edit(Transaction_indetailVM poViewModel)
{
oVAL = new Transaction_in_Validation(poViewModel);
oVAL.Validate_Edit();
//Add Error if exists
for (int i = 0; i < oVAL.aValidationMSG.Count; i++)
{
ModelState.AddModelError(oVAL.aValidationMSG[i].VAL_ERRID, oVAL.aValidationMSG[i].VAL_ERRMSG);
} //End for (int i = 0; i < oVAL.aValidationMSG.Count; i++)
if (ModelState.IsValid)
{
oCRUD.Update(poViewModel);
if (oCRUD.isERR)
{
TempData["ERRMSG"] = oCRUD.ERRMSG;
return(RedirectToAction("ErrorSYS", "Error"));
} //End if (!oCRUD.isERR) {
TempData["CRUDSavedOrDelete"] = valFLAG.FLAG_TRUE;
return(RedirectToAction("Details", new { id = oCRUD.ID }));
}
return(View(poViewModel));
}
//MAP
private Transaction_indetailVM CREATEInitsclub_ViewModel(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//Get INST MONTHLY
oViewModel.MONTHLY_INST = this.getINST_SCLUB(oViewModel);
oViewModel.MONTHLY_INST_SCLUB = oViewModel.MONTHLY_INST;
//Detail MONTHS
oViewModel.MONTHLY_MONTHS = new List <MonthsppVM>();
if (oViewModel.MONTHLY_INST.INST_QTY <= 12)
{
oViewModel.MONTHS = oDSMonthspp.getDatalist_lookup();
oViewModel.MONTHSPP1 = oViewModel.MONTHS.Where(fld => fld.MONTHSPP_SEQNO == (Byte?)oViewModel.MONTHLY_INST.INST_QTY).FirstOrDefault();
foreach (var item in oViewModel.MONTHS)
{
if (item.MONTHSPP_SEQNO >= oViewModel.MONTHSPP1.MONTHSPP_SEQNO)
{
MonthsppVM oVM = new MonthsppVM();
oVM = item;
oViewModel.MONTHLY_MONTHS.Add(item);
} //End if (item.MONTHSPP_SEQNO == oViewModel.MONTHSPP1.MONTHSPP_SEQNO)
} //End foreach (var item in oSPP)
} //End if (oViewModel.MONTHLY_INST.INST_QTY <= 12)
return(oViewModel);
} //End private Transaction_indetailVM CREATEInitspp_ViewModel(Transaction_indetailVM poViewModel)
//ACTION-Main
private ActionResult gotoAction(Transaction_indetailVM poViewModel)
{
Transaction_indetailVM oViewModel = poViewModel;
//ACtionID=1: Save All Transaction
if (oViewModel.ActionID == 1)
{
return(this.gotoAction_1Save(oViewModel));
} //End if (oViewModel.ActionID == 1)
//ACtionID=2: Cancel-All Transaction
if (oViewModel.ActionID == 2)
{
return(this.gotoAction_2Cancel(oViewModel));
} //End if (oViewModel.ActionID == 2)
//ACtionID=3: Add/Edit-Transaction Detail
if (oViewModel.ActionID == 3)
{
return(this.gotoAction_3Detail(oViewModel));
} //End if (oViewModel.ActionID == 3)
//ACtionID=4: Delete-Transaction Detail
if (oViewModel.ActionID == 4)
{
return(this.gotoAction_4Delete(oViewModel));
} //End if (oViewModel.ActionID == 4)
return(View(oViewModel));
} //End private ActionResult gotoAction(Transaction_indetailVM poViewModel)
public virtual ActionResult Create(Transaction_indetailVM poViewModel)
{
if (this._Create_post(poViewModel))
{
return(RedirectToAction("Details", new { id = this.oCRUD.ID }));
} //End if
//Return
return(View("~/Views/Transaction_in/Create.cshtml", poViewModel));
} //End Action
} //End private ActionResult gotoAction_3Detail(Transaction_indetailVM poViewModel)
//ACTION-4Delete
private ActionResult gotoAction_4Delete(Transaction_indetailVM poViewModel)
{
Transaction_indetailVM oViewModel = poViewModel;
oViewModel.DETAIL = this.removeItem(oViewModel);
//Update session
this.updateSESSIOAN_Transaction(oViewModel);
return(RedirectToAction("Create"));
} //End private ActionResult gotoAction_4Delete(Transaction_indetailVM poViewModel)
} //End Action
protected virtual Boolean _Create_post(Transaction_indetailVM poViewModel)
{
Transaction_indetailVM oViewModel = poViewModel;
oViewModel.TRN_AMOUNT = hlpConvertionAndFormating.ConvertStringToDecimal(poViewModel.TRN_AMOUNT_S);
this.oVAL = new Transaction_in_Validation(oViewModel, oDS);
this.oVAL.Validate_Create();
//Add Error if exists
for (int i = 0; i < oVAL.aValidationMSG.Count; i++)
{
ModelState.AddModelError(this.oVAL.aValidationMSG[i].VAL_ERRID, this.oVAL.aValidationMSG[i].VAL_ERRMSG);
} //End for (int i = 0; i < this.oVAL.aValidationMSG.Count; i++)
if (ModelState.IsValid)
{
this.oData = oViewModel;
//BL-DATA=> Inject dependency
this.oBL.CRUD = this.oCRUD;
this.oBL.CRUD_detail = this.oCRUD_detail;
this.oBL.CRUD_inst = this.oCRUD_inst;
this.oBL.HEADER_data = this.oData;
//BL-DATA support (Optional)
//BL-RESULT=> Inject dependency
this.oBL.HEADER_result = new Transaction_indetailVM();
this.oBL.DETAIL_result = new Transaction_inddetailVM();
this.oBL.DETAIL_resultlist = new List <Transaction_inddetailVM>();
this.oBL.HEADER_inst_result = new Installment_indetailVM();
//BL-MAIN
this.oBL.Init();
this.oBL.Process();
this.oBL.Save();
if (this.oBL.RESULT == true)
{
this.oBL.Commit();
}
else
{
this.oBL.Rollback();
}
//this.oCRUD.Create(oViewModel);
//this.oCRUD.Commit();
if (this.oCRUD.isERR)
{
return(false);
} //End if (!this.oCRUD.isERR) {
TempData["CRUDSavedOrDelete"] = valFLAG.FLAG_TRUE;
return(true);
} //End if (ModelState.IsValid)
//Return
return(false);
} //End Method
public ActionResult Create()
{
//ViewBag.AC_MENU_ID = valMENU.MODULE_CREATE;
ViewBag.CRUD_type = hlpFlags_CRUDOption.CREATE;
Transaction_indetailVM oModel = new Transaction_indetailVM();
if (Session[hlpConfig.SessionInfo.getTransaction_inID()] != null)
{
oModel = (Transaction_indetailVM)Session[hlpConfig.SessionInfo.getTransaction_inID()];
} //End if (Session[hlpConfig.SessionInfo.getTransaction_inID()] != null)
//Calculate Transaction
oModel.TRN_AMOUNT = 0;
if (oModel.DETAIL != null)
{
foreach (var item in oModel.DETAIL)
{
if (item.TRND_AMOUNT != null)
{
oModel.TRN_AMOUNT = oModel.TRN_AMOUNT + item.TRND_AMOUNT;
}
} //End foreach (var item in oModel.DETAIL)
} //End if (oModel.DETAIL != null)
prepareLookup();
//Cleanup installment
if (oModel.INSTLIST != null)
{
oModel.INSTLIST.RemoveAll(fld => fld.INST_TYPEID == null);
}
if (oModel.MONTHLY_INST_SPP != null)
{
if (oModel.MONTHLY_INST_SPP.INST_TYPEID == null)
{
oModel.MONTHLY_INST_SPP = null;
}
}
if (oModel.MONTHLY_INST_SCLUB != null)
{
if (oModel.MONTHLY_INST_SCLUB.INST_TYPEID == null)
{
oModel.MONTHLY_INST_SCLUB = null;
}
}
if (oModel.MONTHLY_INST_EKSKUL != null)
{
if (oModel.MONTHLY_INST_EKSKUL.INST_TYPEID == null)
{
oModel.MONTHLY_INST_EKSKUL = null;
}
}
return(View(oModel));
}
} //End private Transaction_inddetailVM getItem_CANINSTALL(MonthsppVM poMonthitem, Transaction_indetailVM poViewModel)
private Transaction_indetailVM CREATEInitCANINSTALL_ViewModel_BAK20170511(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//GET EXTRA CUSTOM-TRANSACTIONDETAIL BASE
oDSClasslevel.getData(oViewModel.CLASSLEVEL_ID, oViewModel.TRINTYPE_ID, oViewModel.IS_PINDAHAN);
//Get INST RANDOM
oViewModel.INST = this.getINST_CANINSTALL(oViewModel);
if (oViewModel.INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
//EXTRA CUSTOM-TRANSACTIONDETAIL BASE
oViewModel.TRND_PRICEBASE = oViewModel.INST.INST_PRICEBASE;
oViewModel.TRND_AMOUNTBASE = oViewModel.INST.INST_AMOUNTBASE;
} //End if
//ACtionID=3: Create/Add transaction Detail
if (oViewModel.ActionID == 3)
{
//EXTRA CUSTOM-TRANSACTIONDETAIL
oViewModel.TRND_AMOUNT = oViewModel.INST.INST_AMOUNT_OUTSTANDING;
oViewModel.TRND_DESC = null;
}
//ACtionID=4: Edit transaction Detail
if (oViewModel.ActionID == 4)
{
//EXTRA CUSTOM-TRANSACTIONDETAIL
oViewModel.TRND_AMOUNT = oViewModel.TRND_AMOUNT;
oViewModel.TRND_DESC = oViewModel.TRND_DESC;
//EXTRA CUSTOM-TRANSACTIONDETAIL-DENDA
oViewModel.TRND_AMOUNT_DENDA = oViewModel.TRND_AMOUNT_DENDA;
oViewModel.TRND_DESC_DENDA = oViewModel.TRND_DESC_DENDA;
} //End if
//Get INSTLIST RANDOM
if (oViewModel.INSTLIST == null)
{
oViewModel.INSTLIST = new List <Installment_indetailVM>();
}
if (oViewModel.INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
//if (oViewModel.INSTLIST == null) oViewModel.INSTLIST = new List<Installment_indetailVM>();
oViewModel.INSTLIST.Add(oViewModel.INST);
}
else
{
oViewModel.INSTLIST.RemoveAll(fld => fld.INST_TYPEID == oViewModel.INST.INST_TYPEID);
oViewModel.INSTLIST.Add(oViewModel.INST);
} //end if
return(oViewModel);
} //End method
public ActionResult Rekap()
{
//ViewBag.AC_MENU_ID = valMENU.MODULE_INDEX;
Transaction_indetailVM oData = new Transaction_indetailVM();
oData.DETAIL = new List <Transaction_inddetailVM>();
oData.YEAR_ID = oDSYear.getData_currentYear().ID;
this.prepareLookupFilter();
return(View(oData));
}
public override ActionResult Create(Transaction_indetailVM poViewModel)
{
if (this._Create_post(poViewModel))
{
//return RedirectToAction("Details", new { id = this.oCRUD.ID });
//return RedirectToAction("Index");
return(RedirectToAction("Create", new { id = poViewModel.STUDENT_ID, id2 = poViewModel.YEAR_ID }));
} //End if
//Return
return(View(poViewModel));
} //End Action
//MAP
private Transaction_indetailVM CREATEInitekskul_ViewModel(Transaction_indetailVM poViewModel)
{
//Update ViewModel
Transaction_indetailVM oViewModel = poViewModel;
//Get INST MONTHLY
oViewModel.MONTHLY_INST = this.getINST_EKSKUL(oViewModel);
oViewModel.MONTHLY_INST_EKSKUL = oViewModel.MONTHLY_INST;
//Detail MONTHS
oViewModel.MONTHLY_MONTHS = oDSMonthspp.getDatalist_lookup();
return(oViewModel);
} //End private Transaction_indetailVM CREATEInitspp_ViewModel(Transaction_indetailVM poViewModel)
public ActionResult Reportprint()
{
//ViewBag.AC_MENU_ID = valMENU.MODULE_INDEX;
if (Session[hlpConfig.SessionInfo.getTransactionView_inID()] == null)
{
return(RedirectToAction("Index"));
} //End if (Session[hlpConfig.SessionInfo.getTransactionView_inID()] == null)
Transaction_indetailVM oViewmodel = (Transaction_indetailVM)Session[hlpConfig.SessionInfo.getTransactionView_inID()];
var oData = oDS.getData(oViewmodel.ID);
oData.DETAIL = oDSDetail.getDatalist_detail(oData.ID);
return(View(oData));
}
public ActionResult CreateOTHER()
{
//ViewBag.AC_MENU_ID = valMENU.MODULE_CREATE;
ViewBag.CRUD_type = hlpFlags_CRUDOption.CREATE;
//Update ViewModel
Transaction_indetailVM oViewModel = this.getSESSIOAN_Transaction();
oViewModel = CREATEInit_ViewModel(oViewModel);
updateSESSIOAN_Transaction(oViewModel);
this.prepareData(oViewModel);
return(View("~/Views/Transaction_in/4OTHER/CreateOTHER.cshtml", oViewModel));
} //End public ActionResult CreateOTHER()
