public async Task <bool> ModifyEmployee_Work_Detail(IEmployee_Work_Details modifiedEmployee_Work_Detail)
{
var param = new
{
modifiedEmployee_Work_Detail.UID,
modifiedEmployee_Work_Detail.Date,
modifiedEmployee_Work_Detail.Worked_hours,
modifiedEmployee_Work_Detail.UID_Employee,
modifiedEmployee_Work_Detail.UID_Project
};
return(await _dataBaseManager.Modify("SP_UPDATE_Employee_Work_Details", param));
}
public async Task <bool> AddEmployee_Work_Detail(IEmployee_Work_Details employee_Work_Detail)
{
var param = new
{
employee_Work_Detail.UID,
employee_Work_Detail.Date,
employee_Work_Detail.Worked_hours,
employee_Work_Detail.UID_Employee,
employee_Work_Detail.UID_Project
};
return(await _dataBaseManager.Add("SP_ADD_Employee_Work_Details", param));
}
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);
}
