public ResponsePersonCrudList getPerson(RequestPersonCrud request) { ResponsePersonCrudList response = new ResponsePersonCrudList(); try { LogicPersonCrud logicPerson = new LogicPersonCrud(); response = logicPerson.getPersonCrudList(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 = "PERSON"; error.method = "getPerson"; 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."; response.status = -1; } return(response); }
public ResponsePersonCrudList getPersonCrudList(RequestPersonCrud request) { try { DataTable dt = new DataTable(); DataPersonCrud datPerson = new DataPersonCrud(); ResponsePersonCrudDetail personCrud; ResponsePersonCrudList response = new ResponsePersonCrudList(); dt = datPerson.getPersonCrud(request); if (dt != null) { if (dt.Rows.Count > 0) { response.code = 1; response.message = "Se encontraron registros"; response.status = 1; response.lst = new List <ResponsePersonCrudDetail>(); foreach (DataRow dr in dt.Rows) { personCrud = new ResponsePersonCrudDetail(); personCrud.id = int.Parse(dr["id"].ToString()); personCrud.firstName = dr["firstName"].ToString(); personCrud.secondName = dr["secondName"].ToString(); personCrud.firstLastName = dr["firstLastName"].ToString(); personCrud.secondLastName = dr["secondLastName"].ToString(); personCrud.dateBorn = DateTime.Parse(dr["dateBorn"].ToString()); personCrud.typeDocument = int.Parse(dr["typeDocument"].ToString()); personCrud.document = dr["document"].ToString(); personCrud.homeAddress = dr["homeAddress"].ToString(); personCrud.homePhone = dr["homePhone"].ToString(); personCrud.workPhone = dr["workPhone"].ToString(); personCrud.movilPhone1 = dr["movilPhone1"].ToString(); personCrud.movilPhone2 = dr["movilPhone2"].ToString(); personCrud.profession = int.Parse(dr["profession"].ToString()); personCrud.workplace = dr["workplace"].ToString(); personCrud.stateRecord = bool.Parse(dr["stateRecord"].ToString()); personCrud.userRegister = dr["userRegister"].ToString(); personCrud.dateRegister = DateTime.Parse(dr["dateRegister"].ToString()); personCrud.userUpdate = dr["userUpdate"].ToString(); personCrud.dateUpdate = DateTime.Parse(dr["dateUpdate"].ToString()); response.lst.Add(personCrud); } } 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 = "PERSON"; error.method = "getPersonCrudList"; 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; } }