public IHttpActionResult Calificar(ConceptQualificationViewModel filter)
{
// falta validar q ya lo haya calificado
ConceptBL oConceptBL = new ConceptBL();
var calificado = oConceptBL.VerificarCalificado(filter.concept_id);
ConceptStatusLogViewModel oConceptStatusLogViewModel = new ConceptStatusLogViewModel();
oConceptStatusLogViewModel.concept_id = filter.concept_id;
oConceptStatusLogViewModel.user_id_created = filter.user_id;
oConceptStatusLogViewModel.qualification = filter.qualification;
//oConceptStatusLogViewModel.certification_path = pdf_path;
oConceptBL.Calificar(oConceptStatusLogViewModel);
if (!calificado)
{
ConceptViewModel pConceptViewModel = oConceptBL.Obtener(oConceptStatusLogViewModel.concept_id);
NotificacionCalificadoConcepto(pConceptViewModel);
}
var result = new
{
data = 1
};
return(Ok(result));
}
// GET: User
public JsonResult ObtenerLista(DataTableAjaxPostModel ofilters, [Bind(Include = "interest_area_id,commission_id,status_id,origin_id,period_id")] ReportFilterViewModel Reportefiltros)//DataTableAjaxPostModel model
{
ConceptBL oConceptBL = new ConceptBL();
UserBL oUserBL = new UserBL();
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
GridModel <ReportViewModel> grid = new GridModel <ReportViewModel>();
Reportefiltros.institution_ids = new List <int>();
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_own_institution_support))
{
Reportefiltros.institution_ids = oUserBL.ObtenerUser(AuthorizeUserAttribute.UsuarioLogeado().user_id).institution_ids;
}
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_all_institution_support))
{
Reportefiltros.institution_ids = null;
}
oConceptBL.ActualizarTablasReporte(Reportefiltros.period_id);
grid = oConceptBL.ObtenerReporte(ofilters, Reportefiltros);
grid.rows.ForEach(x => x.age = Helper.CalculateAge(x.birthdate.Value));
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows,
}));
}
public JsonResult ExportExcel([Bind(Include = "interest_area_id,commission_id,status_id,origin_id,period_id")] ReportFilterViewModel filtros)
{
UserBL oUserBL = new UserBL();
var fileName = "Reporte_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xlsx";
string errorMessage = "";
filtros.institution_ids = new List <int>();
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_own_institution_support))
{
filtros.institution_ids = oUserBL.ObtenerUser(AuthorizeUserAttribute.UsuarioLogeado().user_id).institution_ids;
}
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_all_institution_support))
{
filtros.institution_ids = null;
}
ConceptBL oConceptBL = new ConceptBL();
oConceptBL.ActualizarTablasReporte(filtros.period_id);
List <ReportViewModel> resultado = oConceptBL.ObtenerExportarReporte(filtros);
// resultado.ForEach(RecalcularCampos);
string fullPath = Path.Combine(Server.MapPath("~/temp"), fileName);
Stream fileBytes = CrearReporteExcel(resultado, fullPath, true);
return(Json(new { fileName = fileName, errorMessage = errorMessage }));
}
public IHttpActionResult Concept(ConceptFilterLiteViewModel filter)
{
ConceptBL oConceptBL = new ConceptBL();
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
ConceptDetailLiteViewModel obj = oConceptBL.ObtenerLite(filter);
obj.tags = String.Join(", ", obj.tags_list);
var path = ConfigurationManager.AppSettings["pdf.path"];
obj.pdf_file = obj.pdf_file.Replace(path, "");
var result = new
{
// this is what datatables wants sending back
data = obj
};
return(Ok(result));
}
public JsonResult ObtenerRanking(DataTableAjaxPostModel ofilters)//DataTableAjaxPostModel model
{
ConceptBL oConceptBL = new ConceptBL();
string str_interest_area_id = Request.Form["interest_area_id"];
int interest_area_id = 0;
int.TryParse(str_interest_area_id, out interest_area_id);
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
// int investigator_id = AuthorizeUserAttribute.UsuarioLogeado().investigator_id;
GridModel <RankingViewModel> grid = oConceptBL.ObtenerRanking(ofilters, interest_area_id);
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows
}));
}
public IHttpActionResult ConceptsAll(ConceptsFilterLiteViewModel filter)
{
ConceptBL oConceptBL = new ConceptBL();
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
filter.period_id = oPeriod.period_id;
List <ConceptLiteViewModel> lista = oConceptBL.ObtenerMovil(filter);
var path = ConfigurationManager.AppSettings["pdf.path"];
lista.ForEach(a => a.pdf_file = a.pdf_file.Replace(path, ""));
var result = new
{
// this is what datatables wants sending back
data = lista
};
return(Ok(result));
}
public ActionResult MiHistorial()
{
SelectorBL oSelectorBL = new SelectorBL();
MeritRangeBL oMeritRangeBL = new MeritRangeBL();
List <MeritRangeViewModel> oMeritRange = oMeritRangeBL.ObtenerTodos();
ViewBag.merit_ranges_json = JsonConvert.SerializeObject(oMeritRange);
ViewBag.merit_ranges = oMeritRange;
ConceptBL oConceptBL = new ConceptBL();
MyHistoryViewModel oMyHistoryViewModel = oConceptBL.ObtenerMiHistorial(AuthorizeUserAttribute.UsuarioLogeado().investigator_id);
if (oMyHistoryViewModel == null)
{
oMyHistoryViewModel = new MyHistoryViewModel();
oMyHistoryViewModel.nro_concepts = 0;
oMyHistoryViewModel.my_points = 0;
oMyHistoryViewModel.qualified_concepts = 0;
oMyHistoryViewModel.approved_concepts = 0;
}
ViewBag.my_points = oMyHistoryViewModel.my_points;
return(View(oMyHistoryViewModel));
}
public IHttpActionResult EnviarNotificacion(ConceptSendNotification filter)
{
var base_url = ConfigurationManager.AppSettings["site.url"];
UserBL userBL = new UserBL();
UserViewModel congresista = userBL.ObtenerUser(filter.user_id);
ConceptBL oConceptBL = new ConceptBL();
var concept = oConceptBL.Obtener(filter.concept_id);
InvestigatorViewModel investigador = userBL.ObtenerInvestigator(concept.investigator_id.Value);
SendEmailNotificationBL oSendEmailNotificationBL = new SendEmailNotificationBL();
if (filter.solicitud_datos_investigador == 1)
{
NotificationConceptMovil oNotificationViewModel = new NotificationConceptMovil();
oNotificationViewModel.concept_id = concept.concept_id;
oNotificationViewModel.contact_data_name = investigador.contact_name;
oNotificationViewModel.contact_data_phone = investigador.phone;
oNotificationViewModel.contact_data_email = investigador.user_email;
oNotificationViewModel.name = congresista.contact_name;
// oNotificationViewModel.to = congresista.user_email;
oNotificationViewModel.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"];
oNotificationViewModel.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"];
oNotificationViewModel.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"];
oSendEmailNotificationBL.EnviarNotificacionMovil(oNotificationViewModel, "notificacion.movil.investigator.data");
}
if (filter.solicitud_ampliacion == 1)
{
NotificationConceptMovil oNotificationViewModel = new NotificationConceptMovil();
oNotificationViewModel.concept_id = concept.concept_id;
oNotificationViewModel.contact_data_name = congresista.contact_name;
oNotificationViewModel.contact_data_phone = congresista.phone;
oNotificationViewModel.contact_data_email = congresista.user_email;
oNotificationViewModel.name = investigador.contact_name;
oNotificationViewModel.message = filter.message;
oNotificationViewModel.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"];
oNotificationViewModel.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"];
oNotificationViewModel.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"];
oSendEmailNotificationBL.EnviarNotificacionMovil(oNotificationViewModel, "notificacion.movil.congresista.data");
}
var result = new
{
data = 1
};
return(Ok(result));
}
