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