public Contacttype_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(CONTACTTYPE.CONTACTTYPE_TBL);
q += AddFields.Primary(CONTACTTYPE.CONTACTTYPE_ID);
q += AddFields.Unique_500(CONTACTTYPE.CONTACTTYPE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(CONTACTTYPE.CONTACTTYPE_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Sizes_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(SIZES.SIZES_TBL);
q += AddFields.Primary(SIZES.SIZES_ID);
q += AddFields.Unique_500(SIZES.SIZES_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(SIZES.SIZES_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Taxtype_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(TAXTYPE.TAXTYPE_TBL);
q += AddFields.Primary(TAXTYPE.TAXTYPE_ID);
q += AddFields.Unique_500(TAXTYPE.TAXTYPE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(TAXTYPE.TAXTYPE_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public void QReceiptItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(QRECEIPTITEMS.QRECEIPTITEMS_TBL);
q += AddFields.Primary(QRECEIPTITEMS.QRECEIPTITEMS_ID);
q += AddFields.Foreign(QRECEIPTITEMS.QRECEIPTITEMS_TBL, QRECEIPTITEMS.QRECEIPT_ID);
q += AddFields.VARCHAR_200(QRECEIPTITEMS.QRECEIPT_BY);
q += AddFields.VARCHAR_200(QRECEIPTITEMS.QUOTATION_NO);
q += AddFields.VARCHAR_200(QRECEIPTITEMS.QUOTATION_AMOUNT);
q += AddFields.Decimal_2(QRECEIPTITEMS.QRECEIPT_AMOUNT);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Hsncode_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(HSNCODE.HSNCODE_TBL);
q += AddFields.Primary(HSNCODE.HSNCODE_ID);
q += AddFields.Unique_500(HSNCODE.HSNCODE_NAME);
q += AddFields.VARCHAR_500(HSNCODE.DESCRIPTION);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(HSNCODE.HSNCODE_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Ledger_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(LEDGER.LEDGER_TBL);
q += AddFields.Primary(LEDGER.LEDGER_ID);
q += AddFields.Unique_500(LEDGER.LEDGER_NAME);
q += AddFields.Foreign(LEDGER.LEDGER_TBL, LEDGER.LEDGERGROUP_ID);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(LEDGER.LEDGER_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Unit_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(UNIT.UNIT_TBL);
q += AddFields.Primary(UNIT.UNIT_ID);
q += AddFields.Unique_500(UNIT.UNIT_NAME);
q += AddFields.VARCHAR_200(UNIT.UNIT_DESC);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(UNIT.UNIT_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Vouchertype_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(VOUCHERTYPE.VOUCHERTYPE_TBL);
q += AddFields.Primary(VOUCHERTYPE.VOUCHERTYPE_ID);
q += AddFields.Unique_500(VOUCHERTYPE.VOUCHERTYPE_NAME);
q += AddFields.Foreign(VOUCHERTYPE.VOUCHERTYPE_TBL, VOUCHERTYPE.METHOD_ID);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(VOUCHERTYPE.VOUCHERTYPE_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public State_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(STATE.STATE_TBL);
q += AddFields.Primary(STATE.STATE_ID);
q += AddFields.Unique_500(STATE.STATE_NAME);
q += AddFields.VARCHAR_200(STATE.STATE_CODE);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(STATE.STATE_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Defaultcompany_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(DEFAULTCOMPANY.DEFAULTCOMPANY_TBL);
q += AddFields.Primary(DEFAULTCOMPANY.DEFAULTCOMPANY_ID);
q += AddFields.Int(DEFAULTCOMPANY.COMPANY_ID);
q += AddFields.Int(DEFAULTCOMPANY.ACY_ID);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(DEFAULTCOMPANY.DEFAULTCOMPANY_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public void ReceiptItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(RECEIPTITEMS.RECEIPTITEMS_TBL);
q += AddFields.Primary(RECEIPTITEMS.RECEIPTITEMS_ID);
q += AddFields.Foreign(RECEIPTITEMS.RECEIPTITEMS_TBL, RECEIPTITEMS.RECEIPT_ID);
q += AddFields.VARCHAR_200(RECEIPTITEMS.RECEIPT_BY);
q += AddFields.VARCHAR_200(RECEIPTITEMS.INVOICED_NO);
q += AddFields.VARCHAR_200(RECEIPTITEMS.INVOICED_AMOUNT);
q += AddFields.Decimal_2(RECEIPTITEMS.RECEIPT_AMOUNT);
q += AddFields.EOF;
new DAL().Execute(q);
}
public void paymentItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PAYMENTITEMS.PAYMENTITEMS_TBL);
q += AddFields.Primary(PAYMENTITEMS.PAYMENTITEMS_ID);
q += AddFields.Foreign(PAYMENTITEMS.PAYMENTITEMS_TBL, PAYMENTITEMS.PAYMENT_ID);
q += AddFields.VARCHAR_500(PAYMENTITEMS.PAYMENT_BY);
q += AddFields.VARCHAR_300(PAYMENTITEMS.PURCHASE_NO);
q += AddFields.Decimal_2(PAYMENTITEMS.PURCHASE_AMOUNT);
q += AddFields.Decimal_2(PAYMENTITEMS.PAYMENT_AMOUNT);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Po_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PO.PO_TBL);
q += AddFields.Primary(PO.PO_ID);
q += AddFields.VARCHAR_500(PO.PO_NO);
q += AddFields.Date(PO.PO_DATE);
q += AddFields.Date(PO.DELIVERY_DATE);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(PO.PO_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Acy_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(ACY.ACY_TBL);
q += AddFields.Primary(ACY.ACY_ID);
q += AddFields.Unique_500(ACY.ACY_NAME);
q += AddFields.Date(ACY.FROM_DATE);
q += AddFields.Date(ACY.TO_DATE);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(ACY.ACY_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Month_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(MONTH.MONTH_TBL);
q += AddFields.Primary(MONTH.MONTH_ID);
q += AddFields.Unique_500(MONTH.MONTH_NAME);
q += AddFields.Date(MONTH.MONTH_STARTS);
q += AddFields.Date(MONTH.MONTH_ENDS);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(MONTH.MONTH_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Defaultlogin_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(DEFAULTLOGIN.DEFAULTLOGIN_TBL);
q += AddFields.Primary(DEFAULTLOGIN.DEFAULTLOGIN_ID);
q += AddFields.Unique_500(DEFAULTLOGIN.DEFAULTLOGIN_NAME);
q += AddFields.VARCHAR_500(DEFAULTLOGIN.DEFAULT_PASSWORD);
q += AddFields.DateTime(DEFAULTLOGIN.CREATEON);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(DEFAULTLOGIN.DEFAULTLOGIN_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Version_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(VERSION.VERSION_TBL);
q += AddFields.Primary(VERSION.VERSION_ID);
q += AddFields.Unique_500(VERSION.VERSION_NAME);
q += AddFields.Date(VERSION.CREATED_ON);
q += AddFields.VARCHAR_500(VERSION.CHANGES);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(VERSION.VERSION_TBL);
q += AddFields.EOF;
new SQLITE_DAL().Execute(q);
}
public Bank_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(BANK.BANK_TBL);
q += AddFields.Primary(BANK.BANK_ID);
q += AddFields.Unique_500(BANK.BANK_NAME);
q += AddFields.VARCHAR_500(BANK.ACCOUNT_NUMBER);
q += AddFields.VARCHAR_200(BANK.IFSC_CODE);
q += AddFields.Decimal_2(BANK.OPENING_BALANCE);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(BANK.BANK_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public User_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(USER.USER_TBL);
q += AddFields.Primary(USER.USER_ID);
q += AddFields.Unique_500(USER.USER_NAME);
q += AddFields.VARCHAR_500(USER.USER_PASSWORD);
q += AddFields.DateTime(USER.CREATEON);
q += AddFields.Foreign(USER.USER_TBL, USER.ROLE_ID);
q += AddFields.VARCHAR_200(USER.ENTRYBY);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Cash_receipt_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(CASH_RECEIPT.CASH_RECEIPT_TBL);
q += AddFields.Primary(CASH_RECEIPT.CASH_RECEIPT_ID);
q += AddFields.Date(CASH_RECEIPT.RECEIPT_DATE);
q += AddFields.Foreign(CASH_RECEIPT.CASH_RECEIPT_TBL, CASH_RECEIPT.PARTY_ID);
q += AddFields.VARCHAR_500(CASH_RECEIPT.PURPOSE);
q += AddFields.Decimal_2(CASH_RECEIPT.RECEIPT_AMOUNT);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(CASH_RECEIPT.CASH_RECEIPT_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public void Tex_invoiceItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(QUOTATIONITEMS.QUOTATIONITEMS_TBL);
q += AddFields.Primary(QUOTATIONITEMS.QUOTATIONITEMS_ID);
q += AddFields.Foreign(QUOTATIONITEMS.QUOTATIONITEMS_TBL, QUOTATIONITEMS.QUOTATION_ID);
q += AddFields.Foreign(QUOTATIONITEMS.QUOTATIONITEMS_TBL, QUOTATIONITEMS.PRODUCT_ID);
q += AddFields.Foreign(QUOTATIONITEMS.QUOTATIONITEMS_TBL, QUOTATIONITEMS.SIZES_ID);
q += AddFields.Decimal_3(QUOTATIONITEMS.QTY);
q += AddFields.Decimal_2(QUOTATIONITEMS.PRICE);
q += AddFields.VARCHAR_200(QUOTATIONITEMS.REFERED_ID);
q += AddFields.Smallint(QUOTATIONITEMS.LOCKED);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public static void InwardItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(OUTWARDITEMS.OUTWARDITEMS_TBL);
q += AddFields.Primary(OUTWARDITEMS.OUTWARDITEMS_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.OUTWARD_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.STYLE_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.ARTICLE_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.PRODUCT_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.COLOURS_ID);
q += AddFields.Foreign(OUTWARDITEMS.OUTWARDITEMS_TBL, OUTWARDITEMS.SIZES_ID);
q += AddFields.Decimal_3(OUTWARDITEMS.QTY);
q += AddFields.Smallint(OUTWARDITEMS.LOCKED);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Cash_in_hand_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(CASH_IN_HAND.CASH_IN_HAND_TBL);
q += AddFields.Primary(CASH_IN_HAND.CASH_IN_HAND_ID);
q += AddFields.Date(CASH_IN_HAND.ENTRY_DATE);
q += AddFields.Foreign(CASH_IN_HAND.CASH_IN_HAND_TBL, CASH_IN_HAND.CASH_RECEIPT_ID);
q += AddFields.Foreign(CASH_IN_HAND.CASH_IN_HAND_TBL, CASH_IN_HAND.CASH_PAYMENT_ID);
q += AddFields.Decimal_2(CASH_IN_HAND.RECEIPT_AMOUNT);
q += AddFields.Decimal_2(CASH_IN_HAND.PAYMENT_AMOUNT);
q += AddFields.Decimal_2(CASH_IN_HAND.BALANCE_AMOUNT);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(CASH_IN_HAND.CASH_IN_HAND_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Company_bank_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(COMPANY_BANK.COMPANY_BANK_TBL);
q += AddFields.Primary(COMPANY_BANK.COMPANY_BANK_ID);
q += AddFields.VARCHAR_500(COMPANY_BANK.COMPANY_BANK_NAME);
q += AddFields.VARCHAR_500(COMPANY_BANK.ACCOUNT_NUMBER);
q += AddFields.VARCHAR_500(COMPANY_BANK.IFSC_CODE);
q += AddFields.VARCHAR_500(COMPANY_BANK.BRANCH_NAME);
q += AddFields.Decimal_2(COMPANY_BANK.OPENING_BALANCE);
q += AddFields.VARCHAR_500(COMPANY_BANK.ACCOUNT_OPENSON);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(COMPANY_BANK.COMPANY_BANK_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public static void StyleItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(STYLEITEMS.STYLEITEMS_TBL);
q += AddFields.Primary(STYLEITEMS.STYLEITEMS_ID);
q += AddFields.Foreign(STYLEITEMS.STYLEITEMS_TBL, STYLEITEMS.STYLE_ID);
q += AddFields.VARCHAR_200(STYLEITEMS.STYLE_NO);
q += AddFields.Foreign(STYLEITEMS.STYLEITEMS_TBL, STYLEITEMS.ARTICLE_ID);
q += AddFields.Foreign(STYLEITEMS.STYLEITEMS_TBL, STYLEITEMS.PRODUCT_ID);
q += AddFields.Foreign(STYLEITEMS.STYLEITEMS_TBL, STYLEITEMS.COLOURS_ID);
q += AddFields.Foreign(STYLEITEMS.STYLEITEMS_TBL, STYLEITEMS.SIZES_ID);
q += AddFields.VARCHAR_200(STYLEITEMS.QTY);
q += AddFields.Decimal_2(STYLEITEMS.PRICE);
q += AddFields.VARCHAR_200(STYLEITEMS.REFERED_ID);
q += AddFields.Smallint(STYLEITEMS.LOCKED);
q += AddFields.EOF;
new DAL().Execute(q);
}
public void PurchaseItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PURCHASEITEMS.PURCHASEITEMS_TBL);
q += AddFields.Primary(PURCHASEITEMS.PURCHASEITEMS_ID);
q += AddFields.Foreign(PURCHASEITEMS.PURCHASEITEMS_TBL, PURCHASEITEMS.PURCHASE_ID);
q += AddFields.VARCHAR_200(PURCHASEITEMS.PURCHASE_NO);
q += AddFields.Foreign(PURCHASEITEMS.PURCHASEITEMS_TBL, PURCHASEITEMS.PRODUCT_ID);
q += AddFields.Decimal_3(PURCHASEITEMS.QTY);
q += AddFields.Decimal_2(PURCHASEITEMS.PRICE);
q += AddFields.Decimal_2(PURCHASEITEMS.CGST_PERCENT);
q += AddFields.Decimal_2(PURCHASEITEMS.SGST_PERCENT);
q += AddFields.Decimal_2(PURCHASEITEMS.IGST_PERCENT);
q += AddFields.VARCHAR_200(PURCHASEITEMS.REFERED_ID);
q += AddFields.Smallint(PURCHASEITEMS.LOCKED);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public void OrderItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(ORDERITEMS.ORDERITEMS_TBL);
q += AddFields.Primary(ORDERITEMS.ORDERITEMS_ID);
q += AddFields.Foreign(ORDERITEMS.ORDERITEMS_TBL, ORDERITEMS.ORDER_ID);
q += AddFields.VARCHAR_500(ORDERITEMS.ORDER_NO);
q += AddFields.Foreign(ORDERITEMS.ORDERITEMS_TBL, ORDERITEMS.STYLE_ID);
q += AddFields.VARCHAR_500(ORDERITEMS.STYLE_NAME);
q += AddFields.Foreign(ORDERITEMS.ORDERITEMS_TBL, ORDERITEMS.COLOURS_ID);
q += AddFields.VARCHAR_200(ORDERITEMS.QTY);
q += AddFields.Decimal_2(ORDERITEMS.PRICE);
q += AddFields.Decimal_2(ORDERITEMS.MRP);
q += AddFields.VARCHAR_200(ORDERITEMS.REFERED_ID);
q += AddFields.Smallint(ORDERITEMS.LOCKED);
q += AddFields.EOF;
new DAL().Execute(q);
}
public void Tex_invoiceItems_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(LABOURITEMS.LABOURITEMS_TBL);
q += AddFields.Primary(LABOURITEMS.LABOURITEMS_ID);
q += AddFields.Foreign(LABOURITEMS.LABOURITEMS_TBL, LABOURITEMS.LABOUR_ID);
q += AddFields.VARCHAR_100(LABOURITEMS.PO_NO);
q += AddFields.VARCHAR_100(LABOURITEMS.DC_NO);
q += AddFields.Foreign(LABOURITEMS.LABOURITEMS_TBL, LABOURITEMS.PRODUCT_ID);
q += AddFields.Foreign(LABOURITEMS.LABOURITEMS_TBL, LABOURITEMS.SIZES_ID);
q += AddFields.VARCHAR_100(LABOURITEMS.QTY);
q += AddFields.Decimal_2(LABOURITEMS.PRICE);
q += AddFields.Decimal_2(LABOURITEMS.CGST_PERCENT);
q += AddFields.Decimal_2(LABOURITEMS.SGST_PERCENT);
q += AddFields.Decimal_2(LABOURITEMS.IGST_PERCENT);
q += AddFields.VARCHAR_200(LABOURITEMS.REFERED_ID);
q += AddFields.Smallint(LABOURITEMS.LOCKED);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Labour_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(LABOUR.LABOUR_TBL);
q += AddFields.Primary(LABOUR.LABOUR_ID);
q += AddFields.Unique_500(LABOUR.UNIQUENO);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.COMPANY_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.ACY_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.ORDER_ID);
q += AddFields.Int(LABOUR.LABOUR_NO);
q += AddFields.Date(LABOUR.LABOUR_DATE);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.PARTY_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.TAXTYPE_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.SALESTYPE_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.TRANSPORT_ID);
q += AddFields.Foreign(LABOUR.LABOUR_TBL, LABOUR.DELIVEREDTO_ID);
q += AddFields.VARCHAR_500(LABOUR.BUNDEL);
q += AddFields.VARCHAR_100(LABOUR.TOTAL_QTY);
q += AddFields.Decimal_2(LABOUR.TOTAL_TAXABLE_AMOUNT);
q += AddFields.Decimal_2(LABOUR.TOTAL_CGST);
q += AddFields.Decimal_2(LABOUR.TOTAL_SGST);
q += AddFields.Decimal_2(LABOUR.TOTAL_IGST);
q += AddFields.Decimal_2(LABOUR.GSTTOTAL);
q += AddFields.VARCHAR_200(LABOUR.LEDGER_ID);
q += AddFields.Decimal_2(LABOUR.ADDITIONAL);
q += AddFields.Decimal_2(LABOUR.ROUNDS);
q += AddFields.Decimal_2(LABOUR.GRANDTOTAL);
q += AddFields.Decimal_2(LABOUR.REFERED_AMT);
q += AddFields.Smallint(LABOUR.LOCKED);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(LABOUR.LABOUR_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
Tex_invoiceItems_Tbl(db);
}
public Upvc_Quotation_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(UPVC_QUOTATION.UPVC_QUOTATION_TBL);
q += AddFields.Primary(UPVC_QUOTATION.UPVC_QUOTATION_ID);
q += AddFields.Unique_500(UPVC_QUOTATION.UNIQUENO);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.COMPANY_ID);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.ACY_ID);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.SALESTYPE_ID);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.TAXTYPE_ID);
q += AddFields.VARCHAR_200(UPVC_QUOTATION.QUOTATION_NO);
q += AddFields.Date(UPVC_QUOTATION.QUOTATION_DATE);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.PARTY_ID);
q += AddFields.Int(UPVC_QUOTATION.DELIVEREDTO_ID);
q += AddFields.Foreign(UPVC_QUOTATION.UPVC_QUOTATION_TBL, UPVC_QUOTATION.TRANSPORT_ID);
q += AddFields.VARCHAR_500(UPVC_QUOTATION.VEHICLE_NO);
q += AddFields.Decimal_3(UPVC_QUOTATION.TOTAL_QTY);
q += AddFields.VARCHAR_200(UPVC_QUOTATION.TOTAL_AREASQ);
q += AddFields.Decimal_2(UPVC_QUOTATION.TOTAL_TAXABLE_AMOUNT);
q += AddFields.Decimal_2(UPVC_QUOTATION.TOTAL_CGST);
q += AddFields.Decimal_2(UPVC_QUOTATION.TOTAL_SGST);
q += AddFields.Decimal_2(UPVC_QUOTATION.TOTAL_IGST);
q += AddFields.Decimal_2(UPVC_QUOTATION.GSTTOTAL);
q += AddFields.VARCHAR_500(UPVC_QUOTATION.LEDGER_ID);
q += AddFields.Decimal_2(UPVC_QUOTATION.ADDITIONAL);
q += AddFields.Decimal_2(UPVC_QUOTATION.ROUNDS);
q += AddFields.Decimal_2(UPVC_QUOTATION.GRANDTOTAL);
q += AddFields.Decimal_2(UPVC_QUOTATION.REFERED_NO);
q += AddFields.Smallint(UPVC_QUOTATION.LOCKED);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(UPVC_QUOTATION.UPVC_QUOTATION_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
Upvc_invoiceItems_Tbl(db);
}
