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 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 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 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 void Insert(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(ACY.ACY_TBL);
q += Fields.Primary(ACY.ACY_ID);
q += Fields.Unique(ACY.UNIQUENO);
q += Fields.Foreign(ACY.ACY_TBL, ACY.COMPANY_ID);
q += Fields.Foreign(ACY.ACY_TBL, ACY.DIV_ID);
q += Fields.Foreign(ACY.ACY_TBL, ACY.ACY_ID);
q += Fields.Notes();
q += Fields.Active();
q += Fields.User_id(ACY.ACY_TBL);
new DAL().Execute(q);
}
public User_Tbl(string database)
{
string q = USE.DB(database);
q += CREATE.TABLE(USER.USER_TBL);
q += Fields.Primary(USER.USER_ID);
q += Fields.Unique(USER.USER_NAME);
//q += Fields.VAR200(USER.PASSWORD);
//q += Fields.VAR500(USER.EMAIL);
//q += Fields.DateTime(USER.CREATEDON);
//q += Fields.Foreign(USER.USER_TBL, USER.ROLE_ID);
q += Fields.Notes();
q += Fields.Active();
new DAL().Execute(q);
}
