public bool checkIfPaymentReceivedForBill(string bill_number, ref ArrayList print_id)
{
bool return_val = false;
SQL = "select print_id from check_detail where elt_account_number =";
SQL += elt_account_number + " and bill_number="
+ bill_number;
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
CheckDetailRecord cDRec = new CheckDetailRecord();
GeneralUtility gUtil = new GeneralUtility();
ad.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
print_id.Add(Int32.Parse(dt.Rows[i][""].ToString()));
return_val = true;
}
catch (Exception ex)
{
throw ex;
}
}
return(return_val);
}
public ArrayList getcheckDetailForInvoice(int invoice_no)
{
SQL = "select '../enter_bill.aspx?view=yes&bill_number='+convert( NVARCHAR(10),bill_number) as url, print_id, tran_id, bill_number, due_date, bill_amt, amt_due, amt_paid, memo, pmt_method, check_no, isnull(invoice_no,'0') as invoice_no from check_detail where elt_account_number = " + elt_account_number + " and invoice_no=" + invoice_no;
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
CheckDetailRecord cDRec = new CheckDetailRecord();
GeneralUtility gUtil = new GeneralUtility();
ArrayList list = new ArrayList();
try
{
gUtil.removeNull(ref dt);
cDRec.amt_due = Decimal.Parse(dt.Rows[0]["amt_due"].ToString());
cDRec.amt_paid = Decimal.Parse(dt.Rows[0]["amt_paid"].ToString());
cDRec.bill_amt = Decimal.Parse(dt.Rows[0]["bill_amt"].ToString());
cDRec.bill_number = Int32.Parse((dt.Rows[0]["bill_number"].ToString()));
cDRec.due_date = DateTime.Parse(dt.Rows[0]["due_date"].ToString()).ToShortDateString();
if (dt.Rows[0]["invoice_no"].ToString() == "")
{
dt.Rows[0]["invoice_no"] = "0";
}
cDRec.invoice_no = Int32.Parse(dt.Rows[0]["invoice_no"].ToString());
cDRec.memo = dt.Rows[0]["memo"].ToString();
cDRec.pmt_method = dt.Rows[0]["pmt_method"].ToString();
cDRec.print_id = Int32.Parse((dt.Rows[0]["print_id"].ToString()));
cDRec.tran_id = Int32.Parse((dt.Rows[0]["tran_id"].ToString()));
list.Add(cDRec);
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public bool checkExistCheckDetail(CheckDetailRecord cdRec, ref SqlCommand Cmd)
{
SQL = "select tran_id from check_detail where elt_account_number =";
SQL += elt_account_number + " and tran_id="
+ cdRec.tran_id + " and print_id="
+ cdRec.print_id;
Cmd.CommandText = SQL;
int rowCount = 0;
try
{
rowCount = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
if (rowCount == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool insertCheckDetailList(ArrayList chkList, int printID)
{
bool return_val = false;
for (int i = 0; i < chkList.Count; i++)
{
try
{
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 = new SqlCommand(SQL, Con);
Con.Open();
Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
Con.Close();
}
return_val = true;
}
return(return_val);
}
public DataTable getcheckDetailForPrintIdDt(int print_id)
{
SQL = "select '../enter_bill.aspx?view=yes&bill_number='+convert( NVARCHAR(10),bill_number) as url, print_id, tran_id, bill_number, due_date, bill_amt, amt_due, amt_paid, memo, pmt_method, isnull(invoice_no,'0') as invoice_no from check_detail where elt_account_number = " + elt_account_number + " and print_id=" + print_id;
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
CheckDetailRecord cDRec = new CheckDetailRecord();
GeneralUtility gUtil = new GeneralUtility();
ad.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[0]["invoice_no"].ToString() == "")
{
dt.Rows[0]["invoice_no"] = "0";
}
}
return(dt);
}
public X9_DepositItem(int seqNum, Image image = null, string imageLocation = "")
{
checkDetail = new CheckDetailRecord();
imageViewDataBack = new ImageViewDataRecord();
imageViewDataFront = new ImageViewDataRecord();
imageViewDetailBack = new ImageViewDetailRecord();
imageViewDetailFront = new ImageViewDetailRecord();
imageViewAnalysisBack = new ImageViewAnalysisRecord();
imageViewAnalysisFront = new ImageViewAnalysisRecord();
records = new List <Record>();
imageViewDataFront.ImageData = image;
imageViewDataBack.ImageData = image;
checkImageLocation = imageLocation;
checkDetail = new CheckDetailRecord("044000037", "", "", "0", seqNum.ToString());
//FRONT OF CHECK
imageViewDetailFront = new ImageViewDetailRecord('0', DateTime.Now);
imageViewDataFront = new ImageViewDataRecord(seqNum.ToString(), image, imageLocation);
//BACK OF CHECK
imageViewDetailBack = new ImageViewDetailRecord('0', DateTime.Now);
imageViewDataBack = new ImageViewDataRecord(seqNum.ToString(), image, imageLocation);
addRecords();
}
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);
}
