public void UpdatePaymentDay(BOL_RECEIPT_DETAILS B_Receipt, out string strMessage)
{
strMessage = "";
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, str_Update_Payment_Day);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", B_Receipt.PAYMENT_DAY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SEQ_NO", B_Receipt.SEQ_NO));
oMaster.ExcuteQuery(2, out strMessage);
string some = strMessage;
}
public Response do3B_BatchProcess()
{
DateTime run_date = DateTime.Now;
string strMessage = "";
using (TransactionScope dbTxn = new TransactionScope())
{
try
{
RECEIPT_DETAILS oRCP = new RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
DataTable dtReceiptDetail_Customer = oRCP.getUncompleteReceiptDetail();
for (int i = 0; i < dtReceiptDetail_Customer.Rows.Count; i++)
{
string COMPANY_NO_BOXES = (dtReceiptDetail_Customer.Rows[i]["COMPANIES"] == null ? "" : dtReceiptDetail_Customer.Rows[i]["COMPANIES"].ToString());
INVOICE_INFO oInv = new INVOICE_INFO(Properties.Settings.Default.MyConnection);
DataTable dtInvoice = oInv.getInvoiceByCustomer(COMPANY_NO_BOXES);
int SEQ_NO = 0;
int.TryParse((dtReceiptDetail_Customer.Rows[i]["SEQ_NO"] == null ? "" : dtReceiptDetail_Customer.Rows[i]["SEQ_NO"].ToString()), out SEQ_NO);
lstReserveInfo = new List <BOL_RESERVE_INFO>();
lstReceiptDetail = new List <BOL_RECEIPT_DETAILS>();
lstInvoiceInfo = new List <BOL_INVOICE_INFO>();
if (dtInvoice.Rows.Count > 0)
{
PrepareDataForUpdate(dtReceiptDetail_Customer.Rows[i], dtInvoice, run_date);
}
BOL_RECEIPT_DETAILS oRECEIPT_DETAILS = new BOL_RECEIPT_DETAILS();
oRECEIPT_DETAILS.PAYMENT_DAY = run_date;
oRECEIPT_DETAILS.SEQ_NO = SEQ_NO;
oRCP.UpdatePaymentDay(oRECEIPT_DETAILS, out strMessage);
}
dbTxn.Complete();
if (strMessage != "")
{
response.Status = 0;
}
else
{
response.Status = 1;
}
response.Message = strMessage;
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
dbTxn.Dispose();
return(response);
}
}
}
public void UpdateReceipt_Detail(BOL_RECEIPT_DETAILS B_Receipt, out string strMessage)
{
strMessage = "";
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateReceipt_Detail);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_MONEY", B_Receipt.ALLOCATED_MONEY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", B_Receipt.TYPE_OF_ALLOCATION));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", B_Receipt.PAYMENT_DAY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", B_Receipt.ALLOCATED_COMPLETION_DATE != null ? B_Receipt.ALLOCATED_COMPLETION_DATE : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_QUANTITY", B_Receipt.ALLOCATED_QUANTITY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SEQ_NO", B_Receipt.SEQ_NO));
oMaster.ExcuteQuery(2, out strMessage);
String some = strMessage;
}
public DataTable GetDataByDuplicateKeys(BOL_RECEIPT_DETAILS obj, out string strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strGetDuplicatedRecord);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@HANDLE_DATE", obj.HANDLING_DATE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_AMOUNT", obj.DEPOSIT_AMOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BANK_NAME", obj.BANK_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BRANCH_NAME", obj.BRANCH_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NAME", obj.CUSTOMER_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DATE", obj.TRANSACTION_DATE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NO", obj.TRANSACTION_NO));
oMaster.ExcuteQuery(4, out strMessage);
strMsg = strMessage;
return(oMaster.dtExcuted);
}
public void insert(BOL_RECEIPT_DETAILS B_Receipt, out string strMessage)
{
strMessage = "";
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);
//oMaster.crudCommand.Parameters.Add(new SqlParameter("@SEQ_NO", _SEQ_NO));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@DATA_CLASS", B_Receipt.DATA_CLASS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@RECORD_CLASS", B_Receipt.RECORD_CLASS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DATE", B_Receipt.TRANSACTION_DATE != null ? B_Receipt.TRANSACTION_DATE : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_CONTACT_NAME", B_Receipt.TRANSACTION_CONTACT_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BANKS_NAME", B_Receipt.TRANSACTION_BANKS_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BRANCH_NAME", B_Receipt.TRANSACTION_BRANCH_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO_CLASS", B_Receipt.TRANSACTION_ACCOUNT_NO_CLASS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_TYPE", B_Receipt.TRANSACTION_ACCOUNT_TYPE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO", B_Receipt.TRANSACTION_ACCOUNT_NO));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@RESEND_INDICATION", B_Receipt.RESEND_INDICATION));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NAME", B_Receipt.TRANSACTION_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NO", B_Receipt.TRANSACTION_NO));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DETAIL_CLASS", B_Receipt.TRANSACTION_DETAIL_CLASS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@HANDLING_DATE", B_Receipt.HANDLING_DATE != null ? B_Receipt.HANDLING_DATE : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_DATE", B_Receipt.DEPOSIT_DATE != null ? B_Receipt.DEPOSIT_DATE : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_AMOUNT", B_Receipt.DEPOSIT_AMOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CHECK_CLASS", B_Receipt.CHECK_CLASS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NAME ", B_Receipt.CUSTOMER_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO_SHEETS", B_Receipt.COLLECTION_NO_SHEETS));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO", B_Receipt.COLLECTION_NO));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NO", B_Receipt.CUSTOMER_NO));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BANK_NAME", B_Receipt.BANK_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BRANCH_NAME", B_Receipt.BRANCH_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSFER_MESSAGE", B_Receipt.TRANSFER_MESSAGE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@NOTE", B_Receipt.NOTE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@NUMBER", B_Receipt.NUMBER));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_FILE_NAME", B_Receipt.TRANSACTION_FILE_NAME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_DATE_TIME", B_Receipt.RUN_DATE_TIME != null ? B_Receipt.RUN_DATE_TIME : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_RESULT", B_Receipt.RUN_RESULT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@DATA_MOVEMENT_INFORMATION", B_Receipt.DATA_MOVEMENT_INFORMATION));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", B_Receipt.PAYMENT_DAY != null ? B_Receipt.PAYMENT_DAY : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", B_Receipt.TYPE_OF_ALLOCATION));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_QUANTITY", B_Receipt.ALLOCATED_QUANTITY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_MONEY", B_Receipt.ALLOCATED_MONEY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", B_Receipt.ALLOCATED_COMPLETION_DATE != null ? B_Receipt.ALLOCATED_COMPLETION_DATE : (object)DBNull.Value));
oMaster.ExcuteQuery(1, out strMessage);
//_M01 = oMaster.intRtnID;
// return intRtn;
}
private void PrepareDataForUpdate(DataRow dtReceiptDetail_Customer, DataTable dtBatch_Invoice, DateTime run_date)
{
decimal ALLOCATED_MONEY = 0;
decimal.TryParse((dtReceiptDetail_Customer["ALLOCATED_MONEY"] == null ? "" : dtReceiptDetail_Customer["ALLOCATED_MONEY"].ToString()), out ALLOCATED_MONEY);
decimal DEPOSIT_AMOUNT = 0;
decimal.TryParse((dtReceiptDetail_Customer["DEPOSIT_AMOUNT"] == null ? "" : dtReceiptDetail_Customer["DEPOSIT_AMOUNT"].ToString()), out DEPOSIT_AMOUNT);
decimal decAvailableAmount = DEPOSIT_AMOUNT - ALLOCATED_MONEY;
int SEQ_NO = 0;
int.TryParse((dtReceiptDetail_Customer["SEQ_NO"] == null ? "" : dtReceiptDetail_Customer["SEQ_NO"].ToString()), out SEQ_NO);
DateTime DEPOSIT_DATE;
DateTime.TryParse((dtReceiptDetail_Customer["DEPOSIT_AMOUNT"] == null ? "" : dtReceiptDetail_Customer["DEPOSIT_DATE"].ToString()), out DEPOSIT_DATE);
int ALLOCATED_QUANTITY = 0;
int.TryParse((dtReceiptDetail_Customer["ALLOCATED_QUANTITY"] == null ? "" : dtReceiptDetail_Customer["ALLOCATED_QUANTITY"].ToString()), out ALLOCATED_QUANTITY);
decimal CalculateForType = 0;
if (decAvailableAmount != 0)
{
BOL_RECEIPT_DETAILS oRECEIPT_DETAILS = new BOL_RECEIPT_DETAILS();
oRECEIPT_DETAILS.ALLOCATED_QUANTITY = ALLOCATED_QUANTITY;
oRECEIPT_DETAILS.ALLOCATED_MONEY = ALLOCATED_MONEY; //20201117_追加_ALLOCATED_MONEYを初期値でセット
#region Prepare Invoice, Reserve Info and Receipt Detail
for (int i = 0; i < dtBatch_Invoice.Rows.Count; i++)
{
//BILL PRICE
decimal BILL_PRICE = 0;
decimal.TryParse((dtBatch_Invoice.Rows[i]["BILL_PRICE"] == null ? "" : dtBatch_Invoice.Rows[i]["BILL_PRICE"].ToString()), out BILL_PRICE);
//ALLOCATATION TOTAL AMOUNT calculate
decimal ALLOCATION_TOTAL_AMOUNT = 0;
decimal.TryParse((dtBatch_Invoice.Rows[i]["ALLOCATION_TOTAL_AMOUNT"] == null ? "" : dtBatch_Invoice.Rows[i]["ALLOCATION_TOTAL_AMOUNT"].ToString()), out ALLOCATION_TOTAL_AMOUNT);
//BILL TRANSFER FEE
decimal BILL_TRANSFER_FEE = 0;
decimal.TryParse((dtBatch_Invoice.Rows[i]["BILL_TRANSFER_FEE"] == null ? "" : dtBatch_Invoice.Rows[i]["BILL_TRANSFER_FEE"].ToString()), out BILL_TRANSFER_FEE);
string strYear_Month = (dtBatch_Invoice.Rows[i]["YEAR_MONTH"] == null ? "" : dtBatch_Invoice.Rows[i]["YEAR_MONTH"].ToString());
string strCompanyNoBox = (dtBatch_Invoice.Rows[i]["COMPANY_NO_BOX"] == null ? "" : dtBatch_Invoice.Rows[i]["COMPANY_NO_BOX"].ToString());
CalculateForType = BILL_PRICE - ALLOCATION_TOTAL_AMOUNT + BILL_TRANSFER_FEE;
CalculateForType = (CalculateForType < 0 ? CalculateForType * -1 : CalculateForType);
BOL_RESERVE_INFO oRESERVE_INFO = new BOL_RESERVE_INFO();
BOL_INVOICE_INFO oInvoiceInfo = new BOL_INVOICE_INFO();
if (decAvailableAmount >= CalculateForType) //Type A
{
//Prepare Update For Invoice
oInvoiceInfo.ALLOCATION_TOTAL_AMOUNT = ALLOCATION_TOTAL_AMOUNT + CalculateForType;
oInvoiceInfo.ALLOCATED_COMPLETION_DATE = run_date;
oInvoiceInfo.YEAR_MONTH = strYear_Month;
oInvoiceInfo.COMPANY_NO_BOX = strCompanyNoBox;
oInvoiceInfo.TYPE_OF_ALLOCATION = 1;
oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM = DEPOSIT_DATE.ToString("yyMM");
oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE = DEPOSIT_DATE.ToString("yyyy-MM-dd");
lstInvoiceInfo.Add(oInvoiceInfo);
//Prepare Insert For Reserve Info
oRESERVE_INFO.SEQ_NO = SEQ_NO;
oRESERVE_INFO.BILLING_CODE = strCompanyNoBox + strYear_Month;
oRESERVE_INFO.PAYMENT_DAY = run_date;
oRESERVE_INFO.TYPE_OF_ALLOCATION = 1;
oRESERVE_INFO.RESERVE_AMOUNT = CalculateForType;
oRESERVE_INFO.DIFF_ALLOCATION_AMOUNT = decAvailableAmount - CalculateForType;
lstReserveInfo.Add(oRESERVE_INFO);
//Prepare Update for receipt detail
oRECEIPT_DETAILS.ALLOCATED_MONEY += CalculateForType;
if (DEPOSIT_AMOUNT == oRECEIPT_DETAILS.ALLOCATED_MONEY)
{
oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE = run_date;
}
oRECEIPT_DETAILS.SEQ_NO = SEQ_NO;
oRECEIPT_DETAILS.PAYMENT_DAY = run_date;
oRECEIPT_DETAILS.TYPE_OF_ALLOCATION = 1;
oRECEIPT_DETAILS.ALLOCATED_QUANTITY += 1;
lstReceiptDetail.Add(oRECEIPT_DETAILS);
decAvailableAmount = decAvailableAmount - CalculateForType;
}
else if (decAvailableAmount < CalculateForType) //Type B
{
//Prepare Update For Invoice Info
oInvoiceInfo.ALLOCATION_TOTAL_AMOUNT = ALLOCATION_TOTAL_AMOUNT + decAvailableAmount;
if (CalculateForType == 0)
{
oInvoiceInfo.ALLOCATED_COMPLETION_DATE = run_date;
}
oInvoiceInfo.YEAR_MONTH = strYear_Month;
oInvoiceInfo.COMPANY_NO_BOX = strCompanyNoBox;
oInvoiceInfo.TYPE_OF_ALLOCATION = 1;
oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM = DEPOSIT_DATE.ToString("yyMM");
oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE = DEPOSIT_DATE.ToString("yyyy-MM-dd");
lstInvoiceInfo.Add(oInvoiceInfo);
//Prepare Insert For Reserve Info
oRESERVE_INFO.SEQ_NO = SEQ_NO;
oRESERVE_INFO.BILLING_CODE = strCompanyNoBox + strYear_Month;
oRESERVE_INFO.PAYMENT_DAY = run_date;
oRESERVE_INFO.TYPE_OF_ALLOCATION = 1;
oRESERVE_INFO.RESERVE_AMOUNT = decAvailableAmount;
oRESERVE_INFO.DIFF_ALLOCATION_AMOUNT = decAvailableAmount - CalculateForType;
lstReserveInfo.Add(oRESERVE_INFO);
//Prepare Update for Receipt Detail
oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE = run_date;
oRECEIPT_DETAILS.ALLOCATED_MONEY = DEPOSIT_AMOUNT;
oRECEIPT_DETAILS.SEQ_NO = SEQ_NO;
oRECEIPT_DETAILS.PAYMENT_DAY = run_date;
oRECEIPT_DETAILS.TYPE_OF_ALLOCATION = 1;
oRECEIPT_DETAILS.ALLOCATED_QUANTITY += 1;
lstReceiptDetail.Add(oRECEIPT_DETAILS);
decAvailableAmount = decAvailableAmount - CalculateForType;
}
ALLOCATED_MONEY += oRECEIPT_DETAILS.ALLOCATED_MONEY;
if (oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE != null)
{
break;
}
}
#endregion
RECEIPT_DETAILS oRCP = new RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
INVOICE_INFO oInv = new INVOICE_INFO(Properties.Settings.Default.MyConnection);
RESERVE_INFO oReseve = new RESERVE_INFO(Properties.Settings.Default.MyConnection);
string strMessage = "";
for (int i = 0; i < lstReceiptDetail.Count; i++)
{
oRCP.UpdateReceipt_Detail(lstReceiptDetail[i], out strMessage);
}
for (int i = 0; i < lstInvoiceInfo.Count; i++)
{
oInv.UpdateInvoice_Info(lstInvoiceInfo[i], out strMessage);
}
for (int i = 0; i < lstReserveInfo.Count; i++)
{
oReseve.insert(lstReserveInfo[i], out strMessage);
}
}
}
protected void seperateAmigo_NonAmigo()
{
CUSTOMER_MASTER oCust = new CUSTOMER_MASTER(Properties.Settings.Default.MyConnection);
string run_date = DateTime.Now.ToString();
DataTable dtCustomer = oCust.getBillBankAccounts();
for (int i = 0; i < dtUploadData.Rows.Count; i++)
{
string strCustomerName = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString().Trim() : "");
var query = dtCustomer.AsEnumerable().Where
(r => (r.Field <string>("BILL_BANK_ACCOUNT_NAME-1") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-1").Trim()) == strCustomerName ||
(r.Field <string>("BILL_BANK_ACCOUNT_NAME-2") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-2").Trim()) == strCustomerName ||
(r.Field <string>("BILL_BANK_ACCOUNT_NAME-3") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-3").Trim()) == strCustomerName ||
(r.Field <string>("BILL_BANK_ACCOUNT_NAME-4") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-4").Trim()) == strCustomerName
);
if (query.Any()) //Amigo
{
BOL_RECEIPT_DETAILS oReceipt = new BOL_RECEIPT_DETAILS();
oReceipt.DATA_CLASS = 1;
oReceipt.RECORD_CLASS = (dtUploadData.Rows[i]["RECORD_CLASS"] != null ? dtUploadData.Rows[i]["RECORD_CLASS"].ToString() : "");
oReceipt.TRANSACTION_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["TRANSACTION_DATE"] != null ? dtUploadData.Rows[i]["TRANSACTION_DATE"].ToString() : "");
oReceipt.TRANSACTION_CONTACT_NAME = (dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"].ToString() : "");
oReceipt.TRANSACTION_BANKS_NAME = (dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"].ToString() : "");
oReceipt.TRANSACTION_BRANCH_NAME = (dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"].ToString() : "");
oReceipt.TRANSACTION_ACCOUNT_NO_CLASS = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"].ToString() : "");
oReceipt.TRANSACTION_ACCOUNT_TYPE = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"].ToString() : "");
oReceipt.TRANSACTION_ACCOUNT_NO = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"].ToString() : "");
oReceipt.RESEND_INDICATION = (dtUploadData.Rows[i]["RESEND_INDICATION"] != null ? dtUploadData.Rows[i]["RESEND_INDICATION"].ToString() : "");
oReceipt.TRANSACTION_NAME = (dtUploadData.Rows[i]["TRANSACTION_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_NAME"].ToString() : "");
oReceipt.TRANSACTION_NO = (dtUploadData.Rows[i]["TRANSACTION_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_NO"].ToString() : "");
oReceipt.TRANSACTION_DETAIL_CLASS = (dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"].ToString() : "");
oReceipt.HANDLING_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["HANDLING_DATE"] != null ? dtUploadData.Rows[i]["HANDLING_DATE"].ToString() : "");
oReceipt.DEPOSIT_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["DEPOSIT_DATE"] != null ? dtUploadData.Rows[i]["DEPOSIT_DATE"].ToString() : "");
oReceipt.DEPOSIT_AMOUNT = Utility_Component.dtColumnToDecimal(dtUploadData.Rows[i]["DEPOSIT_AMOUNT"] != null ? dtUploadData.Rows[i]["DEPOSIT_AMOUNT"].ToString() : "");
oReceipt.CHECK_CLASS = (dtUploadData.Rows[i]["CHECK_CLASS"] != null ? dtUploadData.Rows[i]["CHECK_CLASS"].ToString() : "");
oReceipt.CUSTOMER_NAME = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString() : "");
oReceipt.COLLECTION_NO_SHEETS = Utility_Component.dtColumnToInt(dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"] != null ? dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"].ToString() : "");
oReceipt.COLLECTION_NO = (dtUploadData.Rows[i]["COLLECTION_NO"] != null ? dtUploadData.Rows[i]["COLLECTION_NO"].ToString() : "");
oReceipt.CUSTOMER_NO = (dtUploadData.Rows[i]["CUSTOMER_NO"] != null ? dtUploadData.Rows[i]["CUSTOMER_NO"].ToString() : "");
oReceipt.BANK_NAME = (dtUploadData.Rows[i]["BANK_NAME"] != null ? dtUploadData.Rows[i]["BANK_NAME"].ToString() : "");
oReceipt.BRANCH_NAME = (dtUploadData.Rows[i]["BRANCH_NAME"] != null ? dtUploadData.Rows[i]["BRANCH_NAME"].ToString() : "");
oReceipt.TRANSACTION_FILE_NAME = (dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"].ToString() : "");
oReceipt.TRANSFER_MESSAGE = (dtUploadData.Rows[i]["TRANSFER_MESSAGE"] != null ? dtUploadData.Rows[i]["TRANSFER_MESSAGE"].ToString() : "");
oReceipt.NOTE = (dtUploadData.Rows[i]["NOTE"] != null ? dtUploadData.Rows[i]["NOTE"].ToString() : "");
oReceipt.NUMBER = (!String.IsNullOrEmpty(dtUploadData.Rows[i]["NUMBER"].ToString()) ? int.Parse(dtUploadData.Rows[i]["NUMBER"].ToString()) : 0);
oReceipt.RUN_DATE_TIME = run_date;
oReceipt.RUN_RESULT = 1;
oReceipt.DATA_MOVEMENT_INFORMATION = "";
oReceipt.PAYMENT_DAY = null;
oReceipt.TYPE_OF_ALLOCATION = 0;
oReceipt.ALLOCATED_QUANTITY = 0;
oReceipt.ALLOCATED_MONEY = 0;
oReceipt.ALLOCATED_COMPLETION_DATE = null;
lstAmigo.Add(oReceipt);
}
else //Non Amigo
{
BOL_RECEIPT_DETAILS_NON_AMIGO oReceipt_NonAmigo = new BOL_RECEIPT_DETAILS_NON_AMIGO();
oReceipt_NonAmigo.DATA_CLASS = 1;
oReceipt_NonAmigo.RECORD_CLASS = (dtUploadData.Rows[i]["RECORD_CLASS"] != null ? dtUploadData.Rows[i]["RECORD_CLASS"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["TRANSACTION_DATE"] != null ? dtUploadData.Rows[i]["TRANSACTION_DATE"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_CONTACT_NAME = (dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_BANKS_NAME = (dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_BRANCH_NAME = (dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_ACCOUNT_NO_CLASS = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_ACCOUNT_TYPE = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_ACCOUNT_NO = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"].ToString() : "");
oReceipt_NonAmigo.RESEND_INDICATION = (dtUploadData.Rows[i]["RESEND_INDICATION"] != null ? dtUploadData.Rows[i]["RESEND_INDICATION"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_NAME = (dtUploadData.Rows[i]["TRANSACTION_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_NO = (dtUploadData.Rows[i]["TRANSACTION_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_NO"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_DETAIL_CLASS = (dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"].ToString() : "");
oReceipt_NonAmigo.HANDLING_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["HANDLING_DATE"] != null ? dtUploadData.Rows[i]["HANDLING_DATE"].ToString() : "");
oReceipt_NonAmigo.DEPOSIT_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["DEPOSIT_DATE"] != null ? dtUploadData.Rows[i]["DEPOSIT_DATE"].ToString() : "");
oReceipt_NonAmigo.DEPOSIT_AMOUNT = Utility_Component.dtColumnToDecimal(dtUploadData.Rows[i]["DEPOSIT_AMOUNT"] != null ? dtUploadData.Rows[i]["DEPOSIT_AMOUNT"].ToString() : "");
oReceipt_NonAmigo.CHECK_CLASS = (dtUploadData.Rows[i]["CHECK_CLASS"] != null ? dtUploadData.Rows[i]["CHECK_CLASS"].ToString() : "");
oReceipt_NonAmigo.CUSTOMER_NAME = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString() : "");
oReceipt_NonAmigo.COLLECTION_NO_SHEETS = Utility_Component.dtColumnToInt(dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"] != null ? dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"].ToString() : "");
oReceipt_NonAmigo.COLLECTION_NO = (dtUploadData.Rows[i]["COLLECTION_NO"] != null ? dtUploadData.Rows[i]["COLLECTION_NO"].ToString() : "");
oReceipt_NonAmigo.CUSTOMER_NO = (dtUploadData.Rows[i]["CUSTOMER_NO"] != null ? dtUploadData.Rows[i]["CUSTOMER_NO"].ToString() : "");
oReceipt_NonAmigo.BANK_NAME = (dtUploadData.Rows[i]["BANK_NAME"] != null ? dtUploadData.Rows[i]["BANK_NAME"].ToString() : "");
oReceipt_NonAmigo.BRANCH_NAME = (dtUploadData.Rows[i]["BRANCH_NAME"] != null ? dtUploadData.Rows[i]["BRANCH_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSACTION_FILE_NAME = (dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"].ToString() : "");
oReceipt_NonAmigo.TRANSFER_MESSAGE = (dtUploadData.Rows[i]["TRANSFER_MESSAGE"] != null ? dtUploadData.Rows[i]["TRANSFER_MESSAGE"].ToString() : "");
oReceipt_NonAmigo.NOTE = (dtUploadData.Rows[i]["NOTE"] != null ? dtUploadData.Rows[i]["NOTE"].ToString() : "");
oReceipt_NonAmigo.NUMBER = (!String.IsNullOrEmpty(dtUploadData.Rows[i]["NUMBER"].ToString()) ? int.Parse(dtUploadData.Rows[i]["NUMBER"].ToString()) : 0);
oReceipt_NonAmigo.RUN_DATE_TIME = run_date;
oReceipt_NonAmigo.RUN_RESULT = 99;
oReceipt_NonAmigo.DATA_MOVEMENT_INFORMATION = "";
oReceipt_NonAmigo.PAYMENT_DAY = null;
oReceipt_NonAmigo.TYPE_OF_ALLOCATION = 0;
oReceipt_NonAmigo.ALLOCATED_QUANTITY = 0;
oReceipt_NonAmigo.ALLOCATED_MONEY = 0;
oReceipt_NonAmigo.ALLOCATED_COMPLETION_DATE = null;
lstNonAmigo.Add(oReceipt_NonAmigo);
}
}
}
