public void Update(AppointmentUpdateRequest model, int userId) { string procName = "[dbo].[Appointments_Update_V2]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { ColAddParams(model, col, userId); col.AddWithValue("@Id", model.Id); }, returnParameters: null); }
public HttpResponseMessage Put(int Id, AppointmentUpdateRequest model) { if (!ModelState.IsValid || Id != model.Id) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } else { _svc.Put(model); SuccessResponse response = new SuccessResponse(); return(Request.CreateResponse(HttpStatusCode.OK, response)); } }
public void PutType(AppointmentUpdateRequest model) { _prov.ExecuteNonQuery("Appointment_Update" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", model.Id); paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@PersonId", model.PersonId); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@ProgramId", model.ProgramId); paramCollection.AddWithValue("@AppointmentTypeId", model.AppointmentTypeId); paramCollection.AddWithValue("@CriteriaStartDate", model.CriteriaStartDate); paramCollection.AddWithValue("@CriteriaEndDate", model.CriteriaEndDate); }); }
public ActionResult <SuccessResponse> Update(AppointmentUpdateRequest model) { int code = 200; BaseResponse response = null; try { int userId = _authService.GetCurrentUserId(); _service.Update(model, userId); Appointment appointmentWithEmail = _service.GetAppointmentForEmail(model.Id); _emailService.ConfirmAppointmentEmail(appointmentWithEmail); response = new SuccessResponse(); } catch (Exception ex) { code = 500; response = new ErrorResponse(ex.Message); } return(StatusCode(code, response)); }
public void Put(AppointmentUpdateRequest model) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ViaDB"].ConnectionString)) { con.Open(); var cmd = con.CreateCommand(); cmd.CommandText = "dbo.Appointments_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", model.Id); cmd.Parameters.AddWithValue("@Name", model.Name); cmd.Parameters.AddWithValue("@Phone", model.Phone); cmd.Parameters.AddWithValue("@Email", model.Email); cmd.Parameters.AddWithValue("@Address", model.Address); cmd.Parameters.AddWithValue("@Date", model.Date); cmd.Parameters.AddWithValue("@Notes", model.Notes); cmd.Parameters.AddWithValue("@Device", model.Device); cmd.Parameters.AddWithValue("@Repair", model.Repair); cmd.Parameters.AddWithValue("@Total", model.Total); cmd.ExecuteNonQuery(); } }
public AppointmentUpdateResponse UpdateAppointment(AppointmentUpdateRequest query) { return(SubmitRequest <AppointmentUpdateResponse>(query)); }