public List <RolesMenuItems> RolesMenuItemsGetAll()
{
List <RolesMenuItems> lstRolesMenuItems = new List <RolesMenuItems>();
try
{
ds = new DataSet();
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
string sqlSelect = "select * from Roles_Menu_Items ";
cmd = new OracleCommand(sqlSelect, cn);
adapter = new OracleDataAdapter(cmd);
cmd.ExecuteNonQuery();
adapter.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; dt.Rows.Count > i; i++)
{
DataRow dr = dt.Rows[i];
RolesMenuItems NewEnt = new RolesMenuItems();
NewEnt = CargarRolesMenuItems(dr);
lstRolesMenuItems.Add(NewEnt);
}
}
return(lstRolesMenuItems);
}
catch (Exception ex)
{
throw ex;
}
}
public RolesMenuItems RolesMenuItemsGetById(string IdRol, string IdMni)
{
try
{
DataSet ds = new DataSet();
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
string sqlSelect = "select * from Roles_Menu_Items " +
"WHERE ROL_CODIGO='" + IdRol + "' and MNI_CODIGO='" + IdMni + "' ";
cmd = new OracleCommand(sqlSelect, cn);
adapter = new OracleDataAdapter(cmd);
cmd.ExecuteNonQuery();
adapter.Fill(ds);
DataTable dt;
dt = ds.Tables[0];
RolesMenuItems NewEnt = new RolesMenuItems();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt = CargarRolesMenuItems(dr);
}
return(NewEnt);
}
catch (Exception ex)
{
throw ex;
}
}
private RolesMenuItems CargarRolesMenuItems(DataRow dr)
{
try
{
RolesMenuItems oObjeto = new RolesMenuItems();
oObjeto.RolCodigo = dr["ROL_CODIGO"].ToString();
oObjeto.MniCodigo = dr["MNI_CODIGO"].ToString();
oObjeto.RmiSoloLectura = dr["RMI_SOLO_LECTURA"].ToString();
return(oObjeto);
}
catch (Exception ex)
{
throw ex;
}
}
public bool RolesMenuItemsUpdate(RolesMenuItems oRolActual, RolesMenuItems oRolNuevo)
{
try
{
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
ds = new DataSet();
cmd = new OracleCommand("update Roles_Menu_Items " +
"SET RMI_SOLO_LECTURA='" + oRolNuevo.RmiSoloLectura + "' " +
"WHERE ROL_CODIGO='" + oRolActual.RolCodigo + "' and MNI_CODIGO='" + oRolActual.MniCodigo + "'", cn);
adapter = new OracleDataAdapter(cmd);
response = cmd.ExecuteNonQuery();
cn.Close();
return(response > 0);
}
catch (Exception ex)
{
throw ex;
}
}
public int RolesMenuItemsAdd(RolesMenuItems oRol)
{
try
{
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
ds = new DataSet();
cmd = new OracleCommand("insert into Roles_Menu_Items(ROL_CODIGO, " +
"MNI_CODIGO, RMI_SOLO_LECTURA) " +
"values('" + oRol.RolCodigo + "', '" +
oRol.MniCodigo + "', '" + oRol.RmiSoloLectura + "')", cn);
adapter = new OracleDataAdapter(cmd);
response = cmd.ExecuteNonQuery();
cn.Close();
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public int RolesMenuItemsAdd(RolesMenuItems oRolesMenuItems)
{
RolesMenuItemsImpl oRolesMenuItemsImp = new RolesMenuItemsImpl();
return(oRolesMenuItemsImp.RolesMenuItemsAdd(oRolesMenuItems));
}
public bool RolesMenuItemsUpdate(RolesMenuItems oRolesMenuItemsA, RolesMenuItems oRolesMenuItemsN)
{
RolesMenuItemsImpl oRolesMenuItemsImp = new RolesMenuItemsImpl();
return(oRolesMenuItemsImp.RolesMenuItemsUpdate(oRolesMenuItemsA, oRolesMenuItemsN));
}
