public static eSubMenu getItem(System.Int16 IdSMenu)
{
SqlCommand cmd = new SqlCommand("pADM_SubMenu_select");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdSMenu", SqlDbType.SmallInt).Value = IdSMenu;
SqlDataReader reader = ExecuteReader(cmd);
eSubMenu oSubMenu = new eSubMenu();
if (reader.Read())
{
oSubMenu.IdSMenu = reader.GetInt16(0);
oSubMenu.IdMenu = reader.GetByte(1);
oSubMenu.Descripcion = reader.GetString(2);
if (!reader[3].Equals(DBNull.Value))
{
oSubMenu.Posicion = reader.GetInt16(3);
}
oSubMenu.Activo = reader.GetBoolean(4);
}
reader.Close();
return(oSubMenu);
}
public static List <eSubMenu> GetList(Byte IdMenu)
{
SqlCommand cmd = new SqlCommand("pADM_SubMenu_list");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdMenu", SqlDbType.TinyInt).Value = IdMenu;
SqlDataReader reader = ExecuteReader(cmd);
List <eSubMenu> lSubMenu = new List <eSubMenu>();
while (reader.Read())
{
eSubMenu oSubMenu = new eSubMenu();
oSubMenu.IdSMenu = reader.GetInt16(0);
oSubMenu.IdMenu = reader.GetByte(1);
oSubMenu.Descripcion = reader.GetString(2);
if (!reader[3].Equals(DBNull.Value))
{
oSubMenu.Posicion = reader.GetInt16(3);
}
oSubMenu.Activo = reader.GetBoolean(4);
lSubMenu.Add(oSubMenu);
}
reader.Close();
return(lSubMenu);
}
public static int Update(eSubMenu oSubMenu)
{
SqlCommand cmd = new SqlCommand("pADM_SubMenu_update");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdSMenu", SqlDbType.SmallInt).Value = oSubMenu.IdSMenu;
cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 50).Value = oSubMenu.Descripcion;
cmd.Parameters.Add("@Activo", SqlDbType.Bit).Value = oSubMenu.Activo;
return(UpdateCommand(cmd));
}
public static int Insert(eSubMenu oSubMenu)
{
SqlCommand cmd = new SqlCommand("pADM_SubMenu_insert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdMenu", SqlDbType.TinyInt).Value = oSubMenu.IdMenu;
cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 50).Value = oSubMenu.Descripcion;
cmd.Parameters.Add("@Activo", SqlDbType.Bit).Value = oSubMenu.Activo;
return(InsertCommand(cmd, true));
}
public bool SubMenu_edit(eSubMenu oSubMenu)
{
bool isEdit = false;
IdException = cSubMenu.Update(oSubMenu);
if (IdException == 0)
{
isEdit = true;
}
return(isEdit);
}
public int SubMenu_add(eSubMenu oSubMenu)
{
int addNew = 0;
IdException = cSubMenu.Insert(oSubMenu);
if (IdException == 0)
{
addNew = cSubMenu.getLastID;
}
return(addNew);
}
