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);
}
}
}
