//Jorge Luis|26/12/2017|RW-103
/*Método para */
public void GetTotalForCajaBancos(bool moneda, int mesProceso)
{
String rootPath = Server.MapPath("~"); //Ruta física
string nameReport = "rptStdFncr";
string dbCompletePlan = paths.GetStringByFileJson("DataBaseConta", rootPath, Session["IdUser"].ToString(), nameReport, Request.QueryString["idCompany"].ToString(), Request.QueryString["year"].ToString());
string rubrosCompletePlan = paths.GetStringByFileJson("listNamesRubros", rootPath, Session["IdUser"].ToString(), nameReport, Request.QueryString["idCompany"].ToString(), Request.QueryString["year"].ToString());
QueriesCompleteDatabase queriesCompleteDatabase = new QueriesCompleteDatabase()
{
identificacionReporte = 1,
jsonDataSetDBComplete = dbCompletePlan,
jsonDataSetRubrosByFormatos = rubrosCompletePlan,
tipoMoneda = moneda,
mesProceso = mesProceso,
};
string cajaBancos = queriesCompleteDatabase.GetOnlyOneResult(1, "A105");
Session.Remove("CajaBancos");
Session["CajaBancos"] = Math.Round(decimal.Parse(cajaBancos), 2);
}
//Jorge Luis|26/12/2017|RW-103
/*Método para */
public void GetReport(bool moneda, int mesProceso)
{
String rootPath = Server.MapPath("~"); //Ruta física
string nameReport = "rptStdFncr";
string dbCompletePlan = paths.GetStringByFileJson("DataBaseConta", rootPath, Session["IdUser"].ToString(), nameReport, Request.QueryString["idCompany"].ToString(), Request.QueryString["year"].ToString());
string rubrosCompletePlan = paths.GetStringByFileJson("listNamesRubros", rootPath, Session["IdUser"].ToString(), nameReport, Request.QueryString["idCompany"].ToString(), Request.QueryString["year"].ToString());
QueriesCompleteDatabase queriesCompleteDatabase = new QueriesCompleteDatabase()
{
identificacionReporte = 1,
jsonDataSetDBComplete = dbCompletePlan,
jsonDataSetRubrosByFormatos = rubrosCompletePlan,
tipoMoneda = moneda,
mesProceso = mesProceso,
};
tableReport.DataSource = queriesCompleteDatabase.GenerateReportEstadosFinancieros();
tableReport.DataBind();
tableReport.UseAccessibleHeader = true;
tableReport.HeaderRow.TableSection = TableRowSection.TableHeader;
}
protected void Page_Load(object sender, EventArgs e)
{
// variables temporales
string user = "******";
string nameReport = "rptStdFncr";
string idCompany = /*"02"*/ /*"01"*/ "ff";;
string year = /*"2015"*/ /*"2015"*/ "2017";
String rootPath = Server.MapPath("~"); //Ruta física
string dbCompletePlan = paths.GetStringByFileJson("DataBaseConta", rootPath, user, nameReport, idCompany, year);
string rubrosCompletePlan = paths.GetStringByFileJson("listNamesRubros", rootPath, user, nameReport, idCompany, year);
QueriesCompleteDatabase queriesCompleteDatabase = new QueriesCompleteDatabase()
{
identificacionReporte = 1,
jsonDataSetDBComplete = dbCompletePlan,
jsonDataSetRubrosByFormatos = rubrosCompletePlan,
tipoMoneda = true,
mesProceso = 3,
};
string cajaBancos = queriesCompleteDatabase.GetOnlyOneResult(1, "A105");
}