public bool check(string CardNumber) { _q = new QueryExecutor(); return(Convert.ToBoolean(_q.Aggregate( string.Format("select count(*) from cardregistration where cardnumber='{0}'", CardNumber)))); }
public int getCount(string PolicyNumber) { _q = new QueryExecutor(); return(Convert.ToInt32(_q.Aggregate( string.Format("select count(*) from cardregistration where policynumber='{0}'", PolicyNumber)))); }
public bool AddCategory() { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("insert into store_categories(category) values ('{0}')", this.Category)) > 0); }
public List <StoreInventory> getInventory() { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <StoreInventory> (_q.NonTransaction("select * from item_inventory"))); }
public List <Policy> getPolicyCollection() { _q = new QueryExecutor(); DataTable tab = _q.NonTransaction("Select * from policies"); return(DataConvertor.ConvertDataTable <Policy>(tab)); }
public List <BillingChild> getBillItems(int shopNumber, string invNumber) { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <BillingChild>( _q.NonTransaction("select * from billingchild where invoicenumber='" + invNumber + "' and shopnumber=" + shopNumber))); }
public List <ShopCategory> getCategories() { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <ShopCategory>( _q.NonTransaction("select * from floordetails"))); }
public List <StoreSupplier> GetSuppliers() { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <StoreSupplier>( _q.NonTransaction("Select * from store_suppliers"))); }
public List <Package> getPackages() { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <Package> (_q.NonTransaction("select * from packages"))); }
public bool AddGST() { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("insert into store_gst(gst) values ('{0}')", this.gst)) > 0); }
public bool Delete(decimal id) { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("delete from store_gst where gst={0}", id)) > 0); }
public bool Delete(string id) { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("delete from uom where uom='{0}'", id)) > 0); }
public bool AddUOM() { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("insert into uom(uom) values ('{0}')", this.Uom)) > 0); }
public bool Delete(string id) { _q = new QueryExecutor(); return(_q.Transaction(string.Format ("delete from store_categories where category='{0}'", id)) > 0); }
public bool DeleteSupplier(int Supplier_id) { _q = new QueryExecutor(); return(_q .Transaction("delete from store_suppliers where supplier_id=" + Supplier_id) > 0); }
public List <CompanyMaster> GetComapnyByName(string name) { _q = new QueryExecutor(); DataTable tab = _q.NonTransaction(string.Format("Select * from companymaster where company='{0}'", name)); return(DataConvertor.ConvertDataTable <CompanyMaster>(tab)); }
public List <CompanyMaster> GetComapnyById(decimal id) { _q = new QueryExecutor(); DataTable tab = _q.NonTransaction("Select * from companymaster where id=" + id); return(DataConvertor.ConvertDataTable <CompanyMaster>(tab)); }
public List <offerGroup> getOffers() { _q = new QueryExecutor(); return(ProcessData(DataConvertor.ConvertDataTable <Offer>( _q.NonTransaction("Select * from offers")))); }
public List <VendorPayments> getVendorPayments_unpaid(int ShopNumber) { _q = new QueryExecutor(); return(DataConvertor.ConvertDataTable <VendorPayments>( _q.NonTransaction("select * from vendor_payments where status='Unpaid' and shopnumber=" + ShopNumber))); }
public bool RemoveOffer() { _q = new QueryExecutor(); return(_q.Transaction( string.Format("delete from offers where offerid={0}", this.offerid)) > 0); }
public bool RemoveImage(int Slno) { _q = new QueryExecutor(); return(_q.Transaction( "delete from slider_images where slno=" + Slno) > 0); }
public bool AddImage() { _q = new QueryExecutor(); return(_q.Transaction( "insert into slider_images (image,sequence) values ('" + this.Image + "'," + this.sequence + ")") > 0); }
public DataTable getCardTypesTable() { _q = new QueryExecutor(); DataTable tab = _q.NonTransaction("select * from cardtypes"); return(tab); }
public List <Policy> getPolicyByNumber(string PolicyNumber) { _q = new QueryExecutor(); DataTable tab = _q.NonTransaction( string.Format("Select * from policies where policynumber='{0}'", PolicyNumber)); return(DataConvertor.ConvertDataTable <Policy>(tab)); }
public bool AddOffer() { _q = new QueryExecutor(); return(_q.Transaction( string.Format("insert into offers(category,valid_from,valid_till,image)" + "values('{0}','{1}','{2}','{3}')", this.category, this.Valid_From, this.Valid_Till, this.Image)) > 0); }
public List <Shop> getShops() { _q = new QueryExecutor(); return(DataConvertor .ConvertDataTable <Shop>(_q .NonTransaction("Select * from shopdetails"))); }
internal List <SliderImage> getImages() { _q = new QueryExecutor(); return(DataConvertor .ConvertDataTable <SliderImage>(_q.NonTransaction( "Select * from slider_images order by sequence"))); }
internal bool updatePin(string pin, string cardNumber) { _q = new QueryExecutor(); return(_q.Transaction( string.Format("Update cardregistration " + "set pin='{1}' where cardnumber='{0}'", cardNumber, pin)) > 0); }
public bool addMaterialInItem(int mi_number) { _q = new QueryExecutor(); return(_q.Transaction( string.Format("insert into material_inword_items(minumber,particulars,quantity)" + "values ({0},'{1}','{2}')", mi_number, this.particulars, this.Quantity)) > 0); }
internal object acivateAccount(string cardNumber) { _q = new QueryExecutor(); return(_q.Transaction( string.Format("Update cardregistration " + "set isactive='true' where cardnumber='{0}'", cardNumber)) > 0); }