public String ConsultDateAdministrator(String initialDate, String finalDate, int process, int assistance, int office, int identification, char gender, String dateStatus, int consecutive, int age, int professional) { UserModels user = new UserModels(); user.Cedula = identification; user.Gender = gender; user.OfficeID = office; user.Assistance = assistance; AppointmentModels appointment = new AppointmentModels(); appointment.Functionary = user; appointment.Id = consecutive; AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); //appointmentBusiness.SearchAppointmentByFiltersAdministrator(appointment, initialDate, finalDate, process, dateStatus, age, age); return(JsonConvert.SerializeObject(appointmentBusiness.SearchAppointmentByFiltersAdministrator(appointment, initialDate, finalDate, process, dateStatus, age, professional))); }
public string SearchAppointmentProfessional(string initialDate, string finalDate, int process, int assistance, int office, int identification, char gender, string dateStatus, int consecutive, int age) { AppointmentModels appointment = new AppointmentModels(); appointment.Id = consecutive; appointment.Functionary.Cedula = identification; appointment.Functionary.Gender = gender; appointment.Functionary.OfficeID = office; appointment.Functionary.Assistance = assistance; appointment.Professional.ProfessionalId = Int32.Parse((string)Session["Identification"]); appointment.SubProcess.ID = process; appointment.State = dateStatus; AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); List <AppointmentModels> appointmentList = appointmentBusiness.SearchAppointmentsForProfesional(appointment, initialDate, finalDate, age); return(JsonConvert.SerializeObject(appointmentList)); }
internal async Task UpdateAppointmentsAsync() { List <Appointment> appointments = null; using (_controller = new AppointmentController()) await Task.Run(() => appointments = (List <Appointment>) _controller.GetAppointments()); if (appointments != null) { lock (_appointments) lock (AppointmentModels) { _appointments.Clear(); AppointmentModels.Clear(); foreach (var appointment in appointments) { _appointments.Add(appointment); AppointmentModels.Add(new AppointmentModel(appointment)); } } } }
//GET LIST APPOINTMENT BY FILTERS ADMI public List <AppointmentModels> SearchAppointmentByFiltersAdministrator(AppointmentModels _appointment, String initialDate, String finalDate, int process, String appointmentStatus, int age, int professional) { string sqlQuery = $"exec sp_buscar_cita_para_funcionario_admi " + _appointment.Functionary.Cedula + "," + _appointment.Id + ",'" + initialDate + "','" + finalDate + "'," + process + "," + _appointment.Functionary.OfficeID + ", " + professional + ", '" + appointmentStatus + "'," + _appointment.Functionary.Assistance + ", '" + _appointment.Functionary.Gender + "', " + age + " ;"; List <AppointmentModels> appointments = new List <AppointmentModels>(); using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { command.CommandType = CommandType.Text; command.CommandText = sqlQuery; connection.Open(); SqlDataReader responseReader = command.ExecuteReader(); while (responseReader.Read()) { AppointmentModels appointment = new AppointmentModels(); appointment.Id = Int32.Parse(responseReader["pk_id_cita"].ToString()); appointment.Functionary.Cedula = Int32.Parse(responseReader["pk_cedula_usuario"].ToString()); appointment.Functionary.Name = responseReader["tc_nombre"].ToString(); appointment.Functionary.FirstLastName = responseReader["tc_primer_apellido"].ToString(); appointment.Functionary.SecondLastName = responseReader["tc_segundo_apellido"].ToString(); appointment.Date = responseReader["tf_fecha"].ToString(); appointment.Hour = responseReader["tc_hora"].ToString(); appointment.Professional.Cedula = Int32.Parse(responseReader["fk_id_profesional"].ToString()); appointment.SubProcess.Name = responseReader["tc_nombre_proceso"].ToString(); appointment.SubActivity.Name = responseReader["tc_nombre_actividad"].ToString(); appointments.Add(appointment); } connection.Close(); } return(appointments); }
public IcsClient(string url) { using (MemoryStream stream = new MemoryStream(Resource1.HugoCalender)) { calendar = Ical.Net.Calendar.Load(stream); } foreach (var calEvent in calendar.Events) { if ((calEvent.Start.Year == DateTime.Now.Year && calEvent.RecurrenceRules.Count > 0) || calEvent.Start.Year == DateTime.Now.Year) { IList <Ical.Net.DataTypes.Attendee> attendees = calEvent.Attendees; DateTime dateStart = new DateTime(calEvent.Start.Ticks); DateTime dateEnd; if (calEvent.End != null) { dateEnd = new DateTime(calEvent.End.Ticks); } else { dateEnd = new DateTime(calEvent.Start.Ticks); } ScheduleAppointment appointment; foreach (var a in attendees) { Attendee attender = new Attendee(); attender.Name = a.Value.UserInfo; attender.Email = a.CommonName; attending.Add(attender); } if (calEvent.RecurrenceRules != null && calEvent.RecurrenceRules.Count != 0) { var RecRule = new List <RecurrencePattern>(calEvent.RecurrenceRules.AsEnumerable()); var pattern = RecRule.FirstOrDefault(); string stringPattern = pattern?.ToString(); var ex = pattern?.Frequency; RecurrenceProperties recurrenceProperties = new RecurrenceProperties(); recurrenceProperties.RecurrenceType = (RecurrenceType)calEvent.RecurrenceRules[0].Frequency; int[] dayInts = new int[pattern.ByDay.Count]; for (int i = 0; i < pattern.ByDay.Count; i++) { recurrenceProperties.WeekDays = (WeekDays)pattern.ByDay[i].DayOfWeek; } appointment = new ScheduleAppointment() { StartTime = dateStart, EndTime = dateEnd, Subject = calEvent.Summary, IsRecursive = true, RecurrenceRule = stringPattern, Location = calEvent.Location }; AppointmentModels.Add(new AppointmentModel(new ScheduleAppointment() { StartTime = dateStart, EndTime = dateEnd, Subject = calEvent.Summary, IsRecursive = true, RecurrenceRule = stringPattern, Location = calEvent.Location }, attending, stringPattern)); } else { appointment = new ScheduleAppointment() { StartTime = dateStart, EndTime = dateEnd, Subject = calEvent.Summary, IsRecursive = true, Location = calEvent.Location }; AppointmentModels.Add(new AppointmentModel(new ScheduleAppointment() { StartTime = dateStart, EndTime = dateEnd, Subject = calEvent.Summary, IsRecursive = true, Location = calEvent.Location }, attending, null)); } ScheduleAppointments.Add(appointment); } } }
public void CreateMail(AppointmentModels appointment) { CatalogueController catalogue = new CatalogueController(); int process = catalogue.GetProcessBySubprocess(appointment.SubProcess.ID); UserBusiness userBusiness = new UserBusiness(); int cedula = appointment.Professional.Cedula; List <UserModels> professionals = userBusiness.GetProfessionalByIdentification(cedula); String nameProfessional = ""; foreach (UserModels professional in professionals) { nameProfessional = professional.Name + " " + professional.FirstLastName + " " + professional.SecondLastName; } string email = (string)Session["email"]; MailModels mail; String message = "Su cita ha sido programada con éxito. \n " + "\n\tRESUMEN DE CITA:\n" + "Fecha: " + appointment.Date + "\n" + "Hora: " + appointment.Hour + "\n" + "Paciente: " + appointment.Functionary.Cedula + "\n" + "Psicólogo: " + nameProfessional + "\n\n Para cualquier consulta comuniquese al teléfono 2295-4181," + " al correo [email protected] o a nuestro sitio web de citas para cancelar o modificar su cita"; switch (process) { case 1: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA DE PROCESO CLINICO EN SAPSO \n" + message, "CONFIRMACION CITA CLÍNICO", 0); break; case 2: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA DE PROCESO INCIDENTE CRÍTICO EN SAPSO\n" + message + "IMPORTANTE Complete el formulario adjunto y preséntelo el día de su cita", "CONFIRMACION CITA INCIDENTES CRITICOS", 2); break; case 3: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA DE PROCESO ARMAS EN SAPSO \n" + message, "CONFIRMACION DE CITA", 0); break; case 4: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA DE PROCESO CHARLAS EN SAPSO \n" + message, "CONFIRMACION DE CITA", 0); break; case 5: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA DE PROCESO CAPITULO \"V\" EN SAPSO \n" + message + "IMPORTANTE: Complete el formulario adjunto y preséntelo el día de su cita", "CONFIRMACION CITA CAPITULO V", 1); break; default: mail = new MailModels("*****@*****.**", email, "ESTE CORREO ES PARA CONFIRMAR SU CITA EN SAPSO \n" + message, "CONFIRMACION DE CITA", 0); break; } mail.SendMail(); }
public void DeleteAppointment(AppointmentModels appointment) { AppointmentData appointmentData = new AppointmentData(); appointmentData.DeleteAppointment(appointment); }
public List <AppointmentModels> getAppointmentDetail(AppointmentModels _appointment) { AppointmentData appointmentData = new AppointmentData(); return(appointmentData.getAppointmentDetail(_appointment)); }
public List <AppointmentModels> SearchAppointmentsForProfesional(AppointmentModels _appointment, string initialDate, string finalDate, int age) { AppointmentData appointmentData = new AppointmentData(); return(appointmentData.SearchAppointmentsForProfesional(_appointment, initialDate, finalDate, age)); }
public List <AppointmentModels> SearchAppointmentsForFunctionary(AppointmentModels _appointment) { AppointmentData appointmentData = new AppointmentData(); return(appointmentData.SearchAppointmentsForFunctionary(_appointment)); }
public void UpdateAppointment(AppointmentModels _appointment, int idAppointment) { AppointmentData appointmentData = new AppointmentData(); appointmentData.UpdateAppointment(_appointment, idAppointment); }
public void RegisterAppointment(AppointmentModels _appointment) { AppointmentData appointmentData = new AppointmentData(); appointmentData.SaveAppointment(_appointment); }