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