public int Insert(UserEducationAddRequest model) { int returnValue = 0; DataProvider.ExecuteNonQuery("dbo.UserEducation_Insert", inputParamMapper: (SqlParameterCollection inputs) => { inputs.Add(SqlDbParameter.Instance.BuildParameter("@UserBaseId", model.UserBaseId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@CurrentSemester", model.CurrentSemester, SqlDbType.NVarChar, 100)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@SchoolId", model.SchoolId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@GPA", model.GPA, SqlDbType.Decimal)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@ReportCardFileUrl", model.ReportCardFileUrl, SqlDbType.NVarChar, 2000)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@CompletedUnits", model.CompletedUnits, SqlDbType.Decimal)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@EnrollmentDate", model.EnrollmentDate, SqlDbType.DateTime)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@ExpGradDate", model.ExpGradDate, SqlDbType.DateTime)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@Major", model.Major, SqlDbType.NVarChar, 100)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@Plan", model.Plan, SqlDbType.NVarChar, 100)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@SchoolIdNum", model.SchoolIdNum, SqlDbType.NVarChar, 50)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@SchoolIdPhotoFileUrl", model.SchoolIdPhotoFileUrl, SqlDbType.NVarChar, 2000)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@CreatedById", model.CreatedById, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@ModifiedById", model.ModifiedById, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@UnitReportCardUrl", model.UnitReportCardUrl, SqlDbType.NVarChar, 200)); SqlParameter idOut = new SqlParameter("@Id", 0); idOut.Direction = ParameterDirection.Output; inputs.Add(idOut); }, returnParameters: (SqlParameterCollection inputs) => { int.TryParse(inputs["@Id"].Value.ToString(), out returnValue); } ); return(returnValue); }
public IHttpActionResult Post(UserEducationAddRequest model) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ItemResponse <int> response = new ItemResponse <int> { Item = _userEduService.Insert(model) }; return(Ok(response)); } catch (Exception ex) { int currentUser = _currentId; _appLogService.Insert(new AppLogAddRequest { AppLogTypeId = 1, Message = ex.Message, StackTrace = ex.StackTrace, Title = "Error in " + GetType().Name + " " + System.Reflection.MethodBase.GetCurrentMethod().Name, UserBaseId = currentUser }); return(BadRequest(ex.Message)); } }
public JsonResult AddEducation(UserEducationAddRequest input) { _user = GetUser(HttpContext); var education = new UserEducation() { Grade = input.Grade, Major = input.Major, Place = input.Place, InProgress = input.InProgress, Status = 0, }; _educationService.Add(education, _user.Id); return(new JsonResult(GetEducations().Value)); }