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