public static void InsertDefault_offset_po(string db)
{
string q = USE.DB(db);
Offset_po obj = new Offset_po()
{
Offset_po_id = "1",
Uniqueno = "admin~1~000",
Company_id = "1",
Acy_id = "1",
Offset_po_no = "0",
Offset_po_date = "31-03-2019",
Party_id = "1",
Party_po_ref = "party_po_ref",
Delivery_date = "31-03-2019",
Total_qty = "0",
Total_amount = "0",
Locked = "1",
Refered_no = "0",
Notes = "",
Active_id = Core.Active,
User_id = "1"
};
COffset_po.Insert(obj, new DAL());
InsertDefault_poitems(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 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 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 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 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 static void InsertDefault_Role(string db)
{
string q = USE.DB(db);
q += DB.INSERT(ROLE.ROLE_TBL);
q += DB.FIELD_1ST(ROLE.ROLE_ID);
q += DB.FIELD(ROLE.ROLE_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("Admin");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
q = USE.DB(db);
q += DB.INSERT(ROLE.ROLE_TBL);
q += DB.FIELD_1ST(ROLE.ROLE_ID);
q += DB.FIELD(ROLE.ROLE_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.MID;
q += DB.VALUE_1ST("2");
q += DB.VALUE("Accounts");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
}
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 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 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 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 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 static void InsertDefault_offset_dc(string db)
{
string q = USE.DB(db);
Offset_dc obj = new Offset_dc()
{
Offset_dc_id = "1",
Unqiueno = "admin~1~000",
Company_id = "1",
Acy_id = "1",
Offset_dc_no = "1",
Offset_dc_date = "31-03-2019",
Party_id = "1",
Total_qty = "0",
Refered_no = "0",
Locked = "1",
Notes = "Notes",
Active_id = Core.Active,
User_id = "1"
};
COffset_dc.Insert(obj, new DAL());
InsertDefault_offset_dcitems(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 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 static void InsertDefault_Cash_in_hand(string db)
{
string q = USE.DB(db);
q += DB.INSERT(CASH_IN_HAND.CASH_IN_HAND_TBL);
q += DB.FIELD_1ST(CASH_IN_HAND.CASH_IN_HAND_ID);
q += DB.FIELD(CASH_IN_HAND.ENTRY_DATE);
q += DB.FIELD(CASH_IN_HAND.CASH_RECEIPT_ID);
q += DB.FIELD(CASH_IN_HAND.CASH_PAYMENT_ID);
q += DB.FIELD(CASH_IN_HAND.RECEIPT_AMOUNT);
q += DB.FIELD(CASH_IN_HAND.PAYMENT_AMOUNT);
q += DB.FIELD(CASH_IN_HAND.BALANCE_AMOUNT);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("'2020-08-09'");
q += DB.VALUE("1");
q += DB.VALUE("1");
q += DB.VALUE("0");
q += DB.VALUE("0");
q += DB.VALUE("0");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new DAL().Execute(q);
}
public static void InsertDefault_User(string db)
{
string q = USE.DB(db);
q += DB.INSERT(USER.USER_TBL);
q += DB.FIELD_1ST(USER.USER_ID);
q += DB.FIELD(USER.USER_NAME);
q += DB.FIELD(USER.USER_PASSWORD);
q += DB.FIELD(USER.CREATEON);
q += DB.FIELD(USER.ROLE_ID);
q += DB.FIELD(USER.ENTRYBY);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("admin");
q += DB.VALUE("admin");
q += DB.VALUE("2019-05-28 16:10:38");
q += DB.VALUE("1");
q += DB.VALUE("admin");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
}
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 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 static void InsertDefault_Cash_receipt(string db)
{
string q = USE.DB(db);
q += DB.INSERT(CASH_RECEIPT.CASH_RECEIPT_TBL);
q += DB.FIELD_1ST(CASH_RECEIPT.CASH_RECEIPT_ID);
q += DB.FIELD(CASH_RECEIPT.RECEIPT_DATE);
q += DB.FIELD(CASH_RECEIPT.PARTY_ID);
q += DB.FIELD(CASH_RECEIPT.PURPOSE);
q += DB.FIELD(CASH_RECEIPT.RECEIPT_AMOUNT);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("'2020-08-09'");
q += DB.VALUE("1");
q += DB.VALUE("-");
q += DB.VALUE("0");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new DAL().Execute(q);
}
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 static void InsertDefault_Seq(string db)
{
string q = USE.DB(db);
q += DB.INSERT(LABOUR.LABOUR_TBL);
q += DB.FIELD_1ST(LABOUR.LABOUR_ID);
q += DB.FIELD(LABOUR.UNIQUENO);
q += DB.FIELD(LABOUR.COMPANY_ID);
q += DB.FIELD(LABOUR.ACY_ID);
q += DB.FIELD(LABOUR.ORDER_ID);
q += DB.FIELD(LABOUR.LABOUR_NO);
q += DB.FIELD(LABOUR.LABOUR_DATE);
q += DB.FIELD(LABOUR.PARTY_ID);
q += DB.FIELD(LABOUR.TAXTYPE_ID);
q += DB.FIELD(LABOUR.SALESTYPE_ID);
q += DB.FIELD(LABOUR.TRANSPORT_ID);
q += DB.FIELD(LABOUR.DELIVEREDTO_ID);
q += DB.FIELD(LABOUR.BUNDEL);
q += DB.FIELD(LABOUR.TOTAL_QTY);
q += DB.FIELD(LABOUR.TOTAL_TAXABLE_AMOUNT);
q += DB.FIELD(LABOUR.TOTAL_CGST);
q += DB.FIELD(LABOUR.TOTAL_SGST);
q += DB.FIELD(LABOUR.TOTAL_IGST);
q += DB.FIELD(LABOUR.GSTTOTAL);
q += DB.FIELD(LABOUR.LEDGER_ID);
q += DB.FIELD(LABOUR.ADDITIONAL);
q += DB.FIELD(LABOUR.ROUNDS);
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("0");
q += DB.EOF;
new DAL().Execute(q);
}
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 static void InsertDefault_Company_bank(string db)
{
string q = USE.DB(db);
q += DB.INSERT(COMPANY_BANK.COMPANY_BANK_TBL);
q += DB.FIELD_1ST(COMPANY_BANK.COMPANY_BANK_ID);
q += DB.FIELD(COMPANY_BANK.COMPANY_BANK_NAME);
q += DB.FIELD(COMPANY_BANK.ACCOUNT_NUMBER);
q += DB.FIELD(COMPANY_BANK.IFSC_CODE);
q += DB.FIELD(COMPANY_BANK.BRANCH_NAME);
q += DB.FIELD(COMPANY_BANK.OPENING_BALANCE);
q += DB.FIELD(COMPANY_BANK.ACCOUNT_OPENSON);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("-");
q += DB.VALUE("-");
q += DB.VALUE("-");
q += DB.VALUE("-");
q += DB.VALUE("0");
q += DB.VALUE("-");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new DAL().Execute(q);
}
public void Update(string database)
{
string q = USE.DB(database);
q += "";
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);
}
public static void InsertDefault_Colours(string db)
{
string q = USE.DB(db);
q += DB.INSERT(COLOURS.COLOURS_TBL);
q += DB.FIELD_1ST(COLOURS.COLOURS_ID);
q += DB.FIELD(COLOURS.COLOURS_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("-");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
q = USE.DB(db);
q += DB.INSERT(COLOURS.COLOURS_TBL);
q += DB.FIELD_1ST(COLOURS.COLOURS_ID);
q += DB.FIELD(COLOURS.COLOURS_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("2");
q += DB.VALUE("Green");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
q = USE.DB(db);
q += DB.INSERT(COLOURS.COLOURS_TBL);
q += DB.FIELD_1ST(COLOURS.COLOURS_ID);
q += DB.FIELD(COLOURS.COLOURS_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("3");
q += DB.VALUE("Blue");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_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 static void InsertDefault_Receipttype(string db)
{
string q = USE.DB(db);
q += DB.INSERT(RECEIPTTYPE.RECEIPTTYPE_TBL);
q += DB.FIELD_1ST(RECEIPTTYPE.RECEIPTTYPE_ID);
q += DB.FIELD(RECEIPTTYPE.RECEIPTTYPE_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("1");
q += DB.VALUE("CASH");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
q = USE.DB(db);
q += DB.INSERT(RECEIPTTYPE.RECEIPTTYPE_TBL);
q += DB.FIELD_1ST(RECEIPTTYPE.RECEIPTTYPE_ID);
q += DB.FIELD(RECEIPTTYPE.RECEIPTTYPE_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("2");
q += DB.VALUE("CHEQUE");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
q = USE.DB(db);
q += DB.INSERT(RECEIPTTYPE.RECEIPTTYPE_TBL);
q += DB.FIELD_1ST(RECEIPTTYPE.RECEIPTTYPE_ID);
q += DB.FIELD(RECEIPTTYPE.RECEIPTTYPE_NAME);
q += DB.NOTES;
q += DB.ACTIVE_ID;
q += DB.USER_ID;
q += DB.MID;
q += DB.VALUE_1ST("3");
q += DB.VALUE("RTGS");
q += DB.NotesValue;
q += DB.ActiveValue;
q += DB.UserValue;
q += DB.EOF;
new SYS_DAL().Execute(q);
}
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);
}
