public ResponsePersonCrud personCrud(RequestPersonCrud request) { try { DataTable dt = new DataTable(); DataPersonCrud datPerson = new DataPersonCrud(); ResponsePersonCrud response = new ResponsePersonCrud(); dt = datPerson.personCrud(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 = "PERSON"; error.method = "personCrud"; 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 getPersonCrud(RequestPersonCrud 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("spGetPersonCrud", param); return(response); } catch (Exception ex) { throw ex; } }
public DataTable personCrud(RequestPersonCrud request) { try { DataTable response = new DataTable(); SqlParameter[] param = new SqlParameter[21]; DataBase db = new DataBase(); param[0] = new SqlParameter("@id", request.id); param[1] = new SqlParameter("@firstName", request.firstName); param[2] = new SqlParameter("@secondName", request.secondName); param[3] = new SqlParameter("@firstLastName", request.firstLastName); param[4] = new SqlParameter("@secondLastName", request.secondLastName); param[5] = new SqlParameter("@dateBorn", request.dateBorn); param[6] = new SqlParameter("@typeDocument", request.typeDocument); param[7] = new SqlParameter("@document", request.document); param[8] = new SqlParameter("@homeAddress", request.homeAddress); param[9] = new SqlParameter("@homePhone", request.homePhone); param[10] = new SqlParameter("@workPhone", request.workPhone); param[11] = new SqlParameter("@movilPhone1", request.movilPhone1); param[12] = new SqlParameter("@movilPhone2", request.movilPhone2); param[13] = new SqlParameter("@profession", request.profession); param[14] = new SqlParameter("@workplace", request.workplace); param[15] = new SqlParameter("@stateRecord", request.stateRecord); param[16] = new SqlParameter("@userRegister", request.userRegister); param[17] = new SqlParameter("@dateRegister", request.dateRegister); param[18] = new SqlParameter("@userUpdate", request.userUpdate); param[19] = new SqlParameter("@dateUpdate", request.dateUpdate); param[20] = new SqlParameter("@flag", request.flag); response = db.executeDataTable("spPersonCrud", param); return(response); } catch (Exception ex) { throw ex; } }
public ResponsePersonCrud crudPerson(RequestPersonCrud request) { ResponsePersonCrud response = new ResponsePersonCrud(); try { LogicPersonCrud logicPerson = new LogicPersonCrud(); request.dateRegister = System.DateTime.Now; request.dateUpdate = System.DateTime.Now; response = logicPerson.personCrud(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 = "crudPerson"; 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 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; } }