private AppointDom Mapper(SqlDataReader reader)
{
AppointDom model = new AppointDom();
int index = 0;
model.Id = reader.GetInt32(index++);
model.UserId = reader.GetString(index++);
model.CustFName = reader.GetString(index++);
model.CustLName = reader.GetString(index++);
model.Street = reader.GetString(index++);
model.City = reader.GetString(index++);
model.State = reader.GetString(index++);
model.Zip = reader.GetInt32(index++);
model.Email = reader.GetString(index++);
model.Phone = reader.GetString(index++);
model.Appoint = reader.GetDateTime(index++);
model.CreatedDate = reader.GetDateTime(index++);
model.ModifiedDate = reader.GetDateTime(index++);
model.ModifiedBy = reader.GetString(index++);
model.IsCnfrmed = reader.GetBoolean(index++);
model.ReminderSent = reader.GetBoolean(index++);
model.CompName = reader.GetString(index++);
model.CompEmail = reader.GetString(index++);
return(model);
}
public void UpdateReminder(AppointDom model)
{
cmd.CommandText = "Appointment_UpdateReminderSent";
cmd.Parameters.AddWithValue("@Id", model.Id);
cmd.Parameters.AddWithValue("@ReminderSent", model.ReminderSent = true);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public AppointDom GetById(int id)
{
AppointDom model = null;
cmd.CommandText = "Appointment_Selectbyid";
cmd.Parameters.AddWithValue("@Id", id);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model = Mapper(reader);
}
conn.Close();
return(model);
}
public IActionResult CustomerEdit([FromRoute] int id)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
AppointDom uptmodel = new AppointDom();
uptmodel = _svc.GetById(id);
if (uptmodel == null)
{
return(NotFound());
}
//seperate date
string res1 = uptmodel.Appoint.ToString("yyyy-MM-dd");
string res2 = uptmodel.Appoint.ToString("HH:mm");
//build model
CustomerEditModel model = new CustomerEditModel();
model.Id = uptmodel.Id;
model.UserId = uptmodel.UserId;
model.CustFName = uptmodel.CustFName;
model.CustLName = uptmodel.CustLName;
model.Street = uptmodel.Street;
model.City = uptmodel.City;
model.State = uptmodel.State;
model.Zip = uptmodel.Zip;
model.Email = uptmodel.Email;
model.Phone = uptmodel.Phone;
model.AppointDate = res1;
model.AppointTime = res2;
model.ModifiedBy = uptmodel.ModifiedBy;
model.IsCnfrmed = uptmodel.IsCnfrmed;
model.ReminderSent = uptmodel.ReminderSent;
model.CompName = uptmodel.CompName;
model.CompEmail = uptmodel.CompEmail;
return(View(model));
}
catch (Exception ex)
{
return(StatusCode(457, ex));
}
}
public List <AppointDom> GetPast(string id)
{
cmd.CommandText = "Appointment_SelectbyuseridPast";
List <AppointDom> result = new List <AppointDom>();
cmd.Parameters.AddWithValue("@UserId", id);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AppointDom model = Mapper(reader);
result.Add(model);
}
conn.Close();
return(result);
}
public AppointView GetSoonestAppoints(AppointPaging model)
{
AppointView returnModel = new AppointView();
returnModel.appointList = new List <AppointDom>();
cmd.CommandText = "Appointment_Selectbyuserid";
cmd.Parameters.AddWithValue("@PageSize", model.PageSize);
cmd.Parameters.AddWithValue("@PageNum", model.PageNum);
cmd.Parameters.AddWithValue("@SortDir", model.SortDir);
cmd.Parameters.AddWithValue("@SortCol", model.SortCol);
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@CustFNameFilter", model.CustFNameFilter);
cmd.Parameters.AddWithValue("@CustLNameFilter", model.CustLNameFilter);
cmd.Parameters.AddWithValue("@AppointFilter", model.AppointFilter);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
short set = new short();
while (reader.Read())
{
switch (set)
{
case 0:
AppointDom viewModel = Mapper(reader);
returnModel.appointList.Add(viewModel);
break;
case 1:
returnModel.appointTotal = reader.GetInt32(0);
break;
}
}
conn.Close();
return(returnModel);
}
