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); }