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