public int Create(InternCreateRequest request)
{
int id = 0;
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Interns_Insert";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
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);
cmd.Parameters.AddWithValue("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
id = (int)reader["Id"];
}
reader.Close();
}
conn.Close();
}
return(id);
}
public HttpResponseMessage Create(InternCreateRequest request)
{
if (request == null)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, "please enter valid input"));
}
int id = _userService.Create(request);
return(req.CreateResponse(HttpStatusCode.OK, id));
}
