public List <ProductGroupViewModel> GetAllProductGroup()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_ProductGroupSelectAll");
            var       lst = Ultis.DataTableToList <ProductGroupViewModel>(dtb);

            return(lst);
        }
Beispiel #2
0
        public List <NewsViewModel> GetAllNews()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_NewsSelectAll");
            var       lst = Ultis.DataTableToList <NewsViewModel>(dtb);

            return(lst);
        }
        public List <OrderDetailViewModel> GetOrderDetailByOrder(Guid id)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderDetailSelectByOrder", "@Id", id);
            var       lst = Ultis.DataTableToList <OrderDetailViewModel>(dtb);

            return(lst);
        }
        public List <RoleDetailViewModel> GetAllAccountGroup()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_DetailRoleSelectAll");
            var       lst = Ultis.DataTableToList <RoleDetailViewModel>(dtb);

            return(lst);
        }
Beispiel #5
0
        public List <AccountViewModel> GetAllAccount()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectAll");
            var       lst = Ultis.DataTableToList <AccountViewModel>(dtb);

            return(lst);
        }
Beispiel #6
0
        public List <Category> GetlAllCategories()
        {
            DataTable dtb = SqlDb_Ultis.ExeSQLToDataTable("Select * from tbl_Category");
            var       lst = Ultis.DataTableToList <Category>(dtb);

            return(lst);
        }
Beispiel #7
0
        public List <CommentViewModel> GetCommentByProductId(Guid id)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_CommentSelectByProductId", "@Id", id);
            var       lst = Ultis.DataTableToList <CommentViewModel>(dtb);

            return(lst);
        }
Beispiel #8
0
        public List <MenuViewModel> GetAllMenu()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_MenuSelectAll");
            var       lst = Ultis.DataTableToList <MenuViewModel>(dtb);

            return(lst);
        }
Beispiel #9
0
        public List <MenuViewModel> GetMenuByPId(Guid id)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_MenuSelectByPID", "@Id", id);
            var       lst = Ultis.DataTableToList <MenuViewModel>(dtb);

            return(lst);
        }
        public List <ProductAttributeValueViewModel> GetProductAttributeValueByProId(Guid Id)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Product_Attribute_ValueSelectByProId", "@Id", Id);
            var       lst = Ultis.DataTableToList <ProductAttributeValueViewModel>(dtb);

            return(lst);
        }
        public List <ProductAttributeValueViewModel> GetAllProductAttributeValue()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Product_Attribute_ValueSelectAll");
            var       lst = Ultis.DataTableToList <ProductAttributeValueViewModel>(dtb);

            return(lst);
        }
Beispiel #12
0
        public List <OrderViewModel> GetOrderByAccount(string id)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderSelectByAccount", "@Id", id);
            var       lst = Ultis.DataTableToList <OrderViewModel>(dtb);

            return(lst);
        }
Beispiel #13
0
        public List <OrderViewModel> GetAllOrder()
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderSelectAll");
            var       lst = Ultis.DataTableToList <OrderViewModel>(dtb);

            return(lst);
        }
        public List <ProductAttributeViewModel> GetAllProducAttributebySP(Guid masanpham)
        {
            DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("LoadAttr", "@Id", masanpham);
            var       lst = Ultis.DataTableToList <ProductAttributeViewModel>(dtb);

            return(lst);
        }