public Order_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(ORDER.ORDER_TBL);
q += AddFields.Primary(ORDER.ORDER_ID);
q += AddFields.Unique_500(ORDER.UNIQUENO);
q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.COMPANY_ID);
q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.ACY_ID);
q += AddFields.VARCHAR_500(ORDER.ORDER_NO);
q += AddFields.Date(ORDER.ORDER_DATE);
q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.ORDERTYPE_ID);
q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.PARTY_ID);
q += AddFields.VARCHAR_500(ORDER.PARTY_REF);
q += AddFields.VARCHAR_500(ORDER.REFERED_NO);
q += AddFields.Smallint(ORDER.LOCKED);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(ORDER.ORDER_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
OrderItems_Tbl(db);
}
public QreceiptTbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(QRECEIPT.QRECEIPT_TBL);
q += Fields.Primary(QRECEIPT.QRECEIPT_ID);
q += Fields.Unique_500(QRECEIPT.UNIQUENO);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.COMPANY_ID);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.DIV_ID);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.ACY_ID);
q += Fields.Int(QRECEIPT.QRECEIPT_NO);
q += Fields.Date(QRECEIPT.QRECEIPT_DATE);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.PARTY_ID);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.RECEIPTTYPE_ID);
q += Fields.VARCHAR_200(QRECEIPT.CHEQ_NO);
q += Fields.Decimal_2(QRECEIPT.QRECEIPT_AMOUNT);
q += Fields.VARCHAR_100(QRECEIPT.CHEQ_DATE);
q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.BANK_ID);
q += Fields.Decimal_2(QRECEIPT.TOTAL_AMOUNT);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(QRECEIPT.QRECEIPT_TBL);
q += Fields.EOF;
new DAL().Execute(q);
QreceiptitemsTbl(db);
}
public Knitting_receipt_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL);
q += Fields.Primary(KNITTING_RECEIPT.KNITTING_RECEIPT_ID);
q += Fields.Unique_500(KNITTING_RECEIPT.UNIQUENO);
q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.COMPANY_ID);
q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.ACY_ID);
q += Fields.Int(KNITTING_RECEIPT.KNITTING_RECEIPT_NO);
q += Fields.Date(KNITTING_RECEIPT.KNITTING_RECEIPT_DATE);
q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.PARTY_ID);
q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.RECEIPTTYPE_ID);
q += Fields.VARCHAR_200(KNITTING_RECEIPT.CHEQ_NO);
q += Fields.Decimal_2(KNITTING_RECEIPT.KNITTING_RECEIPT_AMOUNT);
q += Fields.VARCHAR_200(KNITTING_RECEIPT.CHEQ_DATE);
q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.BANK_ID);
q += Fields.Decimal_2(KNITTING_RECEIPT.TOTAL_AMOUNT);
q += Fields.VARCHAR_200(KNITTING_RECEIPT.REFERED_NO);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL);
q += Fields.EOF;
new SYS_DAL().Execute(q);
Knitting_receiptItems_Tbl(db);
}
public Receipt_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(RECEIPT.RECEIPT_TBL);
q += AddFields.Primary(RECEIPT.RECEIPT_ID);
q += AddFields.Unique_500(RECEIPT.UNIQUENO);
q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.COMPANY_ID);
q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.ACY_ID);
q += AddFields.Int(RECEIPT.RECEIPT_NO);
q += AddFields.Date(RECEIPT.RECEIPT_DATE);
q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.PARTY_ID);
q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.RECEIPTTYPE_ID);
q += AddFields.VARCHAR_200(RECEIPT.CHEQ_NO);
q += AddFields.Decimal_2(RECEIPT.RECEIPT_AMOUNT);
q += AddFields.VARCHAR_200(RECEIPT.CHEQ_DATE);
q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.BANK_ID);
q += AddFields.Decimal_2(RECEIPT.TOTAL_AMOUNT);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(RECEIPT.RECEIPT_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
ReceiptItems_Tbl(db);
}
public Garment_order_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(GARMENT_ORDER.GARMENT_ORDER_TBL);
q += Fields.Primary(GARMENT_ORDER.GARMENT_ORDER_ID);
q += Fields.Unique_500(GARMENT_ORDER.UNIQUENO);
q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.COMPANY_ID);
q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.ACY_ID);
q += Fields.Int(GARMENT_ORDER.GARMENT_ORDER_NO);
q += Fields.Date(GARMENT_ORDER.GARMENT_ORDER_DATE);
q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.ORDERTYPE_ID);
q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.PARTY_ID);
q += Fields.VARCHAR_500(GARMENT_ORDER.PARTY_REF);
q += Fields.VARCHAR_500(GARMENT_ORDER.STYLE_REF);
q += Fields.VARCHAR_500(GARMENT_ORDER.REFERED_NO);
q += Fields.Smallint(GARMENT_ORDER.LOCKED);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(GARMENT_ORDER.GARMENT_ORDER_TBL);
q += Fields.EOF;
new DAL().Execute(q);
Garment_orderItems_Tbl(db);
}
public Offset_invoice_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(OFFSET_INVOICE.OFFSET_INVOICE_TBL);
q += Fields.Primary(OFFSET_INVOICE.OFFSET_INVOICE_ID);
q += Fields.Unique_500(OFFSET_INVOICE.UNIQUENO);
q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.COMPANY_ID);
q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.ACY_ID);
q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.TAXTYPE_ID);
q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.SALESTYPE_ID);
q += Fields.Int(OFFSET_INVOICE.OFFSET_INVOICE_NO);
q += Fields.Date(OFFSET_INVOICE.OFFSET_INVOICE_DATE);
q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.PARTY_ID);
q += Fields.VARCHAR_200(OFFSET_INVOICE.TOTAL_QTY);
q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_TAXABLE_AMOUNT);
q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_CGST);
q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_SGST);
q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_IGST);
q += Fields.Decimal_2(OFFSET_INVOICE.GSTTOTAL);
q += Fields.VARCHAR_500(OFFSET_INVOICE.LEDGER_ID);
q += Fields.Decimal_2(OFFSET_INVOICE.ADDITIONAL);
q += Fields.Decimal_2(OFFSET_INVOICE.ROUNDS);
q += Fields.Decimal_2(OFFSET_INVOICE.GRANDTOTAL);
q += Fields.VARCHAR_200(OFFSET_INVOICE.REFERED_AMT);
q += Fields.Smallint(OFFSET_INVOICE.LOCKED);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(OFFSET_INVOICE.OFFSET_INVOICE_TBL);
q += Fields.EOF;
new SYS_DAL().Execute(q);
Offset_invoiceItems_Tbl(db);
}
public Party_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PARTY.PARTY_TBL);
q += AddFields.Primary(PARTY.PARTY_ID);
q += AddFields.Unique_500(PARTY.PARTY_NAME);
q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.CONTACTTYPE_ID);
q += AddFields.VARCHAR_500(PARTY.CONTACT_PERSON);
q += AddFields.VARCHAR_500(PARTY.STREET_1);
q += AddFields.VARCHAR_500(PARTY.STREET_2);
q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.CITY_ID);
q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.STATE_ID);
q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.COUNTRY_ID);
q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.PINCODE_ID);
q += AddFields.VARCHAR_500(PARTY.PHONE);
q += AddFields.VARCHAR_500(PARTY.CELL);
q += AddFields.VARCHAR_500(PARTY.EMAIL);
q += AddFields.VARCHAR_500(PARTY.WEBSITE);
q += AddFields.VARCHAR_200(PARTY.GSTIN);
q += AddFields.VARCHAR_200(PARTY.PAN);
q += AddFields.Decimal_2(PARTY.OPENING_BALANCE);
q += AddFields.Decimal_2(PARTY.CREDIT_DAYS);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(PARTY.PARTY_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Gstfile(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(GSTFILE.GSTFILE_TBL);
q += Fields.Primary(GSTFILE.GSTFILE_ID);
q += Fields.VAR100(GSTFILE.MONTH);
q += Fields.VAR100(GSTFILE.INVOICEDATE);
q += Fields.VAR100(GSTFILE.INVOICENO);
q += Fields.Foreign(GSTFILE.GSTFILE_TBL, GSTFILE.PARTY_ID);
q += Fields.VAR100(GSTFILE.GSTNO);
q += Fields.Decimal_2(GSTFILE.TAXABLEVALUE);
q += Fields.Decimal_2(GSTFILE.SGST_PERCENT);
q += Fields.Decimal_2(GSTFILE.SGST_AMOUNT);
q += Fields.Decimal_2(GSTFILE.CGST_PERCENT);
q += Fields.Decimal_2(GSTFILE.CGST_AMOUNT);
q += Fields.Decimal_2(GSTFILE.IGST_PERCENT);
q += Fields.Decimal_2(GSTFILE.IGST_AMOUNT);
q += Fields.Decimal_2(GSTFILE.GST_AMOUNT);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(GSTFILE.GSTFILE_TBL);
q += Fields.EOF;
new DAL().Execute(q);
}
public Garment_Receipt_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL);
q += Fields.Primary(GARMENT_RECEIPT.GARMENT_RECEIPT_ID);
q += Fields.Unique_500(GARMENT_RECEIPT.UNIQUENO);
q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.COMPANY_ID);
q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.ACY_ID);
q += Fields.Int(GARMENT_RECEIPT.GARMENT_RECEIPT_NO);
q += Fields.Date(GARMENT_RECEIPT.GARMENT_RECEIPT_DATE);
q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.PARTY_ID);
q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.RECEIPTTYPE_ID);
q += Fields.VARCHAR_200(GARMENT_RECEIPT.CHEQ_NO);
q += Fields.Decimal_2(GARMENT_RECEIPT.GARMENT_RECEIPT_AMOUNT);
q += Fields.VARCHAR_200(GARMENT_RECEIPT.CHEQ_DATE);
q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.BANK_ID);
q += Fields.Decimal_2(GARMENT_RECEIPT.TOTAL_AMOUNT);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL);
q += Fields.EOF;
new SYS_DAL().Execute(q);
Garment_receiptItems_Tbl(db);
}
public Quotation_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(QUOTATION.QUOTATION_TBL);
q += AddFields.Primary(QUOTATION.QUOTATION_ID);
q += AddFields.Unique_500(QUOTATION.UNIQUENO);
q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.COMPANY_ID);
q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.ACY_ID);
q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.ORDER_ID);
q += AddFields.Int(QUOTATION.QUOTATION_NO);
q += AddFields.Date(QUOTATION.QUOTATION_DATE);
q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.PARTY_ID);
q += AddFields.Decimal_3(QUOTATION.TOTAL_QTY);
q += AddFields.Decimal_2(QUOTATION.TOTAL_TAXABLE_AMOUNT);
q += AddFields.VARCHAR_200(QUOTATION.LEDGER_ID);
q += AddFields.Decimal_2(QUOTATION.ADDITIONAL);
q += AddFields.Decimal_2(QUOTATION.ROUNDS);
q += AddFields.Decimal_2(QUOTATION.GRANDTOTAL);
q += AddFields.Decimal_2(QUOTATION.REFERED_AMT);
q += AddFields.Smallint(QUOTATION.LOCKED);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(QUOTATION.QUOTATION_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
Tex_invoiceItems_Tbl(db);
}
public Outward_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(OUTWARD.OUTWARD_TBL);
q += AddFields.Primary(OUTWARD.OUTWARD_ID);
q += AddFields.Unique_500(OUTWARD.UNIQUENO);
q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.COMPANY_ID);
q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.ACY_ID);
q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.ORDER_ID);
q += AddFields.Int(OUTWARD.OUTWARD_NO);
q += AddFields.Date(OUTWARD.OUTWARD_DATE);
q += AddFields.Int(OUTWARD.PARTY_ID);
q += AddFields.VARCHAR_200(OUTWARD.TOTAL_QTY);
q += AddFields.VARCHAR_200(OUTWARD.TOTAL_BUNDEL);
q += AddFields.VARCHAR_200(OUTWARD.DELIVREDTHROUGH);
q += AddFields.Smallint(OUTWARD.LOCKED);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(OUTWARD.OUTWARD_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
InwardItems_Tbl(db);
}
public Offset_po_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(OFFSET_PO.OFFSET_PO_TBL);
q += Fields.Primary(OFFSET_PO.OFFSET_PO_ID);
q += Fields.Unique_500(OFFSET_PO.UNIQUENO);
q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.COMPANY_ID);
q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.ACY_ID);
q += Fields.Unique_500(OFFSET_PO.OFFSET_PO_NO);
q += Fields.Date(OFFSET_PO.OFFSET_PO_DATE);
q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.PARTY_ID);
q += Fields.VARCHAR_500(OFFSET_PO.PARTY_PO_REF);
q += Fields.Date(OFFSET_PO.DELIVERY_DATE);
q += Fields.VARCHAR_500(OFFSET_PO.TOTAL_QTY);
q += Fields.Decimal_2(OFFSET_PO.TOTAL_AMOUNT);
q += Fields.VARCHAR_200(OFFSET_PO.REFERED_NO);
q += Fields.Smallint(OFFSET_PO.LOCKED);
q += Fields.Notes;
q += Fields.Active;
q += Fields.User_id(OFFSET_PO.OFFSET_PO_TBL);
q += Fields.EOF;
new SYS_DAL().Execute(q);
Offset_poItems_Tbl(db);
}
public Company_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(COMPANY.COMPANY_TBL);
q += AddFields.Primary(COMPANY.COMPANY_ID);
q += AddFields.Unique_500(COMPANY.COMPANY_NAME);
q += AddFields.VARCHAR_500(COMPANY.DISPLAY_NAME);
q += AddFields.VARCHAR_500(COMPANY.STREET1);
q += AddFields.VARCHAR_500(COMPANY.STREET2);
q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.CITY_ID);
q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.STATE_ID);
q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.COUNTRY_ID);
q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.PINCODE_ID);
q += AddFields.VARCHAR_200(COMPANY.CELL1);
q += AddFields.VARCHAR_500(COMPANY.CELL2);
q += AddFields.VARCHAR_500(COMPANY.PHONE);
q += AddFields.VARCHAR_500(COMPANY.EMAIL);
q += AddFields.VARCHAR_500(COMPANY.WEBSITE);
q += AddFields.VARCHAR_500(COMPANY.GSTIN);
q += AddFields.VARCHAR_500(COMPANY.PAN);
q += AddFields.VARCHAR_500(COMPANY.COMP_CODE);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(COMPANY.COMPANY_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Payment_Tbl(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(PAYMENT.PAYMENT_TBL);
q += Fields.Primary(PAYMENT.PAYMENT_ID);
q += Fields.Unique(PAYMENT.UNIQUENO);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.COMPANY_ID);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.DIV_ID);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.ACY_ID);
q += Fields.Int(PAYMENT.PAYMENT_NO);
q += Fields.Date(PAYMENT.PAYMENT_DATE);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.PARTY_ID);
q += Fields.Decimal(PAYMENT.AMOUNT);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.MODE_ID);
q += Fields.VAR100(PAYMENT.CHEQUE_NO);
q += Fields.Date(PAYMENT.CHEQUE_DATE);
q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.BANK_ID);
q += Fields.Date(PAYMENT.DEPOSITON);
q += Fields.Notes();
q += Fields.Active();
q += Fields.User_id(PAYMENT.PAYMENT_TBL);
//new DAL().Execute(q);
System.Diagnostics.Debug.WriteLine(q);
}
public void Insert(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(INVOICE.INVOICE_TBL);
q += Fields.Primary(INVOICE.INVOICE_ID);
q += Fields.Unique(INVOICE.UNIQUENO);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.COMPANY_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.DIV_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.ACY_ID);
q += Fields.Int(INVOICE.INVOICE_NO);
q += Fields.Date(INVOICE.INVOICE_DATE);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.TAXTYPE_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.SALESTYPE_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.PARTY_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.TRANSPORT_ID);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.DELIVERYAT_ID);
q += Fields.VAR100(INVOICE.BUNDLE);
q += Fields.Decimal(INVOICE.TOTAL_TAXABLE_AMOUNT);
q += Fields.Decimal(INVOICE.TOTAL_CGST);
q += Fields.Decimal(INVOICE.TOTAL_SGST);
q += Fields.Decimal(INVOICE.TOTAL_IGST);
q += Fields.Decimal(INVOICE.GSTTOTAL);
q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.LEDGER_ID);
q += Fields.Decimal(INVOICE.ADDITIONAL);
q += Fields.Decimal(INVOICE.ROUNDS);
q += Fields.Decimal(INVOICE.GRANDTOTAL);
q += Fields.Decimal(INVOICE.REFERED_AMT);
q += Fields.Notes();
q += Fields.Active();
q += Fields.User_id(INVOICE.INVOICE_TBL);
new DAL().Execute(q);
}
public Payment_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PAYMENT.PAYMENT_TBL);
q += AddFields.Primary(PAYMENT.PAYMENT_ID);
q += AddFields.Unique_500(PAYMENT.UNIQUENO);
q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.COMPANY_ID);
q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.ACY_ID);
q += AddFields.Int(PAYMENT.PAYMENT_NO);
q += AddFields.Date(PAYMENT.PAYMENT_DATE);
q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.PARTY_ID);
q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.RECEIPTTYPE_ID);
q += AddFields.VARCHAR_200(PAYMENT.CHEQUE_NO);
q += AddFields.Decimal_2(PAYMENT.PAYMENT_AMOUNT);
q += AddFields.VARCHAR_200(PAYMENT.CHEQUE_DATE);
q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.BANK_ID);
//q += Fields.Decimal_2(GARMENT_PAYMENT.TOTAL_AMOUNT);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(PAYMENT.PAYMENT_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
paymentItems_Tbl(db);
}
public void CreateGlobal(string name)
{
const string CREATE =
@"<AUTHORIZATION><AUTHORIZATIONPACKET action=""addnew"" name=""{0}""/></AUTHORIZATION>";
var answer = Project.ExecuteRQL(CREATE.RQLFormat(name));
CheckAnswer(name, answer);
}
public Pincode_Tbl(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(PINCODE.PINCODE_TBL);
q += Fields.Primary(PINCODE.PINCODE_ID);
q += Fields.Unique(PINCODE.PINCODE_NAME);
q += Fields.Notes();
q += Fields.Active();
new DAL().Execute(q);
}
public Role_Tbl(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(ROLE.ROLE_TBL);
q += Fields.Primary(ROLE.ROLE_ID);
q += Fields.Unique(ROLE.ROLE_NAME);
q += Fields.Notes();
q += Fields.Active();
new DAL().Execute(q);
}
public Country_Tbl(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(COUNTRY.COUNTRY_TBL);
q += Fields.Primary(COUNTRY.COUNTRY_ID);
q += Fields.Unique(COUNTRY.COUNTRY_NAME);
q += Fields.Notes();
q += Fields.Active();
new DAL().Execute(q);
}
private void CreateDetail(string elementtype, IRedDotObject obj, string name, AuthorizationType type)
{
const string CREATE =
@"<AUTHORIZATION><{0} guid=""{1}><AUTHORIZATIONPACKET action=""addnew"" name=""{2}"" guid="" type=""{3}""/></{0}></AUTHORIZATION>";
string query = CREATE.RQLFormat(elementtype, obj, name, (int)type);
var answer = Project.ExecuteRQL(query);
CheckAnswer(name, answer);
Standard.InvalidateCache();
}
public Cxversion_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(CXVERSION.CXVERSION_TBL);
q += AddFields.Primary(CXVERSION.CXVERSION_ID);
q += AddFields.Unique_500(CXVERSION.CXVERSION_NAME);
q += AddFields.Date(CXVERSION.CREATED_ON);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Role_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(ROLE.ROLE_TBL);
q += AddFields.Primary(ROLE.ROLE_ID);
q += AddFields.Unique_500(ROLE.ROLE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Ordertype_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(ORDERTYPE.ORDERTYPE_TBL);
q += AddFields.Primary(ORDERTYPE.ORDERTYPE_ID);
q += AddFields.Unique_500(ORDERTYPE.ORDERTYPE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(ORDERTYPE.ORDERTYPE_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Bundle_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(BUNDLE.BUNDLE_TBL);
q += AddFields.Primary(BUNDLE.BUNDLE_ID);
q += AddFields.Unique_500(BUNDLE.BUNDLE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(BUNDLE.BUNDLE_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Ledgergroup_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(LEDGERGROUP.LEDGERGROUP_TBL);
q += AddFields.Primary(LEDGERGROUP.LEDGERGROUP_ID);
q += AddFields.Unique_500(LEDGERGROUP.LEDGERGROUP_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(LEDGERGROUP.LEDGERGROUP_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Shipping_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(SHIPPING.SHIPPING_TBL);
q += AddFields.Primary(SHIPPING.SHIPPING_ID);
q += AddFields.Unique_500(SHIPPING.SHIPPING_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(SHIPPING.SHIPPING_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Method_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(METHOD.METHOD_TBL);
q += AddFields.Primary(METHOD.METHOD_ID);
q += AddFields.Unique_500(METHOD.METHOD_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(METHOD.METHOD_TBL);
q += AddFields.EOF;
new DAL().Execute(q);
}
public Producttype_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(PRODUCTTYPE.PRODUCTTYPE_TBL);
q += AddFields.Primary(PRODUCTTYPE.PRODUCTTYPE_ID);
q += AddFields.Unique_500(PRODUCTTYPE.PRODUCTTYPE_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(PRODUCTTYPE.PRODUCTTYPE_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public Country_Tbl(string db)
{
string q = USE.DB(db);
q += CREATE.TABLE(COUNTRY.COUNTRY_TBL);
q += AddFields.Primary(COUNTRY.COUNTRY_ID);
q += AddFields.Unique_500(COUNTRY.COUNTRY_NAME);
q += AddFields.Notes;
q += AddFields.Active;
q += AddFields.User_id(COUNTRY.COUNTRY_TBL);
q += AddFields.EOF;
new SYS_DAL().Execute(q);
}
public static extern int _lcreat([In] [MarshalAs(UnmanagedType.LPStr)] string lpPathName, CREATE iAttribute);
