public IEnumerable <E_BannerCat> Get_BannerCatList()
        {
            BLLDBOperations blldb = new BLLDBOperations(InvConstr);
            Hashtable       hst   = new Hashtable();
            DataTable       dt;

            hst.Add("Action", "GetBannerCatList");
            dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
            IEnumerable <E_BannerCat> lst = DbOperation.ConvertDataTable <E_BannerCat>(dt);

            return(lst);
        }
        public IEnumerable <E_Banner> SrchBanner()
        {
            BLLDBOperations blldb = new BLLDBOperations(InvConstr);
            Hashtable       hst   = new Hashtable();
            DataTable       dt;

            hst.Add("Action", "SrchBanner");
            //hst.Add("BannerName", BannerName);
            dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
            IEnumerable <E_Banner> lst = DbOperation.ConvertDataTable <E_Banner>(dt);

            return(lst);
        }
Esempio n. 3
0
        public IEnumerable <E_Company> SrchCompany()
        {
            BLLDBOperations blldb = new BLLDBOperations();
            Hashtable       hst   = new Hashtable();
            DataTable       dt;

            hst.Add("Action", "SrchCompany");
            //hst.Add("CompanyName", CompanyName);
            dt = blldb.GetDataTable("SP_CompanyMaster", CommandType.StoredProcedure, hst);
            IEnumerable <E_Company> lst = DbOperation.ConvertDataTable <E_Company>(dt);

            return(lst);
        }