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_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));
}