public void UpdateRole(RoleViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_RoleUpDate",
"@Id", viewModel.Id,
"@Code", viewModel.Code,
"@Role", viewModel.Role);
}
public List <ProductAttributeValueViewModel> GetAllProductAttributeValue()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Product_Attribute_ValueSelectAll");
var lst = Ultis.DataTableToList <ProductAttributeValueViewModel>(dtb);
return(lst);
}
public void InsertRole(RoleViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_RoleInsert",
"@Id", viewModel.Id,
"@Code", viewModel.Code,
"@Role", viewModel.Role);
}
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 <ProductAttributeValueViewModel> GetProductAttributeValueByProId(Guid Id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Product_Attribute_ValueSelectByProId", "@Id", Id);
var lst = Ultis.DataTableToList <ProductAttributeValueViewModel>(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 <ProductGroupViewModel> GetAllProductGroup()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_ProductGroupSelectAll");
var lst = Ultis.DataTableToList <ProductGroupViewModel>(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 <MenuViewModel> GetAllMenu()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_MenuSelectAll");
var lst = Ultis.DataTableToList <MenuViewModel>(dtb);
return(lst);
}
public List <RoleDetailViewModel> GetAllAccountGroup()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_DetailRoleSelectAll");
var lst = Ultis.DataTableToList <RoleDetailViewModel>(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);
}
public List <AccountViewModel> GetAllAccount()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectAll");
var lst = Ultis.DataTableToList <AccountViewModel>(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 <NewsViewModel> GetAllNews()
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_NewsSelectAll");
var lst = Ultis.DataTableToList <NewsViewModel>(dtb);
return(lst);
}
public void UpdateAccountGroup(RoleDetailViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_DetailRoleUpDate",
"@Id", viewModel.Id,
"@GroupAccId", viewModel.GroupAccId,
"@Role", viewModel.Role);
}
public List <CommentViewModel> GetCommentByProductId(Guid id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_CommentSelectByProductId", "@Id", id);
var lst = Ultis.DataTableToList <CommentViewModel>(dtb);
return(lst);
}
public void UpdateAccountGroup(GroupAccountViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_GroupAccountUpdate",
"@Id", viewModel.Id,
"@GroupCode", viewModel.GroupCode,
"@GroupName", viewModel.GroupName);
}
public void UpdateProductAttributeValue(ProductAttributeValueViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Product_Attribute_ValueUpDate",
"@Id", viewModel.Id,
"@ProductId", viewModel.AttributeId,
"@AttributeId", viewModel.ProductId,
"@Value", viewModel.Value);
}
public void UpdateProductAttribute(ProductAttributeViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Product_AttributeUpDate",
"@Id", viewModel.Id,
"@AttributeName", viewModel.AttributeName,
"@AttributeType", viewModel.AttributeType,
"@Status", viewModel.Status);
}
public void UpdateOrderDetail(OrderDetailViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_OrderDetailUpDate",
"@OrderId", viewModel.OrderId,
"@ProductId", viewModel.ProductId,
"@Amount", viewModel.Amount,
"@Notes", viewModel.Notes,
"@Price", viewModel.Price);
}
public void UpdateMenu(MenuViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_MenuUpDate",
"@Title", viewModel.Title,
"@Order", viewModel.Order,
"@ParrentId", viewModel.ParrentId,
"@Id", viewModel.Id,
"@Status", viewModel.Status,
"@Link", viewModel.Link);
}
public OrderDetailViewModel GetOrderEtailById(Guid proid, Guid oid)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderDetailSelectByID", "@ProductId", proid, "@OrderID", oid);
OrderDetailViewModel role = new OrderDetailViewModel();
foreach (DataRow item in dtb.Rows)
{
role = Ultis.GetItem <OrderDetailViewModel>(item);
}
return(role);
}
public NewsViewModel GetNewsById(Guid Id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_NewsSelectByID", "@Id", Id);
NewsViewModel role = new NewsViewModel();
foreach (DataRow item in dtb.Rows)
{
role = Ultis.GetItem <NewsViewModel>(item);
}
return(role);
}
public void UpdateInfo(AccountViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_UpdateInfor",
"@Id", viewModel.Id,
"@FullName", viewModel.FullName,
"@Gender", viewModel.Gender,
"@Birthday", viewModel.Birthday,
"@Email", viewModel.Email,
"@PhoneNumber", viewModel.PhoneNumber,
"@Address", viewModel.Address);
}
public RoleDetailViewModel GetAccountGroupById(Guid Id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_DetailRoleSelectByID", "@Id", Id);
RoleDetailViewModel accgr = new RoleDetailViewModel();
foreach (DataRow item in dtb.Rows)
{
accgr = Ultis.GetItem <RoleDetailViewModel>(item);
}
return(accgr);
}
public ProductGroupViewModel GetProductGroupById(Guid Id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_ProductGroupSelectByID", "@Id", Id);
ProductGroupViewModel role = new ProductGroupViewModel();
foreach (DataRow item in dtb.Rows)
{
role = Ultis.GetItem <ProductGroupViewModel>(item);
}
return(role);
}
public void UpdateNewsGroup(NewsGroupViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_NewsGroupUpDate",
"@Id", viewModel.Id,
"@NameGroup", viewModel.NameGroup,
"@Description", viewModel.Description,
"@Status", viewModel.Status,
"@Modifier", viewModel.Modifier,
"@ModifyDate", viewModel.ModifyDate,
"@Url", viewModel.Url);
}
public void UpdateProductGroup(ProductGroupViewModel viewModel)
{
SqlDb_Ultis.ExeNonStored("Tbl_ProductGroupUpDate",
"@Id", viewModel.Id,
"@GroupName", viewModel.GroupName,
"@Description", viewModel.Description,
"@Status", viewModel.Status,
"@Modifier", viewModel.Modifier,
"@ModifyDate", viewModel.ModifyDate,
"@Url", viewModel.Url);
}
public CommentViewModel GetCommentById(Guid id)
{
DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_CommentSelectByID", "@Id", id);
CommentViewModel role = new CommentViewModel();
foreach (DataRow item in dtb.Rows)
{
role = Ultis.GetItem <CommentViewModel>(item);
}
return(role);
}
