public DataTable adminRoleApplication(RequestAdminRoleApplicationData request)
{
try
{
DataTable response = new DataTable();
SqlParameter[] param = new SqlParameter[1];
DataBase db = new DataBase();
param[0] = new SqlParameter("@tblRoleApplication", "tblRoleApplication");
param[0].Value = request.dtRoleApplication;
response = db.executeDataTable("spAdminRoleApplication", param);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
