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