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