public void Actualizar(SCE_CATEGORIA_BE BE) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CATEGORIA_UPD"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CATEGORIA", BE.ID_CATEGORIA); cmd.Parameters.AddWithValue("@NOM_CATEGORIA", BE.NOM_CATEGORIA); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Insertar(string nombre) { try { BE = new SCE_CATEGORIA_BE(); BE.NOM_CATEGORIA = nombre; DA.SCE_CATEGORIA_DA DA = new DA.SCE_CATEGORIA_DA(usrLogin); DA.Insertar(BE); } catch (Exception ex) { throw ex; } }
public void Actualizar(int Id, string nombre) { try { BE = new SCE_CATEGORIA_BE(); BE.ID_CATEGORIA = Id; BE.NOM_CATEGORIA = nombre; DA.SCE_CATEGORIA_DA DA = new DA.SCE_CATEGORIA_DA(usrLogin); DA.Actualizar(BE); } catch (Exception ex) { throw ex; } }
public List <SCE_CATEGORIA_BE> ListarConf() { List <SCE_CATEGORIA_BE> lstBE = new List <SCE_CATEGORIA_BE>(); SCE_CATEGORIA_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CATEGORIA_SEL_CONF"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BE = new SCE_CATEGORIA_BE(); BE.ID_CATEGORIA = Convert.ToInt32(reader["ID_CATEGORIA"]); BE.NOM_CATEGORIA = Convert.ToString(reader["NOM_CATEGORIA"]); lstBE.Add(BE); } return(lstBE); } } } catch (Exception ex) { throw ex; } }
public SCE_CATEGORIA_BE ObtenerPorID(int Id) { SCE_CATEGORIA_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CATEGORIA_GET"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CATEGORIA", Id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { BE = new SCE_CATEGORIA_BE(); BE.ID_CATEGORIA = Convert.ToInt32(reader["ID_CATEGORIA"]); BE.NOM_CATEGORIA = Convert.ToString(reader["NOM_CATEGORIA"]); } return(BE); } } } catch (Exception ex) { throw ex; } }