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