protected void BindData(DateTime?startDate, DateTime?endDate)
{
DateTime?timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(rangeDateControlCriteria.StartDateValueLocal);
DateTime?timezoneEndDate = DateTimeUtil.GetEastCoastDate(rangeDateControlCriteria.EndDateValueLocal);
dtCollectionList = new OrderManager().GetVersionSummary(timezoneStartDate, timezoneEndDate, false);
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe(hitsLinkUserName, hitsLinkPassword, ReportsEnum.MultiVariate, TimeFrameEnum.Daily, Convert.ToDateTime(startDate), Convert.ToDateTime(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);
}
//Update Version List information
foreach (ReportFields item in dtCollectionList[1])
{
decimal visitor = 0;
if (item.Title.ToLower().Equals(item.ShortName.ToLower()))
{
if (HitLinkVisitor.ContainsKey(item.Title))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
}
}
else
{
//Added this to fix bug of orderhelper.getversionname()
if (HitLinkVisitor.ContainsKey(item.Title))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
}
if (HitLinkVisitor.ContainsKey(item.ShortName.ToLower()))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.ShortName.ToLower()].ToString());
}
visitor = Math.Abs(visitor);
}
item.UniqueVisitors = visitor;
if (visitor > 0)
{
item.Conversion = Math.Round((Convert.ToDecimal(item.TotalOrders) * 100) / visitor, 1);
item.RevenuePerVisit = Convert.ToDecimal(item.TotalRevenue) / visitor;
}
else
{
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
dlVersionCategoryList.DataSource = CSFactory.GetAllVersionCateogry();
dlVersionCategoryList.DataBind();
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
protected int BindData(DateTime startDate, DateTime endDate, string VersionName)
{
//DateTime? timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(startDate);
//DateTime? timezoneEndDate = DateTimeUtil.GetEastCoastDate(endDate);
HitLinkVisitor.Clear();
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe("smoothxbike", "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);
}
_dtOrderInfo1 = null;
CategoryUniqueVistiors = 0;
string Archivedata = "0";
DataTable OrderInfo1 = getDataTable("pr_report_order_version_batch", startDate, EndOfDay(startDate), Archivedata);
//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);
}
}
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;
CategoryUniqueVistiors += visitor;
//}
}
return(CategoryUniqueVistiors);
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
protected bool GeneratePredictiveReport(DateTime startDate, DateTime endDate, string FUllPAthwithFileName)
{
bool result = false;
try
{
DataTable reportData;
DAL dal = new DAL();
//get the versionSummary data from db , using OrderManager
dal.SQLServer.GetOrdersForPredictive(StartOfDay(startDate), EndOfDay(endDate), out reportData);
//get hitslink data using hitslink service , and update the versionSummary data accordingly trynono_url
ReportWSSoapClient hitslinkWS = new ReportWSSoapClient();
Data rptData = new ReportWSSoapClient().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);
}
//Update Version List information
foreach (DataRow dataRow in reportData.Rows)
{
//decimal visitor = 0;
string versionName = dataRow["Version_Code"].ToString().ToLower();
if (HitLinkVisitor.ContainsKey(versionName))
{
dataRow["Visits"] = HitLinkVisitor[versionName].ToString().ToLower();
}
else
{
dataRow["Visits"] = "0";
}
//dataRow["Revenue"]
dataRow["Date"] = startDate.ToString("dd-MMM-yy");
}
try
{
result = CreateCSVFile(reportData, FUllPAthwithFileName, true);
}
catch (Exception ex)
{
string loginfo = "File creation status:" + result + Environment.NewLine + ex.Message.ToString();
LogToFile(loginfo);
}
return(result);
}
catch (Exception ex)
{
string loginfo = "Report generation status:" + result + Environment.NewLine + ex.Message.ToString();
LogToFile(loginfo);
Console.WriteLine(ex.ToString());
return(result);
}
}
protected int BindData(DateTime startDate, DateTime endDate, string VersionName)
{
HitLinkVisitor.Clear();
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe("trynono_url", "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);
}
CategoryUniqueVistiors = 0;
return(CategoryUniqueVistiors);
}
public bool Get_NoNo_Skin_Web_Report(DateTime startDate, DateTime endDate, out DataTable returnTable)
{
bool result = false;
Hashtable HitLinkVisitor = new Hashtable();
try
{
//DateTime currentDay = startDate;
HitLinkVisitor.Clear();
DataTable reportData;
DAL dal = new DAL();
//get the versionSummary data from db , using OrderManager
dal.SQLServer.Get_NoNo_Skin_Web_Report_Table(Logging.StartOfDay(startDate), Logging.EndOfDay(endDate), out reportData);
//get hitslink data using hitslink service , and update the versionSummary data accordingly
ReportWSSoapClient hitslinkWS = new ReportWSSoapClient();
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe("toddgelman", "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);
}
//Update Version List information
foreach (DataRow dataRow in reportData.Rows)
{
//decimal visitor = 0;
string versionName = dataRow["Version"].ToString().ToLower();
if (HitLinkVisitor.ContainsKey(versionName))
{
decimal visitor = Convert.ToDecimal(HitLinkVisitor[versionName].ToString().ToLower());
visitor = Math.Abs(visitor);
if (visitor > 0)
{
dataRow["Unique_Visitors"] = visitor.ToString();
dataRow["Conversion_Perc"] = Math.Round((Convert.ToDecimal(dataRow["Total_Orders"]) * 100) / visitor, 1).ToString() + '%';
dataRow["Revenue_Per_Visitor"] = (Convert.ToDecimal(dataRow["Total_Revenue"]) / visitor).ToString("N");
}
//dataRow["Date"] =endDate.ToString("M-d-yyyy");
}
}
returnTable = reportData;
return(true);
}
catch (Exception ex)
{
string loginfo = "Report generation status:" + result + Environment.NewLine + ex.Message.ToString();
Logging.LogToFile(loginfo);
Console.WriteLine(ex.ToString());
returnTable = null;
return(false);
}
}
protected int BindData(DateTime startDate, DateTime endDate, string VersionName)
{
HitLinkVisitor.Clear();
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe("tgelman", "china2006", ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, startDate, endDate, 1000, 0, 0);
for (int i = 0; i <= rptData.Rows.GetUpperBound(0); i++)
{
if (rptData.Rows[i].Columns[0].Value.ToString().ToLower().Contains("cpa_im"))
{
HitLinkVisitor.Add(rptData.Rows[i].Columns[0].Value.ToString(), rptData.Rows[i].Columns[3].Value.ToString());
}
}
CategoryUniqueVistiors = 0;
return(CategoryUniqueVistiors);
}
protected void BindData(DateTime?startDate, DateTime?endDate)
{
DateTime? timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(rangeDateControlCriteria.StartDateValueLocal);
DateTime? timezoneEndDate = DateTimeUtil.GetEastCoastDate(rangeDateControlCriteria.EndDateValueLocal);
List <ReportFields> ItemList = new OrderManager().GetOrderCustomFieldReport(timezoneStartDate, timezoneEndDate, 2, false);
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe(hitsLinkUserName, hitsLinkPassword, ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, Convert.ToDateTime(startDate), Convert.ToDateTime(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[7].Value);
}
//Update Version List information
foreach (ReportFields item in ItemList)
{
if (HitLinkVisitor.ContainsKey(item.Title))
{
decimal visitor = Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
item.UniqueVisitors = visitor;
if (visitor > 0)
{
item.Conversion = Math.Round((Convert.ToDecimal(item.TotalOrders) * 100) / visitor, 1);
item.RevenuePerVisit = Convert.ToDecimal(item.TotalRevenue) / visitor;
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
dlVersionList.DataSource = ItemList;
dlVersionList.DataBind();
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
protected void BindData(DateTime?startDate, DateTime?endDate)
{
DateTime?timezoneStartDate = new DateTime();
DateTime?timezoneEndDate = new DateTime();
if (OrderHelper.IsReportEST())
{
timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(rangeDateControlCriteria.StartDateValueLocal);
timezoneEndDate = DateTimeUtil.GetEastCoastDate(rangeDateControlCriteria.EndDateValueLocal);
}
else//PST
{
timezoneStartDate = rangeDateControlCriteria.StartDateValueLocal;
timezoneEndDate = DateTimeUtil.GetEndDate(rangeDateControlCriteria.EndDateValueLocal);
//liSubHeader.Text = DateTime.Now.DayOfWeek + " " + DateTime.Now.ToShortTimeString() + " (PST)";
}
//Passsing custom field value as 1000 which is combination of mid and sid. Special case for dermwand.com only
List <ReportFields> ItemList = new OrderManager().GetOrderCustomFieldReport(timezoneStartDate, timezoneEndDate, 1, false);
try
{
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe(hitsLinkUserName, hitsLinkPassword, ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, Convert.ToDateTime(startDate), Convert.ToDateTime(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[3].Value);
}
}
catch (Exception ex)
{ }
List <string> keysAdded = new List <string>();
//Update Version List information
foreach (ReportFields item in ItemList)
{
if (HitLinkVisitor.ContainsKey(item.Title))
{
keysAdded.Add(item.Title);
decimal visitor = Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
item.UniqueVisitors = visitor;
if (visitor > 0)
{
item.Conversion = Math.Round((Convert.ToDecimal(item.TotalOrders) * 100) / visitor, 1);
item.RevenuePerVisit = Convert.ToDecimal(item.TotalRevenue) / visitor;
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
if (string.IsNullOrEmpty(item.Title))
{
item.Title = "(none)";
}
}
// add keys not already list (visits but no orders)
foreach (string key in HitLinkVisitor.Keys)
{
if (!keysAdded.Contains(key))
{
ReportFields item = new ReportFields();
item.Title = key;
decimal visitor = Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
item.UniqueVisitors = visitor;
item.Conversion = 0;
item.RevenuePerVisit = 0;
ItemList.Add(item);
}
}
dlVersionList.DataSource = ItemList;
dlVersionList.DataBind();
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
//Garo:This function was written for Icon Media to pull unqiue visitors data per version for any range of dates , and store it in c:\
//Not to be used unless requested
//the call is in btn_submit , marked as comment
protected void get_unique_visitors(DateTime?startDate, DateTime?endDate)
{
DateTime?timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(rangeDateControlCriteria.StartDateValueLocal);
DateTime?timezoneEndDate = DateTimeUtil.GetEastCoastDate(rangeDateControlCriteria.EndDateValueLocal);
DateTime date1 = Convert.ToDateTime(timezoneStartDate);
DateTime date2 = Convert.ToDateTime(timezoneEndDate);
string filename = "c:\\" + date1.AddDays(1).ToString("MM") + date1.AddDays(1).ToString("dd") + date1.AddDays(1).ToString("yy") + "-" + date2.ToString("MM") + date2.ToString("dd") + date2.ToString("yy") + ".txt";
WriteHeaderCSVFile(filename);
TimeSpan span = Convert.ToDateTime(date2) - Convert.ToDateTime(date1);
for (int j = 0; j < Convert.ToInt16(span.TotalDays); j++)
{
HitLinkVisitor.Clear();
DateTime zdate1 = date1.AddDays(j);
DateTime zdate2 = date1.AddDays(j + 1);
DateTime hdate1 = Convert.ToDateTime(startDate).AddDays(j);
DateTime hdate2 = Convert.ToDateTime(startDate).AddDays(j + 1);
if (dtCollectionList != null)
{
dtCollectionList.Clear();
}
dtCollectionList = new OrderManager().GetVersionSummary(zdate1, zdate2, false);
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe(hitsLinkUserName, hitsLinkPassword, ReportsEnum.MultiVariate, TimeFrameEnum.Daily, hdate1, hdate1, 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);
foreach (ReportFields item in dtCollectionList[1])
{
decimal visitor = 0;
if (item.Title.ToLower().Equals(item.ShortName.ToLower()))
{
if (HitLinkVisitor.ContainsKey(item.Title))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
}
}
else
{
//Added this to fix bug of orderhelper.getversionname()
if (HitLinkVisitor.ContainsKey(item.Title))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
}
if (HitLinkVisitor.ContainsKey(item.ShortName.ToLower()))
{
visitor += Convert.ToDecimal(HitLinkVisitor[item.ShortName.ToLower()].ToString());
}
visitor = Math.Abs(visitor);
}
item.UniqueVisitors = visitor;
if (visitor > 0)
{
item.Conversion = Math.Round((Convert.ToDecimal(item.TotalOrders) * 100) / visitor, 1);
item.RevenuePerVisit = Convert.ToDecimal(item.TotalRevenue) / visitor;
}
else
{
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
}
WritetoCSVFile(dtCollectionList[1], filename, Convert.ToDateTime(hdate1));
}
//Update Version List information
dlVersionCategoryList.DataSource = CSFactory.GetAllVersionCateogry();
dlVersionCategoryList.DataBind();
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
public bool Get_NoNo_Web_Report_Report(DateTime startDate, DateTime endDate, out DataTable returnTable)
{
bool result = false;
Hashtable HitLinkVisitor = new Hashtable();
try
{
DataTable reportData;
List <string> OrderPresentKey = new List <string>();
DAL dal = new DAL();
//get the versionSummary data from db , using OrderManager
dal.SQLServer.Get_NoNo_Web_Report_Table(startDate, endDate, out reportData);
HitLinkVisitor.Clear();
//get hitslink data using hitslink service , and update the versionSummary data accordingly
ReportWSSoapClient hitslinkWS = new ReportWSSoapClient();
//get hitslink data for the url list using hitslink service
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe("tgelman", "china2006", ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, startDate.AddHours(3), endDate.AddHours(3), 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[3].Value);
}
DataTable returnTable1 = reportData.Clone();
try
{
foreach (DataRow dataRow in reportData.Rows)
{
string _url = dataRow["MID"].ToString().ToLower();
if (_url.Contains("im_"))
{
returnTable1.ImportRow(dataRow);
OrderPresentKey.Add(_url);
}
}
}
catch
{ }
foreach (DataRow dataRow in returnTable1.Rows)
{
string versionName = dataRow["mid"].ToString().ToLower();
decimal visitor = 0;
foreach (string key in HitLinkVisitor.Keys)
{
try
{
if ((key.Contains(versionName)))
{
visitor = Convert.ToDecimal(HitLinkVisitor[key].ToString().ToLower());
}
}
catch
{
}
}
visitor = Math.Abs(visitor);
if (visitor > 0)
{
dataRow["UniqueVisitors"] = visitor.ToString();
try
{
dataRow["Conversion"] = Math.Round((Convert.ToDecimal(dataRow["TotalOrders"]) * 100) / visitor, 2) + "%";
}
catch
{
dataRow["Conversion"] = "0%";
}
}
else
{
dataRow["Conversion"] = "100%";
}
}
foreach (string key in HitLinkVisitor.Keys)
{
try
{
if (key.Contains("im_") && !OrderPresentKey.Contains(key))
{
returnTable1.Rows.Add(new object[] { key.ToUpper(), HitLinkVisitor[key].ToString(), "0", "0", "0%", "0" });
}
}
catch
{
}
}
returnTable = returnTable1;
return(true);
}
catch (Exception ex)
{
string loginfo = "Report generation status:" + result + Environment.NewLine + ex.Message.ToString();
Logging.LogToFile(loginfo);
Console.WriteLine(ex.ToString());
returnTable = null;
return(false);
}
}
