Beispiel #1
0
        public List <Policy> getPolicyCollection()
        {
            _q = new QueryExecutor();
            DataTable tab = _q.NonTransaction("Select * from policies");

            return(DataConvertor.ConvertDataTable <Policy>(tab));
        }
Beispiel #2
0
        public List <ShopCategory> getCategories()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <ShopCategory>(
                       _q.NonTransaction("select * from floordetails")));
        }
Beispiel #3
0
        public List <StoreInventory> getInventory()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <StoreInventory>
                       (_q.NonTransaction("select * from item_inventory")));
        }
Beispiel #4
0
        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 <Material_In_Items> getMaterialInItems(int mi_number)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Material_In_Items>(
                       _q.NonTransaction("select * from material_inword_items where minumber=" + mi_number)));
        }
Beispiel #6
0
        public List <StoreSupplier> GetSuppliers()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <StoreSupplier>(
                       _q.NonTransaction("Select * from store_suppliers")));
        }
Beispiel #7
0
        public Material_In getMaterialIn(int Min)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Material_In>(
                       _q.NonTransaction("select * from material_inword where mi_number=" + Min))[0]);
        }
Beispiel #8
0
        public List <Material_In> getMaterialIn()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Material_In>(
                       _q.NonTransaction("select * from material_inword")));
        }
Beispiel #9
0
        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)));
        }
Beispiel #10
0
        public List <Testimonials> getTesimonials()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Testimonials>
                       (_q.NonTransaction("select * from testimonials")));
        }
Beispiel #11
0
        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)));
        }
Beispiel #12
0
        public List <Package> getPackages()
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Package>
                       (_q.NonTransaction("select * from packages")));
        }
Beispiel #13
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));
        }
Beispiel #14
0
        public List <offerGroup> getOffers()
        {
            _q = new QueryExecutor();

            return(ProcessData(DataConvertor.ConvertDataTable <Offer>(
                                   _q.NonTransaction("Select * from offers"))));
        }
Beispiel #15
0
        public List <Package> getPackageDescription(int Amount)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Package>
                       (_q.NonTransaction(
                           string.Format("select * from packages where amount='{0}'", Amount))));
        }
Beispiel #16
0
        public List <Package> getPackages_cardType(string cardType)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Package>
                       (_q.NonTransaction(
                           string.Format("select * from packages where cardtype='{0}'", cardType))));
        }
Beispiel #17
0
        public Package getPackageByAmount(int id)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <Package>
                       (_q.NonTransaction(
                           string.Format("select * from packages where amount='{0}'", id)))[0]);
        }
Beispiel #18
0
        internal List <SliderImage> getImages()
        {
            _q = new QueryExecutor();

            return(DataConvertor
                   .ConvertDataTable <SliderImage>(_q.NonTransaction(
                                                       "Select * from slider_images order by sequence")));
        }
Beispiel #19
0
        public List <CompanyProfile> GetCompanyProfiles(string cmpny)
        {
            _q = new QueryExecutor();
            DataTable tabProfile = _q.NonTransaction(string.Format(
                                                         "Select * from companyprofile where company='{0}'", cmpny));

            return(DataConvertor.ConvertDataTable <CompanyProfile>(tabProfile));
        }
Beispiel #20
0
        public List <Shop> getShops()
        {
            _q = new QueryExecutor();

            return(DataConvertor
                   .ConvertDataTable <Shop>(_q
                                            .NonTransaction("Select * from shopdetails")));
        }
Beispiel #21
0
        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));
        }
Beispiel #22
0
        internal StoreInventory getInventory_ItemCode(string id)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <StoreInventory>
                       (_q.NonTransaction(
                           string.Format("select * from item_inventory where item_code='{0}'", id)))[0]);
        }
        public List <UserTransaction> getUserTransactions(string CardNumber)
        {
            _q = new QueryExecutor();

            return(DataConvertor.ConvertDataTable <UserTransaction>
                       (_q.NonTransaction("SELECT * FROM mis_trans_customer_cardtransaction_details " +
                                          "where cardnumber='" + CardNumber + "' " +
                                          "ORDER BY trans_date DESC LIMIT 90 ")));
        }
Beispiel #24
0
        public List <CardRegistration> getPolicyCards(string policyNumber)
        {
            _q = new QueryExecutor();

            return(DataConvertor
                   .ConvertDataTable <CardRegistration>(_q
                                                        .NonTransaction(string
                                                                        .Format("select * from cardregistration where policynumber='{0}'", policyNumber))));
        }
Beispiel #25
0
        public List <CardType> getCardTypes()
        {
            _q = new QueryExecutor();
            DataTable tab = _q.NonTransaction("select * from cardtypes");

            CardTypesCollection = new List <CardType>();
            CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
            return(CardTypesCollection);
        }
Beispiel #26
0
        public CardType getCardTypeById(int id)
        {
            _q = new QueryExecutor();
            DataTable tab = _q.NonTransaction("select * from cardtypes where cardTypeid=" + id);

            CardTypesCollection = new List <CardType>();
            CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
            return(CardTypesCollection[0]);
        }
Beispiel #27
0
        public WebContent getWhatsNewContent()
        {
            _q = new QueryExecutor();

            DataTable tab = _q.NonTransaction(
                string.Format("select * from web_contents where content_type='WhatsNew'"));

            return(tab.Rows.Count != 0 ?
                   DataConvertor.ConvertDataTable <WebContent>(tab)[0] : new WebContent());
        }
Beispiel #28
0
        public CardType getCardTypeByName(string card)
        {
            _q = new QueryExecutor();
            DataTable tab = _q.NonTransaction(
                string.Format("select * from cardtypes where type='{0}'", card));

            CardTypesCollection = new List <CardType>();
            CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
            return(CardTypesCollection[0]);
        }
Beispiel #29
0
        public Shop getShopById(int id)
        {
            _q = new QueryExecutor();

            List <Shop> result = DataConvertor
                                 .ConvertDataTable <Shop>(_q
                                                          .NonTransaction("Select * from shopdetails where shopnumber=" + id));

            return(result.Count != 0 ? result[0] : null);
        }
Beispiel #30
0
        public Shop getShopByEmail(string Email)
        {
            _q = new QueryExecutor();

            List <Shop> result = DataConvertor
                                 .ConvertDataTable <Shop>(_q
                                                          .NonTransaction(string.Format("Select * from shopdetails where email='{0}' or mobilenumber='{0}'", Email)));

            return(result.Count != 0 ? result[0] : null);
        }