public int Insert(ApplicationAddRequest model)
{
int ApplicantKey = 0;
int CredentialKey = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Applicant_Insert", inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@FirstName", model.FirstName);
paramCollection.AddWithValue("@LastName", model.LastName);
paramCollection.AddWithValue("@Phone", model.Phone);
paramCollection.AddWithValue("@Email", model.Email);
paramCollection.AddWithValue("@CredentialKey", CredentialKey);
paramCollection.AddWithValue("@UserName", model.UserName);
paramCollection.AddWithValue("@Password", model.Password);
paramCollection.AddWithValue("@IsAdmin", model.IsAdmin);
SqlParameter p = new SqlParameter("@ApplicantKey", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@ApplicantKey"].Value.ToString(), out ApplicantKey);
}
);
int InsertExperience = _interestService.Insert(model, ApplicantKey);
int InsertInterest = _interestService.Insert(model, ApplicantKey);
return(ApplicantKey);
}
public HttpResponseMessage CreateApplication(ApplicationAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
int id = _applicationService.Insert(model);
ItemResponse <int> response = new ItemResponse <int>();
response.Item = id;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public int Insert(ApplicationAddRequest model, int ApplicantKey)
{
for (int i = 0; i < model.Experience.Length; i++)
{
int ExperienceKey = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Experience_Insert", inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ExperienceKey", ExperienceKey);
paramCollection.AddWithValue("@ApplicantKey", ApplicantKey);
paramCollection.AddWithValue("@CategoryKey", model.Experience[i].CategoryKey);
paramCollection.AddWithValue("@ExperienceLevel", model.Experience[i].ExperienceLevel);
});
}
return(ApplicantKey);
}
