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 DataRetrieve()
{
try
{
Settlement_InfoController STFCtrl = new Settlement_InfoController();
dgvRefundLog.AutoGenerateColumns = false;
_dataSource = STFCtrl.SelectRefundList(clsGlobal.vSTFDate.ToString("yyyy/MM/dd"));
dgvRefundLog.DataSource = _dataSource;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool Update(MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections)
{
try
{
DataController.StartTransaction();
foreach (MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo in memberBankDetailTransactionInfoCollections)
{
DataController.Update(memberBankDetailTransactionInfoInfo.AcquringInstitutionID, memberBankDetailTransactionInfoInfo.ForwardInstitutionID, memberBankDetailTransactionInfoInfo.SystemTraceNo, memberBankDetailTransactionInfoInfo.TransDateTime, memberBankDetailTransactionInfoInfo.PAN, memberBankDetailTransactionInfoInfo.transAmount, memberBankDetailTransactionInfoInfo.AcceptanceAmount, memberBankDetailTransactionInfoInfo.CardHolderTransFee, memberBankDetailTransactionInfoInfo.MessageType, memberBankDetailTransactionInfoInfo.ProcessingCode, memberBankDetailTransactionInfoInfo.MerchantType, memberBankDetailTransactionInfoInfo.TerminalNo, memberBankDetailTransactionInfoInfo.CardAcceptorIDCode, memberBankDetailTransactionInfoInfo.RetrievalRefNo, memberBankDetailTransactionInfoInfo.POSConditionCode, memberBankDetailTransactionInfoInfo.AuthResponseCode, memberBankDetailTransactionInfoInfo.RecInstitutionID, memberBankDetailTransactionInfoInfo.OrgSystemTraceNo, memberBankDetailTransactionInfoInfo.ResponseCode, memberBankDetailTransactionInfoInfo.POSEntryMode, memberBankDetailTransactionInfoInfo.ServiceFeeReceive, memberBankDetailTransactionInfoInfo.ServiceFeePayable, memberBankDetailTransactionInfoInfo.InterChangeServiceFee, memberBankDetailTransactionInfoInfo.SAndDSwitchFlag, memberBankDetailTransactionInfoInfo.ReservedForUse, memberBankDetailTransactionInfoInfo.CreatedDate, memberBankDetailTransactionInfoInfo.BatchNo, memberBankDetailTransactionInfoInfo.FILENAME, memberBankDetailTransactionInfoInfo.FileType, memberBankDetailTransactionInfoInfo.SETTLEMENTDATE);
}
DataController.CommitTransaction();
}
catch (Exception ex)
{
DataController.RollbackTransaction();
return(false);
}
return(true);
}
public bool DeleteByAcquireInstitutionID(MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections)
{
string uniqueKey = "";
try
{
DataController.StartTransaction();
foreach (MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo in memberBankDetailTransactionInfoCollections)
{
uniqueKey = memberBankDetailTransactionInfoInfo.AcquringInstitutionID;
DataController.DeleteByAcquireInstitutionID(memberBankDetailTransactionInfoInfo.AcquringInstitutionID);
}
DataController.CommitTransaction();
}
catch (Exception ex)
{
DataController.RollbackTransaction();
return(false);
}
return(true);
}
public bool Add(MemberBankDetailTransactionInfoCollections memberBankDetailTransactionInfoCollections)
{
string uniqueKey = "";
try
{
DataController.StartTransaction();
foreach (MemberBankDetailTransactionInfoInfo memberBankDetailTransactionInfoInfo in memberBankDetailTransactionInfoCollections)
{
uniqueKey = memberBankDetailTransactionInfoInfo.AcquringInstitutionID;
memberBankDetailTransactionInfoInfo.AcquringInstitutionID =
DataController.Insert(
memberBankDetailTransactionInfoInfo.PAN,
memberBankDetailTransactionInfoInfo.ProcessingCode,
memberBankDetailTransactionInfoInfo.transAmount,
memberBankDetailTransactionInfoInfo.settlementAmount,
memberBankDetailTransactionInfoInfo.SetConservationRate,
memberBankDetailTransactionInfoInfo.SystemTraceNo,
memberBankDetailTransactionInfoInfo.TransDateTime,
memberBankDetailTransactionInfoInfo.SETTLEMENTDATE,
memberBankDetailTransactionInfoInfo.MerchantType,
memberBankDetailTransactionInfoInfo.TerminalNo,
memberBankDetailTransactionInfoInfo.AcquringInstitutionID,
memberBankDetailTransactionInfoInfo.IssuerBankCode,
memberBankDetailTransactionInfoInfo.BeneficiaryBankCode,
memberBankDetailTransactionInfoInfo.ForwardInstitutionID,
memberBankDetailTransactionInfoInfo.AuthResponseCode,
memberBankDetailTransactionInfoInfo.RetrievalRefNo,
memberBankDetailTransactionInfoInfo.CardAcceptorTerminalNo,
memberBankDetailTransactionInfoInfo.TransactionCurCode,
memberBankDetailTransactionInfoInfo.SettlementCurcode,
memberBankDetailTransactionInfoInfo.FromAccount,
memberBankDetailTransactionInfoInfo.ToAccount,
memberBankDetailTransactionInfoInfo.MessageType,
memberBankDetailTransactionInfoInfo.CardAcceptorIDCode,
memberBankDetailTransactionInfoInfo.ResponseCode,
memberBankDetailTransactionInfoInfo.ServiceFeeReceive,
memberBankDetailTransactionInfoInfo.ServiceFeePayable,
memberBankDetailTransactionInfoInfo.InterChangeServiceFee,
memberBankDetailTransactionInfoInfo.POSEntryMode,
memberBankDetailTransactionInfoInfo.OrgSystemTraceNo,
memberBankDetailTransactionInfoInfo.POSConditionCode,
memberBankDetailTransactionInfoInfo.AcceptanceAmount,
memberBankDetailTransactionInfoInfo.CardHolderTransType,
memberBankDetailTransactionInfoInfo.CardHolderTransFee,
memberBankDetailTransactionInfoInfo.TranTranmissionDate,
memberBankDetailTransactionInfoInfo.ReservedForUse,
memberBankDetailTransactionInfoInfo.CreatedDate,
memberBankDetailTransactionInfoInfo.BatchNo,
memberBankDetailTransactionInfoInfo.FILENAME,
memberBankDetailTransactionInfoInfo.FileType,
memberBankDetailTransactionInfoInfo.TranRespCode,
memberBankDetailTransactionInfoInfo.RefundStatus);
}
DataController.CommitTransaction();
}
catch (Exception ex)
{
DataController.RollbackTransaction();
return(false);
}
return(true);
}
public IBFTController()
{
//DataController = new MemberBankDetailTransactionInfoDataController();
MemberBankDetailController = new MemberBankDetailTransactionInfoController();
memberBankDetailTransactionInfoInfosCol = MemberBankDetailController.Select();
}