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