public int EditEmployee(EmployeeEditRequest model)
{
using (var conn = Getconn())
{
int id = 0;
if (conn.State == ConnectionState.Open)
{
using (var cmd = new SqlCommand("Employee_Update", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@employee_id", model.Employee_Id);
cmd.Parameters.AddWithValue("@first_name", model.First_Name);
cmd.Parameters.AddWithValue("@last_name", model.Last_Name);
cmd.Parameters.AddWithValue("@gender", model.Gender);
cmd.Parameters.AddWithValue("@salary", model.Salary);
cmd.Parameters.AddWithValue("@position", model.Position);
cmd.Parameters.AddWithValue("@department_id", model.Department_Id);
cmd.ExecuteNonQuery();
id = (int)cmd.Parameters["@employee_id"].Value;
}
}
else
{
BadConn();
}
return(id);
}
}
public IHttpActionResult Update(EmployeeEditRequest model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
else
{
return(Ok("Employee " + svc.EditEmployee(model) + " has been updated"));
}
}
