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