public void verRecibosPorPagar() { GridViewRecibosPendientes2.Columns[0].Visible = true; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connDB"].ConnectionString)) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@InNumFinca", SqlDbType.VarChar).Value = labelID; cmd.CommandText = "SPSRecibosPendientes"; cmd.Connection = conn; conn.Open(); GridViewRecibosPendientes2.DataSource = cmd.ExecuteReader(); GridViewRecibosPendientes2.DataBind(); labelTitulo.InnerText = "Finca número: " + labelID; botonVolver1.Visible = true; ccConversor(1, 1); } catch (SqlException ex) { ShowMessage(ex.Errors[0].Message); ccConversor(1, 1); } } }
public void enviarRecibosPriori() { ccConversor(0, 1); DataTable tabla = getTablaRecibosPendientes(0); string JSON = DataTableToJSONWithStringBuilder(tabla); if (!checkSelectionsDone()) { ccConversor(1, 1); return; } ButtonCotizar.Visible = false; labelTitulo.InnerText = "Detalles con Intereses Calculados"; labelTitulo.Visible = true; GridViewRecibosPendientes2.Columns[0].Visible = false; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connDB"].ConnectionString)) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SPGenerarInteresesMoratorios"; cmd.Parameters.Add("@JSONRecibos", SqlDbType.VarChar).Value = JSON; cmd.Connection = conn; conn.Open(); GridViewRecibosPendientes2.DataSource = cmd.ExecuteReader(); GridViewRecibosPendientes2.DataBind(); labelMontoTotalCotiz.Text = "Monto Total: ₡" + String.Format("{0:0.00}", obtenerMonto()); labelMontoTotalCotiz.Visible = true; GridViewRecibosPendientes2.Columns[0].Visible = false; ButtonArregloPago.Visible = true; ButtonPagar.Visible = true; ButtonCancelar.Visible = true; ccConversor(1, 1); } catch (SqlException ex) { ShowMessage(ex.Errors[0].Message); ccConversor(1, 1); } } }