private void cmdFinalizar_Click(object sender, EventArgs e) { cmd = new SqlCommand("ROAD_TO_PROYECTO.Finalizar_Publicacion", db.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PubliId", SqlDbType.Int).Value = (int)dgPublis[0, fila].Value; cmd.ExecuteNonQuery(); MessageBox.Show("Publicación finalizada"); cmd = new SqlCommand("ROAD_TO_PROYECTO.Buscar_Ultima_Factura", db.Connection); cmd.CommandType = CommandType.StoredProcedure; sdr = cmd.ExecuteReader(); while (sdr.Read()) { factId = int.Parse(sdr["FactNro"].ToString()); } sdr.Close(); dgPublis.Visible = false; cmdActivar.Visible = false; cmdModificar.Visible = false; cmdFinalizar.Visible = false; WindowsFormsApplication1.ComprarOfertar.Facturar factura = new WindowsFormsApplication1.ComprarOfertar.Facturar(); factura.factId = factId; factura.publId = int.Parse(dgPublis[0, fila].Value.ToString()); factura.esPorConsulta = 0; factura.Show(); this.Hide(); }
private void cmdFinalizar_Click(object sender, EventArgs e) { cmd = new SqlCommand("ROAD_TO_PROYECTO.Usuario_Nuevo", db.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Usuario", SqlDbType.Int).Value = user; sdr = cmd.ExecuteReader(); while (sdr.Read()) { esNuevo = int.Parse(sdr["Nuevo"].ToString()); } sdr.Close(); cmd = new SqlCommand("ROAD_TO_PROYECTO.Visibilidad_Publicacion", db.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PubliId", SqlDbType.Int).Value = (int)dgPublis[0, fila].Value; sdr = cmd.ExecuteReader(); while (sdr.Read()) { visibPubli = sdr["Descripcion"].ToString(); } sdr.Close(); cmd = new SqlCommand("ROAD_TO_PROYECTO.Finalizar_Publicacion", db.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PubliId", SqlDbType.Int).Value = (int)dgPublis[0, fila].Value; cmd.Parameters.AddWithValue("@FechaActual", SqlDbType.DateTime).Value = Fecha.getFechaActual(); cmd.ExecuteNonQuery(); MessageBox.Show("Se finalizó la publicación", "Sr.Usuario", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); dgPublis.Visible = false; cmdActivar.Visible = false; cmdModificar.Visible = false; cmdPausar.Visible = false; cmdFinalizar.Visible = false; if (esNuevo == 0 && !(visibPubli == "Gratis")) { cmd = new SqlCommand("ROAD_TO_PROYECTO.Buscar_Ultima_Factura", db.Connection); cmd.CommandType = CommandType.StoredProcedure; sdr = cmd.ExecuteReader(); while (sdr.Read()) { factId = int.Parse(sdr["FactNro"].ToString()); } sdr.Close(); WindowsFormsApplication1.ComprarOfertar.Facturar factura = new WindowsFormsApplication1.ComprarOfertar.Facturar(); factura.factId = factId; factura.publId = int.Parse(dgPublis[0, fila].Value.ToString()); factura.esPorConsulta = 0; factura.Show(); this.Hide(); } }
private void cmdVerFactura_Click(object sender, EventArgs e) { int fila = dataGridView1.CurrentRow.Index; WindowsFormsApplication1.ComprarOfertar.Facturar factura = new WindowsFormsApplication1.ComprarOfertar.Facturar(); factura.factId = int.Parse(dataGridView1[0, fila].Value.ToString()); factura.publId = int.Parse(dataGridView1[1, fila].Value.ToString()); factura.esPorConsulta = 1; factura.Show(); this.Hide(); }