public static Person Add(ProjectPersonRequest model)
{
Person p = null;
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.PersonProject_Insert";
cmd.Parameters.AddWithValue("@ProjectId", model.ProjectId);
cmd.Parameters.AddWithValue("@Email", model.Email);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
p = new Person();
int ord = 0;
p.Id = reader.GetSafeInt32(ord++);
p.Name = reader.GetSafeString(ord++);
p.Email = reader.GetSafeString(ord++);
}
}
conn.Close();
}
return(p);
}
public HttpResponseMessage Add(ProjectPersonRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <Person> response = new ItemResponse <Person>();
try
{
response.Item = ProjectPersonService.Add(model);
}
catch (Exception ex)
{
if (ex.GetType() == typeof(SqlException))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
