public void Actualizar(InvClaseDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_ACTUALIZAR); db.AddInParameter(dbCommand, "@id_clase", DbType.Int32, obj.IdClase); db.AddInParameter(dbCommand, "@cod_clase", DbType.String, obj.CodClase); db.AddInParameter(dbCommand, "@nombre_clase", DbType.String, obj.NombreClase); db.AddInParameter(dbCommand, "@estado", DbType.String, obj.Estado); db.ExecuteNonQuery(dbCommand); }
public int Agregar(InvClaseDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_AGREGAR); db.AddInParameter(dbCommand, "@cod_clase", DbType.String, obj.CodClase); db.AddInParameter(dbCommand, "@nombre_clase", DbType.String, obj.NombreClase); db.AddInParameter(dbCommand, "@estado", DbType.String, obj.Estado); db.ExecuteNonQuery(dbCommand); dbCommand = db.GetSqlStringCommand("SELECT MAX(id_clase) FROM INV_CLASE"); int id = Convert.ToInt32(db.ExecuteScalar(dbCommand)); return id; }
protected void btnActualizar_Click(object sender, EventArgs e) { InvClaseDTO obj = new InvClaseDTO(); obj = objInvClaseDAO.ListarPorClave(Convert.ToInt32(this.txtId.Text)); obj.CodClase = this.txtCodigo.Text; obj.NombreClase = this.txtDescripcion.Text; if (this.chkEstado.Checked) obj.Estado = "1"; else obj.Estado = "0"; objInvClaseDAO.Actualizar(obj); }
protected void btnEliminar_Click(object sender, EventArgs e) { InvClaseDTO obj = new InvClaseDTO(); if (this.txtId.Text != "") { objInvClaseDAO.Eliminar(Convert.ToInt32(this.txtId.Text)); this.txtId.Text = ""; this.txtCodigo.Text = ""; this.txtDescripcion.Text = ""; this.chkEstado.Checked = true; } this.panRegistro.Visible = false; this.panLista.Visible = true; Listar(); }
protected void btnGrabar_Click(object sender, EventArgs e) { InvClaseDTO obj = new InvClaseDTO(); obj.CodClase = this.txtCodigo.Text; obj.NombreClase = this.txtDescripcion.Text; if (this.chkEstado.Checked) obj.Estado = "1"; else obj.Estado = "0"; int id = objInvClaseDAO.Agregar(obj); this.txtId.Text = id.ToString(); this.btnNuevo.Visible = false; this.btnActualizar.Visible = true; this.btnEliminar.Visible = true; this.panRegistro.Visible = true; this.panLista.Visible = false; }
public List<InvClaseDTO> Listar() { List<InvClaseDTO> Lista = new List<InvClaseDTO>(); Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_LISTAR); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { InvClaseDTO obj = new InvClaseDTO(); if (dr["id_clase"] != System.DBNull.Value) obj.IdClase = (int)dr["id_clase"]; if (dr["cod_clase"] != System.DBNull.Value) obj.CodClase = (string)dr["cod_clase"]; if (dr["nombre_clase"] != System.DBNull.Value) obj.NombreClase = (string)dr["nombre_clase"]; if (dr["estado"] != System.DBNull.Value) obj.Estado = (string)dr["estado"]; Lista.Add(obj); } } return Lista; }
public InvClaseDTO ListarPorClave(int IdClase) { InvClaseDTO obj = null; Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_LISTAR_POR_CLAVE); db.AddInParameter(dbCommand, "id_clase", DbType.Int32, IdClase); using (IDataReader dr = db.ExecuteReader(dbCommand)) { if (dr.Read()) { obj = new InvClaseDTO(); if (dr["id_clase"] != System.DBNull.Value) obj.IdClase = (int)dr["id_clase"]; if (dr["cod_clase"] != System.DBNull.Value) obj.CodClase = (string)dr["cod_clase"]; if (dr["nombre_clase"] != System.DBNull.Value) obj.NombreClase = (string)dr["nombre_clase"]; if (dr["estado"] != System.DBNull.Value) obj.Estado = (string)dr["estado"]; } } return obj; }