public List <ProductGroupViewModel> GetAllProductGroup()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_ProductGroupSelectAll");
var lst = Ultis.DataTableToList <ProductGroupViewModel>(dtb);
return(lst);
}
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);
}
public List <AccountViewModel> GetAllAccount()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectAll");
var lst = Ultis.DataTableToList <AccountViewModel>(dtb);
return(lst);
}
public List <Category> GetlAllCategories()
{
DataTable dtb = SqlDb_Ultis.ExeSQLToDataTable("Select * from tbl_Category");
var lst = Ultis.DataTableToList <Category>(dtb);
return(lst);
}
public List <CommentViewModel> GetCommentByProductId(Guid id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_CommentSelectByProductId", "@Id", id);
var lst = Ultis.DataTableToList <CommentViewModel>(dtb);
return(lst);
}
public List <MenuViewModel> GetAllMenu()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_MenuSelectAll");
var lst = Ultis.DataTableToList <MenuViewModel>(dtb);
return(lst);
}
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);
}
public List <OrderViewModel> GetOrderByAccount(string id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderSelectByAccount", "@Id", id);
var lst = Ultis.DataTableToList <OrderViewModel>(dtb);
return(lst);
}
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);
}