public bool DeleteByAcquireInstitutionID(MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo)
{
MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections = new MemberBankDetailTransactionInfoCollections();
memberBankDetailTransactionInfoCollections.Add(memberBankDetailTransactionInfoInfo);
return(DeleteByAcquireInstitutionID(memberBankDetailTransactionInfoCollections));
}
private void btnApprove_Click(object sender, EventArgs e)
{
try
{
Settlement_InfoController STMCtrl = new Settlement_InfoController();
MemberBankDetailTransactionInfoCollections MBStmColl = new MemberBankDetailTransactionInfoCollections();
MemberBankDetailTransactionInfoInfo MBInfo;
for (int i = 0; i < dgvRefundLog.Rows.Count; i++)
{
string hostname = Dns.GetHostName();
string myIP = Dns.GetHostEntry(hostname).AddressList[0].ToString();
if (Convert.ToString(dgvRefundLog.Rows[i].Cells["Approve"].Value) == "1" && Convert.ToString(dgvRefundLog.Rows[i].Cells["FileType"].Value) == "MBA")
{
MBInfo = new MemberBankDetailTransactionInfoInfo();
MBInfo.PAN = Convert.ToString(dgvRefundLog.Rows[i].Cells["PAN"].Value);
MBInfo.settlementAmount = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["settlementAmount"].Value);
MBInfo.transAmount = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["transAmount"].Value);
MBInfo.ServiceFeeReceive = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["ServiceFeeReceive"].Value);
MBInfo.ServiceFeePayable = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["ServiceFeePayable"].Value);
MBInfo.FILENAME = Convert.ToString(dgvRefundLog.Rows[i].Cells["FILENAME"].Value);
MBInfo.RefundStatus = "A";
MBInfo.FileType = Convert.ToString(dgvRefundLog.Rows[i].Cells["FileType"].Value);
MBInfo.SETTLEMENTDATE = DateTime.Parse(dgvRefundLog.Rows[i].Cells["SETTLEMENTDATE"].Value.ToString());
MBStmColl.Add(MBInfo);
}
else if (Convert.ToString(dgvRefundLog.Rows[i].Cells["Approve"].Value) == "1" && Convert.ToString(dgvRefundLog.Rows[i].Cells["FileType"].Value) == "MBI")
{
MBInfo = new MemberBankDetailTransactionInfoInfo();
MBInfo.PAN = Convert.ToString(dgvRefundLog.Rows[i].Cells["PAN"].Value);
MBInfo.settlementAmount = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["settlementAmount"].Value);
MBInfo.transAmount = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["transAmount"].Value);
MBInfo.ServiceFeeReceive = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["ServiceFeeReceive"].Value);
MBInfo.ServiceFeePayable = Convert.ToDecimal(dgvRefundLog.Rows[i].Cells["ServiceFeePayable"].Value);
MBInfo.FILENAME = Convert.ToString(dgvRefundLog.Rows[i].Cells["FILENAME"].Value);
MBInfo.RefundStatus = "A";
MBInfo.FileType = Convert.ToString(dgvRefundLog.Rows[i].Cells["FileType"].Value);
MBInfo.SETTLEMENTDATE = DateTime.Parse(dgvRefundLog.Rows[i].Cells["SETTLEMENTDATE"].Value.ToString());
MBStmColl.Add(MBInfo);
}
} //end of for loop
if (MBStmColl.Count > 0)
{
STMCtrl.UpdateRefundStatus(MBStmColl); // Update Refund Status
}
if (MBStmColl.Count <= 0)
{
MessageBox.Show("There is no row to process.");
}
DataRetrieve();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MemberBankDetailTransactionInfoCollections Select()
{
IDataReader dataReader = DataController.Select();
MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections = new MemberBankDetailTransactionInfoCollections();
while (dataReader.Read())
{
MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo = new MemberBankDetailTransactionInfoInfo();
Fill(dataReader, memberBankDetailTransactionInfoInfo);
memberBankDetailTransactionInfoCollections.Add(memberBankDetailTransactionInfoInfo);
}
return(memberBankDetailTransactionInfoCollections);
}
public bool Add(MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo)
{
try
{
MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections = new MemberBankDetailTransactionInfoCollections();
memberBankDetailTransactionInfoCollections.Add(memberBankDetailTransactionInfoInfo);
return(Add(memberBankDetailTransactionInfoCollections));
}
catch (Exception ex)
{
throw ex;
}
}
private void Fill(IDataReader dataReader, MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo)
{
if (!(dataReader["AcquireInstitutionID"] is DBNull))
{
memberBankDetailTransactionInfoInfo.AcquringInstitutionID = Convert.ToString(dataReader["AcquireInstitutionID"]);
}
if (!(dataReader["ForwardInstitutionID"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ForwardInstitutionID = Convert.ToString(dataReader["ForwardInstitutionID"]);
}
if (!(dataReader["SystemTraceNo"] is DBNull))
{
memberBankDetailTransactionInfoInfo.SystemTraceNo = Convert.ToString(dataReader["SystemTraceNo"]);
}
if (!(dataReader["TransDateTime"] is DBNull))
{
memberBankDetailTransactionInfoInfo.TransDateTime = Convert.ToString(dataReader["TransDateTime"]);
}
if (!(dataReader["PAN"] is DBNull))
{
memberBankDetailTransactionInfoInfo.PAN = Convert.ToString(dataReader["PAN"]);
}
if (!(dataReader["transAmount"] is DBNull))
{
memberBankDetailTransactionInfoInfo.transAmount = Convert.ToDecimal(dataReader["transAmount"]);
}
if (!(dataReader["AcceptanceAmount"] is DBNull))
{
memberBankDetailTransactionInfoInfo.AcceptanceAmount = Convert.ToDecimal(dataReader["AcceptanceAmount"]);
}
if (!(dataReader["CardHolderTransFee"] is DBNull))
{
memberBankDetailTransactionInfoInfo.CardHolderTransFee = Convert.ToDecimal(dataReader["CardHolderTransFee"]);
}
if (!(dataReader["MessageType"] is DBNull))
{
memberBankDetailTransactionInfoInfo.MessageType = Convert.ToString(dataReader["MessageType"]);
}
if (!(dataReader["ProcessingCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ProcessingCode = Convert.ToString(dataReader["ProcessingCode"]);
}
if (!(dataReader["MerchantType"] is DBNull))
{
memberBankDetailTransactionInfoInfo.MerchantType = Convert.ToString(dataReader["MerchantType"]);
}
if (!(dataReader["TerminalNo"] is DBNull))
{
memberBankDetailTransactionInfoInfo.TerminalNo = Convert.ToString(dataReader["TerminalNo"]);
}
if (!(dataReader["CardAcceptorIDCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.CardAcceptorIDCode = Convert.ToString(dataReader["CardAcceptorIDCode"]);
}
if (!(dataReader["RetrievalRefNo"] is DBNull))
{
memberBankDetailTransactionInfoInfo.RetrievalRefNo = Convert.ToString(dataReader["RetrievalRefNo"]);
}
if (!(dataReader["POSConditionCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.POSConditionCode = Convert.ToString(dataReader["POSConditionCode"]);
}
if (!(dataReader["AuthResponseCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.AuthResponseCode = Convert.ToString(dataReader["AuthResponseCode"]);
}
if (!(dataReader["OrgSystemTraceNo"] is DBNull))
{
memberBankDetailTransactionInfoInfo.OrgSystemTraceNo = Convert.ToString(dataReader["OrgSystemTraceNo"]);
}
if (!(dataReader["ResponseCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ResponseCode = Convert.ToString(dataReader["ResponseCode"]);
}
if (!(dataReader["TranResponseCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.TranRespCode = Convert.ToString(dataReader["TranResponseCode"]);
}
if (!(dataReader["FromAccount"] is DBNull))
{
memberBankDetailTransactionInfoInfo.FromAccount = Convert.ToString(dataReader["FromAccount"]);
}
if (!(dataReader["ToAccount"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ToAccount = Convert.ToString(dataReader["ToAccount"]);
}
if (!(dataReader["POSEntryMode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.POSEntryMode = Convert.ToString(dataReader["POSEntryMode"]);
}
if (!(dataReader["ServiceFeeReceive"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ServiceFeeReceive = Convert.ToDecimal(dataReader["ServiceFeeReceive"]);
}
if (!(dataReader["ServiceFeePayable"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ServiceFeePayable = Convert.ToDecimal(dataReader["ServiceFeePayable"]);
}
if (!(dataReader["IssuerBankCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.IssuerBankCode = Convert.ToString(dataReader["IssuerBankCode"]);
}
// BeneficiaryBankCode
if (!(dataReader["BeneficiaryBankCode"] is DBNull))
{
memberBankDetailTransactionInfoInfo.BeneficiaryBankCode = Convert.ToString(dataReader["BeneficiaryBankCode"]);
}
if (!(dataReader["InterChangeServiceFee"] is DBNull))
{
memberBankDetailTransactionInfoInfo.InterChangeServiceFee = Convert.ToDecimal(dataReader["InterChangeServiceFee"]);
}
if (!(dataReader["ReservedForUse"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ReservedForUse = Convert.ToString(dataReader["ReservedForUse"]);
}
if (!(dataReader["ReservedForUse"] is DBNull))
{
memberBankDetailTransactionInfoInfo.ReservedForUse = Convert.ToString(dataReader["ReservedForUse"]);
}
if (!(dataReader["CreatedDate"] is DBNull))
{
memberBankDetailTransactionInfoInfo.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
}
if (!(dataReader["BatchNo"] is DBNull))
{
memberBankDetailTransactionInfoInfo.BatchNo = Convert.ToDecimal(dataReader["BatchNo"]);
}
if (!(dataReader["FILENAME"] is DBNull))
{
memberBankDetailTransactionInfoInfo.FILENAME = Convert.ToString(dataReader["FILENAME"]);
}
if (!(dataReader["FileType"] is DBNull))
{
memberBankDetailTransactionInfoInfo.FileType = Convert.ToString(dataReader["FileType"]);
}
if (!(dataReader["SETTLEMENTDATE"] is DBNull))
{
memberBankDetailTransactionInfoInfo.SETTLEMENTDATE = Convert.ToDateTime(dataReader["SETTLEMENTDATE"]);
}
}
