public DataTable adminUser(RequestAdminUser request) { try { DataTable response = new DataTable(); SqlParameter[] param = new SqlParameter[13]; DataBase db = new DataBase(); param[0] = new SqlParameter("@id", request.id); param[1] = new SqlParameter("@idPerson", request.idPerson); param[2] = new SqlParameter("@loginName", request.loginName); param[3] = new SqlParameter("@personalKey", request.personalKey); param[4] = new SqlParameter("@attemps", request.attemps); param[5] = new SqlParameter("@name", request.name); param[6] = new SqlParameter("@idRole", request.idRole); param[7] = new SqlParameter("@stateRecord", request.stateRecord); param[8] = new SqlParameter("@userRegister", request.userRegister); param[9] = new SqlParameter("@dateRegister", request.dateRegister); param[10] = new SqlParameter("@userUpdate", request.userUpdate); param[11] = new SqlParameter("@dateUpdate", request.dateUpdate); param[12] = new SqlParameter("@flag", request.flag); response = db.executeDataTable("spAdminUser", param); return(response); } catch (Exception ex) { throw ex; } }
public ActionResult UpdateUser(ResponseAdminUserList item1, RequestAdminUser item2, ResponseAdminUserDetail item3, ResponseAdminUser item4) { if (ModelState.IsValid) { LogicAdminUser adm = new LogicAdminUser(); ResponseAdminUser response = new ResponseAdminUser(); item2.flag = 'M'; item2.dateUpdate = DateTime.Now; item2.userUpdate = Session["user"].ToString(); item2.userRegister = ""; response = adm.setUser(item2); if (response.code == 50000) { Session.Add("msgOk", response.message); } else { Session.Add("msgEr", response.message); } } return(RedirectToAction("User")); }
public ActionResult addUser(ResponseAdminUserList item1, RequestAdminUser item2, ResponseAdminUserDetail item3, ResponseAdminUser item4) { // Método para agregar Rol if (ModelState.IsValid) { LogicAdminUser adm = new LogicAdminUser(); item2.id = 0; item2.stateRecord = true; item2.flag = 'N'; item2.dateRegister = DateTime.Now; item2.userRegister = Session["user"].ToString(); item2.dateUpdate = DateTime.Now; item2.userUpdate = Session["user"].ToString(); item2.profession = 9; // Profesión genérica item4 = adm.setUser(item2); if (item4.code == 50000) { Session.Add("msgOk", item4.message); } else { Session.Add("msgEr", item4.message); } } Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response = new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(item1, item2, item3, item4); return(RedirectToAction("User")); }
public ActionResult UpdateUser(string id) { // Cargar los datos del usuario a modificar RequestAdminUser req = new RequestAdminUser(); ResponseAdminUserList res = new ResponseAdminUserList(); LogicAdminUser logic = new LogicAdminUser(); req.id = int.Parse(id); res = logic.getUserList(req); // Recuperar los campos de la persona RequestPerson reqPer = new RequestPerson(); ResponsePersonList resPer = new ResponsePersonList(); LogicAdminPerson logicPer = new LogicAdminPerson(); reqPer.id = res.lst[0].idPerson; resPer = logicPer.getPerson(reqPer); // Setear los campos del modelo req.attemps = res.lst[0].attemps; req.dateBorn = resPer.lst[0].dateBorn; req.dateRegister = res.lst[0].dateRegister; req.dateUpdate = res.lst[0].dateUpdate; req.document = resPer.lst[0].document; req.firstLastName = resPer.lst[0].firstLastName; req.firstName = resPer.lst[0].firstName; req.flag = 'M'; req.homeAddress = resPer.lst[0].homeAddress; req.homePhone = resPer.lst[0].homePhone; req.idRole = res.lst[0].idRole; req.idPerson = res.lst[0].idPerson; req.loginName = res.lst[0].loginName; req.movilPhone1 = resPer.lst[0].movilPhone1; req.movilPhone2 = resPer.lst[0].movilPhone2; req.name = res.lst[0].name; req.personalKey = res.lst[0].personalKey; req.profession = resPer.lst[0].profession; req.secondLastName = resPer.lst[0].secondLastName; req.secondName = resPer.lst[0].secondName; req.stateRecord = res.lst[0].stateRecord; req.typeDocument = resPer.lst[0].typeDocument; req.userRegister = res.lst[0].userRegister; req.userUpdate = res.lst[0].userUpdate; req.workPhone = resPer.lst[0].workPhone; req.workplace = resPer.lst[0].workplace; Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response = new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(res, req, null, null); return(View(response)); }
public ActionResult User() { // Obtener el listado de Usuarios RequestAdminUser req = new RequestAdminUser(); ResponseAdminUserList res = new ResponseAdminUserList(); LogicAdminUser logic = new LogicAdminUser(); req.id = 0; res = logic.getUserList(req); req.stateRecord = true; Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response = new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(res, null, null, null); return(View(response)); }
public ResponseAdminUser adminUser(RequestAdminUser request) { try { DataTable dt = new DataTable(); DataAdminUser datUser = new DataAdminUser(); ResponseAdminUser response = new ResponseAdminUser(); request.personalKey = LogicPrincipal.encryptSHA1(request.personalKey); dt = datUser.adminUser(request); if (dt != null) { if (dt.Rows.Count > 0) { response.code = int.Parse(dt.Rows[0]["code"].ToString()); response.message = dt.Rows[0]["message"].ToString(); response.status = int.Parse(dt.Rows[0]["state"].ToString()); } } return(response); } catch (System.Data.SqlClient.SqlException exSql) { // Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado throw exSql; } catch (Exception ex) { // Registrar el error real DataLogError datError = new DataLogError(); LogError error = new LogError(); error.module = "ADMIN"; error.method = "adminUser"; error.errorMessage = ex.Message; error.moreInfo = request.id.ToString(); datError.newError(error); // Modificar la excepción Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema."); throw exResult; } }
public DataTable getAdminUser(RequestAdminUser request) { try { DataTable response = new DataTable(); SqlParameter[] param = new SqlParameter[1]; DataBase db = new DataBase(); param[0] = new SqlParameter("@id", request.id); response = db.executeDataTable("spGetAdminUser", param); return(response); } catch (Exception ex) { throw ex; } }
public ResponseAdminUser adminUser(RequestAdminUser request) { ResponseAdminUser response = new ResponseAdminUser(); try { LogicAdminUser logicUser = new LogicAdminUser(); request.dateRegister = System.DateTime.Now; request.dateUpdate = System.DateTime.Now; response = logicUser.adminUser(request); } catch (System.Data.SqlClient.SqlException exSql) { // Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado response.code = exSql.ErrorCode; response.message = exSql.Message; response.status = exSql.State; } catch (Exception ex) { // Registrar el error real LogicLogError logicError = new LogicLogError(); LogError error = new LogError(); error.module = "ADMIN"; error.method = "adminUser"; error.errorMessage = ex.Message; error.moreInfo = request.id.ToString(); logicError.newError(error); response.code = -1; response.message = "Error no controlado, favor consultar con el administrador del sistema."; } return(response); }
public ResponseAdminUser setUser(RequestAdminUser req) { ResponseAdminUser rUser = new ResponseAdminUser(); ResponsePerson rPerson = new ResponsePerson(); try { LogicCommon com = new LogicCommon(); string json = ""; int idPerson = req.idPerson; int idUser = req.id; // Primero Registrar la persona if (req.flag != 'N') { req.id = idPerson; } json = com.HttpPost("Person/crudPerson", req); rPerson = JsonConvert.DeserializeObject <ResponsePerson>(json); if (rPerson.code == 50000) { if (req.flag == 'N') { req.idPerson = rPerson.status; } else { req.id = idUser; } // Completar el nombre completo para el usuario req.name = req.firstName + " "; req.name += req.secondName == null ? "" : req.secondName + " "; req.name += req.firstLastName == null ? "" : req.firstLastName + " "; req.name += req.secondLastName == null ? "" : req.secondLastName; req.name = req.name.Trim(); // Ahora registrar el usuario json = com.HttpPost("User/adminUser", req); rUser = JsonConvert.DeserializeObject <ResponseAdminUser>(json); // Revertir perfil de la persona, ya que no fue posible crear el usuario if (rUser.code != 50000) { } } else { rUser.code = -1; rUser.message = "Error creando el perfil de la persona, favor contactar con el administrador del sistema"; } return(rUser); } catch (Exception ex) { rUser.code = -1; rUser.message = ex.Message; } return(rUser); }
public ResponseAdminUserList getUserList(RequestAdminUser req) { ResponseAdminUserList response = new ResponseAdminUserList(); try { LogicCommon com = new LogicCommon(); string json = com.HttpPost("User/getAdminUser", req); response = JsonConvert.DeserializeObject <ResponseAdminUserList>(json); // Cargar el listado completo de Roles RequestAdminRole reqRole = new RequestAdminRole(); ResponseAdminRoleList resRole = new ResponseAdminRoleList(); LogicAdminRole logicRole = new LogicAdminRole(); List <SelectListItem> lstTmpRole = new List <SelectListItem>(); // Obtener el listado completo de Roles reqRole.id = 0; resRole = logicRole.getRoleList(reqRole); // Llenar el listado de Roles foreach (ResponseAdminRoleDetail r in resRole.lst) { lstTmpRole.Add(new SelectListItem { Text = r.detail, Value = r.id.ToString(), Selected = r.id == req.idRole ? true : false }); } // Agregar el listado de Roles response.lstRole = lstTmpRole; // Cargar el catálogo de tipos de documentos RequestAdminClsMaster reqCls = new RequestAdminClsMaster(); ResponseAdminClsMasterList resCls = new ResponseAdminClsMasterList(); LogicAdminClsMaster logicCls = new LogicAdminClsMaster(); List <SelectListItem> lstTmpCls = new List <SelectListItem>(); // Obtener el catálogo de tipos de documentos reqCls.catalogId = "TIPOSDOCUMENTO"; reqCls.child = true; resCls = logicCls.getClsMasterList(reqCls); // Llenar el listado de acuerdo al catálogo foreach (ResponseAdminClsMasterDetail r in resCls.lst) { lstTmpCls.Add(new SelectListItem { Text = r.detail, Value = r.id.ToString(), Selected = r.id == req.typeDocument ? true : false }); } // Agregar el listado del catálogo documentos response.lstTypeDocument = lstTmpCls; return(response); } catch (Exception ex) { response.code = -1; response.message = ex.Message; } return(response); }
public ResponseAdminUserList getAdminUserList(RequestAdminUser request) { try { DataTable dt = new DataTable(); DataAdminUser datUser = new DataAdminUser(); ResponseAdminUserDetail adminUser; ResponseAdminUserList response = new ResponseAdminUserList(); dt = datUser.getAdminUser(request); if (dt != null) { if (dt.Rows.Count > 0) { response.code = 1; response.message = "Se encontraron registros"; response.status = 1; response.lst = new List <ResponseAdminUserDetail>(); foreach (DataRow dr in dt.Rows) { adminUser = new ResponseAdminUserDetail(); adminUser.id = int.Parse(dr["id"].ToString()); adminUser.idPerson = int.Parse(dr["idPerson"].ToString()); adminUser.loginName = dr["loginName"].ToString(); adminUser.personalKey = dr["personalKey"].ToString(); adminUser.attemps = int.Parse(dr["attemps"].ToString()); adminUser.name = dr["name"].ToString(); adminUser.idRole = int.Parse(dr["idRole"].ToString()); adminUser.stateRecord = bool.Parse(dr["stateRecord"].ToString()); adminUser.userRegister = dr["userRegister"].ToString(); adminUser.dateRegister = DateTime.Parse(dr["dateRegister"].ToString()); adminUser.userUpdate = dr["userUpdate"].ToString(); adminUser.dateUpdate = DateTime.Parse(dr["dateUpdate"].ToString()); response.lst.Add(adminUser); } } else { response.code = 0; response.message = "No se encontraron registros"; response.status = 0; } } else { response.code = 0; response.message = "No se encontraron registros"; response.status = 0; } return(response); } catch (System.Data.SqlClient.SqlException exSql) { // Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado throw exSql; } catch (Exception ex) { // Registrar el error real DataLogError datError = new DataLogError(); LogError error = new LogError(); error.module = "ADMIN"; error.method = "getAdminUserList"; error.errorMessage = ex.Message; error.moreInfo = request.id.ToString(); datError.newError(error); // Modificar la excepción Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema."); throw exResult; } }