public bool DeleteByMPU_CODE(MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo) { MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections = new MPU_Settlement_InfoCollections(); mPU_Settlement_InfoCollections.Add(mPU_Settlement_InfoInfo); return(DeleteByMPU_CODE(mPU_Settlement_InfoCollections)); }
public bool Add(MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo) { MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections = new MPU_Settlement_InfoCollections(); mPU_Settlement_InfoCollections.Add(mPU_Settlement_InfoInfo); return(Add(mPU_Settlement_InfoCollections)); }
public MPU_Settlement_InfoCollections SelectCore_ATMACQandISS(string SettlementDate) { IDataReader dataReader = DataController.SelectCore_ATMACQandISS(SettlementDate); MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections = new MPU_Settlement_InfoCollections(); while (dataReader.Read()) { MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo = new MPU_Settlement_InfoInfo(); Filll(dataReader, mPU_Settlement_InfoInfo); mPU_Settlement_InfoCollections.Add(mPU_Settlement_InfoInfo); } return(mPU_Settlement_InfoCollections); }
public MPU_Settlement_InfoCollections Select() { IDataReader dataReader = DataController.Select(); MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections = new MPU_Settlement_InfoCollections(); while (dataReader.Read()) { MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo = new MPU_Settlement_InfoInfo(); Fill(dataReader, mPU_Settlement_InfoInfo); mPU_Settlement_InfoCollections.Add(mPU_Settlement_InfoInfo); } return(mPU_Settlement_InfoCollections); }
public bool Update(MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections) { try { DataController.StartTransaction(); foreach (MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo in mPU_Settlement_InfoCollections) { DataController.Update(mPU_Settlement_InfoInfo.MPU_CODE, mPU_Settlement_InfoInfo.OUTGOINGAMOUNT, mPU_Settlement_InfoInfo.OUTGOINGFEE, mPU_Settlement_InfoInfo.OUTGOINGMPUFEE, mPU_Settlement_InfoInfo.ATMOUTGOINGAMOUNT, mPU_Settlement_InfoInfo.ATMOUTGOINGFEE, mPU_Settlement_InfoInfo.ATMOUTGOINGMPUFEE, mPU_Settlement_InfoInfo.POSOUTGOINGAMOUNT, mPU_Settlement_InfoInfo.POSOUTGOINGFEE, mPU_Settlement_InfoInfo.POSOUTGOINGMPUFEE, mPU_Settlement_InfoInfo.INCOMINGAMOUNT, mPU_Settlement_InfoInfo.INCOMINGFEE, mPU_Settlement_InfoInfo.INCOMINGMPUFEE, mPU_Settlement_InfoInfo.ATMINCOMINGAMOUNT, mPU_Settlement_InfoInfo.ATMINCOMINGFEE, mPU_Settlement_InfoInfo.ATMINCOMINGMPUFEE, mPU_Settlement_InfoInfo.POSINCOMINGAMOUNT, mPU_Settlement_InfoInfo.POSINCOMINGFEE, mPU_Settlement_InfoInfo.POSINCOMINGMPUFEE, mPU_Settlement_InfoInfo.STFAMOUNT, mPU_Settlement_InfoInfo.STFFEE, mPU_Settlement_InfoInfo.OUTGOINGSUMMARY, mPU_Settlement_InfoInfo.INCOMINGSUMMARY, mPU_Settlement_InfoInfo.MPUSTARTDATE, mPU_Settlement_InfoInfo.MPUENDDATE); } DataController.CommitTransaction(); } catch (Exception ex) { DataController.RollbackTransaction(); return(false); } return(true); }
public bool DeleteByMPU_CODE(MPU_Settlement_InfoCollections mPU_Settlement_InfoCollections) { string uniqueKey = ""; try { DataController.StartTransaction(); foreach (MPU_Settlement_InfoInfo mPU_Settlement_InfoInfo in mPU_Settlement_InfoCollections) { uniqueKey = mPU_Settlement_InfoInfo.MPU_CODE; DataController.DeleteByMPU_CODE(mPU_Settlement_InfoInfo.MPU_CODE); } DataController.CommitTransaction(); } catch (Exception ex) { DataController.RollbackTransaction(); return(false); } return(true); }
private void MPUSettlementStatusRecord(int rowIndex, string status) { int i = rowIndex; try { //aa DateTime STFDate = Convert.ToDateTime(dgvSettlementLog.Rows[i].Cells["SettlementDate"].Value); MPU_Settlement_InfoController MPUSTFCtrl = new MPU_Settlement_InfoController(); MPU_Settlement_InfoCollections MPUSTFColl = MPUSTFCtrl.SelectBySettlementDate(STFDate.ToString("yyyy/MM/dd")); MPUSettlementStatusInfo MpuStmStatusinfo = new MPUSettlementStatusInfo(); MPUSettlementStatusController MPUSTFStaCol = new MPUSettlementStatusController(); MpuStmStatusinfo.MPUIncomingAmount = Convert.ToDecimal(dgvSettlementLog.Rows[i].Cells["IncomingAmount"].Value); MpuStmStatusinfo.MPUOutgoingAmount = Convert.ToDecimal(dgvSettlementLog.Rows[i].Cells["OUTGOINGAMOUNT"].Value); MpuStmStatusinfo.MPUIncomingFee = Convert.ToDecimal(dgvSettlementLog.Rows[i].Cells["INCOMINGFEE"].Value); MpuStmStatusinfo.MPUOutgoingFee = Convert.ToDecimal(dgvSettlementLog.Rows[i].Cells["OUTGOINGFEE"].Value); MpuStmStatusinfo.SettlementDate = Convert.ToDateTime(dgvSettlementLog.Rows[i].Cells["SettlementDate"].Value); MpuStmStatusinfo.CreatedDate = DateTime.Now; MpuStmStatusinfo.MPUSettlementID = Convert.ToString(System.Guid.NewGuid()); MpuStmStatusinfo.STATUS = status; if (MPUSTFColl.Count > 0) { MpuStmStatusinfo.CBSOutgoingAmount = Convert.ToDecimal(MPUSTFColl[0].INCOMINGAMOUNT); MpuStmStatusinfo.CBSOutgoingFee = Convert.ToDecimal(MPUSTFColl[0].INCOMINGMPUFEE); MpuStmStatusinfo.CBSIncomingAmount = Convert.ToDecimal(MPUSTFColl[0].OUTGOINGAMOUNT); MpuStmStatusinfo.CBSIncomingFee = Convert.ToDecimal(MPUSTFColl[0].OUTGOINGMPUFEE); } MPUSTFStaCol.Add(MpuStmStatusinfo); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dgvSettlementLog_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex < 0 || e.RowIndex < 0) { return; } if (Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["FileType"].Value) == "MB" & Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["STFFileName"].Value).Substring(0, 3) == "INC") { if (Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["FileType"].Value) == "MB" && Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["STFFileName"].Value).Substring(9, 3) == "01S") { DateTime STFDate = Convert.ToDateTime(dgvSettlementLog.Rows[e.RowIndex].Cells["SettlementDate"].Value); MPU_Settlement_InfoController MPUSTFCtrl = new MPU_Settlement_InfoController(); MPU_Settlement_InfoCollections MPUSTFColl = MPUSTFCtrl.SelectCore_EcomandPOSACQ(STFDate.ToString("yyyy/MM/dd")); DataReconcile frm = new DataReconcile(); frm.MPUOutgoingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingAmount"].Value); frm.MPUOutgoingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingFee"].Value); frm.MPUIncomingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingAmount"].Value); frm.MPUIncomingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingFee"].Value); if (MPUSTFColl.Count > 0) { frm.CBSIncomingAmount = Convert.ToString(MPUSTFColl[e.RowIndex].INCOMINGAMOUNT); frm.CBSIncomingFee = Convert.ToString(MPUSTFColl[e.RowIndex].INCOMINGMPUFEE); frm.CBSOutgoingAmount = Convert.ToString(MPUSTFColl[e.RowIndex].OUTGOINGAMOUNT); frm.CBSOutgoingFee = Convert.ToString(MPUSTFColl[e.RowIndex].OUTGOINGMPUFEE); } frm.ShowDialog(this); } else { DateTime STFDate = Convert.ToDateTime(dgvSettlementLog.Rows[e.RowIndex].Cells["SettlementDate"].Value); MPU_Settlement_InfoController MPUSTFCtrl = new MPU_Settlement_InfoController(); MPU_Settlement_InfoCollections MPUSTFColl = MPUSTFCtrl.SelectCore_EcomandPOSISS(STFDate.ToString("yyyy/MM/dd")); DataReconcile frm = new DataReconcile(); frm.MPUOutgoingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingAmount"].Value); frm.MPUOutgoingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingFee"].Value); frm.MPUIncomingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingAmount"].Value); frm.MPUIncomingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingFee"].Value); if (MPUSTFColl.Count > 0) { frm.CBSIncomingAmount = Convert.ToString(MPUSTFColl[0].INCOMINGAMOUNT); frm.CBSIncomingFee = Convert.ToString(MPUSTFColl[0].INCOMINGMPUFEE); frm.CBSOutgoingAmount = Convert.ToString(MPUSTFColl[0].OUTGOINGAMOUNT); frm.CBSOutgoingFee = Convert.ToString(MPUSTFColl[0].OUTGOINGMPUFEE); } frm.ShowDialog(this); } } else { DateTime STFDate = Convert.ToDateTime(dgvSettlementLog.Rows[e.RowIndex].Cells["SettlementDate"].Value); MPU_Settlement_InfoController MPUSTFCtrl = new MPU_Settlement_InfoController(); MPU_Settlement_InfoCollections MPUSTFColl = MPUSTFCtrl.SelectCore_ATMACQandISS(STFDate.ToString("yyyy/MM/dd")); DataReconcile frm = new DataReconcile(); frm.MPUOutgoingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingAmount"].Value); frm.MPUOutgoingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["IncomingFee"].Value); frm.MPUIncomingAmount = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingAmount"].Value); frm.MPUIncomingFee = Convert.ToString(dgvSettlementLog.Rows[e.RowIndex].Cells["OutgoingFee"].Value); if (MPUSTFColl.Count > 0) { frm.CBSIncomingAmount = Convert.ToString(MPUSTFColl[0].INCOMINGAMOUNT); frm.CBSIncomingFee = Convert.ToString(MPUSTFColl[0].INCOMINGMPUFEE); frm.CBSOutgoingAmount = Convert.ToString(MPUSTFColl[0].OUTGOINGAMOUNT); frm.CBSOutgoingFee = Convert.ToString(MPUSTFColl[0].OUTGOINGMPUFEE); } frm.ShowDialog(this); } }
private void DataReconcilation() { try { MPU_Settlement_InfoController MPUSTFCtrl = new MPU_Settlement_InfoController(); MPU_Settlement_InfoCollections MPUSTFColl = MPUSTFCtrl.Select(); string ErrorText = string.Empty; for (int j = 0; j < dgvSettlementLog.Rows.Count; j++) { ErrorText = string.Empty; if ((Convert.ToString(dgvSettlementLog.Rows[j].Cells["FileType"].Value) == "MB" && MPUSTFColl.Count <= 0)) { dgvSettlementLog.Rows[j].ErrorText = "There is no transaction at core-banking."; } for (int i = 0; i < MPUSTFColl.Count; i++) { if (Convert.ToString(dgvSettlementLog.Rows[j].Cells["FileType"].Value) != "MB") { break; } //Data Reconcile for Each Summary file if (Convert.ToDateTime(Convert.ToString(dgvSettlementLog.Rows[j].Cells["SettlementDate"].Value)).ToString("MM/dd/yyyy") == MPUSTFColl[i].MPUENDDATE.ToString("MM/dd/yyyy")) { if (Convert.ToString(dgvSettlementLog.Rows[j].Cells["FileType"].Value).Substring(0, 3) == "INC") { if (Convert.ToString(dgvSettlementLog.Rows[j].Cells["FileType"].Value).Substring(9, 3) == "01S") //for Acq { if (MPUSTFColl[i].POSINCOMINGAMOUNT + MPUSTFColl[i].EcomInamt != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["IncomingAmount"].Value)) { ErrorText = "POS and Ecom Incoming Amount isn't match."; } else if (MPUSTFColl[i].ATMINCOMINGFEE + MPUSTFColl[i].EcomInfee != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["IncomingFee"].Value)) { ErrorText = "POS and Ecom Incoming Fee isn't match."; } dgvSettlementLog.Rows[j].ErrorText = ErrorText; } else //for Issusing { if (MPUSTFColl[i].POSOUTGOINGAMOUNT + MPUSTFColl[i].Ecomoutamt != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["OutgoingAmount"].Value)) { ErrorText = "POS and Ecom Outgoing Amount isn't match."; } else if (MPUSTFColl[i].POSOUTGOINGFEE + MPUSTFColl[i].Ecomoutfee != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["OutgoingFee"].Value)) { ErrorText = " POS and Ecom Outgoing Fee isn't match."; } dgvSettlementLog.Rows[j].ErrorText = ErrorText; } } else //for ATM ACQ and ISS { if (MPUSTFColl[i].ATMINCOMINGAMOUNT != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["IncomingAmount"].Value)) { ErrorText = "ATM Incoming Amount isn't match."; } else if (MPUSTFColl[i].ATMINCOMINGFEE != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["IncomingFee"].Value)) { ErrorText = "ATM Incoming Fee isn't match."; } else if (MPUSTFColl[i].ATMOUTGOINGAMOUNT != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["OutgoingAmount"].Value)) { ErrorText = "ATM Outgoing Amount isn't match."; } else if (MPUSTFColl[i].ATMOUTGOINGFEE != Convert.ToDecimal(dgvSettlementLog.Rows[j].Cells["OutgoingFee"].Value)) { ErrorText = "ATM Outgoing Fee isn't match."; } else { ErrorText = string.Empty; dgvSettlementLog.Rows[j].ErrorText = ErrorText; } dgvSettlementLog.Rows[j].ErrorText = ErrorText; } } else { ErrorText = string.Empty; dgvSettlementLog.Rows[j].ErrorText = ErrorText; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }