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