public async Task <IEnumerable <IColor> > GetColors(int numberOfColors) { string query = @"SELECT TOP(@num) * FROM Colors"; var param = new { num = numberOfColors }; return(await _dataBaseManager.Read <Color>(query, param)); }
public async Task <IEnumerable <ICompany> > GetCompanies(int numberOfCompanies) { var param = new { numberOfCompanies }; string query = "SELECT TOP(@numberOfCompanies) * FROM Companies"; return(await _dataBaseManager.Read <Company>(query, param)); }
public async Task <IEnumerable <IEmployee_Work_Details> > GetEmployee_Work_Details() { string query = "SELECT * FROM Employee_Work_Detailes"; return(await _dataBaseManager.Read <Employee_Work_Details>(query)); }
public async Task <IEnumerable <IProduct_Command> > GetProduct_Commands() { string query = @"SELECT * FROM Product_Command"; return(await _dataBaseManager.Read <Product_Command>(query)); }
public async Task <IEnumerable <IService_Call> > GetService_Calls() { string query = @"SELECT * FROM Service_Calls ORDER BY Date_time"; return(await _dataBaseManager.Read <Service_Call>(query)); }
public async Task <IEnumerable <IOrder_Details> > GetOrder_Details() { string query = "SELECT * FROM Order_Details"; return(await _dataBaseManager.Read <Order_Details>(query)); }
public async Task <IEnumerable <IProperty> > GetProperties() { string query = @"SELECT * FROM Properties ORDER BY Construction_Date"; return(await _dataBaseManager.Read <Property>(query)); }
public async Task <IEnumerable <IFile> > GetFiles() { string query = @"SELECT * FROM Files "; return(await _dataBaseManager.Read <File>(query)); }
public async Task <IEnumerable <IProduct_Category> > GetProduct_Categories() { string query = "SELECT * FROM Product_Category"; return(await _dataBaseManager.Read <Product_Category>(query)); }
public async Task <IEnumerable <IProject> > GetProjects() { string query = @"SELECT * FROM Projects ORDER BY Start_Date"; return(await _dataBaseManager.Read <Project>(query)); }
public async Task <IEnumerable <IAddress> > GetAddresses() { return(await _dataBaseManager.Read <Address>($"SELECT * FROM Addresses")); }
public async Task <IEnumerable <IEmployee> > GetEmployees() { string query = @"SELECT * FROM Employees "; return(await _dataBaseManager.Read <Employee>(query)); }
public async Task <IEnumerable <ICustomer> > GetCustomers() { return(await _dataBaseManager.Read <Customer>("SELECT * FROM Customers")); }
public async Task <IEnumerable <IUsed_Products_Details> > GetUsed_Products_Details() { string query = @"SELECT * FROM Used_Products_Details"; return(await _dataBaseManager.Read <Used_Products_Details>(query)); }
public async Task <IEnumerable <IProduct_Stock> > GetProducts_Stock() { string query = @"SELECT * FROM Product_Stock "; return(await _dataBaseManager.Read <Product_Stock>(query)); }
public async Task <IEnumerable <IDesign> > GetDesignes() { string query = @"SELECT * FROM Design"; return(await _dataBaseManager.Read <Design>(query)); }
public async Task <IEnumerable <ISupplier> > GetSuppliers() { string query = @"SELECT * FROM Suppliers"; return(await _dataBaseManager.Read <Supplier>(query)); }