public DataTable GetDataByDuplicateKeys(BOL_RECEIPT_DETAILS_NON_AMIGO 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_NON_AMIGO B_RECEIPT_DETAILS_NON_AMIGO, 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_DETAILS_NON_AMIGO.DATA_CLASS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@RECORD_CLASS", B_RECEIPT_DETAILS_NON_AMIGO.RECORD_CLASS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DATE", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_DATE != null ? B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_CONTACT_NAME", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_CONTACT_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BANKS_NAME", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_BANKS_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BRANCH_NAME", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_BRANCH_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO_CLASS", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_ACCOUNT_NO_CLASS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_TYPE", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_ACCOUNT_TYPE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_ACCOUNT_NO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@RESEND_INDICATION", B_RECEIPT_DETAILS_NON_AMIGO.RESEND_INDICATION)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NAME", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NO", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_NO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DETAIL_CLASS", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_DETAIL_CLASS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@HANDLING_DATE", B_RECEIPT_DETAILS_NON_AMIGO.HANDLING_DATE != null ? B_RECEIPT_DETAILS_NON_AMIGO.HANDLING_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_DATE", B_RECEIPT_DETAILS_NON_AMIGO.DEPOSIT_DATE != null ? B_RECEIPT_DETAILS_NON_AMIGO.DEPOSIT_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_AMOUNT", B_RECEIPT_DETAILS_NON_AMIGO.DEPOSIT_AMOUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CHECK_CLASS", B_RECEIPT_DETAILS_NON_AMIGO.CHECK_CLASS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NAME ", B_RECEIPT_DETAILS_NON_AMIGO.CUSTOMER_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO_SHEETS", B_RECEIPT_DETAILS_NON_AMIGO.COLLECTION_NO_SHEETS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO", B_RECEIPT_DETAILS_NON_AMIGO.COLLECTION_NO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NO", B_RECEIPT_DETAILS_NON_AMIGO.CUSTOMER_NO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BANK_NAME", B_RECEIPT_DETAILS_NON_AMIGO.BANK_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BRANCH_NAME", B_RECEIPT_DETAILS_NON_AMIGO.BRANCH_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSFER_MESSAGE", B_RECEIPT_DETAILS_NON_AMIGO.TRANSFER_MESSAGE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@NOTE", B_RECEIPT_DETAILS_NON_AMIGO.NOTE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@NUMBER", B_RECEIPT_DETAILS_NON_AMIGO.NUMBER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_FILE_NAME", B_RECEIPT_DETAILS_NON_AMIGO.TRANSACTION_FILE_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_DATE_TIME", B_RECEIPT_DETAILS_NON_AMIGO.RUN_DATE_TIME != null ? B_RECEIPT_DETAILS_NON_AMIGO.RUN_DATE_TIME : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_RESULT", B_RECEIPT_DETAILS_NON_AMIGO.RUN_RESULT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DATA_MOVEMENT_INFORMATION", B_RECEIPT_DETAILS_NON_AMIGO.DATA_MOVEMENT_INFORMATION)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", B_RECEIPT_DETAILS_NON_AMIGO.PAYMENT_DAY != null ? B_RECEIPT_DETAILS_NON_AMIGO.PAYMENT_DAY : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", B_RECEIPT_DETAILS_NON_AMIGO.TYPE_OF_ALLOCATION)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_QUANTITY", B_RECEIPT_DETAILS_NON_AMIGO.ALLOCATED_QUANTITY)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_MONEY", B_RECEIPT_DETAILS_NON_AMIGO.ALLOCATED_MONEY)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", B_RECEIPT_DETAILS_NON_AMIGO.ALLOCATED_COMPLETION_DATE != null ? B_RECEIPT_DETAILS_NON_AMIGO.ALLOCATED_COMPLETION_DATE : (object)DBNull.Value)); oMaster.ExcuteQuery(1, out strMessage); //_M01 = oMaster.intRtnID; // return intRtn; }
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); } } }