protected void PopulateDDL() { try { string userID = User.Identity.GetUserId(); using (CallTraxEntities callTraxDb = new CallTraxEntities()) { ClientUser user = callTraxDb.ClientUsers.Where(u => u.AspNetUserId == userID).FirstOrDefault(); if (user != null) { List <ClientLocation> locations = callTraxDb.ClientLocations.Where(l => l.ClientId == user.ClientId).ToList(); foreach (ClientLocation location in user.Client.ClientLocations) { ddlLocation.Items.Add(new ListItem { Text = location.LocationName, Value = location.ClientLocationId.ToString() }); } List <Consultant> consultants = callTraxDb.Consultants.Where(c => c.ClientId == user.ClientId).ToList(); foreach (Consultant consultant in consultants) { ddlConsultant.Items.Add(new ListItem { Text = consultant.ConsultantName, Value = consultant.ConsultantId.ToString() }); } PopulateServicesDDL(ddlConsultant.SelectedValue); } } } catch (Exception) { throw; } }
protected void PopulateServicesDDL(string ConsultantId) { try { ddlService.Items.Clear(); using (CallTraxEntities callTraxDb = new CallTraxEntities()) { List <SessionTime> sessionList = callTraxDb.SessionTimes.Where(s => s.ConsultantId.ToString() == ddlConsultant.SelectedValue).ToList(); foreach (SessionTime session in sessionList) { ddlService.Items.Add(new ListItem(session.ServiceCategory.Name, session.ServiceCategory.ServiceCategoryId.ToString())); } } } catch (Exception) { throw; } }
public static DataTable GetData(string locationId, string consultantId, DateTime startDate, DateTime endDate) { DataTable dt; dt = new DataTable(); try { dt.Columns.Add("start", typeof(DateTime)); dt.Columns.Add("end", typeof(DateTime)); dt.Columns.Add("name", typeof(string)); dt.Columns.Add("id", typeof(string)); dt.Columns.Add("color", typeof(string)); using (CallTraxEntities callTraxDb = new CallTraxEntities()) { List <Appointment> appointments = callTraxDb.Appointments.Where(a => a.LocationId.ToString() == locationId && a.ConsultantId.ToString() == consultantId && a.StartDateTime >= startDate && a.EndDateTime <= endDate).ToList(); foreach (Appointment appointment in appointments) { DataRow dr; dr = dt.NewRow(); dr["id"] = appointment.AppointmentId.ToString(); dr["start"] = appointment.StartDateTime; dr["end"] = appointment.EndDateTime; dr["name"] = $"{appointment.CustomerFirstName} {appointment.CustomerLastName}"; ; dt.Rows.Add(dr); } } dt.PrimaryKey = new DataColumn[] { dt.Columns["id"] }; } catch (Exception) { //throw; //TODO:Log Error } return(dt); }
public static void MoveAppointment(long appointmentId, DateTime startDate, DateTime endDate) { try { using (CallTraxEntities callTraxDb = new CallTraxEntities()) { Appointment app = callTraxDb.Appointments.Where(a => a.AppointmentId == appointmentId).FirstOrDefault(); if (app != null) { app.StartDateTime = startDate; app.EndDateTime = endDate; callTraxDb.SaveChanges(); } } } catch (Exception) { throw; } }
protected void SetLocationBussinessHours() { try { Session["BusinessBeginsHour"] = 9; Session["BusinessEndsHour"] = 18; using (CallTraxEntities callTraxDb = new CallTraxEntities()) { ClientLocation loc = callTraxDb.ClientLocations.Where(l => l.ClientLocationId.ToString() == ddlLocation.SelectedValue).FirstOrDefault(); if (loc != null) { Session["BusinessBeginsHour"] = (int)loc.BusinessBeginsHour; Session["BusinessEndsHour"] = (int)loc.BusinessEndsHour; } } } catch (Exception) { throw; } }