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