public void Borrar() { AsignaturaCategoria fac = new AsignaturaCategoria(); fac.Id = Convert.ToInt32(this.txtId.Text); db.borrarAsignaturaCategoria(fac); cargarDataGrid(); edicion(false); }
public bool Guardar() { edicion(false); if (this.txtId.Text == "") { /*------------INSERTAR AsignaturaCategoria----------------*/ if (this.txtDescripcion.Text != "") { AsignaturaCategoria fac = new AsignaturaCategoria(); fac.Descripcion = this.txtDescripcion.Text; insertAsignaturaCategoria(fac); this.dgAsignaturaCategorias.Enabled = true; cargarDataGrid(); this.txtId.DataBindings.Add("Text", AsignaturaCategoriasBindingSource, "Id"); this.txtDescripcion.DataBindings.Add("Text", AsignaturaCategoriasBindingSource, "Descripcion"); this.AsignaturaCategoriasBindingSource.MoveLast(); return true; } else { MessageBox.Show("Descripción no puede estar vacio.", "Error", MessageBoxButtons.OK); return false; } /*---------FIN INSERTAR AsignaturaCategoria----------------*/ } else { /*------------Actualizar AsignaturaCategoria----------------*/ if (this.txtDescripcion.Text != "") { AsignaturaCategoria fac = new AsignaturaCategoria(); fac.Id = Convert.ToInt32(this.txtId.Text); fac.Descripcion = this.txtDescripcion.Text; actualizarAsignaturaCategoria(fac); this.dgAsignaturaCategorias.Enabled = true; cargarDataGrid(); return true; } else { MessageBox.Show("Descripción no puede estar vacio","Error",MessageBoxButtons.OK); return false; } /*---------FIN Actualizar AsignaturaCategoria----------------*/ } }
public Boolean insertAsignaturaCategoria(AsignaturaCategoria AsignaturaCategoria) { this.connection.Open(); this.command = this.connection.CreateCommand(); this.transaction = this.connection.BeginTransaction(); this.command.Connection = this.connection; this.command.Transaction = this.transaction; try { this.command.CommandText = "insert into asignatura_categoria(Descripcion) values(@descripcion);" + "SELECT CAST(scope_identity() AS int)"; this.command.Parameters.Add(new SqlParameter("@descripcion", SqlDbType.NVarChar, 50)); this.command.Parameters["@descripcion"].Value = AsignaturaCategoria.Descripcion; this.lastUpdated = this.command.ExecuteScalar().ToString(); this.transaction.Commit(); return true; } catch (Exception e) { try { transaction.Rollback(); throw new Exception("Error al insertar registro. " + e.Message); return false; } catch (Exception ex) { throw new Exception("Error al roolback accion. " + ex.Message); } } finally { this.connection.Close(); } }
public Boolean actualizarAsignaturaCategoria(AsignaturaCategoria AsignaturaCategoria) { this.connection.Open(); this.command = this.connection.CreateCommand(); this.transaction = this.connection.BeginTransaction(); this.command.Connection = this.connection; this.command.Transaction = this.transaction; try { this.command.CommandText = "Update asignatura_categoria set descripcion=@descripcion where id_categoria=@id;"; this.command.Parameters.Add(new SqlParameter("@descripcion", SqlDbType.NVarChar, 50)); this.command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); this.command.Parameters["@descripcion"].Value = AsignaturaCategoria.Descripcion; this.command.Parameters["@id"].Value = AsignaturaCategoria.Id; this.command.ExecuteNonQuery(); this.transaction.Commit(); return true; } catch (Exception e) { try { this.transaction.Rollback(); throw new Exception("Error al Actualizar." + e.Message); return false; } catch (Exception ex) { throw new Exception("Error al rollback accion." + ex.Message); return false; } } finally { this.connection.Close(); } }
/*--------------------FIN CATALOGO PeriodoS------------------------*/ /*--------------------Catalogo de AsignaturaCategorias-------------------------*/ public List<AsignaturaCategoria> getAsignaturaCategorias() { SqlDataReader dataReader = null; List<AsignaturaCategoria> AsignaturaCategorias = new List<AsignaturaCategoria>(); try { string query = "Select * from asignatura_categoria"; command = new SqlCommand(query, connection); command.Connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { AsignaturaCategoria edi = new AsignaturaCategoria(); edi.Id = Convert.ToInt32(dataReader["id_categoria"].ToString()); edi.Descripcion = dataReader["descripcion"].ToString(); AsignaturaCategorias.Add(edi); } return AsignaturaCategorias; } catch (Exception e) { throw new Exception("Error al obtener datos de AsignaturaCategoria. " + e.Message.ToString()); } finally { command.Connection.Close(); } }
public Boolean borrarAsignaturaCategoria(AsignaturaCategoria AsignaturaCategoria) { this.connection.Open(); this.command = this.connection.CreateCommand(); this.transaction = this.connection.BeginTransaction(); this.command.Connection = this.connection; this.command.Transaction = this.transaction; try { this.command.CommandText = "delete from asignatura_categoria where id_categoria=@id;"; this.command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); this.command.Parameters["@id"].Value = AsignaturaCategoria.Id; this.command.ExecuteNonQuery(); this.transaction.Commit(); return true; } catch (Exception e) { try { this.transaction.Rollback(); throw new Exception("Error al borrar registro. " + e.Message); return false; } catch (Exception ex) { throw new Exception("Error al rollback acción. " + ex.Message); return false; } } finally { this.connection.Close(); } }
private bool insertAsignaturaCategoria(AsignaturaCategoria fac) { try { db.insertAsignaturaCategoria(fac); } catch (Exception e) { MessageBox.Show(e.Message); } return true; }
private bool actualizarAsignaturaCategoria(AsignaturaCategoria fac) { try { db.actualizarAsignaturaCategoria(fac); } catch (Exception e) { MessageBox.Show(e.Message); } return true; }