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