public async Task <bool> CompanyExists(ICompany company) { var param = new { company.UID, company.COM_Name }; string query = "SELECT * FROM Companies WHERE UID=@UID AND TRIM(LOWER(@COM_Name))=TRIM(LOWER(COM_Name))"; return(await _dataBaseManager.Find <Company>(query, param) != null); }
public async Task <IProduct> FindProduct(string UID) { var param = new { UID }; string query = "SELECT * FROM Products WHERE [UID] LIKE @UID"; return(await _dataBaseManager.Find <Product>(query, param)); }
public async Task <IProperty> FindProperty(string UID) { string query = @"SELECT * FROM Properties WHERE [UID] LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Property>(query, param)); }
public async Task <ISupplier> FindSupplier(string UID) { string query = @"SELECT * FROM Suppliers WHERE [UID] LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Supplier>(query, param)); }
public async Task <IProduct_Command_Details> FindProduct_Command_Details(string UID) { string query = @"SELECT * FROM Product_Command_Details WHERE UID LIKE @UID OR UID_PRO LIKE @UID OR UID_PRO_Command LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Product_Command_Details>(query, param)); }
public async Task <IProduct_Stock> FindProduct_Stock(string UID_Prod) { var param = new { UID_Prod }; string query = @"SELECT * FROM Product_Stock WHERE [Product_UID] LIKE @UID_Prod "; return(await _dataBaseManager.Find <Product_Stock>(query, param)); }
public async Task <IService_Call> FindService_Call(string UID) { string query = @"SELECT * FROM Service_Calls WHERE [UID] LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Service_Call>(query, param)); }
public async Task <IUsed_Products_Details> FindUsed_Products_Details(string UID) { string query = @"SELECT * FROM Used_Products_Details WHERE [UID] LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Used_Products_Details>(query, param)); }
public async Task <IProduct_Command> FindProduct_Command(string UID) { string query = @"SELECT * FROM Product_Command WHERE UID LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Product_Command>(query, param)); }
public async Task <IProduct_Category> FindProduct_Category(string UID) { string query = "SELECT * FROM Product_Category WHERE [UID] LIKE @UID"; var param = new { UID }; return(await _dataBaseManager.Find <Product_Category>(query, param)); }
public async Task <IOrder_Details> FindOrder_Details(string UID = "", string customerID = "") { string query = @"SELECT * FROM Order_Details WHERE [UID] LIKE @UID OR [UID] LIKE @UID_Customer "; var param = new { UID, UID_Customer = customerID }; return(await _dataBaseManager.Find <Order_Details>(query, param)); }
public async Task <bool> DesignExists(IDesign design) { string query = @"SELECT * FROM Design WHERE TRIM(LOWER(Design_Title)) LIKE TRIM(LOWER(@Design_Title))"; var param = new { design.Design_Title }; return(await _dataBaseManager.Find <Design>(query, param) != null); }
public async Task <bool> ColorExists(IColor color) { var param = new { color.UID, color.Color_Name }; string query = "SELECT * FROM Colors WHERE UID=@UID AND Color_Name=@Color_Name"; return(await _dataBaseManager.Find <Color>(query, param) != null); }
public async Task <bool> EmployeeExists(IEmployee employee) { string query = @"SELECT * FROM Employees WHERE UID LIKE @UID OR ( TRIM(LOWER(EMP_Username)) LIKE TRIM(LOWER(@USR_Username)) )"; var param = new { employee.UID, employee.USR_Username }; return(await _dataBaseManager.Find <Employee>(query, param) != null); }
public async Task <bool> Employee_Work_DetailExists(IEmployee_Work_Details employee_Work_Detail) { string query = @"SELECT * FROM Employee_Work_Details WHERE [Date]=@Date AND UID_Employee=@UID_Employee AND UID_Project=@UID_Project"; var param = new { employee_Work_Detail.Date, employee_Work_Detail.UID_Employee, employee_Work_Detail.UID_Project }; return(await _dataBaseManager.Find <Employee_Work_Details>(query, param) != null); }
public async Task <bool> FileExists(IFile file) { var param = new { file.UID, file.FIL_Name, file.FIL_Path }; string query = @"SELECT * FROM Files WHERE [UID] LIKE @UID OR (TRIM(LOWER(FIL_Name)) LIKE TRIM(LOWER(@FIL_Name)) AND TRIM(LOWER(FIL_Path)) LIKE TRIM(LOWER(@FIL_Path)))"; return(await _dataBaseManager.Find <File>(query, param) != null); }
public async Task <bool> CustomerExists(ICustomer customer) { var param = new { customer.USR_First_Name, customer.USR_Last_Name, customer.USR_Username }; string query = @"SELECT * FROM Customers WHERE TRIM(LOWER(@USR_First_Name))=TRIM(LOWER(CUS_First_Name)) TRIM(LOWER(@USR_Last_Name) =TRIM(LOWER(CUS_Last_Name)) TRIM(LOWER(@USR_Username)) =TRIM(LOWER(CUS_Username))"; return(await _dataBaseManager.Find <Customer>(query, param) != null); }
public async Task <bool> AddressExists(IAddress address) { string query = @"SELECT * FROM Addresses WHERE ADR_City LIKE @ADR_City AND ADR_Country LIKE @ADR_Country ADR_Street LIKE @ADR_Street AND ADR_Number LIKE @ADR_Number AND ADR_State LIKE @ADR_State"; var param = new { address.ADR_City, address.ADR_Country, address.ADR_Number, address.ADR_State, address.ADR_Street }; return(await _dataBaseManager.Find <Address>(query, param) != null); }