public JsonResult Crear([Bind(Include = "investigator_id,user_id,first_name,second_name,last_name,second_last_name,gender_id,mobile_phone," + "birthdate_text,user_email,user_pass,document_type_id,doc_nro,nationality_id,contract_name,phone,address,user_pass2,institution_id," + "investigation_group_id,program_id,interest_areas,address_country_id,department_id,address_municipality_id,commissions,educational_institution_id,education_level_id,CVLAC")] InvestigatorViewModel pViewModel) { // TODO: Add insert logic here if (pViewModel == null) { return(Json(new { message_error = "Datos inavalidos", status = "0", })); } pViewModel.investigator_id = 0; pViewModel.user_id_created = 0; pViewModel.birthdate = DateTime.ParseExact(pViewModel.birthdate_text, "dd/MM/yyyy", CultureInfo.InvariantCulture); var user_pass = pViewModel.user_pass; pViewModel.user_pass = Helper.Encripta(pViewModel.user_pass); pViewModel.user_name = pViewModel.first_name + " " + pViewModel.second_name + " " + pViewModel.last_name + " " + pViewModel.second_last_name; pViewModel.user_name = pViewModel.user_name.Replace(" ", " ").Replace(" ", " "); pViewModel.contact_name = pViewModel.user_name; string user_code = Guid.NewGuid().ToString(); pViewModel.user_code_activate = user_code; UserBL oBL = new UserBL(); var user_id = oBL.AgregarInvestigador(pViewModel); SendEmailNotificationBL oSendEmailNotificationBL = new SendEmailNotificationBL(); NotificationGeneralAccountViewModel oNotification = new NotificationGeneralAccountViewModel(); oNotification.url_activar_cuenta = ConfigurationManager.AppSettings["site.url"] + "/Account/Activar/?code=" + user_code; oNotification.url_home = ConfigurationManager.AppSettings["site.url"]; oNotification.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"]; oNotification.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"]; oNotification.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"]; oNotification.name = pViewModel.contact_name; oNotification.to = pViewModel.user_email; oSendEmailNotificationBL.EnviarNotificacionActivarCuenta(oNotification); return(Json(new { // this is what datatables wants sending back status = "1", })); }
public JsonResult ObtenerLista(DraftLawFiltersViewModel ofilters, [Bind(Include = "period_id")] GeneralFilterViewModel generalfiltros)//DataTableAjaxPostModel model { DraftLawBL oDraftLawBL = new DraftLawBL(); //DraftLawFiltersViewModel ofilters = new DraftLawFiltersViewModel(); UserBL oUserBL = new UserBL(); InvestigatorViewModel oInvestigatorViewModel = oUserBL.ObtenerInvestigator(AuthorizeUserAttribute.UsuarioLogeado().investigator_id); GridModel <DraftLawViewModel> grid = oDraftLawBL.ObtenerMisProyectosLey(ofilters, oInvestigatorViewModel.commissions, oInvestigatorViewModel.interest_areas, generalfiltros); return(Json(new { // this is what datatables wants sending back draw = ofilters.draw, recordsTotal = grid.total, recordsFiltered = grid.recordsFiltered, data = grid.rows })); }
public ActionResult Editar([Bind(Include = "investigator_id,user_id,first_name,second_name,last_name,second_last_name,gender_id,mobile_phone," + "birthdate_text,user_email,user_pass,document_type_id,doc_nro,nationality_id,contract_name,phone,address,user_pass2,institution_id," + "investigation_group_id,program_id,interest_areas,address_country_id,department_id,address_municipality_id,commissions,educational_institution_id,education_level_id,CVLAC")] InvestigatorViewModel pViewModel) { // TODO: Add insert logic here if (pViewModel == null) { return(HttpNotFound()); } UserBL oUserBL = new UserBL(); pViewModel.user_id_modified = AuthorizeUserAttribute.UsuarioLogeado().user_id; pViewModel.user_name = pViewModel.first_name + " " + pViewModel.second_name + " " + pViewModel.last_name + " " + pViewModel.second_last_name; pViewModel.user_name = pViewModel.user_name.Replace(" ", " ").Replace(" ", " "); pViewModel.contact_name = pViewModel.user_name; pViewModel.birthdate = DateTime.ParseExact(pViewModel.birthdate_text, "dd/MM/yyyy", CultureInfo.InvariantCulture); pViewModel.avatar = null; if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var extension = Path.GetExtension(file.FileName); var fileName = Guid.NewGuid().ToString() + "." + extension; pViewModel.avatar = "/Avatars/" + fileName; var path = Path.Combine(Server.MapPath("~/Avatars/"), fileName); file.SaveAs(path); } } oUserBL.ModificarInvestigator(pViewModel); CurrentUserViewModel result = oUserBL.GetCurrentUser(pViewModel.user_id.Value); result.name_abbre = Helper.Substring(result.name, 20); Session[System.Configuration.ConfigurationManager.AppSettings["session.usuario.actual"]] = result; return(Redirect("/Account/Editar/" + pViewModel.investigator_id)); }
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)); }
public ActionResult Editar(string id) { UserBL oBL = new UserBL(); int pIntID = 0; int.TryParse(id, out pIntID); InvestigatorViewModel pViewModel = oBL.ObtenerInvestigator(pIntID); if (pViewModel == null) { pViewModel = new InvestigatorViewModel(); } SelectorBL oSelectorBL = new SelectorBL(); if (pViewModel != null) { pViewModel.birthdate_text = pViewModel.birthdate.HasValue ? pViewModel.birthdate.Value.ToString("dd/MM/yyyy") : String.Empty; } List <SelectOptionItem> oEstatus = oSelectorBL.EstatusUserSelector(); List <SelectOptionItem> oRoles = oSelectorBL.RolesSelector(); List <SelectOptionItem> oNationalities = oSelectorBL.NationalitiesSelector(); List <SelectOptionItem> oDocumentTypes = oSelectorBL.DocumentTypesSelector(); List <SelectOptionItem> oGenders = oSelectorBL.GendersSelector(); List <SelectOptionItem> oPrograms = oSelectorBL.ProgramsSelector((pViewModel.educational_institution_id != null ? pViewModel.educational_institution_id.Value : 0)); List <SelectOptionItem> oInterestAreas = oSelectorBL.InterestAreasSelector(); List <SelectOptionItem> oDepartments = oSelectorBL.DepartmentsSelector(); List <SelectOptionItem> oMunicipalities = oSelectorBL.MunicipalitiesSelector(pViewModel != null && pViewModel.department_id.HasValue? pViewModel.department_id.Value:0); List <SelectOptionItem> oAcademicLevels = oSelectorBL.AcademicLevelsSelector(); List <SelectOptionItem> oCommissions = oSelectorBL.CommissionsSelector(); List <SelectOptionItem> oEducationalInstitutions = oSelectorBL.EducationalInstitutionsSelector(); List <SelectOptionItem> oEducationLevels = oSelectorBL.EducationLevelsSelector((pViewModel.educational_institution_id != null ? pViewModel.educational_institution_id.Value : 0), (pViewModel.program_id != null ? pViewModel.program_id.Value : 0)); List <SelectOptionItem> oInvestigationGroups = oSelectorBL.InvestigationGroupsSelector((pViewModel.institution_id != null ? pViewModel.institution_id.Value : 0)); List <SelectListItem> estatus = Helper.ConstruirDropDownList <SelectOptionItem>(oEstatus, "Value", "Text", "", true, "", ""); List <SelectListItem> roles = Helper.ConstruirDropDownList <SelectOptionItem>(oRoles, "Value", "Text", "", true, "", ""); List <SelectListItem> nationalities = Helper.ConstruirDropDownList <SelectOptionItem>(oNationalities, "Value", "Text", "", true, "", ""); List <SelectListItem> documentTypes = Helper.ConstruirDropDownList <SelectOptionItem>(oDocumentTypes, "Value", "Text", "", true, "", ""); List <SelectListItem> genders = Helper.ConstruirDropDownList <SelectOptionItem>(oGenders, "Value", "Text", "", true, "", ""); List <SelectListItem> programs = Helper.ConstruirDropDownList <SelectOptionItem>(oPrograms, "Value", "Text", "", true, "", ""); List <SelectListItem> interest_areas = Helper.ConstruirDropDownList <SelectOptionItem>(oInterestAreas, "Value", "Text", "", false, "", ""); List <SelectListItem> departments = Helper.ConstruirDropDownList <SelectOptionItem>(oDepartments, "Value", "Text", "", true, "", ""); List <SelectListItem> municipalities = Helper.ConstruirDropDownList <SelectOptionItem>(oMunicipalities, "Value", "Text", "", true, "", ""); List <SelectListItem> academic_levels = Helper.ConstruirDropDownList <SelectOptionItem>(oAcademicLevels, "Value", "Text", "", true, "", ""); List <SelectListItem> commissions = Helper.ConstruirDropDownList <SelectOptionItem>(oCommissions, "Value", "Text", "", true, "", ""); List <SelectListItem> educational_institutions = Helper.ConstruirDropDownList <SelectOptionItem>(oEducationalInstitutions, "Value", "Text", "", true, "", ""); List <SelectListItem> investigation_groups = Helper.ConstruirDropDownList <SelectOptionItem>(oInvestigationGroups, "Value", "Text", "", true, "", ""); List <SelectListItem> education_levels = Helper.ConstruirDropDownList <SelectOptionItem>(oEducationLevels, "Value", "Text", "", true, "", ""); List <SelectListItem> oListaVacia = Helper.ConstruirDropDownList <SelectOptionItem>(new List <SelectOptionItem>(), "Value", "Text", "", true, "", ""); interest_areas = interest_areas.Select(a => new SelectListItem { Text = a.Text, Value = a.Value, Selected = (pViewModel.interest_areas != null ? pViewModel.interest_areas.Contains(int.Parse(a.Value)) : false) }).ToList(); List <SelectListItem> institutions = new List <SelectListItem>(); if (pViewModel.institution != null) { institutions.Add(new SelectListItem { Text = pViewModel.institution, Value = pViewModel.institution_id.ToString(), Selected = true }); } ViewBag.programs = programs; ViewBag.education_levels = education_levels; ViewBag.educational_institutions = educational_institutions; ViewBag.institutions = institutions; ViewBag.investigation_groups = investigation_groups; ViewBag.interest_areas = interest_areas; // ViewBag.programs = programs; ViewBag.departments = departments; ViewBag.municipalities = municipalities; ViewBag.estatus = estatus; ViewBag.roles = roles; ViewBag.nationalities = nationalities; ViewBag.documentTypes = documentTypes; ViewBag.genders = genders; ViewBag.academic_levels = academic_levels; pViewModel.commissionsMultiSelectList = new MultiSelectList(oSelectorBL.CommissionsSelector(), "Value", "Text"); return(View(pViewModel)); }
public ActionResult Crear() { SelectorBL oSelectorBL = new SelectorBL(); List <SelectOptionItem> oEstatus = oSelectorBL.EstatusUserSelector(); List <SelectOptionItem> oRoles = oSelectorBL.RolesSelector(); List <SelectOptionItem> oNationalities = oSelectorBL.NationalitiesSelector(); List <SelectOptionItem> oDocumentTypes = oSelectorBL.DocumentTypesSelector(); List <SelectOptionItem> oGenders = oSelectorBL.GendersSelector(); List <SelectOptionItem> oPrograms = oSelectorBL.ProgramsSelector(); List <SelectOptionItem> oInterestAreas = oSelectorBL.InterestAreasSelector(); List <SelectOptionItem> oDepartments = oSelectorBL.DepartmentsSelector(); List <SelectOptionItem> oAcademicLevels = oSelectorBL.AcademicLevelsSelector(); List <SelectOptionItem> oCommissions = oSelectorBL.CommissionsSelector(); List <SelectOptionItem> oEducationalInstitutions = oSelectorBL.EducationalInstitutionsSelector(); List <SelectListItem> estatus = Helper.ConstruirDropDownList <SelectOptionItem>(oEstatus, "Value", "Text", "", true, "", ""); List <SelectListItem> roles = Helper.ConstruirDropDownList <SelectOptionItem>(oRoles, "Value", "Text", "", true, "", ""); List <SelectListItem> nationalities = Helper.ConstruirDropDownList <SelectOptionItem>(oNationalities, "Value", "Text", "", true, "", ""); List <SelectListItem> documentTypes = Helper.ConstruirDropDownList <SelectOptionItem>(oDocumentTypes, "Value", "Text", "", true, "", ""); List <SelectListItem> genders = Helper.ConstruirDropDownList <SelectOptionItem>(oGenders, "Value", "Text", "", true, "", ""); List <SelectListItem> programs = Helper.ConstruirDropDownList <SelectOptionItem>(oPrograms, "Value", "Text", "", true, "", ""); List <SelectListItem> interest_areas = Helper.ConstruirDropDownList <SelectOptionItem>(oInterestAreas, "Value", "Text", "", false, "", ""); List <SelectListItem> departments = Helper.ConstruirDropDownList <SelectOptionItem>(oDepartments, "Value", "Text", "", true, "", ""); List <SelectListItem> academic_levels = Helper.ConstruirDropDownList <SelectOptionItem>(oAcademicLevels, "Value", "Text", "", true, "", ""); List <SelectListItem> commissions = Helper.ConstruirDropDownList <SelectOptionItem>(oCommissions, "Value", "Text", "", true, "", ""); List <SelectListItem> educational_institutions = Helper.ConstruirDropDownList <SelectOptionItem>(oEducationalInstitutions, "Value", "Text", "", true, "", ""); List <SelectListItem> oListaVacia = Helper.ConstruirDropDownList <SelectOptionItem>(new List <SelectOptionItem>(), "Value", "Text", "", true, "", ""); ViewBag.programs = oListaVacia; ViewBag.education_levels = oListaVacia; ViewBag.educational_institutions = educational_institutions; ViewBag.institutions = oListaVacia; ViewBag.investigation_groups = oListaVacia; ViewBag.interest_areas = interest_areas; // ViewBag.programs = programs; ViewBag.departments = departments; ViewBag.municipalities = oListaVacia; ViewBag.estatus = estatus; ViewBag.roles = roles; ViewBag.nationalities = nationalities; ViewBag.documentTypes = documentTypes; ViewBag.genders = genders; ViewBag.academic_levels = academic_levels; ViewBag.commissions = commissions; InvestigatorViewModel pViewModel = new InvestigatorViewModel(); ConfigurationBL oConfigurationBL = new ConfigurationBL(); pViewModel.terms_conditions = oConfigurationBL.Obtener().terms_conditions; pViewModel.commissionsMultiSelectList = new MultiSelectList(oSelectorBL.CommissionsSelector(), "Value", "Text"); return(View(pViewModel)); }
public void ModificarInvestigator(InvestigatorViewModel pInvestigatorViewModel) { using (var scope = new TransactionScope()) { investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id); users ousers = oRepositorio.FindById(oinvestigators.user_id); ousers.user_name = pInvestigatorViewModel.user_name; // ousers.user_email = pInvestigatorViewModel.user_email; // ousers.user_pass = pInvestigatorViewModel.user_pass; ousers.contact_name = pInvestigatorViewModel.contact_name; ousers.document_type_id = pInvestigatorViewModel.document_type_id; ousers.doc_nro = pInvestigatorViewModel.doc_nro; ousers.nationality_id = pInvestigatorViewModel.nationality_id; // contract_name = pInvestigatorViewModel.contract_name, ousers.phone = pInvestigatorViewModel.phone; ousers.address = pInvestigatorViewModel.address; ousers.address_municipality_id = pInvestigatorViewModel.address_municipality_id; ousers.address_country_id = pInvestigatorViewModel.address_country_id; ousers.user_id_modified = pInvestigatorViewModel.user_id_modified; ousers.date_modified = DateTime.Now; if (pInvestigatorViewModel.avatar != null) { ousers.avatar = pInvestigatorViewModel.avatar; } oRepositorio.Update(ousers); //investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id); oinvestigators.user_id = ousers.id; oinvestigators.first_name = pInvestigatorViewModel.first_name; oinvestigators.second_name = pInvestigatorViewModel.second_name; oinvestigators.last_name = pInvestigatorViewModel.last_name; oinvestigators.second_last_name = pInvestigatorViewModel.second_last_name; oinvestigators.gender_id = pInvestigatorViewModel.gender_id; oinvestigators.mobile_phone = pInvestigatorViewModel.mobile_phone; oinvestigators.birthdate = pInvestigatorViewModel.birthdate; oinvestigators.institution_id = pInvestigatorViewModel.institution_id; oinvestigators.investigation_group_id = pInvestigatorViewModel.investigation_group_id; oinvestigators.program_id = pInvestigatorViewModel.program_id; oinvestigators.educational_institution_id = pInvestigatorViewModel.educational_institution_id; oinvestigators.education_level_id = pInvestigatorViewModel.education_level_id; oinvestigators.CVLAC = pInvestigatorViewModel.CVLAC; oRepositorioInvestigatorCommission.DeleteMultiple(pInvestigatorViewModel.investigator_id); oRepositorioInvestigatorInterestArea.DeleteMultiple(pInvestigatorViewModel.investigator_id); foreach (int interest_area_id in pInvestigatorViewModel.interest_areas) { oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas { interest_area_id = interest_area_id, investigator_id = pInvestigatorViewModel.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } foreach (int commission_id in pInvestigatorViewModel.commissions) { oRepositorioInvestigatorCommission.Add(new investigators_commissions { commission_id = commission_id, investigator_id = pInvestigatorViewModel.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } oRepositorioInvestigator.Update(oinvestigators); oUnitOfWork.SaveChanges(); scope.Complete(); } }
public int?AgregarInvestigador(InvestigatorViewModel pInvestigatorViewModel) { users ousers = new users { id = 0, user_name = pInvestigatorViewModel.user_name, user_email = pInvestigatorViewModel.user_email, user_pass = pInvestigatorViewModel.user_pass, contact_name = pInvestigatorViewModel.contact_name, user_role_id = 11, user_status_id = 2, document_type_id = pInvestigatorViewModel.document_type_id, doc_nro = pInvestigatorViewModel.doc_nro, nationality_id = pInvestigatorViewModel.nationality_id, // contract_name = pInvestigatorViewModel.contract_name, phone = pInvestigatorViewModel.phone, address = pInvestigatorViewModel.address, address_municipality_id = pInvestigatorViewModel.address_municipality_id, address_country_id = pInvestigatorViewModel.address_country_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, user_code_activate = pInvestigatorViewModel.user_code_activate, user_code_recover = pInvestigatorViewModel.user_code_recover, }; ousers = oRepositorio.Add(ousers); investigators oinvestigators = new investigators { investigator_id = 0, user_id = ousers.id, first_name = pInvestigatorViewModel.first_name, second_name = pInvestigatorViewModel.second_name, last_name = pInvestigatorViewModel.last_name, second_last_name = pInvestigatorViewModel.second_last_name, gender_id = pInvestigatorViewModel.gender_id, mobile_phone = pInvestigatorViewModel.mobile_phone, birthdate = pInvestigatorViewModel.birthdate, institution_id = pInvestigatorViewModel.institution_id, investigation_group_id = pInvestigatorViewModel.investigation_group_id, program_id = pInvestigatorViewModel.program_id, educational_institution_id = pInvestigatorViewModel.educational_institution_id, education_level_id = pInvestigatorViewModel.education_level_id, CVLAC = pInvestigatorViewModel.CVLAC, }; foreach (int interest_area_id in pInvestigatorViewModel.interest_areas) { oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas { interest_area_id = interest_area_id, investigator_id = oinvestigators.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } foreach (int commission_id in pInvestigatorViewModel.commissions) { oRepositorioInvestigatorCommission.Add(new investigators_commissions { commission_id = commission_id, investigator_id = oinvestigators.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } oinvestigators = oRepositorioInvestigator.Add(oinvestigators); oUnitOfWork.SaveChanges(); return(oinvestigators.user_id); }