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