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 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 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); }
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 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 MenuViewModel GetMenuById(Guid id) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_MenuSelectByID", "@Id", id); MenuViewModel role = new MenuViewModel(); foreach (DataRow item in dtb.Rows) { role = Ultis.GetItem <MenuViewModel>(item); } return(role); }
public CompanyInfoViewModel GetCompanyInfo() { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_InforCompanySelectAll"); CompanyInfoViewModel role = new CompanyInfoViewModel(); foreach (DataRow item in dtb.Rows) { role = Ultis.GetItem <CompanyInfoViewModel>(item); } return(role); }
public ProductAttributeValueViewModel GetProductAttributeValueById(Guid Id) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Product_Attribute_ValueSelectByID", "@Id", Id); ProductAttributeValueViewModel role = new ProductAttributeValueViewModel(); foreach (DataRow item in dtb.Rows) { role = Ultis.GetItem <ProductAttributeValueViewModel>(item); } return(role); }
public RoleViewModel GetRoleById(Guid Id) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_RoleSelectByID", "@Id", Id); RoleViewModel role = new RoleViewModel(); foreach (DataRow item in dtb.Rows) { role = Ultis.GetItem <RoleViewModel>(item); } return(role); }
public OrderViewModel GetOrderById(Guid id) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_OrderSelectByID", "@Id", id); OrderViewModel role = new OrderViewModel(); foreach (DataRow item in dtb.Rows) { role = Ultis.GetItem <OrderViewModel>(item); } return(role); }
public AccountViewModel GetAccountByUserName(string userName) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectByUserName1", "@UserName", userName); AccountViewModel acc = new AccountViewModel(); foreach (DataRow item in dtb.Rows) { acc = Ultis.GetItem <AccountViewModel>(item); } return(acc); }
public AccountViewModel GetAccountById(Guid Id) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectByID", "@Id", Id); AccountViewModel acc = new AccountViewModel(); foreach (DataRow item in dtb.Rows) { acc = Ultis.GetItem <AccountViewModel>(item); } return(acc); }
public AccountViewModel GetAccountByEmail(string email) { DataTable dtb = SqlDb_Ultis.ExeStoredToDataTable("Tbl_AccountSelectByEmail", "@Email", email); AccountViewModel acc = new AccountViewModel(); foreach (DataRow item in dtb.Rows) { acc = Ultis.GetItem <AccountViewModel>(item); } return(acc); }