public override string GetInsertSQL()
{
return(String.Format(@"insert into table_customerinvoice
( ci_date,
ci_noticedate,
ci_scentrytype,
emp_id,
ci_notes,
ci_posted,
ci_eventstatus,
div_id,
top_id,
ci_duedate,
ccy_id,
ci_subtotal,
ci_discpercent,
ci_discafteramount,
ci_discamount,
tax_id,
ci_taxafteramount,
ci_otherexpense,
ci_nettotal,
ci_code,
cus_id,
ci_docno,
ci_docdate,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}',{7},{8},'{9}',{10},
{11},{12},{13},{14},{15},{16},{17},{18},'{19}',{20},'{21}','{22}','{23}','{24}','{25}')",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.CustomerInvoice.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
DIVISION == null ? 0 : DIVISION.ID,
TOP == null ? 0 : TOP.ID,
DUE_DATE.ToString(Utils.DATE_FORMAT),
CURRENCY == null ? 0 : CURRENCY.ID,
SUB_TOTAL,
DISC_PERCENT,
DISC_AFTER_AMOUNT,
DISC_AMOUNT,
TAX == null ? 0 : TAX.ID,
TAX_AFTER_AMOUNT,
OTHER_EXPENSE,
NET_TOTAL,
CODE,
CUSTOMER == null ? 0 : CUSTOMER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_purchaseorder set
po_date = '{0}',
po_noticedate = '{1}',
po_scentrytype = '{2}',
emp_id = {3},
po_notes = '{4}',
po_posted = {5},
po_eventstatus = '{6}',
div_id = {7},
top_id = {8},
po_duedate = '{9}',
ccy_id = {10},
po_subtotal = {11},
po_discpercent = {12},
po_discafteramount = {13},
po_discamount = {14},
tax_id = {15},
po_taxafteramount = {16},
po_otherexpense = {17},
po_nettotal = {18},
po_againsgrnstatus = '{19}',
po_code = '{20}',
sup_id = {21},
po_docno = '{22}',
po_docdate ='{23}',
modified_by='{24}',
modified_date='{25}',
modified_computer='{26}'
where po_id = {27}",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.PurchaseOrder.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
DIVISION == null ? 0 : DIVISION.ID,
TOP == null ? 0 : TOP.ID,
DUE_DATE.ToString(Utils.DATE_FORMAT),
CURRENCY == null ? 0 : CURRENCY.ID,
SUB_TOTAL,
DISC_PERCENT,
DISC_AFTER_AMOUNT,
DISC_AMOUNT,
TAX == null ? 0 : TAX.ID,
TAX_AFTER_AMOUNT,
OTHER_EXPENSE,
NET_TOTAL,
AGAINST_GRN_STATUS.ToString(),
CODE,
SUPPLIER == null ? 0 : SUPPLIER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_purchasereturn
( prn_date,
prn_noticedate,
prn_scentrytype,
emp_id,
prn_notes,
prn_posted,
prn_eventstatus,
prn_code,
sup_id,
prn_docno,
prn_docdate,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}',{8},'{9}','{10}','{11}','{12}','{13}')",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.PurchaseReturn.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
CODE,
SUPPLIER == null ? 0 : SUPPLIER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_purchasereturn set
prn_date = '{0}',
prn_noticedate= '{1}',
prn_scentrytype= '{2}',
emp_id= {3},
prn_notes= '{4}',
prn_posted= {5},
prn_eventstatus= '{6}',
prn_code = '{7}',
sup_id = {8},
prn_docno = '{9}',
prn_docdate ='{10}',
modified_by='{11}',
modified_date='{12}',
modified_computer='{13}'
where prn_id = {14}",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.PurchaseReturn.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
CODE,
SUPPLIER == null ? 0 : SUPPLIER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_openingstock set
opst_date = '{0}',
opst_noticedate= '{1}',
opst_scentrytype= '{2}',
emp_id= {3},
opst_notes= '{4}',
opst_posted= {5},
opst_eventstatus= '{6}',
warehouse_id= {7},
opst_amount= {8},
ccy_id= {9},
opst_code = '{10}',
modified_by='{11}',
modified_date='{12}',
modified_computer='{13}'
where opst_id = {14}",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.OpeningStock.ToString(), //STOCK_CARD_ENTRY_TYPE.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
WAREHOUSE.ID,
AMOUNT,
CURRENCY.ID,
CODE,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_salesreturn set
srn_date = '{0}',
srn_noticedate= '{1}',
srn_scentrytype= '{2}',
emp_id= {3},
srn_notes= '{4}',
srn_posted= {5},
srn_eventstatus= '{6}',
srn_code = '{7}',
cus_id = {8},
modified_by='{9}',
modified_date='{10}',
modified_computer='{11}'
where srn_id = {12}",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.SalesReturn.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
CODE,
CUSTOMER == null ? 0 : CUSTOMER.ID,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_openingstock
( opst_date,
opst_noticedate,
opst_scentrytype,
emp_id,
opst_notes,
opst_posted,
opst_eventstatus,
warehouse_id,
opst_amount,
ccy_id,
opst_code,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}',{7},{8},{9},'{10}','{11}','{12}','{13}')",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.OpeningStock.ToString(),//STOCK_CARD_ENTRY_TYPE.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
WAREHOUSE.ID,
AMOUNT,
CURRENCY.ID,
CODE,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_salesreturn
( srn_date,
srn_noticedate,
srn_scentrytype,
emp_id,
srn_notes,
srn_posted,
srn_eventstatus,
srn_code,
cus_id,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}',{8},'{9}','{10}','{11}')",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.SalesReturn.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
CODE,
CUSTOMER == null ? 0 : CUSTOMER.ID,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_customerinvoicejournal
(
cij_code,
cij_date,
cus_id,
ccy_id,
entry_type,
cij_notes,
cij_posted,
cij_eventstatus,
cij_subtotalamount,
cij_discpercent,
cij_amountafterdiscpercent,
cij_discamount,
cij_amountafterdiscamount,
cij_otherexpense,
cij_netamount,
emp_id,
ci_id,
cij_againstreceiptstatus,
pos_id,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',
{8},{9},{10},{11},{12},{13},{14},{15},{16},'{17}',{18},'{19}','{20}','{21}')",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.CustomerInvoice.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
CUSTOMER_INVOICE == null ? 0 : CUSTOMER_INVOICE.ID,
AGAINST_RECEIPT_STATUS.ToString(),
POS_INVOICE == null ? 0 : POS_INVOICE.ID,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_apdebitnote
(
apdn_code,
apdn_date,
sup_id,
ccy_id,
entry_type,
apdn_notes,
apdn_posted,
apdn_eventstatus,
apdn_subtotalamount,
apdn_discpercent,
apdn_amountafterdiscpercent,
apdn_discamount,
apdn_amountafterdiscamount,
apdn_otherexpense,
apdn_netamount,
emp_id,
apdn_usedforpayment,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',{8},{9},{10},{11},{12},{13},{14},{15},{16}
,'{17}','{18}','{19}')",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.APDebitNote.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
USED_FOR_PAYMENT,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_supplierinvoicejournal set
sij_code = '{0}',
sij_date= '{1}',
sup_id = {2},
ccy_id= {3},
entry_type= '{4}',
sij_notes= '{5}',
sij_posted= {6},
sij_eventstatus= '{7}',
sij_subtotalamount= {8},
sij_discpercent= {9},
sij_amountafterdiscpercent= {10},
sij_discamount= {11},
sij_amountafterdiscamount= {12},
sij_otherexpense= {13},
sij_netamount= {14},
emp_id = {15},
si_id = {16},
sij_againstpaymentstatus = '{17}',
modified_by='{18}',
modified_date='{19}',
modified_computer='{20}'
where sij_id = {21}",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.SupplierInvoice.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
SUPPLIER_INVOICE == null ? 0 : SUPPLIER_INVOICE.ID,
AGAINST_PAYMENT_STATUS.ToString(),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_supplieroutstandinginvoice
(
sosti_code,
sosti_date,
sup_id,
ccy_id,
entry_type,
sosti_notes,
sosti_posted,
sosti_eventstatus,
sosti_subtotalamount,
sosti_discpercent,
sosti_amountafterdiscpercent,
sosti_discamount,
sosti_amountafterdiscamount,
sosti_otherexpense,
sosti_netamount,
emp_id,
sosti_againstpaymentstatus,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',{8},{9},{10},{11},{12},{13},{14},{15},'{16}','{17}','{18}','{19}')",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.SupplierOutStandingInvoice.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
AGAINST_PAYMENT_STATUS.ToString(),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_apdebitnote set
apdn_code = '{0}',
apdn_date= '{1}',
sup_id = {2},
ccy_id= {3},
entry_type= '{4}',
apdn_notes= '{5}',
apdn_posted= {6},
apdn_eventstatus= '{7}',
apdn_subtotalamount= {8},
apdn_discpercent= {9},
apdn_amountafterdiscpercent= {10},
apdn_discamount= {11},
apdn_amountafterdiscamount= {12},
apdn_otherexpense= {13},
apdn_netamount= {14},
emp_id= {15},
apdn_usedforpayment = {16},
modified_by='{17}',
modified_date='{18}',
modified_computer='{19}'
where apdn_id = {20}",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.APDebitNote.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
USED_FOR_PAYMENT,
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_customeroutstandinginvoice set
costi_code = '{0}',
costi_date= '{1}',
cus_id = {2},
ccy_id= {3},
entry_type= '{4}',
costi_notes= '{5}',
costi_posted= {6},
costi_eventstatus= '{7}',
costi_subtotalamount= {8},
costi_discpercent= {9},
costi_amountafterdiscpercent= {10},
costi_discamount= {11},
costi_amountafterdiscamount= {12},
costi_otherexpense= {13},
costi_netamount= {14},
emp_id= {15},
costi_againstreceiptstatus = '{16}',
modified_by='{17}',
modified_date='{18}',
modified_computer='{19}'
where costi_id = {20}",
CODE,
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
VENDOR.ID,
CURRENCY.ID,
VendorBalanceEntryType.CustomerOutStandingInvoice.ToString(),
NOTES,
POSTED,
EVENT_STATUS.ToString(),
SUBTOTAL_AMOUNT,
DISC_PERCENT,
AMOUNT_AFTER_DISC_PERCENT,
DISC_AMOUNT,
AMOUNT_AFTER_DISC_AMOUNT,
OTHER_EXPENSE,
NET_AMOUNT,
EMPLOYEE.ID,
AGAINST_RECEIPT_STATUS.ToString(),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}
public override string GetInsertSQL()
{
return(String.Format(@"insert into table_deliveryorder
( do_date,
do_noticedate,
do_scentrytype,
emp_id,
do_notes,
do_posted,
do_eventstatus,
do_againstprstatus,
do_code,
cus_id,
do_docno,
do_docdate,
modified_by,
modified_date,
modified_computer
)
VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}','{14}')",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.DeliveryOrder.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
AGAINST_SR_STATUS.ToString(),
CODE,
CUSTOMER == null ? 0 : CUSTOMER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME
));
}
public override string GetUpdateSQL()
{
return(String.Format(@"update table_deliveryorder set
do_date = '{0}',
do_noticedate= '{1}',
do_scentrytype= '{2}',
emp_id= {3},
do_notes= '{4}',
do_posted= {5},
do_eventstatus= '{6}',
do_againstprstatus= '{7}',
do_code = '{8}',
cus_id = {9},
do_docno = '{10}',
do_docdate = '{11}',
modified_by='{12}',
modified_date='{13}',
modified_computer='{14}'
where do_id = {15}",
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
NOTICE_DATE.ToString(Utils.DATE_FORMAT),
StockCardEntryType.DeliveryOrder.ToString(),
EMPLOYEE.ID,
NOTES,
POSTED,
EVENT_STATUS.ToString(),
AGAINST_SR_STATUS.ToString(),
CODE,
CUSTOMER == null ? 0 : CUSTOMER.ID,
DOCUMENT_NO,
DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
MODIFIED_BY,
DateTime.Now.ToString(Utils.DATE_FORMAT),
MODIFIED_COMPUTER_NAME,
ID));
}