public void getChartData(long vOrderId, string opc) { string vXmlData = ""; StringBuilder sb = new StringBuilder(); StringBuilder sbData2 = new StringBuilder(); try { System.DateTime vFecha; string vImpredia = ""; string vClicsdia = ""; System.DateTime st = new System.DateTime(); var vFechaConvert = GetUnixEpoch(st); DataTable dataTable = new DataTable(); Decimal vDecimal = 0; Decimal vDecTot = 0; Decimal vDecClic = 0; string vTotImpresiones = ""; string vTotClics = ""; string vCTR = ""; LitTitulo.Text = ""; LitGrafInfo.Text = ""; dataTable = vReport.ReportWithFilter(vOrderId, opc); if (dataTable.Rows.Count > 0) { sb.Append("["); sbData2.Append("["); int i = 0; int tam = dataTable.Rows.Count - 1; foreach (DataRow dr in dataTable.Rows) { vFecha = Convert.ToDateTime(dataTable.Rows[i][2]); st = new System.DateTime(vFecha.Year, vFecha.Month, vFecha.Day, 0, 0, 0, DateTimeKind.Utc); vFechaConvert = GetUnixEpoch(st); vImpredia = Convert.ToString(dataTable.Rows[i][3]); vClicsdia = Convert.ToString(dataTable.Rows[i][4]); vDecTot += Convert.ToDecimal(dataTable.Rows[i][3]); vDecClic += Convert.ToDecimal(dataTable.Rows[i][4]); //vDecimal += Convert.ToDecimal(dataTable.Rows[i][5]); //if (i < 20) if (i < tam) { sb.Append("[" + Convert.ToString(vFechaConvert) + ", " + vImpredia + "],"); sbData2.Append("[" + Convert.ToString(vFechaConvert) + ", " + vClicsdia + "],"); } else { sb.Append("[" + Convert.ToString(vFechaConvert) + ", " + vImpredia + "]"); sbData2.Append("[" + Convert.ToString(vFechaConvert) + ", " + vClicsdia + "]"); } i++; } sb.Append("]"); sbData2.Append("]"); //LitTitulo.Text = " Ordén " + Convert.ToString(dataTable.Rows[0][0]); LitTitulo.Text = " Campaña " + Convert.ToString(dataTable.Rows[0][0]); vDecimal = (Convert.ToDecimal(vDecClic) / Convert.ToDecimal(vDecTot)); vTotImpresiones = vDecTot.ToString("0,0"); vTotClics = vDecClic.ToString("0,0"); vCTR = vDecimal.ToString("P"); LitImpGrafico.Text = vTotImpresiones; LitClicsGrafico.Text = vTotClics; LitCTRgrafico.Text = vCTR; LitGrafInfo.Text = ""; } else { LitTitulo.Text = ""; LitImpGrafico.Text = ""; LitClicsGrafico.Text = ""; LitCTRgrafico.Text = ""; sbData2 = sbData2.Clear(); sb = sb.Clear(); if (!IsPostBack) { LitGrafInfo.Text = "No se pudo obtener información " + "Intente con una búsqueda de las opciones"; } else { LitGrafInfo.Text = "No se encontró información para esta búsqueda " + "Intente con otra diferente"; } } lblData2.Text = Convert.ToString(sbData2); lblData3.Text = Convert.ToString(sb); } catch (Exception ex) { throw; } //return vXmlData; }
public void getChartData(long vOrderId, string opc) { string vXmlData = ""; StringBuilder sb = new StringBuilder(); StringBuilder sbData2 = new StringBuilder(); try { System.DateTime vFecha; string vImpredia = ""; string vClicsdia = ""; System.DateTime st = new System.DateTime(); var vFechaConvert = GetUnixEpoch(st); DataTable dataTable = new DataTable(); Decimal vDecimal = 0; Decimal vDecTot = 0; Decimal vDecClic = 0; string vTotImpresiones = ""; string vTotClics = ""; string vCTR = ""; LitTitulo.Text = ""; LitGrafInfo.Text = ""; dataTable = vReport.ReportWithFilter(vOrderId, opc); if (dataTable.Rows.Count > 0) { sb.Append("["); sbData2.Append("["); int i = 0; int tam = dataTable.Rows.Count - 1; foreach (DataRow dr in dataTable.Rows) { vFecha = Convert.ToDateTime(dataTable.Rows[i][2]); st = new System.DateTime(vFecha.Year, vFecha.Month, vFecha.Day, 0, 0, 0, DateTimeKind.Utc); vFechaConvert = GetUnixEpoch(st); vImpredia = Convert.ToString(dataTable.Rows[i][3]); vClicsdia = Convert.ToString(dataTable.Rows[i][4]); vDecTot += Convert.ToDecimal(dataTable.Rows[i][3]); vDecClic += Convert.ToDecimal(dataTable.Rows[i][4]); //vDecimal += Convert.ToDecimal(dataTable.Rows[i][5]); //if (i < 20) if (i < tam) { sb.Append("[" + Convert.ToString(vFechaConvert) + ", " + vImpredia + "],"); sbData2.Append("[" + Convert.ToString(vFechaConvert) + ", " + vClicsdia + "],"); } else { sb.Append("[" + Convert.ToString(vFechaConvert) + ", " + vImpredia + "]"); sbData2.Append("[" + Convert.ToString(vFechaConvert) + ", " + vClicsdia + "]"); } i++; } sb.Append("]"); sbData2.Append("]"); LitTitulo.Text = " Campaña " + Convert.ToString(dataTable.Rows[0][0]); vDecimal = (Convert.ToDecimal(vDecClic) / Convert.ToDecimal(vDecTot)); vTotImpresiones = vDecTot.ToString("0,0"); vTotClics = vDecClic.ToString("0,0"); vCTR = vDecimal.ToString("P"); LitImpGrafico.Text = vTotImpresiones; LitClicsGrafico.Text = vTotClics; LitCTRgrafico.Text = vCTR; LitGrafInfo.Text = ""; } else { LitTitulo.Text = ""; LitImpGrafico.Text = ""; LitClicsGrafico.Text = ""; LitCTRgrafico.Text = ""; sbData2 = sbData2.Clear(); sb = sb.Clear(); if (!IsPostBack) { LitGrafInfo.Text = "No se pudo obtener información " + "Intente con una búsqueda de las opciones"; } else { LitGrafInfo.Text = "No se encontró información para esta búsqueda " + "Intente con otra diferente"; } } /*sb.Append("["+ * "["+Convert.ToString(fecha1)+", 800], "+ "["+Convert.ToString(fecha2)+", 500], "+ * "["+ Convert.ToString(fecha3)+ ", 600], " + "[" + Convert.ToString(fecha4) + ", 600], " + * "["+Convert.ToString(fecha5)+", 700]"+ * "]");*/ //System.DateTime st = new System.DateTime(2012, 1, 1, 0, 0, 0, DateTimeKind.Utc); //var unixTime1 = GetUnixEpoch(st); //GetTime(); /* sb.Append("[" + * "[1325397600000, 800], [1325484000000, 500], [1325570400000, 600], [1325656800000, 700]," + * "[1325743200000, 500], [1325829600000, 456], [1325916000000, 800], [1326002400000, 589]," + * "[1326088800000, 467], [1326175200000, 876], [1326261600000, 689], [1326348000000, 700]," + * "[1326434400000, 500], [1326520800000, 600], [1326607200000, 700], [1326693600000, 786]," + * "[1326780000000, 345], [1326866400000, 888], [1326952800000, 888], [1327039200000, 888]," + * "[1327125600000, 987], [1327212000000, 444], [1327298400000, 999], [1327384800000, 567]," + * "[1327471200000, 786], [1327557600000, 666], [1327644000000, 888], [1327730400000, 900]," + * "[1327816800000, 178], [1327903200000, 555], [1327989600000, 993]" + * "]");*/ //sb.Append("[[1325397600000, 800], [1325484000000, 500], [1325570400000, 600], [1325656800000, 700], [1325743200000, 500], [1325829600000, 456], [1325916000000, 800], [1326002400000, 589], [1326088800000, 467], [1326175200000, 876], [1326261600000, 689], [1326348000000, 700], [1326434400000, 500], [1326520800000, 600], [1326607200000, 700], [1326693600000, 786], [1326780000000, 345], [1326866400000, 888], [1326952800000, 888], [1327039200000, 888], [1327125600000, 987], [1327212000000, 444], [1327298400000, 999], [1327384800000, 567], [1327471200000, 786], [1327557600000, 666], [1327644000000, 888], [1327730400000, 900], [1327816800000, 178], [1327903200000, 555], [1327989600000, 993]]"); lblData2.Text = Convert.ToString(sbData2); lblData3.Text = Convert.ToString(sb); } catch (Exception ex) { throw; } //return vXmlData; }