public DataSet GetById(SqlConnection oConn, SqlTransaction oTran, Categoria oCategoria) { using (SqlDataAdapter adapter = new SqlDataAdapter()) { using (SqlCommand oComm = new SqlCommand()) { try { DataSet ds = new DataSet(); oComm.Connection = oTran != null ? oTran.Connection : oConn; oComm.Transaction = oTran; oComm.CommandType = CommandType.Text; oComm.CommandText = string.Format("SELECT [id],[nombre] FROM {0}.{1} WHERE id=@id", Constants.esquema, Constants.tablaCategorias); oComm.Parameters.AddWithValue("id",oCategoria.Id); adapter.SelectCommand = oComm; adapter.Fill(ds); return ds; } finally { } } } }
public void Insert(SqlConnection oConn, SqlTransaction oTran, Categoria oCategoria) { using (SqlCommand oComm = new SqlCommand()) { oComm.Connection = (oTran != null) ? oTran.Connection : oConn; oComm.Transaction = oTran; oComm.CommandType = CommandType.Text; oComm.CommandText = string.Format("INSERT INTO {0}.{1}(nombre) VALUES (@nombre)", Constants.esquema, Constants.tablaCategorias); oComm.Parameters.AddWithValue("@nombre", oCategoria.Nombre); oComm.ExecuteNonQuery(); } }
public DataSet GetCategoriaById(Categoria oCategoria) { SqlConnection oConn = new SqlConnection(Constants.connectionString); oConn.Open(); try { using (CategoriaDataAccess tDataAccess = new CategoriaDataAccess()) { return tDataAccess.GetById(oConn, null, oCategoria); } } finally { oConn.Close(); } }
protected void Publicar_Categoria(object sender, EventArgs e) { if (Page.IsValid) { var oCategoria = new Categoria() { Nombre = txt_nombre.Text }; try { new CategoriaBusiness().InsertCategoria(oCategoria); lbl_resultado.Text = "Categoria publicada correctamente"; } catch(Exception ex) { lbl_resultado.Text = "Hubo un error: "+ex.Message; } } else { lbl_resultado.Text = "Por favor, complete los campos obligatorios del formulario"; } }
public void InsertCategoria(Categoria oCategoria) { SqlConnection oConn = new SqlConnection(Constants.connectionString); oConn.Open(); SqlTransaction oTran = oConn.BeginTransaction(); try { using (CategoriaDataAccess tDataAccess = new CategoriaDataAccess()) { tDataAccess.Insert(oConn, oTran, oCategoria); } oTran.Commit(); } catch (Exception ex) { oTran.Rollback(); throw ex; } finally { oConn.Close(); oTran.Dispose(); } }