public ActionResult ShowAppointmentDetail(int FunctionaryId, int IdAppointment) { AppointmentModels appointmentModels = new AppointmentModels(); appointmentModels.Functionary.Cedula = FunctionaryId; appointmentModels.Id = IdAppointment; Debug.WriteLine("ID FUNCTIONARY" + FunctionaryId); Debug.WriteLine("IDAPPOINTMENT" + IdAppointment); AppointmentBusiness appointment = new AppointmentBusiness(); ViewBag.appointment = appointment.getAppointmentDetail(appointmentModels); foreach (AppointmentModels assistance in ViewBag.appointment) { Debug.WriteLine(assistance.Id); Debug.WriteLine(assistance.Functionary.Cedula); Debug.WriteLine(assistance.Functionary.Name); Debug.WriteLine(assistance.Functionary.FirstLastName); Debug.WriteLine(assistance.Functionary.SecondLastName); Debug.WriteLine(assistance.Functionary.Gender); Debug.WriteLine(assistance.Functionary.NamePlace); Debug.WriteLine(assistance.Functionary.NameArea); Debug.WriteLine(assistance.Functionary.NameOffice); Debug.WriteLine(assistance.Functionary.PersonalPhone); Debug.WriteLine(assistance.Functionary.Mail); Debug.WriteLine(assistance.Date); Debug.WriteLine(assistance.Hour); Debug.WriteLine(assistance.Professional.Name); } return(View("AppointmentDetail")); }
public string GetProfesionalScheldule(int professionalId) { AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); List <AppointmentModels> appointmentList = appointmentBusiness.getProfessinalScheldule(professionalId); return(JsonConvert.SerializeObject(appointmentList)); }
public ActionResult DeleteAppointment(AppointmentModels appointment) { AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); appointmentBusiness.DeleteAppointment(appointment); return(Json("Exitoso")); }
public ActionResult ShowAppointmentDetailPost() { string FunctionaryId = Request.Params["cedula"]; string IdAppointment = Request.Params["id"]; AppointmentModels appointmentModels = new AppointmentModels(); appointmentModels.Functionary.Cedula = Int32.Parse(FunctionaryId); appointmentModels.Id = Int32.Parse(IdAppointment); AppointmentBusiness appointment = new AppointmentBusiness(); ViewBag.appointment = appointment.getAppointmentDetail(appointmentModels); foreach (AppointmentModels assistance in ViewBag.appointment) { Debug.WriteLine(assistance.Id); Debug.WriteLine(assistance.Functionary.Cedula); Debug.WriteLine(assistance.Functionary.Name); Debug.WriteLine(assistance.Functionary.FirstLastName); Debug.WriteLine(assistance.Functionary.SecondLastName); Debug.WriteLine(assistance.Functionary.Gender); Debug.WriteLine(assistance.Functionary.NamePlace); Debug.WriteLine(assistance.Functionary.NameArea); Debug.WriteLine(assistance.Functionary.NameOffice); Debug.WriteLine(assistance.Functionary.PersonalPhone); Debug.WriteLine(assistance.Functionary.Mail); Debug.WriteLine(assistance.Date); Debug.WriteLine(assistance.Hour); Debug.WriteLine(assistance.Professional.Name); } return(View("AppointmentDetail")); }
protected void btnActualizar_Click(object sender, EventArgs e) { string date = clDate.SelectedDate.ToShortDateString(); string[] dateArray = date.Split(' '); string[] formatDate = dateArray[0].Split('/'); finalDate = formatDate[2] + "-" + formatDate[0] + "-" + formatDate[1]; //Se valida la fecha validateMessage = validateDate(finalDate, Convert.ToInt32(txtHour.Text)); if (validateMessage == "Disponible") { this.appointmentBusiness = new AppointmentBusiness(this.conn); this.appo = new Appointment(Convert.ToInt32(txtHour.Text), finalDate); this.user = new Userr(txtIdentityCard.Text); //Se guarda un mensaje basado en la operación que se realizo operationMessage = this.appointmentBusiness.updateAppointmentBusiness(this.appo, this.user, txtOldDate.Text, txtOldHour.Text); txtMensaje.Text = operationMessage; } else { txtMensaje.Text = validateMessage; } }
private string validateDate(string date, int hour) { string message = ""; this.appointmentBusiness = new AppointmentBusiness(this.conn); message = appointmentBusiness.validateDateBusiness(date, hour); return(message); }
protected void btnAgendar_Click(object sender, EventArgs e) { string date = clFechaCita.SelectedDate.ToShortDateString(); string[] dateArray = date.Split(' '); string[] formatDate = dateArray[0].Split('/'); finalDate = formatDate[2] + "-" + formatDate[0] + "-" + formatDate[1]; //Se valida la fecha validateMessage = validateDate(finalDate, Convert.ToInt32(txtHour.Text)); if (validateMessage == "Disponible") { this.appointmentBusiness = new AppointmentBusiness(this.conn); this.appo = new Appointment(Convert.ToInt32(txtHour.Text), finalDate); //this.user = new Userr(txtNumCedula.Text); //RSG this.userBusiness = new UserBusiness(this.conn); this.user = this.userBusiness.getUserData(Session["identityCard"].ToString()); if (this.user.errorMessage != null && this.user.errorMessage != "") { //txtMensaje.Text = this.user.errorMessage; return; } if (this.user.name == null || this.user.name == "") { txtMensaje.Text = "El cliente no existe en la base de datos."; return; } //Se guarda un mensaje basado en la operación que se realizo operationMessage = this.appointmentBusiness.insertAppointmentBusiness(this.appo, this.user); //Se valida que la operación sea exitosa if (operationMessage != "Error al ejecutar la operación en la base de datos") { txtId.Text = operationMessage; txtMensaje.Text = "La operación se realizó satisfactoriamente"; } else { txtMensaje.Text = operationMessage; } } else { txtMensaje.Text = validateMessage; } }
public ActionResult SearchAppointmentFunctionary(int _FunctionaryId, int _IdAppointment) { AppointmentModels appointment = new AppointmentModels(); appointment.Id = _IdAppointment; appointment.Functionary.Cedula = _FunctionaryId; AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); ViewBag.appointments = appointmentBusiness.SearchAppointmentsForFunctionary(appointment); return(View("ConsultAppointmentFunctionary")); }
public ActionResult SaveAppointment(AppointmentModels _appointment) { UserBusiness functionaryBusiness = new UserBusiness(); functionaryBusiness.RegisterFunctionary((UserModels)Session["functionary"]); CreateMail(_appointment); AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); appointmentBusiness.RegisterAppointment(_appointment); Session["appointment"] = _appointment; return(Json("ok")); }
public ActionResult UpdateAppointment(AppointmentModels _appointment) { UserBusiness functionaryBusiness = new UserBusiness(); functionaryBusiness.RegisterFunctionary((UserModels)Session["functionary"]); CreateMail(_appointment); AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); string idAppointment = (string)Session["idAppointment"]; appointmentBusiness.UpdateAppointment(_appointment, Int32.Parse(idAppointment)); Session["appointment"] = _appointment; return(Json("ok")); }
public void GetAppointmentForExistingAppointmentId(int searchedAppointmentId) { // Arrange var appointmentDataAccessMock = new Mock <IAppointmentDataAccess>(); appointmentDataAccessMock.Setup(x => x.GetAppointment(searchedAppointmentId)).Returns(new Appointment { AppointmentId = searchedAppointmentId }); var appointmentBusiness = new AppointmentBusiness(appointmentDataAccessMock.Object); // Act var databaseAppointment = appointmentBusiness.GetAppointment(searchedAppointmentId); // Assert Assert.NotNull(databaseAppointment); }
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))); }
protected void btnCancelar_Click(object sender, EventArgs e) { this.appointmentBusiness = new AppointmentBusiness(this.conn); this.appo = new SalutemDomain.Appointment(Convert.ToInt32(txtId.Text), Convert.ToInt32(txtHour.Text), finalDate); //Se guarda un mensaje basado en la operación que se realizo operationMessage = this.appointmentBusiness.cancelAppointmentBusiness(this.appo); //Se valida que la operación sea exitosa if (operationMessage != "Error al ejecutar la operación en la base de datos") { txtMensaje.Text = "La operación se realizo satisfactoriamente"; } else { txtMensaje.Text = operationMessage; } }
public ActionResult ConsultDateAdministrator() { CatalogueModels catalogueProcess = new CatalogueModels(); catalogueProcess.Table = "proceso"; CatalogueBusiness catalogueBusiness = new CatalogueBusiness(); ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess); ViewBag.offices = catalogueBusiness.GetCatalogueFunctionary("oficina"); UserBusiness userBusiness = new UserBusiness(); ViewBag.professional = userBusiness.GetListProfessionals(); AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); ViewBag.appointments = appointmentBusiness.GetAppointmentsByFilter(); catalogueProcess.Table = "asistencia"; ViewBag.assistance = catalogueBusiness.GetListCatalogue(catalogueProcess); return(View("ConsultDateAdministrator")); }
protected void btnCancelar_Click(object sender, EventArgs e) { string date = clDate.SelectedDate.ToShortDateString(); string[] dateArray = date.Split(' '); string[] formatDate = dateArray[0].Split('/'); finalDate = formatDate[2] + "-" + formatDate[0] + "-" + formatDate[1]; this.appointmentBusiness = new AppointmentBusiness(this.conn); this.appo = new Appointment(Convert.ToInt32(txtHour.Text), finalDate); this.user = new Userr(txtIdentityCard.Text); //Se guarda un mensaje basado en la operación que se realizo operationMessage = this.appointmentBusiness.cancelAppointmentWithoutAppointmentIdBusiness(this.appo, this.user); txtMensaje.Text = operationMessage; }
public void getAppointmentsBusinessFilters(string identityCard, string status) { this.appointmentBusiness = new AppointmentBusiness(conn); List <Appointment> appointmentList = this.appointmentBusiness.getAppointmentsBusinessFilters(identityCard, status); // En la variable se mete los datos necesarios para que se genere el archivo json. var resultado = new { iTotalRecords = appointmentList.Count, iTotalDisplayRecords = appointmentList.Count, aaData = appointmentList }; //Se utiliza JavaScritp Serializer para poder crear el archivo json con los valores de la lista //El tamaño se setea al máximo ya que esto es para consultas que devuelvan miles de tuplas. JavaScriptSerializer js = new JavaScriptSerializer(); js.MaxJsonLength = Int32.MaxValue; Context.Response.Write(js.Serialize(resultado)); }
public ActionResult ProfessionalLogin() { CatalogueModels catalogueProcess = new CatalogueModels(); catalogueProcess.Table = "proceso"; CatalogueBusiness catalogueBusiness = new CatalogueBusiness(); ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess); catalogueProcess.Table = "oficina"; ViewBag.office = catalogueBusiness.GetListCatalogue(catalogueProcess); catalogueProcess.Table = "asistencia"; ViewBag.assistance = catalogueBusiness.GetListCatalogue(catalogueProcess); AppointmentBusiness appointmentBusiness = new AppointmentBusiness(); int idprofesional = Int32.Parse((string)Session["Identification"]); List <AppointmentModels> appointmentList = appointmentBusiness.getProfessinalScheldule(idprofesional); ViewBag.appointmentList = appointmentList; return(View("DashboardProfessional")); }
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)); }
protected void btnCancelar_Click(object sender, EventArgs e) { finalDate = txtActualDate.Text; this.appointmentBusiness = new AppointmentBusiness(this.conn); this.appo = new Appointment(Convert.ToInt32(txtActualHour.Text), finalDate); this.user = new Userr(txtIdentityCard.Text); //Se guarda un mensaje basado en la operación que se realizo operationMessage = this.appointmentBusiness.cancelAppointmentWithoutAppointmentIdBusiness(this.appo, this.user); //Se valida que la operación sea exitosa if (operationMessage != "Error al ejecutar la operación en la base de datos") { txtMensaje.Text = "La operación se realizo satisfactoriamente"; } else { txtMensaje.Text = operationMessage; } }