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