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