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