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);
}
}
