/*
* Get a list of a specific table that is part of the catalog
*/
public List <CatalogueModels> GetListCatalogue(CatalogueModels _catalogue)
{
List <CatalogueModels> catalogueItems = new List <CatalogueModels>();
string sqlQuery = $"exec sp_obtener_" + _catalogue.Table;
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader catalogueReader = command.ExecuteReader();
while (catalogueReader.Read())
{
CatalogueModels catalogueTemp = new CatalogueModels();
catalogueTemp.ID = Int32.Parse(catalogueReader["pk_id_" + _catalogue.Table].ToString());
catalogueTemp.Name = catalogueReader["tc_nombre_" + _catalogue.Table].ToString();
if (_catalogue.Table.Equals("subactividad"))
{
catalogueTemp.FatherID = Int32.Parse(catalogueReader[2].ToString());
}
if (_catalogue.Table.Equals("subproceso"))
{
catalogueTemp.FatherID = Int32.Parse(catalogueReader[2].ToString());
}
catalogueItems.Add(catalogueTemp);
}
connection.Close();
}
return(catalogueItems);
}
public List <CatalogueModels> GetCatalogueFunctionary(string _catalogue)
{
List <CatalogueModels> catalogues = new List <CatalogueModels>();
string sqlQuery = $"exec sp_obtener_" + _catalogue;
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader responseReader = command.ExecuteReader();
while (responseReader.Read())
{
CatalogueModels resultCatalogue = new CatalogueModels();
resultCatalogue.ID = Int32.Parse(responseReader["pk_id_" + _catalogue].ToString());
resultCatalogue.Name = responseReader["tc_nombre_" + _catalogue].ToString();
catalogues.Add(resultCatalogue);
}
connection.Close();
}
return(catalogues);
}
public List <CatalogueModels> GetProfessionalsByProcess(int id_process)
{
var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connDB"].ConnectionString);
List <CatalogueModels> catalogueItems = new List <CatalogueModels>();
string sqlQuery = $"sp_obtener_profesional_por_proceso @proceso='{id_process}'";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader catalogueReader = command.ExecuteReader();
while (catalogueReader.Read())
{
CatalogueModels catalogueTemp = new CatalogueModels();
catalogueTemp.ID = Int32.Parse(catalogueReader["pk_cedula_usuario"].ToString());
catalogueTemp.Name = catalogueReader["tc_nombre"].ToString();
catalogueItems.Add(catalogueTemp);
}
connection.Close();
}
return(catalogueItems);
}
public ActionResult ManageProcessAdministrator()
{
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
return(View("ManageProcessAdministrator"));
}
public ActionResult ManageActivityAdministrator()
{
CatalogueModels catalogueActivity = new CatalogueModels();
catalogueActivity.Table = "actividad";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.activity = catalogueBusiness.GetListCatalogue(catalogueActivity);
return(View("ManageActivityAdministrator"));
}
public ActionResult ManagePlaceAdministrator()
{
CatalogueModels cataloguePlace = new CatalogueModels();
cataloguePlace.Table = "puesto";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.places = catalogueBusiness.GetListCatalogue(cataloguePlace);
return(View("ManagePlaceAdministrator"));
}
public ActionResult ManageAreaAdministrator()
{
CatalogueModels catalogueArea = new CatalogueModels();
catalogueArea.Table = "area";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.areas = catalogueBusiness.GetListCatalogue(catalogueArea);
return(View("ManageAreaAdministrator"));
}
public ActionResult ManageOfficeAdministrator()
{
CatalogueModels catalogueOffice = new CatalogueModels();
catalogueOffice.Table = "oficina";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.offices = catalogueBusiness.GetListCatalogue(catalogueOffice);
return(View("ManageOfficeAdministrator"));
}
public ActionResult ManageAssistanceAdministrator()
{
CatalogueModels catalogueOffice = new CatalogueModels();
catalogueOffice.Table = "asistencia";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.assistance = catalogueBusiness.GetListCatalogue(catalogueOffice);
return(View("ManageAssistanceAdministrator"));
}
public ActionResult DeleteAssistanceAdministrator(int id)
{
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "asistencia";
catalogueProcess.ID = id;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.DeleteCatalogueItems(catalogueProcess);
return(Json("Exitoso"));
}
public ActionResult ModifyAssistanceAdministrator(int id, String description)
{
CatalogueModels cataloguePlace = new CatalogueModels();
cataloguePlace.ID = id;
cataloguePlace.Name = description;
cataloguePlace.Table = "asistencia";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.ModifyCatalogueItems(cataloguePlace);
return(Json("Exitoso"));
}
public ActionResult DeleteActivityAdministrator(int id)
{
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "actividad";
catalogueProcess.ID = id;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.DeleteCatalogueItems(catalogueProcess);
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
return(Json("Exitoso"));
}
public ActionResult DeleteSubprocessAdministrator(int id)
{
CatalogueModels catalogue = new CatalogueModels();
catalogue.Table = "subproceso";
catalogue.ID = id;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.DeleteCatalogueItems(catalogue);
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogue);
return(Json("Exitoso"));
}
public ActionResult ScheduleDatesAdministrator()
{
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
CatalogueBusiness appointmentBusiness = new CatalogueBusiness();
UserBusiness userBusiness = new UserBusiness();
ViewBag.professional = userBusiness.GetListProfessionals();
ViewBag.subprocess = appointmentBusiness.GetCatalogueFunctionary("subproceso");
ViewBag.process = appointmentBusiness.GetListCatalogue(catalogueProcess);
return(View());
}
public ActionResult ModifyProcessAdministrator(int id, String description)
{
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
catalogueProcess.ID = id;
catalogueProcess.Name = description;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.ModifyCatalogueItems(catalogueProcess);
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
return(Json("Exitoso"));
}
public ActionResult MainProfessionalRegisterAdministrator(UserModels professional)
{
UserBusiness professionalBusiness = new UserBusiness();
professionalBusiness.RegisterProfessional(professional);
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
return(View("MainProfessionalRegisterAdministrator"));
}
public ActionResult RegisterAssistanceAdministrator(String description)
{
if (description != "")
{
CatalogueModels catalogueAssitance = new CatalogueModels();
catalogueAssitance.Table = "asistencia";
catalogueAssitance.Name = description;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.RegisterCatalogueItem(catalogueAssitance);
return(Json("Exitoso"));
}
return(Json("Debe ingresar una descripción"));
}
public ActionResult MainProfessionalUpdateAdministrator(UserModels professional)
{
UserBusiness professionalBusiness = new UserBusiness();
professionalBusiness.ModifyProfessional(professional);
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
return(Json("Exitoso"));
}
public ActionResult RegisterPlaceAdministrator(String description)
{
if (description != "")
{
CatalogueModels cataloguePlace = new CatalogueModels();
cataloguePlace.Table = "puesto";
cataloguePlace.Name = description;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.RegisterCatalogueItem(cataloguePlace);
ViewBag.process = catalogueBusiness.GetListCatalogue(cataloguePlace);
return(Json("Exitoso"));
}
return(Json("Debe ingresar una descripción"));
}
public ActionResult ModifySubprocessAdministrator(int id, String description, int father)
{
CatalogueModels catalogue = new CatalogueModels();
catalogue.Table = "subproceso";
catalogue.ID = id;
catalogue.Name = description;
catalogue.FatherID = father;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.ModifyCatalogueItems(catalogue);
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogue);
return(Json("Exitoso"));
}
public ActionResult RegisterSubprocessAdministrator(String description, int father)
{
if (description != "")
{
CatalogueModels catalogue = new CatalogueModels();
catalogue.Table = "subproceso";
catalogue.Name = description;
catalogue.FatherID = father;
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
catalogueBusiness.RegisterCatalogueItem(catalogue);
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogue);
return(Json("Exitoso"));
}
return(Json("Debe ingresar una descripción"));
}
public ActionResult MainProfessionalUpdateAdministrator()
{
int id_professional = Convert.ToInt32(Request.Params["login"]);
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
UserBusiness userBusiness = new UserBusiness();
ViewBag.professional = userBusiness.GetProfessionalByIdentification(id_professional);
ViewBag.processProfessional = catalogueBusiness.GetListProcessProfessional(id_professional);
return(View("MainProfessionalUpdateAdministrator"));
}
/*
* Modify catalogue items for a specific table
*/
public void ModifyCatalogueItems(CatalogueModels _catalogue)
{
string sqlQuery = $"exec sp_modificar_" + _catalogue.Table + " " + _catalogue.ID + " , '" + _catalogue.Name + "';";
if (_catalogue.FatherID != 0)
{
sqlQuery = $"exec sp_modificar_" + _catalogue.Table + " " + _catalogue.ID + " , '" + _catalogue.Name + "' , '" + _catalogue.FatherID + "';";
}
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteReader();
connection.Close();
}
}
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"));
}
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"));
}
/*
* Delete catalogue items for a specific table
*/
public void DeleteCatalogueItems(CatalogueModels _catalogue)
{
string sqlQuery = $"exec sp_eliminar_" + _catalogue.Table + " " + _catalogue.ID + " ;";
if (_catalogue.FatherID != 0)
{
sqlQuery = $"exec sp_eliminar_" + _catalogue.Table + " " + _catalogue.ID + "' , '" + _catalogue.FatherID + "' ;";
}
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into prueba values(11,'Luis')";
cmd.Connection = connection;
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteReader();
connection.Close();
}
}
public ActionResult MainFunctionaryRegisterHome(UserModels functionary)
{
// UserBusiness functionaryBusiness = new UserBusiness();
// functionaryBusiness.RegisterFunctionary(functionary);
CatalogueModels catalogueProcess = new CatalogueModels();
catalogueProcess.Table = "proceso";
UserBusiness userBusiness = new UserBusiness();
ViewBag.professional = userBusiness.GetListProfessionals();
CatalogueBusiness catalogueBusiness = new CatalogueBusiness();
ViewBag.subprocess = catalogueBusiness.GetCatalogueFunctionary("subproceso");
ViewBag.process = catalogueBusiness.GetListCatalogue(catalogueProcess);
Session["functionary"] = functionary;
Session["email"] = functionary.Mail;
ViewBag.functionary = functionary;
return(View("ScheduleDatesHome"));
}
public List <CatalogueModels> GetSubprocessListByProcess(int processId)
{
var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connDB"].ConnectionString);
List <CatalogueModels> catalogueItems = new List <CatalogueModels>();
string sqlQuery = $"exec sp_obtener_subprocesos_de_proceso @proceso={processId}";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader catalogueReader = command.ExecuteReader();
while (catalogueReader.Read())
{
CatalogueModels catalogueTemp = new CatalogueModels();
catalogueTemp.ID = Int32.Parse(catalogueReader["pk_id_subproceso"].ToString());
catalogueTemp.Name = catalogueReader["tc_nombre_subproceso"].ToString();
catalogueItems.Add(catalogueTemp);
}
connection.Close();
}
return(catalogueItems);
}
public void DeleteCatalogueItems(CatalogueModels _catalogue)
{
CatalogueData adminData = new CatalogueData();
adminData.DeleteCatalogueItems(_catalogue);
}
public void ModifyCatalogueItems(CatalogueModels _catalogue)
{
CatalogueData adminData = new CatalogueData();
adminData.ModifyCatalogueItems(_catalogue);
}
