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