public override string GetInsertSQL()
{
return(String.Format(@"insert into table_receiptitem
(
rec_id,
cus_id,
ccy_id,
reci_amount,
vbe_id,
vb_id,
reci_entrytype,
reci_invoicedate,
reci_invoiceno,
reci_duedate,
emp_id,
reci_discount,
reci_amountbeforediscount,
top_id,
reci_description,
reci_notes,
inv_id,
inv_type,
bank_id,
reci_receipttype,
arcr_id
)
VALUES ({0},{1},{2},{3},{4},{5},'{6}','{7}','{8}','{9}',{10},{11},{12},{13},
'{14}','{15}',{16},'{17}',{18},'{19}',{20})",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null?0:VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null?0:VENDOR_BALANCE.ID,
VendorBalanceEntryType.Receipt.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP == null?0:TOP.ID,
DESCRIPTION,
NOTES,
CUSTOMER_INVOICE_JOURNAL_ITEM.GetID(),
VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE.ToString(),
BANK == null?0:BANK.ID,
PAYMENT_TYPE.ToString(),
AR_CREDIT_NOTE == null?0:AR_CREDIT_NOTE.ID
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_receiptitem set
rec_id = {0},
cus_id = {1},
ccy_id = {2},
reci_amount = {3},
vbe_id = {4},
vb_id = {5},
reci_entrytype = '{6}',
reci_invoicedate = '{7}',
reci_invoiceno = '{8}',
reci_duedate = '{9}',
emp_id = {10},
reci_discount = {11},
reci_amountbeforediscount = {12},
top_id = {13},
reci_description = '{14}',
reci_notes = '{15}',
inv_id = {16},
inv_type = '{17}',
bank_id = {18},
reci_receipttype = '{19}',
arcr_id = {20}
where reci_id = {21}",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null ? 0 : VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null ? 0 : VENDOR_BALANCE.ID,
VendorBalanceEntryType.Receipt.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP == null ? 0 : TOP.ID,
DESCRIPTION,
NOTES, CUSTOMER_INVOICE_JOURNAL_ITEM.GetID(),
VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE.ToString(),
BANK == null?0:BANK.ID,
PAYMENT_TYPE.ToString(),
AR_CREDIT_NOTE == null?0:AR_CREDIT_NOTE.ID,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_supplieroutstandinginvoiceitem
(
sosti_id,
sup_id,
ccy_id,
sostii_amount,
vbe_id,
vb_id,
sostii_entrytype,
sostii_invoicedate,
sostii_invoiceno,
sostii_duedate,
emp_id,
sostii_discount,
sostii_amountbeforediscount,
top_id,
sostii_description,
sostii_notes,
sostii_againstpaymentstatus,
sostii_outstandingamount,
sostii_paidamount
)
VALUES ({0},{1},{2},{3},{4},{5},'{6}','{7}','{8}','{9}',{10},{11},{12},{13},'{14}','{15}'
,'{16}',{17},{18})",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null?0:VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null?0:VENDOR_BALANCE.ID,
VendorBalanceEntryType.SupplierOutStandingInvoice.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP.ID,
DESCRIPTION,
NOTES,
AGAINST_PAYMENT_STATUS.ToString(),
AMOUNT,
0
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_supplieroutstandinginvoiceitem set
sosti_id = {0},
sup_id = {1},
ccy_id = {2},
sostii_amount = {3},
vbe_id = {4},
vb_id = {5},
sostii_entrytype = '{6}',
sostii_invoicedate = '{7}',
sostii_invoiceno = '{8}',
sostii_duedate = '{9}',
emp_id = {10},
sostii_discount = {11},
sostii_amountbeforediscount = {12},
top_id = {13},
sostii_description = '{14}',
sostii_notes = '{15}',
sostii_againstpaymentstatus = '{16}',
sostii_outstandingamount = {17},
sostii_paidamount = {18}
where sostii_id = {19}",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null ? 0 : VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null ? 0 : VENDOR_BALANCE.ID,
VendorBalanceEntryType.SupplierOutStandingInvoice.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP.ID,
DESCRIPTION,
NOTES,
AGAINST_PAYMENT_STATUS.ToString(),
//OUTSTANDING_AMOUNT,
AMOUNT,
0,
ID));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_customerinvoicejournalitem set
cij_id = {0},
cus_id = {1},
ccy_id = {2},
ciji_amount = {3},
vbe_id = {4},
vb_id = {5},
ciji_entrytype = '{6}',
ciji_invoicedate = '{7}',
ciji_invoiceno = '{8}',
ciji_duedate = '{9}',
emp_id = {10},
ciji_discount = {11},
ciji_amountbeforediscount = {12},
top_id = {13},
ciji_description = '{14}',
ciji_notes = '{15}',
ciji_againstpaymentstatus = '{16}',
ciji_outstandingamount = {17},
ciji_receiptamount = {18}
where ciji_id = {16}",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null ? 0 : VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null ? 0 : VENDOR_BALANCE.ID,
VendorBalanceEntryType.CustomerInvoice.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP.ID,
DESCRIPTION,
NOTES,
AGAINST_RECEIPT_STATUS.ToString(),
OUTSTANDING_AMOUNT,
RECEIPT_AMOUNT,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_arcreditnoteitem
(
arcr_id,
cus_id,
ccy_id,
arcri_amount,
vbe_id,
vb_id,
arcri_entrytype,
arcri_invoicedate,
arcri_invoiceno,
arcri_duedate,
emp_id,
arcri_discount,
arcri_amountbeforediscount,
top_id,
arcri_description,
arcri_notes,
srn_id
)
VALUES ({0},{1},{2},{3},{4},{5},'{6}','{7}','{8}','{9}',{10},{11},{12},{13},'{14}','{15}',{16})",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null?0:VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null?0:VENDOR_BALANCE.ID,
VendorBalanceEntryType.ARCreditNote.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP == null?0:TOP.ID,
DESCRIPTION,
NOTES,
SALES_RETURN == null?0:SALES_RETURN.ID
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_arcreditnoteitem set
arcr_id = {0},
cus_id = {1},
ccy_id = {2},
arcri_amount = {3},
vbe_id = {4},
vb_id = {5},
arcri_entrytype = '{6}',
arcri_invoicedate = '{7}',
arcri_invoiceno = '{8}',
arcri_duedate = '{9}',
emp_id = {10},
arcri_discount = {11},
arcri_amountbeforediscount = {12},
top_id = {13},
arcri_description = '{14}',
arcri_notes = '{15}',
srn_id = {16}
where arcri_id = {17}",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null ? 0 : VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null ? 0 : VENDOR_BALANCE.ID,
VendorBalanceEntryType.ARCreditNote.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP == null ? 0 : TOP.ID,
DESCRIPTION,
NOTES,
SALES_RETURN == null?0:SALES_RETURN.ID,
ID));
}