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