public static int PostReminder(ReminderPostRequest request) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Reminder_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Description", request.ReminderDescription); paramCollection.AddWithValue("@ReminderDateTime", request.ReminderDateTime); paramCollection.AddWithValue("@ReminderDateTimeString", request.ReminderDateTimeString); paramCollection.AddWithValue("@ReminderType", request.ReminderType); paramCollection.AddWithValue("@CreatedBy", request.CreatedBy); paramCollection.AddWithValue("@ModifiedBy", request.CreatedBy); SqlParameter p = new SqlParameter("@ID", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection paramCollection) { int.TryParse(paramCollection["@ID"].Value.ToString(), out id); }); return(id); }
public HttpResponseMessage PostReminder(ReminderPostRequest request) { if (!ModelState.IsValid) { ErrorLogService svc = new ErrorLogService(); ErrorLogAddRequest error = new ErrorLogAddRequest(); error.ErrorFunction = "Aic.Web.Controllers.Api.PostReminder"; error.ErrorMessage = ModelState.ToString(); error.UserId = UserService.UserSelect().PersonId; svc.ErrorLogInsert(error); return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); request.CreatedBy = HttpContext.Current.User.Identity.GetUserId(); response.Item = RecruiterService.PostReminder(request); return(Request.CreateResponse(response)); }
public HttpResponseMessage PostRecruiter(RecruiterPostRequest request) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } try { SuccessResponse response = new SuccessResponse(); RecruiterService.PostRecruiter(request); RecruiterService.UpgradeToRecruiter(); ReminderPostRequest reminder = new ReminderPostRequest(); reminder.CreatedBy = HttpContext.Current.User.Identity.GetUserId(); reminder.ReminderDateTime = DateTime.UtcNow; reminder.ReminderDateTimeString = reminder.ReminderDateTime.ToString(); reminder.ReminderDescription = "Thank you for signing up as a Recruiter, your account is now capable of posting Jobs along with managing Jobs in your Recruiter Dashboard"; reminder.ReminderType = 2; RecruiterService.PostReminder(reminder); UserService.Logout(); return(Request.CreateResponse(response)); } catch (Exception ex) { ErrorLogService svc = new ErrorLogService(); ErrorLogAddRequest payload = new ErrorLogAddRequest(); payload.ErrorFunction = "Aic.Web.Controllers.Api.PostRecruiter"; payload.ErrorMessage = ex.Message; payload.UserId = UserService.UserSelect().PersonId; svc.ErrorLogInsert(payload); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }