public int Update(InternUpdateRequest request, int id)
{
int returnId = 0;
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Intern_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", id);
cmd.Parameters.AddWithValue("FirstName", request.FirstName);
cmd.Parameters.AddWithValue("LastName", request.LastName);
cmd.Parameters.AddWithValue("Email", request.Email);
cmd.Parameters.AddWithValue("Password", request.Password);
cmd.Parameters.AddWithValue("PhoneNumber", request.PhoneNumber);
cmd.Parameters.AddWithValue("Sponsorship", request.Sponsorship);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
returnId = (int)reader["Id"];
}
reader.Close();
}
conn.Close();
}
return(returnId);
}
public HttpResponseMessage UpdateById(InternUpdateRequest request, int id)
{
var retId = _userService.UpdateUser(request, id);
return(Request.CreateResponse(HttpStatusCode.OK, retId));
}
