public ResponseAdminClsMaster adminClsMaster(RequestAdminClsMaster request)
{
try
{
DataTable dt = new DataTable();
DataAdminClsMaster dat = new DataAdminClsMaster();
ResponseAdminClsMaster response = new ResponseAdminClsMaster();
if (request.subValue == null)
{
request.subValue = "";
}
if (request.detail == null)
{
request.detail = "";
}
dt = dat.adminClsMaster(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 = "adminClsMaster";
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 bool validateUser(string user, string password, ref string userName)
{
try
{
object objresponse = new object();
bool response = false;
DataAdminUser datUser = new DataAdminUser();
string passwordEncrypt = LogicPrincipal.encryptSHA1(password);
objresponse = datUser.validateUser(user, passwordEncrypt);
if (objresponse != null)
{
if (objresponse.ToString().Split('|')[0] == "OK")
{
userName = objresponse.ToString().Split('|')[1];
response = true;
}
}
return(response);
}
catch (Exception ex)
{
// Registrar el error real
DataLogError datError = new DataLogError();
LogError error = new LogError();
error.module = "LOGIN";
error.method = "validateUser";
error.errorMessage = ex.Message;
error.moreInfo = user + "\\" + password;
datError.newError(error);
// Modificar la excepción
Exception exResult = new Exception("Error validando usuario API");
throw exResult;
}
}
public bool validateUserApi(string user, string password)
{
try
{
object objresponse = new object();
bool response = false;
DataAdminUserApi datUserApi = new DataAdminUserApi();
objresponse = datUserApi.validateUserApi(user, password);
if (objresponse != null)
{
if (objresponse.ToString() == "ok")
{
response = true;
}
}
return(response);
}
catch (Exception ex) {
// Registrar el error real
DataLogError datError = new DataLogError();
LogError error = new LogError();
error.module = "ADMIN";
error.method = "validateUserApi";
error.errorMessage = ex.Message;
error.moreInfo = null;
datError.newError(error);
// Modificar la excepción
Exception exResult = new Exception("Error validando usuario API");
throw exResult;
}
}
public ResponseAdminRoleList getAdminRoleList(RequestAdminRole request)
{
try
{
DataTable dt = new DataTable();
DataAdminRole datRole = new DataAdminRole();
ResponseAdminRoleDetail adminRole;
ResponseAdminRoleList response = new ResponseAdminRoleList();
dt = datRole.getAdminRole(request);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
response.code = 1;
response.message = "Se encontraron registros";
response.status = 1;
response.lst = new List <ResponseAdminRoleDetail>();
foreach (DataRow dr in dt.Rows)
{
adminRole = new ResponseAdminRoleDetail();
adminRole.id = int.Parse(dr["id"].ToString());
adminRole.name = dr["name"].ToString();
adminRole.detail = dr["detail"].ToString();
adminRole.stateRecord = bool.Parse(dr["stateRecord"].ToString());
adminRole.userRegister = dr["userRegister"].ToString();
adminRole.dateRegister = DateTime.Parse(dr["dateRegister"].ToString());
adminRole.userUpdate = dr["userUpdate"].ToString();
adminRole.dateUpdate = DateTime.Parse(dr["dateUpdate"].ToString());
response.lst.Add(adminRole);
}
}
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 = "getAdminRoleList";
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 void newError(LogError error)
{
DataLogError dataError = new DataLogError();
dataError.newError(error);
}
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;
}
}
public ResponseAdminRoleApplication adminRoleApplication(RequestAdminRoleApplicationList request)
{
try
{
DataTable dt = new DataTable();
DataTable dtRoleApp = LogicPrincipal.makeDt("id,idRole,idApplication,stateRecord,userRegister,dateRegister,userUpdate,dateUpdate,flag");
DataAdminRoleApplication datRoleApplication = new DataAdminRoleApplication();
RequestAdminRoleApplicationData requesData = new RequestAdminRoleApplicationData();
ResponseAdminRoleApplication response = new ResponseAdminRoleApplication();
// Transformar la lista a un DataTable
foreach (RequestAdminRoleApplication i in request.lst)
{
DataRow r = dtRoleApp.NewRow();
r["id"] = i.id.ToString();
r["idRole"] = i.idRole.ToString();
r["idApplication"] = i.idApplication.ToString();
r["stateRecord"] = i.stateRecord.ToString();
r["userRegister"] = i.userRegister.ToString();
r["dateRegister"] = i.dateRegister.ToString();
r["userUpdate"] = i.userUpdate.ToString();
r["dateUpdate"] = i.dateUpdate.ToString();
r["flag"] = "N";
dtRoleApp.Rows.Add(r);
}
requesData.dtRoleApplication = dtRoleApp;
dt = datRoleApplication.adminRoleApplication(requesData);
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 = "adminRoleApplication";
error.errorMessage = ex.Message;
error.moreInfo = "";
datError.newError(error);
// Modificar la excepción
Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema.");
throw exResult;
}
}
