public bool UpdateEmployee(EmployeeTemplate employee, int id)
{
using (var db = new SqlConnection(conString))
{
var result = db.Execute(@"update employee
set [name] = @name, [is_supervisor] = @is_supervisor, [department_id] = @department_id
where employee.id = @id", new { id = id, name = employee.name, is_supervisor = employee.is_supervisor, department_id = employee.department_id });
return(result == 1);
}
}
public bool AddEmployee(EmployeeTemplate employee)
{
using (var db = new SqlConnection(conString))
{
var result = db.Execute(@"insert into employee
([name],[is_supervisor], [department_id])
values
(@name, @is_supervisor, @department_id)", employee);
return(result == 1);
}
}
public IActionResult UpdateEmployee(EmployeeTemplate employee, int id)
{
if (employee.name == "")
{
string message = "Please include a name.";
return(BadRequest(message));
}
else if (employee.department_id <= 0)
{
string message = "Department Id cannot be less than 1.";
return(BadRequest(message));
}
return(Ok(_storage.UpdateEmployee(employee, id)));
}
public IActionResult UpdateEmployee(EmployeeTemplate employee, int id)
{
return(Ok(_storage.UpdateEmployee(employee, id)));
}
public IActionResult AddEmployee(EmployeeTemplate employee)
{
return(Ok(_storage.AddEmployee(employee)));
}
