public bool searchPayment(int id, string type, ref CheckQueueRecord Check)
{
int print_id = 0;
string tran_type = "BP-CHK";
if (type == "Check")
{
Check = getcheckQueueWithCheckNumber(id);
}
else
{
Check = getcheckQueue(id);
}
print_id = Check.print_id;
if (print_id != 0)
{
Check.CheckDetailList = cdMgr.getcheckDetailListForPrintId(print_id);
if (Check.pmt_method != "Check")
{
tran_type = "PMT";
}
Check.All_accounts_journal_entry_list = aajMgr.get_Entries(print_id, tran_type);
}
else
{
return(false);
}
return(true);
}
public bool checkIfExistCheck(CheckQueueRecord cRec)
{
SQL = "select count(print_id) from check_queue where elt_account_number = " + elt_account_number + " and print_id=" + cRec.print_id;
Cmd = new SqlCommand(SQL, Con);
int rowCount = 0;
try
{
Con.Open();
rowCount = Int32.Parse(Cmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
Con.Close();
}
if (rowCount > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable getCheckQueueDTwithinPeriod(string start, string end, int vendor_id, string checkNo, string refNo, int bank_acct, string method, Decimal amount)
{
DataTable dt = new DataTable();
SQL = "select convert( varchar(10), DATEPART(month, a.print_date)) +'/'+ convert( NVARCHAR(10),DATEPART(day, a.print_date))+'/'+convert( varchar(10),DATEPART(year, a.print_date)) as print_date,a.*, 0 as is_selected, case when check_type='BP' then 'pay_bills.aspx?view=yes&CheckQueueID='+convert( varchar(10),a.print_id) else 'write_check.aspx?view=yes&CheckQueueID='+convert( varchar(10),a.print_id) end as url" +
" from check_queue a where isnull(a.chk_void,'N') <>'Y' and a.elt_account_number = "
+ elt_account_number + " AND a.print_date >='" + start + "'and a.print_date <= '" + end + "'";
if (vendor_id != 0)
{
SQL += " AND vendor_number = " + vendor_id;
}
if (checkNo != "")
{
SQL += " AND check_no = '" + checkNo + "'";
}
if (refNo != "")
{
SQL += " AND memo = '" + refNo + "'";
}
if (bank_acct != 0)
{
SQL += " AND bank = " + bank_acct;
}
if (method != "")
{
SQL += " AND pmt_method = '" + method + "'";
}
if (amount != 0)
{
SQL += " AND check_amt = " + amount;
}
try
{
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
CheckQueueRecord cQRec = new CheckQueueRecord();
GeneralUtility gUtil = new GeneralUtility();
ad.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public CheckQueueRecord getcheckQueue(int print_id)
{
SQL = "select isnull(chk_void,'N') as chk_void, isnull(chk_complete,'N') as chk_complete, * from check_queue where elt_account_number = " + elt_account_number + " and print_id=" + print_id;
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
CheckQueueRecord cQRec = new CheckQueueRecord();
GeneralUtility gUtil = new GeneralUtility();
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
try
{
gUtil.removeNull(ref dt);
cQRec.ap = Int32.Parse(dt.Rows[0]["ap"].ToString());
cQRec.bank = Int32.Parse(dt.Rows[0]["bank"].ToString());
cQRec.bill_date = dt.Rows[0]["bill_date"].ToString();
cQRec.bill_due_date = dt.Rows[0]["bill_due_date"].ToString();
cQRec.check_amt = Decimal.Parse(dt.Rows[0]["check_amt"].ToString());
cQRec.check_no = Int32.Parse(dt.Rows[0]["Check_no"].ToString());
cQRec.check_type = dt.Rows[0]["Check_type"].ToString();
cQRec.is_org_merged = dt.Rows[0]["is_org_merged"].ToString();
cQRec.memo = dt.Rows[0]["memo"].ToString();
cQRec.pmt_method = dt.Rows[0]["pmt_method"].ToString();
cQRec.print_check_as = dt.Rows[0]["print_check_as"].ToString();
cQRec.print_date = dt.Rows[0]["print_date"].ToString();
cQRec.print_id = Int32.Parse((dt.Rows[0]["print_id"].ToString()));
cQRec.print_status = dt.Rows[0]["print_status"].ToString();
cQRec.vendor_info = dt.Rows[0]["vendor_info"].ToString();
cQRec.vendor_name = dt.Rows[0]["vendor_name"].ToString();
cQRec.vendor_number = Int32.Parse((dt.Rows[0]["vendor_number"].ToString()));
cQRec.chk_void = (dt.Rows[0]["chk_void"].ToString() == "Y" ? true : false);
cQRec.chk_complete = (dt.Rows[0]["chk_complete"].ToString() == "Y" ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
return(cQRec);
}
public bool enqueuePayment(CheckQueueRecord Check, string tran_type)
{
Check.replaceQuote();
bool return_val = false;
ArrayList AAJEntryList = Check.All_accounts_journal_entry_list;
int printID = getNextPrintID();
Check.print_id = printID;
for (int i = 0; i < AAJEntryList.Count; i++)
{
this.aajMgr.checkInitial_Acct_Record((AllAccountsJournalRecord)AAJEntryList[i]);
}
Cmd = new SqlCommand();
Cmd.Connection = Con;
Con.Open();
SqlTransaction trans = Con.BeginTransaction();
Cmd.Transaction = trans;
try
{
//UPDATE LIST OF BILLS TO SET THE CHANGES MADE BY PAYMENT
ArrayList bRecList = Check.BillList;
for (int i = 0; i < bRecList.Count; i++)
{
BillRecord bRec = (BillRecord)bRecList[i];
SQL = "update [bill] set ";
SQL += "elt_account_number='" + elt_account_number + "'";
SQL += ",bill_number='" + bRec.Bill_number + "'";
SQL += ",bill_type='" + bRec.Bill_type + "'";
SQL += ",vendor_number='" + bRec.Vendor_number + "'";
SQL += ",vendor_name='" + bRec.Vendor_name + "'";
SQL += ",bill_date='" + bRec.Bill_date + "'";
SQL += ",bill_due_date='" + bRec.Bill_due_date + "'";
SQL += ",bill_amt='" + bRec.Bill_amt + "'";
SQL += ",bill_amt_paid='" + bRec.Bill_amt_paid + "'";
SQL += ",bill_amt_due='" + bRec.Bill_amt_due + "'";
SQL += ",ref_no='" + bRec.Bill_amt_paid + "'";
SQL += ",bill_expense_acct='" + bRec.Bill_expense_acct + "'";
SQL += ",bill_ap='" + bRec.Bill_ap + "'";
SQL += ",bill_status='" + bRec.Bill_status + "'";
SQL += ",print_id='" + printID + "'";
SQL += ",lock='" + bRec.Lock + "'";
SQL += ",pmt_method='" + bRec.Pmt_method + "'";
SQL += " WHERE elt_account_number = " + elt_account_number + " and bill_number=" + bRec.Bill_number;
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
//INSERT CHECK DETAIL LIST
ArrayList chkList = Check.CheckDetailList;
for (int i = 0; i < chkList.Count; i++)
{
CheckDetailRecord cdRec = (CheckDetailRecord)chkList[i];
cdRec.replaceQuote();
cdRec.print_id = printID;
SQL = "INSERT INTO [check_detail] ";
SQL += "( elt_account_number, ";
SQL += "amt_due,";
SQL += "amt_paid,";
SQL += "bill_amt,";
SQL += "bill_number,";
SQL += "due_date,";
SQL += "invoice_no,";
SQL += "memo,";
SQL += "pmt_method,";
SQL += "print_id,";
SQL += "tran_id)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + cdRec.amt_due;
SQL += "','" + cdRec.amt_paid;
SQL += "','" + cdRec.bill_amt;
SQL += "','" + cdRec.bill_number;
SQL += "','" + cdRec.due_date;
SQL += "','" + cdRec.invoice_no;
SQL += "','" + cdRec.memo;
SQL += "','" + cdRec.pmt_method;
SQL += "','" + printID;
SQL += "','" + cdRec.tran_id;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
//INSERT AAJ ENTRIES
int tran_seq_id = 0;
SQL = "select max(tran_seq_num) from all_accounts_journal where elt_account_number = "
+ elt_account_number;
Cmd.CommandText = SQL;
int current = 0;
string id_str = Cmd.ExecuteScalar().ToString();
if (id_str != "")
{
current = Int32.Parse(id_str);
}
else
{
current = 0;
}
tran_seq_id = current + 1;
for (int i = 0; i < AAJEntryList.Count; i++)
{
((AllAccountsJournalRecord)AAJEntryList[i]).replaceQuote();
((AllAccountsJournalRecord)AAJEntryList[i]).tran_num = printID;
SQL = "INSERT INTO [all_accounts_journal] ";
SQL += "( elt_account_number, ";
SQL += "tran_num,";
SQL += "gl_account_number,";
SQL += "gl_account_name,";
SQL += "tran_seq_num,";
SQL += "tran_type,";
SQL += "tran_date,";
SQL += "Customer_Number,";
SQL += "Customer_Name,";
SQL += "debit_amount,";
SQL += "credit_amount,";
SQL += "balance,";
SQL += "previous_balance,";
SQL += "gl_balance,";
SQL += "gl_previous_balance)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_num;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_name;
SQL += "','" + tran_seq_id++;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_type;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_date;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_name;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).debit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).credit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).previous_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_previous_balance;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
string check_type = "";
if (tran_type == "BP-CHK")//ONLY AT BILL PAY
{
check_type = "C";
}
else
{
check_type = "BP";
}
SQL = "INSERT INTO [check_queue] ";
SQL += "(elt_account_number,";
SQL += "ap,";
SQL += "bank,";
SQL += "bill_date,";
SQL += "bill_due_date,";
SQL += "check_amt,";
SQL += "check_type,";
SQL += "memo,";
SQL += "pmt_method,";
SQL += "print_check_as,";
SQL += "print_date,";
SQL += "print_id,";
SQL += "print_status,";
SQL += "vendor_info,";
SQL += "vendor_name,";
if (Check.check_no != 0)
{
SQL += "check_no,";
}
SQL += "vendor_number)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + Check.ap;
SQL += "','" + Check.bank;
SQL += "','" + Check.bill_date;
SQL += "','" + Check.bill_due_date;
SQL += "','" + Check.check_amt;
SQL += "','" + check_type;
SQL += "','" + Check.memo;
SQL += "','" + Check.pmt_method;
SQL += "','" + Check.print_check_as;
SQL += "','" + Check.print_date;
SQL += "','" + Check.print_id;
SQL += "','" + Check.print_status;
SQL += "','" + Check.vendor_info;
SQL += "','" + Check.vendor_name;
if (Check.check_no != 0)
{
SQL += "','" + Check.check_no;
}
SQL += "','" + Check.vendor_number;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
trans.Commit();
return_val = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
Con.Close();
}
if (Check.check_no != 0)
{
GLManager glmgr = new GLManager(elt_account_number);
try
{
glmgr.updateNextCheckNumber(Check.bank, Check.check_no);
}
catch (Exception ex2)
{
throw ex2;
}
}
return(return_val);
}
public bool updateCheck(CheckQueueRecord Check, string tran_type)
{
bool return_val = false;
Check.replaceQuote();
BillManager bMgr = new BillManager(elt_account_number);
ArrayList AAJEntryList = Check.All_accounts_journal_entry_list;
int printID = Check.print_id;
BillRecord bRec = (BillRecord)Check.BillList[0];
if (bMgr.updateBillRecord(ref bRec, "CHK"))
{
for (int i = 0; i < AAJEntryList.Count; i++)
{
if (((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != -1 && ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != 0)
{
this.aajMgr.checkInitial_Acct_Record((AllAccountsJournalRecord)AAJEntryList[i]);
}
}
int tran_seq_id = this.aajMgr.getNextTranSeqNumber();
Cmd = new SqlCommand();
Cmd.Connection = Con;
Con.Open();
SqlTransaction trans = Con.BeginTransaction();
Cmd.Transaction = trans;
try
{
//DELETE PREVIOUS CHECK_DETAIL LIST
SQL = "DELETE FROM check_detail where elt_account_number =" + elt_account_number + " and print_id=" + printID;
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
//DELETE ALL_ACCOUNTS_JOURNAL ENTRY
SQL = "DELETE FROM all_accounts_journal where elt_account_number =" + elt_account_number + " and tran_num=" + printID + " and tran_type='" + tran_type + "'";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
//INSERT CHECK_DETAL LIST
ArrayList chkList = Check.CheckDetailList;
for (int i = 0; i < chkList.Count; i++)
{
CheckDetailRecord cdRec = (CheckDetailRecord)chkList[i];
cdRec.replaceQuote();
cdRec.print_id = printID;
SQL = "INSERT INTO [check_detail] ";
SQL += "( elt_account_number, ";
SQL += "amt_due,";
SQL += "amt_paid,";
SQL += "bill_amt,";
SQL += "bill_number,";
SQL += "due_date,";
SQL += "invoice_no,";
SQL += "memo,";
SQL += "pmt_method,";
SQL += "print_id,";
SQL += "tran_id)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + cdRec.amt_due;
SQL += "','" + cdRec.amt_paid;
SQL += "','" + cdRec.bill_amt;
SQL += "','" + cdRec.bill_number;
SQL += "','" + cdRec.due_date;
SQL += "','" + cdRec.invoice_no;
SQL += "','" + cdRec.memo;
SQL += "','" + cdRec.pmt_method;
SQL += "','" + printID;
SQL += "','" + cdRec.tran_id;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
//INSERT AAJ ENTRIES
for (int i = 0; i < AAJEntryList.Count; i++)
{
if (((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != -1 && ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != 0)
{
((AllAccountsJournalRecord)AAJEntryList[i]).replaceQuote();
((AllAccountsJournalRecord)AAJEntryList[i]).tran_num = printID;
SQL = "INSERT INTO [all_accounts_journal] ";
SQL += "( elt_account_number, ";
SQL += "tran_num,";
SQL += "gl_account_number,";
SQL += "gl_account_name,";
SQL += "tran_seq_num,";
SQL += "tran_type,";
SQL += "tran_date,";
SQL += "Customer_Number,";
SQL += "Customer_Name,";
SQL += "debit_amount,";
SQL += "credit_amount,";
SQL += "balance,";
SQL += "previous_balance,";
SQL += "gl_balance,";
SQL += "gl_previous_balance)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_num;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_name;
SQL += "','" + tran_seq_id++;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_type;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_date;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_name;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).debit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).credit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).previous_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_previous_balance;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
}
//UPDATE THE CHECK
string check_type = "";
if (tran_type == "CHK" || tran_type == "CSH" || tran_type == "CRC" || tran_type == "BTB")
{
check_type = "C";
}
else
{
check_type = "BP";
}
SQL = "UPDATE [check_queue] ";
SQL += "Set elt_account_number='" + elt_account_number + "',";
SQL += "ap='" + Check.ap + "',";
SQL += "bank='" + Check.bank + "',";
SQL += "bill_date='" + Check.bill_date + "',";
SQL += "bill_due_date='" + Check.bill_due_date + "',";
SQL += "check_amt='" + Check.check_amt + "',";
SQL += "check_type='" + check_type + "',";
SQL += "memo='" + Check.memo + "',";
SQL += "pmt_method='" + Check.pmt_method + "',";
SQL += "print_check_as='" + Check.print_check_as + "',";
SQL += "print_date='" + Check.print_date + "',";
SQL += "print_id='" + Check.print_id + "',";
SQL += "print_status='" + Check.print_status + "',";
SQL += "vendor_info='" + Check.vendor_info + "',";
SQL += "vendor_name='" + Check.vendor_name + "',";
SQL += "vendor_number='" + Check.vendor_number + "'";
SQL += "where elt_account_number =" + elt_account_number
+ " and print_id=" + printID;
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
trans.Commit();
return_val = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
Con.Close();
}
}
return(return_val);
}
public bool enqueueCheck(CheckQueueRecord Check, string tran_type)
{
bool return_val = false;
Check.replaceQuote();
BillManager bMgr = new BillManager(elt_account_number);
ArrayList AAJEntryList = Check.All_accounts_journal_entry_list;
int printID = getNextPrintID();
Check.print_id = printID;
BillRecord bRec = (BillRecord)Check.BillList[0];
bRec.Print_id = printID;
if (bMgr.insertBillRecord(ref bRec, "CHK"))
{
for (int i = 0; i < AAJEntryList.Count; i++)
{
if (((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != -1 && ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != 0)
{
this.aajMgr.checkInitial_Acct_Record((AllAccountsJournalRecord)AAJEntryList[i]);
}
}
int tran_seq_id = this.aajMgr.getNextTranSeqNumber();
//INSERT CHECK_DETAL LIST
Cmd = new SqlCommand();
Cmd.Connection = Con;
Con.Open();
SqlTransaction trans = Con.BeginTransaction();
Cmd.Transaction = trans;
try
{
ArrayList chkList = Check.CheckDetailList;
for (int i = 0; i < chkList.Count; i++)
{
CheckDetailRecord cdRec = (CheckDetailRecord)chkList[i];
cdRec.replaceQuote();
cdRec.print_id = printID;
SQL = "INSERT INTO [check_detail] ";
SQL += "( elt_account_number, ";
SQL += "amt_due,";
SQL += "amt_paid,";
SQL += "bill_amt,";
SQL += "bill_number,";
SQL += "due_date,";
SQL += "invoice_no,";
SQL += "memo,";
SQL += "pmt_method,";
SQL += "print_id,";
SQL += "tran_id)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + cdRec.amt_due;
SQL += "','" + cdRec.amt_paid;
SQL += "','" + cdRec.bill_amt;
SQL += "','" + cdRec.bill_number;
SQL += "','" + cdRec.due_date;
SQL += "','" + cdRec.invoice_no;
SQL += "','" + cdRec.memo;
SQL += "','" + cdRec.pmt_method;
SQL += "','" + printID;
SQL += "','" + cdRec.tran_id;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
//INSERT AAJ ENTRIES
for (int i = 0; i < AAJEntryList.Count; i++)
{
if (((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != -1 && ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number != 0)
{
((AllAccountsJournalRecord)AAJEntryList[i]).replaceQuote();
((AllAccountsJournalRecord)AAJEntryList[i]).tran_num = printID;
SQL = "INSERT INTO [all_accounts_journal] ";
SQL += "( elt_account_number, ";
SQL += "tran_num,";
SQL += "gl_account_number,";
SQL += "gl_account_name,";
SQL += "tran_seq_num,";
SQL += "tran_type,";
SQL += "tran_date,";
SQL += "Customer_Number,";
SQL += "Customer_Name,";
SQL += "debit_amount,";
SQL += "credit_amount,";
SQL += "balance,";
SQL += "previous_balance,";
SQL += "gl_balance,";
SQL += "gl_previous_balance)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_num;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_account_name;
SQL += "','" + tran_seq_id++;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_type;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).tran_date;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_number;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).customer_name;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).debit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).credit_amount;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).previous_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_balance;
SQL += "','" + ((AllAccountsJournalRecord)AAJEntryList[i]).gl_previous_balance;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
}
}
//INSERT A CHECK
string check_type = "";
if (tran_type == "CHK" || tran_type == "CSH" || tran_type == "CRC" || tran_type == "BTB")
{
check_type = "C";
}
else
{
check_type = "BP";
}
SQL = "INSERT INTO [check_queue] ";
SQL += "(elt_account_number,";
SQL += "ap,";
SQL += "bank,";
SQL += "bill_date,";
SQL += "bill_due_date,";
SQL += "check_amt,";
SQL += "check_type,";
SQL += "memo,";
SQL += "pmt_method,";
SQL += "print_check_as,";
SQL += "print_date,";
SQL += "print_id,";
SQL += "print_status,";
SQL += "vendor_info,";
SQL += "vendor_name,";
if (Check.check_no != 0)
{
SQL += "check_no,";
}
SQL += "vendor_number)";
SQL += "VALUES";
SQL += "('" + elt_account_number;
SQL += "','" + Check.ap;
SQL += "','" + Check.bank;
SQL += "','" + Check.bill_date;
SQL += "','" + Check.bill_due_date;
SQL += "','" + Check.check_amt;
SQL += "','" + check_type;
SQL += "','" + Check.memo;
SQL += "','" + Check.pmt_method;
SQL += "','" + Check.print_check_as;
SQL += "','" + Check.print_date;
SQL += "','" + Check.print_id;
SQL += "','" + Check.print_status;
SQL += "','" + Check.vendor_info;
SQL += "','" + Check.vendor_name;
if (Check.check_no != 0)
{
SQL += "','" + Check.check_no;
}
SQL += "','" + Check.vendor_number;
SQL += "')";
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
trans.Commit();
return_val = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
Con.Close();
}
}
if (Check.check_no != 0)
{
GLManager glmgr = new GLManager(elt_account_number);
try
{
glmgr.updateNextCheckNumber(Check.bank, Check.check_no);
}
catch (Exception ex2)
{
throw ex2;
}
}
return(return_val);
}
