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