public int Put(int id, AppointUpt model)
{
cmd.CommandText = "Appointment_Update";
cmd.Parameters.AddWithValue("@Id", model.Id);
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@CustFName", model.CustFName);
cmd.Parameters.AddWithValue("@CustLName", model.CustLName);
cmd.Parameters.AddWithValue("@Street", model.Street);
cmd.Parameters.AddWithValue("@City", model.City);
cmd.Parameters.AddWithValue("@State", model.State);
cmd.Parameters.AddWithValue("@Zip", model.Zip);
cmd.Parameters.AddWithValue("@Email", model.Email);
cmd.Parameters.AddWithValue("@Phone", model.Phone);
cmd.Parameters.AddWithValue("@Appoint", model.Appoint);
cmd.Parameters.AddWithValue("@ModifiedBy", model.ModifiedBy);
cmd.Parameters.AddWithValue("@IsCnfrmed", model.IsCnfrmed);
cmd.Parameters.AddWithValue("@ReminderSent", model.ReminderSent);
cmd.Parameters.AddWithValue("@CompName", model.CompName);
cmd.Parameters.AddWithValue("@CompEmail", model.CompEmail);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(0);
}
public async Task <IActionResult> Put(int id, [FromBody] AppointUpt model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != model.Id)
{
return(BadRequest());
}
try
{
var user = await GetCurrentUser();
model.UserId = user.Id;
model.ModifiedBy = user.UserName;
_svc.Put(id, model);
}
catch (System.Exception ex)
{
return(StatusCode(420, ex));
}
return(Ok());
}
public IActionResult CustomerEdit([FromRoute] int id, CustomerEditModel model)
{
try
{
if (ModelState.IsValid)
{
//build model
AppointUpt uptmodel = new AppointUpt();
uptmodel.Id = model.Id;
uptmodel.UserId = model.UserId;
uptmodel.CustFName = model.CustFName;
uptmodel.CustLName = model.CustLName;
uptmodel.Street = model.Street;
uptmodel.City = model.City;
uptmodel.State = model.State.ToUpper();
uptmodel.Zip = model.Zip;
uptmodel.Email = model.Email;
uptmodel.Phone = model.Phone;
DateTime newDate = DateTime.Parse(model.AppointDate + "T" + model.AppointTime);
uptmodel.Appoint = newDate;
uptmodel.ModifiedBy = model.CustFName + " " + model.CustLName;
uptmodel.IsCnfrmed = model.IsCnfrmed;
uptmodel.ReminderSent = model.ReminderSent;
uptmodel.CompName = model.CompName;
uptmodel.CompEmail = model.CompEmail;
_svc.Put(id, uptmodel);
return(RedirectToAction("DoneEdit", "Account"));
}
else
{
return(BadRequest(ModelState));
}
}
catch (Exception ex)
{
return(StatusCode(420, ex));
}
}
