public bool ProductionOrderExists(int saleBranchNo, int saleNo)
{
_authorization.CheckUserActivity(ProductionOrdersCoveringSalesUserActivityCode);
return(_dataConnection.GetItem(
(r) => (r.GetInt32(0) != 0),
"select Sign(Count(*)) from SALES s, DEPTS d where (s.SALE_BRANCH_CODE = d.DEPT_CODE) and (d.CUSTOM_CODE = :SALE_BRANCH_NO) and (s.SALE_NO = :SALE_NO)",
new SqlDataParameter("SALE_BRANCH_NO", saleBranchNo),
new SqlDataParameter("SALE_NO", saleNo)));
}
public Product GetProductByCode(int productCode)
{
_authorization.CheckUserActivity(PoductsUserActivityCode);
return(GetProduct(
"select p.PRODUCT_CODE, p.NAME, p.CUSTOM_CODE, ProductUtils.ProductCompanyProductNames(p.PRODUCT_CODE) as PRODUCT_PARTNER_NAMES from PRODUCTS p where (p.PRODUCT_CODE = :PRODUCT_CODE) and (p.CUSTOM_CODE is not null)",
new SqlDataParameter("PRODUCT_CODE", productCode)));
}
public void AddEmployeeMovement(int employeeNo, int inOut, DateTime movementDateTime)
{
_authorization.CheckUserActivity(AutomatedAddEmployeeMovementsUserActivityCode);
TryAddEmployeeMovement(employeeNo, inOut, movementDateTime);
}