public ActionResult Editar(EmployeeValidador employeeValidador) { Employee employee = (Employee)System.Web.HttpContext.Current.Session["_SessionUser"]; if (employee == null) { return(RedirectToAction("Index", "Login")); } ViewBag.Nombre = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(string.Format("{0} {1} {2}", employee.FirstName.ToLower(), employee.LastName.ToLower(), employee.MiddleName.ToLower())); ViewBag.EmailUser = employee.CompanyEmail; ViewBag.ImageUser = employee.GoogleImage; ViewBag.AccessGroup = employee.AreaName; ViewBag.Rol = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(employee.PositionName.ToLower()); //ViewBag.RecordCount = null; ViewBag.EnumRol = employee.Rol; ViewBag.CardNumber = employee.CardNumber; EmployeeValidadorServices service = new EmployeeValidadorServices(); var result = service.UpdateEmployee(employeeValidador); if (!result.Success) { TempData["AlertMessage"] = "Hubo un problema al actualizar los datos del empleado, intente de nuevo"; return(RedirectToAction("Index", "ValidadorDatos")); } TempData["AlertMessage"] = "Los datos del empleado se actualizaron exitosamente"; return(RedirectToAction("Index", "ValidadorDatos")); }
public Result UpdateEmployee(EmployeeValidador employeeValidador) { _SpProcedureName = "[dbo].[Sp_UpdateEmployeeValidador]"; Result resultado = new Result(); try { List <SqlParameter> parametros = new List <SqlParameter> { new SqlParameter("@CardNumber", employeeValidador.CardNumber) , new SqlParameter("@FirstName", employeeValidador.FirstName) , new SqlParameter("@LastName", employeeValidador.LastName) , new SqlParameter("@MiddleName", employeeValidador.MiddleName) , new SqlParameter("@FullName", employeeValidador.FullName) , new SqlParameter("@Rfc", employeeValidador.Rfc) , new SqlParameter("@Curp", employeeValidador.Curp) , new SqlParameter("@NSS", employeeValidador.NSS) , new SqlParameter("@BirthDay", employeeValidador.BirthDay) , new SqlParameter("@PhoneNumber", employeeValidador.PhoneNumber) , new SqlParameter("@CellPhoneNumber", employeeValidador.CellPhoneNumber) , new SqlParameter("@PersonalEmail", employeeValidador.PersonalEmail) , new SqlParameter("@StreetName", employeeValidador.StreetName) , new SqlParameter("@NumberExt", employeeValidador.NumberExt) , new SqlParameter("@NumberInt", employeeValidador.NumberInt) , new SqlParameter("@Delegation", employeeValidador.Delegation) , new SqlParameter("@Colony", employeeValidador.Colony) , new SqlParameter("@CP", employeeValidador.CP) , new SqlParameter("@Banco", employeeValidador.Banco) , new SqlParameter("@Clabe", employeeValidador.Clabe) , new SqlParameter("@EdoCivil", employeeValidador.EdoCivil) , new SqlParameter("@LugarNacimiento", employeeValidador.LugarNacimiento) , new SqlParameter("@CreditoInfonavit", employeeValidador.CreditoInfonavit) , new SqlParameter("@EstadoEmpleado", employeeValidador.EstadoEmpleado) , new SqlParameter("@Sexo", employeeValidador.Sexo) , new SqlParameter("@TramiteInfSn", employeeValidador.TRAMITE_INF_SN) , new SqlParameter("@Etapa", employeeValidador.Etapa) , new SqlParameter("@Estudios", employeeValidador.Estudios) , new SqlParameter("@NivelEstudios", employeeValidador.Nivel_Estudios) , new SqlParameter("@Universidad", employeeValidador.Universidad) , new SqlParameter("@NoJefe", employeeValidador.Id_Jefe) , new SqlParameter("@NombreJefe", employeeValidador.Nombre_jefe) , new SqlParameter("@Ult_GradoEstudios", employeeValidador.Ultimo_GradoEstudios) , new SqlParameter("@Estatus", employeeValidador.Estatus) }; _dao.ExecuteProcedure(parametros, _SpProcedureName); resultado.Success = true; } catch (Exception e) { resultado.Success = false; resultado.ErrorMessage = String.Format("Se ha producido un error al procesar datos de archivo Error {0}", e.Message); } return(resultado); }
public ActionResult Editar(string NoEmpleado) { Employee employee = (Employee)System.Web.HttpContext.Current.Session["_SessionUser"]; if (employee == null) { return(RedirectToAction("Index", "Login")); } ViewBag.Nombre = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(string.Format("{0} {1} {2}", employee.FirstName.ToLower(), employee.LastName.ToLower(), employee.MiddleName.ToLower())); ViewBag.EmailUser = employee.CompanyEmail; ViewBag.ImageUser = employee.GoogleImage; ViewBag.AccessGroup = employee.AreaName; ViewBag.Rol = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(employee.PositionName.ToLower()); //ViewBag.RecordCount = null; ViewBag.EnumRol = employee.Rol; ViewBag.CardNumber = employee.CardNumber; EmployeeValidadorModel model = new EmployeeValidadorModel(); model.NoEmpleado = NoEmpleado; EmployeeValidador empleado = new EmployeeValidador(); EmployeeValidadorServices service = new EmployeeValidadorServices(model); var _model = service.GetDataByFilter(); if (!service.result.Success) { TempData["AlertMessage"] = service.result.ErrorMessage; return(View(_model)); } _model.Rol = employee.Rol; _model.EmployeeIdConected = Convert.ToInt32(employee.EmployeeId); _model.LstEmployeesValidador.ForEach(g => g.CertificatePath = "/Pdfs/"); empleado = _model.LstEmployeesValidador.Where(i => i.CardNumber == model.NoEmpleado).FirstOrDefault(); TempData["PageCount"] = _model.PageCount; TempData["RecordCount"] = _model.RecordCount; TempData["CurrentPageIndex"] = 1; return(View("_Edicion", empleado)); }
public Result GetAllEmployessValidador(out List <EmployeeValidador> lstEmployees, string nombre, string no_empleado, string Rfc, string Nss) { lstEmployees = null; _SpProcedureName = "[dbo].[Sp_GetEmployeesValidadorByFilter]"; Result resultado = new Result(); try { List <SqlParameter> parametros = new List <SqlParameter> { new SqlParameter("@Nombre", string.IsNullOrEmpty(nombre) ?null:nombre) , new SqlParameter("@NoEmpleado", string.IsNullOrEmpty(no_empleado) ?null:no_empleado) , new SqlParameter("@Rfc", string.IsNullOrEmpty(Rfc) ?null:Rfc) , new SqlParameter("@Nss", string.IsNullOrEmpty(Nss) ?null:Nss) }; SqlDataReader reader = _dao.ExecuteReader(parametros, _SpProcedureName); if (reader.HasRows) { lstEmployees = new List <EmployeeValidador>(); while (reader.Read()) { EmployeeValidador employee = new EmployeeValidador(); employee.EmployeeId = reader["PK_TEMP"].ToString(); //employee.CardId = reader["CardId"].ToString(); employee.CardNumber = reader["NO_EMPLEADO"].ToString(); employee.FirstName = reader["NOMBRE"].ToString(); employee.LastName = reader["PATERNO"].ToString(); employee.MiddleName = reader["MATERNO"].ToString(); employee.FullName = reader["FULLNAME"].ToString(); employee.Rfc = reader["Rfc"].ToString(); employee.Curp = reader["Curp"].ToString(); employee.NSS = reader["NSS"].ToString(); employee.BirthDay = reader["F_NACIMIENTO"] == DBNull.Value ? null : (DateTime?)reader["F_NACIMIENTO"]; //employee.AdmissionDate = reader["F_INGRESO"] == DBNull.Value ? null : (DateTime?)reader["F_INGRESO"]; //employee.EntryDate = reader["F_ANTIGUEDAD"] == DBNull.Value ? null : (DateTime?)reader["F_ANTIGUEDAD"]; //employee.LeavingDate = reader["F_BAJA"] == DBNull.Value ? null : (DateTime?)reader["F_BAJA"]; employee.StreetName = reader["CALLE"].ToString(); employee.NumberExt = reader["NUM EXT"].ToString(); employee.NumberInt = reader["NO_INT"].ToString(); employee.Delegation = reader["DELEGACION"].ToString(); employee.Colony = reader["COLONIA"].ToString(); employee.CP = reader["CP"].ToString(); employee.PhoneNumber = reader["TEL_CASA"].ToString(); employee.CellPhoneNumber = reader["CELULAR"].ToString(); //employee.OfficePhone = reader["OfficePhone"].ToString(); //employee.OfficeExt = reader["OfficeExt"].ToString(); employee.PersonalEmail = reader["EMAIL"].ToString(); //employee.CompanyEmail = reader["CompanyEmail"].ToString(); //employee.Enabled = (bool)reader["Enabled"]; //employee.LocalizationId = reader["LocalizationId"] == DBNull.Value ? null : (int?)reader["LocalizationId"]; //employee.PayRollId = reader["PayRollId"] == DBNull.Value ? null : (int?)reader["PayRollId"]; //employee.CompanyId = reader["CompanyId"] == DBNull.Value ? null : (int?)reader["CompanyId"]; //employee.NationalityId = reader["NationalityId"] == DBNull.Value ? null : (int?)reader["NationalityId"]; //employee.EmployeePositionId = reader["EmployeePositionId"] == DBNull.Value ? null : (int?)reader["EmployeePositionId"]; //employee.BossId = reader["BossId"] == DBNull.Value ? null : (int?)reader["BossId"]; //employee.BossName = reader["BossName"].ToString(); //employee.AreaName = reader["AreaName"].ToString(); //employee.PositionName = reader["PUESTO"].ToString(); //employee.FingerPrint = reader["FingerPrint"] == DBNull.Value ? false : Convert.ToBoolean(reader["FingerPrint"]) ? true : false; //employee.ParkingSpace = reader["ParkingSpace"].ToString(); //employee.CardId = reader["CardId"].ToString(); //employee.Compania = reader["COMPANIA"].ToString(); employee.Banco = reader["BANCO"].ToString(); employee.Clabe = reader["CLABE"].ToString(); employee.CreditoInfonavit = reader["CREDITO_INFONAVIT"].ToString(); employee.LugarNacimiento = reader["LUGAR_NAC"].ToString(); employee.EdoCivil = reader["EDO_CIVIL"].ToString(); employee.EstadoEmpleado = reader["ESTADO"].ToString(); employee.LstDocumentos = new List <Documentacion>() { new Documentacion() { TipoDocto = "Acta Nacimiento", NombreDocto = "ACTA_NACIMIENTO.pdf" } , new Documentacion() { TipoDocto = "Curp", NombreDocto = "CURP.pdf" } , new Documentacion() { TipoDocto = "Comprobante Domicilio", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Identificación", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Comprobante Domicilio", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Imss", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Rfc", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Carta de Recomendación", NombreDocto = "DOMICILIO.pdf" } , new Documentacion() { TipoDocto = "Estado de cuenta", NombreDocto = "DOMICILIO.pdf" } }; employee.Sexo = reader["SEXO"].ToString(); employee.TRAMITE_INF_SN = reader["TRAMITE_INF_SN"].ToString(); employee.Etapa = reader["ETAPA"].ToString(); employee.Estudios = reader["ESTUDIOS"].ToString(); employee.Nivel_Estudios = reader["NIVEL ESTUDIOS"].ToString(); employee.Universidad = reader["UNIVERSIDAD"].ToString(); employee.Id_Jefe = reader["ID JEFE"].ToString(); employee.Nombre_jefe = reader["NOMBRE JEFE"].ToString(); employee.Ultimo_GradoEstudios = reader["ULT_GRADO_ESTUDIOS"].ToString(); employee.Estatus = reader["ESTATUS"] == DBNull.Value ? false : Convert.ToBoolean(reader["ESTATUS"]); lstEmployees.Add(employee); } } reader.Close(); resultado.Success = true; } catch (Exception e) { resultado.Success = false; resultado.ErrorMessage = String.Format("Se ha producido un error al procesar datos de archivo Error {0}", e.Message); } return(resultado); }
public Result UpdateEmployee(EmployeeValidador employeeValidador) { return(_employeeValidadorRepository.UpdateEmployee(employeeValidador)); }