public ClaseBEAN BuscarClaseId(int id) { ClaseBEAN oClase = new ClaseBEAN(); try { using (var con = new SqlConnection(_StringConnection)) { using (var cmd = new SqlCommand("SP_BuscarClaseId", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idClase", id); con.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.Read()) { oClase = new ClaseBEAN(); oClase.IdClase = Convert.ToInt32(dr[0]); oClase.NombClase = Convert.ToString(dr[1]); oClase.IdCat = Convert.ToInt32(dr[2]); } } } } } catch (Exception ex) { throw ex; } return(oClase); }
public List <ClaseBEAN> ListarClase() { List <ClaseBEAN> lista = new List <ClaseBEAN>(); ClaseBEAN oClase; try { using (var conn = new SqlConnection(_StringConnection)) { using (var cmd = new SqlCommand("sp_ListClase", conn)) { cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { oClase = new ClaseBEAN(); oClase.IdClase = Convert.ToInt32(dr[0]); oClase.NombClase = Convert.ToString(dr[1]); oClase.NombreCat = Convert.ToString(dr[2]); lista.Add(oClase); } } } } } catch (Exception ex) { throw ex; } return(lista); }
public ClaseBEAN ActualizarCategoria(ClaseBEAN oClase) { try { using (var con = new SqlConnection(_StringConnection)) { using (var cmd = new SqlCommand("SP_Update_Clase", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idClase", oClase.IdClase); cmd.Parameters.AddWithValue("@nombreClase", oClase.NombClase); cmd.Parameters.AddWithValue("@idCat", oClase.IdCat); con.Open(); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } return(oClase); }
public List <ClaseBEAN> RegistrarClase(ClaseBEAN oClaseBean) { List <ClaseBEAN> lista = new List <ClaseBEAN>(); try { using (var con = new SqlConnection(_StringConnection)) { using (var cmd = new SqlCommand("InstertClase", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nombreClase", oClaseBean.NombClase); cmd.Parameters.AddWithValue("@IdCat", oClaseBean.IdCat); con.Open(); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } return(lista); }