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