private Hashtable BindData(DateTime ReportDate, DateTime ReportEndDate) // , DateTime endDate) { Hashtable hashtable = new Hashtable(); try { DateTime endDate = ReportDate; // ReportEndDate; // new DateTime(ReportDate.Year, ReportDate.Month, ReportDate.Day, 21, 0, 0); DateTime startDate = ReportDate; // new DateTime(yesterday.Year, yesterday.Month, yesterday.Day, 21, 0, 0); //Console.WriteLine(startDate); //Console.WriteLine(endDate); ReportWS ws = new ReportWS(); Data rptData = default(Data); // Call the webservice and retrieve the report data rptData = ws.GetDataFromTimeframe("tgelman", "china2006", ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, startDate, endDate, 1000, 0, 0); for (int i = 0; i <= rptData.Rows.GetUpperBound(0); i++) { hashtable.Add(rptData.Rows[i].Columns[0].Value.ToString(), rptData.Rows[i].Columns[3].Value.ToString()); // Console.WriteLine("Unique Clicks " + rptData.Rows[i].Columns[0].Value + "-" + rptData.Rows[i].Columns[3].Value); } } catch { } return(hashtable); }
public int BindData(DateTime startDate, DateTime endDate) { int visitCount = 0; try { // VersionVisistorInfo.Clear(); StringBuilder sb = new StringBuilder(); ReportWS ws = new ReportWS(); int i = 0; Data rptData = default(Data); // Call the webservice and retrieve the report data rptData = ws.GetDataFromTimeframe("tryelastin", "china2006", ReportsEnum.MultiVariate, TimeFrameEnum.Daily, startDate, endDate, 100000000, 0, 0); decimal visitor = 0; for (i = 0; i <= rptData.Rows.GetUpperBound(0); i++) { // VersionVisistorInfo.Add(rptData.Rows[i].Columns[0].Value.ToUpper(), rptData.Rows[i].Columns[13].Value); //Response.Write(rptData.Rows[i].Columns[0].Value +"-"+rptData.Rows[i].Columns[13].Value); if (rptData.Rows[i].Columns[0].Value.Equals("--- Overall ---")) { visitCount = Convert.ToInt32(rptData.Rows[i].Columns[13].Value); } } } catch { } return(visitCount); }
private static void WriteHitsLinkData(DateTime startDate, DateTime endDate, StreamWriter sb) { Hashtable HitLinkVisitor = new Hashtable(); Data rptData = new ReportWS().GetDataFromTimeframe("dermawand", "china2006", ReportsEnum.MultiVariate, TimeFrameEnum.Daily, startDate, endDate, 100000000, 0, 0); for (int i = 0; i <= rptData.Rows.GetUpperBound(0); i++) { HitLinkVisitor.Add(rptData.Rows[i].Columns[0].Value.ToLower(), rptData.Rows[i].Columns[9].Value); } DataTable OrderInfo1 = DAL.SQLDAL.GetOrders("pr_report_order_version_batch", null, null); //Update Version List information foreach (DataRow row in OrderInfo1.Rows) { int visitor = 0; //if (row["Title"].ToString().ToLower().Equals(VersionName.ToLower())) // 04/01 Orders and Visitiors from B2 version only Pranav //{ if (row["Title"].ToString().ToLower().Equals(row["ShortName"].ToString().ToLower())) { if (HitLinkVisitor.ContainsKey(row["Title"].ToString().ToLower())) { visitor += Convert.ToInt32(HitLinkVisitor[row["Title"].ToString().ToLower()].ToString()); visitor = Math.Abs(visitor); for (int i = 0; i < visitor; i++) { WriteRow(sb, row["Title"].ToString(), startDate); } } } //else //{ // //Added this to fix bug of orderhelper.getversionname() // if (HitLinkVisitor.ContainsKey(row["Title"].ToString().ToLower())) // { // visitor += Convert.ToInt32(HitLinkVisitor[row["Title"].ToString().ToLower()].ToString()); // } // if (HitLinkVisitor.ContainsKey(row["ShortName"].ToString().ToLower())) // { // visitor += Convert.ToInt32(HitLinkVisitor[row["ShortName"].ToString().ToLower()].ToString()); // } // visitor = Math.Abs(visitor); //} //item.UniqueVisitors = visitor; //} } }