private void RefreshGrid()
{
PeriodType period = ReportFilterUtilities.ConvertToPeriodType(uxPeriodGraphicDrop.SelectedValue);
ReportFilterUtilities.GetOrderDateRange(period, out _startOrderDate, out _endOrderDate);
decimal revenue = 0;
int sumQuantity = 0;
decimal sumTax = 0;
decimal sumShipping = 0;
SaleReportBuilder reportBuilder = new SaleReportBuilder();
DataTable table = reportBuilder.GetReportData(
period,
_startOrderDate,
_endOrderDate,
StoreID
);
foreach (DataRow row in table.Rows)
{
revenue += Convert.ToDecimal(row["Total"]);
sumQuantity += Convert.ToInt32(row["Quantity"]);
sumTax += Convert.ToDecimal(row["TotalTax"]);
sumShipping += Convert.ToDecimal(row["TotalShippingCost"]);
}
uxRevenueValueLabel.Text = revenue.ToString("F", CultureInfo.InvariantCulture);
uxQuantityValueLabel.Text = sumQuantity.ToString("F", CultureInfo.InvariantCulture);
uxTaxValueLabel.Text = sumTax.ToString("F", CultureInfo.InvariantCulture);
uxShippingValueLabel.Text = sumShipping.ToString("F", CultureInfo.InvariantCulture);
}
protected void Page_Load(object sender, EventArgs e)
{
uxPagingControl.BubbleEvent += new EventHandler(uxGrid_RefreshHandler);
if (!MainContext.IsPostBack)
{
HttpBrowserCapabilities browser = Request.Browser;
string browserName = browser.Browser;
PopulateControls();
RefreshGrid();
string script = "<script language='javascript'>CreateChart(document.getElementById('" +
uxPeriodDrop.ClientID + "').value,document.getElementById('" + uxReportDrop.ClientID + "').value," +
"'null','null','" + browserName + "','true','0')</script>";
ScriptManager.RegisterStartupScript(this, GetType(), "startScript", script, false);
}
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
uxSetDate.Style.Add("display", "block");
}
else
{
uxSetDate.Style.Add("display", "none");
}
}
protected void uxExportButton_Click(object sender, EventArgs e)
{
string message, message1, filePhysicalPathName, fileNameLinkText, fileNameLinkURL;
CustomerReportType customerReportType = ReportFilterUtilities.ConvertToCustomerReportType(uxReportDrop.SelectedValue);
filePhysicalPathName = Server.MapPath("../");
if (customerReportType == CustomerReportType.UserRegistration)
{
CustomerReportExporter exporter = new CustomerReportExporter();
fileNameLinkURL = exporter.ExportCustomerReportData(
customerReportType,
ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue),
filePhysicalPathName,
_startOrderDate,
_endOrderDate,
out message,
out message1,
out fileNameLinkText);
}
else
{
CustomerReportExporter exporter = new CustomerReportExporter();
fileNameLinkURL = exporter.ExportCustomerReportData(
ReportFilterUtilities.ConvertToCustomerReportType(uxReportDrop.SelectedValue),
ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue),
uxNumberItemsDrop.SelectedItem.ToString(),
filePhysicalPathName,
_startOrderDate,
_endOrderDate,
out message,
out message1,
out fileNameLinkText);
}
if (String.IsNullOrEmpty(fileNameLinkURL))
{
uxMessage.DisplayError(message);
uxMessage1.Visible = false;
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
}
else
{
uxMessage.DisplayMessage(message);
uxMessage1.Visible = true;
uxMessage1.DisplayMessageNoNewLIne(message1);
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
uxFileNameLink.Target = "_blank";
}
if (uxReportDrop.SelectedItem.ToString() == "Customer Registration")
{
CreateChart();
}
setCustomDateDisplay();
}
private void RefreshGrid()
{
if (!MainContext.IsPostBack)
{
uxPagingControl.ItemsPerPages = AdminConfig.OrderItemsPerPage;
}
int totalItems;
PeriodType period = ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue);
if (period == PeriodType.Custom)
{
string errorMessage;
if (VerifyCustomInput(out errorMessage))
{
LoadCustomInput();
}
else
{
uxMessage.DisplayError(errorMessage);
uxMessage1.Visible = false;
return;
}
}
else
{
ReportFilterUtilities.GetOrderDateRange(period, out _startOrderDate, out _endOrderDate);
}
BestSellingReportBuilder bestSellingReportBuilder = new BestSellingReportBuilder();
DataTable table = bestSellingReportBuilder.GetBestSellingReportData(
GridHelper.GetFullSortText(),
StoreContext.Culture.CultureID,
period,
ReportFilterUtilities.ConvertToBestSellReportType(uxReportDrop.SelectedValue),
uxNumberItemsDrop.SelectedItem.ToString(),
StoreContext.CurrentStore.StoreID,
_startOrderDate,
_endOrderDate,
uxPagingControl.StartIndex,
uxPagingControl.EndIndex,
out totalItems);
if (table.Rows.Count > 0)
{
uxTitleLabel.Visible = true;
setTitle();
}
else
{
uxTitleLabel.Visible = false;
}
uxPagingControl.NumberOfPages = (int)Math.Ceiling((double)totalItems / uxPagingControl.ItemsPerPages);
uxGrid.DataSource = table;
uxGrid.DataBind();
setCustomDateDisplay();
}
private void RefreshGrid()
{
if (!MainContext.IsPostBack)
{
uxPagingControl.ItemsPerPages = AdminConfig.OrderItemsPerPage;
}
int totalItems;
_errorFlag = false;
PeriodType period = ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue);
if (period == PeriodType.Custom)
{
string errorMessage;
if (VerifyCustomInput(out errorMessage))
{
LoadCustomInput();
}
else
{
uxMessage.DisplayError(errorMessage);
uxMessage1.Visible = false;
_errorFlag = true;
return;
}
}
else
{
ReportFilterUtilities.GetOrderDateRange(period, out _startOrderDate, out _endOrderDate);
}
PaymentReportBuilder paymentReportBuilder = new PaymentReportBuilder();
DataTable table = paymentReportBuilder.GetPaymentReportData(
GridHelper.GetFullSortText(),
period,
_startOrderDate,
_endOrderDate,
uxPagingControl.StartIndex,
uxPagingControl.EndIndex,
out totalItems);
if (table.Rows.Count == 0)
{
uxDisplayChart.Style.Add("Display", "none");
}
else
{
uxDisplayChart.Style.Add("Display", "");
}
uxPagingControl.NumberOfPages = (int)Math.Ceiling((double)totalItems / uxPagingControl.ItemsPerPages);
uxGrid.DataSource = table;
uxGrid.DataBind();
setCustomDateDisplay();
}
protected string GetDateTimeText(object registerPeriod)
{
DateTime startDate = DateTime.Now;
DateTime endDate = DateTime.Now;
return(RepositoryDisplayFormatter.GetDateTimeText(
registerPeriod,
ReportFilterUtilities.ConvertToPeriodType(uxPeriodGraphicDrop.SelectedValue),
startDate,
endDate));
}
private void setCustomDateDisplay()
{
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
uxSetDate.Style.Add("display", "block");
}
else
{
uxSetDate.Style.Add("display", "none");
}
}
private void setTitle()
{
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
uxTitleLabel.Text = uxReportDrop.SelectedItem.ToString() + " ( From " +
uxStartDateCalendarPopup.SelectedDate.ToShortDateString() + " To " +
uxEndDateCalendarPopUp.SelectedDate.ToShortDateString() + ")";
}
else
{
uxTitleLabel.Text = uxReportDrop.SelectedItem.ToString() + " (" +
uxPeriodDrop.SelectedItem.Text + ")";
}
}
protected string GetDateTimeText(object registerPeriod)
{
DateTime startDate = DateTime.Now;
DateTime endDate = DateTime.Now;
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
startDate = uxStartDateCalendarPopup.SelectedDate;
endDate = uxEndDateCalendarPopUp.SelectedDate;
}
return(RepositoryDisplayFormatter.GetDateTimeText(
registerPeriod,
ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue),
startDate,
endDate));
}
private void RefreshGrid()
{
if (!MainContext.IsPostBack)
{
uxPagingControl.ItemsPerPages = AdminConfig.OrderItemsPerPage;
}
int totalItems;
_errorFlag = false;
PeriodType period = ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue);
ReportFilterUtilities.GetOrderDateRange(period, out _startOrderDate, out _endOrderDate);
SaleReportBuilder reportBuilder = new SaleReportBuilder();
DataTable table = reportBuilder.GetReportData(
GridHelper.GetFullSortText(),
period,
_startOrderDate,
_endOrderDate,
uxPagingControl.StartIndex,
uxPagingControl.EndIndex,
StoreID,
out totalItems);
uxPagingControl.NumberOfPages = (int)Math.Ceiling((double)totalItems / uxPagingControl.ItemsPerPages);
uxGrid.DataSource = table;
uxGrid.DataBind();
decimal revenue = 0;
int sumQuantity = 0;
decimal sumTax = 0;
decimal sumShipping = 0;
foreach (DataRow row in table.Rows)
{
revenue += Convert.ToDecimal(row["Total"]);
sumQuantity += Convert.ToInt32(row["Quantity"]);
sumTax += Convert.ToDecimal(row["TotalTax"]);
sumShipping += Convert.ToDecimal(row["TotalShippingCost"]);
}
uxRevenueValueLabel.Text = revenue.ToString("F", CultureInfo.InvariantCulture);
uxQuantityValueLabel.Text = sumQuantity.ToString("F", CultureInfo.InvariantCulture);
uxTaxValueLabel.Text = sumTax.ToString("F", CultureInfo.InvariantCulture);
uxShippingValueLabel.Text = sumShipping.ToString("F", CultureInfo.InvariantCulture);
}
protected void Page_Load(object sender, EventArgs e)
{
uxPagingControl.BubbleEvent += new EventHandler(uxGrid_RefreshHandler);
if (!MainContext.IsPostBack)
{
PopulateControls();
RefreshGrid();
}
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
uxSetDate.Style.Add("display", "block");
}
else
{
uxSetDate.Style.Add("display", "none");
}
}
private void setCustomDateDisplay()
{
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
uxSetDate.Style.Add("display", "block");
}
else
{
uxSetDate.Style.Add("display", "none");
}
if (ReportFilterUtilities.ConvertToCustomerReportType(uxReportDrop.SelectedValue) != CustomerReportType.UserRegistration)
{
uxSetItems.Style.Add("display", "block");
}
else
{
uxSetItems.Style.Add("display", "none");
}
}
protected void uxExportButton_Click(object sender, EventArgs e)
{
string message, message1, filePhysicalPathName, fileNameLinkText, fileNameLinkURL;
filePhysicalPathName = Server.MapPath("../");
BestSellerReportExporter exporter = new BestSellerReportExporter(
CurrencyUtilities.BaseCurrencySymbol, StoreContext.Culture.CultureID);
fileNameLinkURL = exporter.ExportBestSellerReportData(
ReportFilterUtilities.ConvertToBestSellReportType(uxReportDrop.SelectedValue),
ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue),
uxNumberItemsDrop.SelectedItem.ToString(),
filePhysicalPathName,
StoreContext.CurrentStore.StoreID,
_startOrderDate,
_endOrderDate,
out message,
out message1,
out fileNameLinkText
);
if (String.IsNullOrEmpty(fileNameLinkURL))
{
uxMessage.DisplayError(message);
uxMessage1.Visible = false;
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
}
else
{
uxMessage.DisplayMessage(message);
uxMessage1.Visible = true;
uxMessage1.DisplayMessageNoNewLIne(message1);
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
uxFileNameLink.Target = "_blank";
}
setCustomDateDisplay();
}
protected void uxExportButton_Click(object sender, EventArgs e)
{
string message, message1, filePhysicalPathName, fileNameLinkText, fileNameLinkURL;
filePhysicalPathName = Server.MapPath("../");
SaleReportExporter exporter = new SaleReportExporter(CurrencyUtilities.BaseCurrencySymbol);
fileNameLinkURL = exporter.ExportSellReportData(
ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue),
filePhysicalPathName,
_startOrderDate,
_endOrderDate,
"0",
out message,
out message1,
out fileNameLinkText
);
if (String.IsNullOrEmpty(fileNameLinkURL))
{
uxMessage.DisplayError(message);
uxMessage1.Visible = false;
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
}
else
{
uxMessage.DisplayMessage(message);
uxMessage1.Visible = true;
uxMessage1.DisplayMessageNoNewLIne(message1);
uxFileNameLink.Text = fileNameLinkText;
uxFileNameLink.NavigateUrl = fileNameLinkURL;
uxFileNameLink.Target = "_blank";
}
RefreshGrid();
CreateChart();
setCustomDateDisplay();
}
private void CreateChart()
{
HttpBrowserCapabilities browser = Request.Browser;
string browserName = browser.Browser;
if (ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue) == PeriodType.Custom)
{
string script = "<script language='javascript'>CreateCustomerChart(document.getElementById('" +
uxPeriodDrop.ClientID + "').value,document.getElementById('" + uxReportDrop.ClientID + "').value, '" +
_startOrderDate.ToShortDateString() + "','" +
_endOrderDate.ToShortDateString() + "','" +
browserName +
"')</script>";
ScriptManager.RegisterStartupScript(this, GetType(), "startScript", script, false);
}
else
{
string script = "<script language='javascript'>CreateCustomerChart(document.getElementById('" +
uxPeriodDrop.ClientID + "').value,document.getElementById('" + uxReportDrop.ClientID + "').value, " +
"'null','null','" + browserName + "')</script>";
ScriptManager.RegisterStartupScript(this, GetType(), "startScript", script, false);
}
}
private void RefreshGrid()
{
if (!MainContext.IsPostBack)
{
uxPagingControl.ItemsPerPages = AdminConfig.OrderItemsPerPage;
}
int totalItems;
_errorFlag = false;
PeriodType period = ReportFilterUtilities.ConvertToPeriodType(uxPeriodDrop.SelectedValue);
CustomerReportType customerReportType = ReportFilterUtilities.ConvertToCustomerReportType(uxReportDrop.SelectedValue);
if (period == PeriodType.Custom)
{
string errorMessage;
if (VerifyCustomInput(out errorMessage))
{
LoadCustomInput();
}
else
{
uxMessage.DisplayError(errorMessage);
uxMessage1.Visible = false;
_errorFlag = true;
return;
}
}
else
{
ReportFilterUtilities.GetOrderDateRange(period, out _startOrderDate, out _endOrderDate);
}
CustomerReportBuilder customerReportBuilder = new CustomerReportBuilder();
if (customerReportType != CustomerReportType.UserRegistration)
{
_table = customerReportBuilder.GetTopCustomerReportData(
GridHelper1.GetFullSortText(),
period,
customerReportType,
uxNumberItemsDrop.SelectedItem.ToString(),
_startOrderDate,
_endOrderDate,
uxPagingControl.StartIndex,
uxPagingControl.EndIndex,
out totalItems);
uxTopCustomerGrid.DataSource = _table;
uxTopCustomerGrid.DataBind();
uxTopCustomerGrid.Visible = true;
uxGrid.Visible = false;
uxPadding.Visible = false;
if (_table.Rows.Count > 0)
{
uxTitleLabel.Visible = true;
setTitle();
}
else
{
uxTitleLabel.Visible = false;
}
}
else
{
_table = customerReportBuilder.GetCustomerReportData(
GridHelper.GetFullSortText(),
period,
_startOrderDate,
_endOrderDate,
uxPagingControl.StartIndex,
uxPagingControl.EndIndex,
out totalItems);
uxGrid.DataSource = _table;
uxGrid.DataBind();
uxGrid.Visible = true;
uxTopCustomerGrid.Visible = false;
uxPadding.Visible = true;
uxTitleLabel.Visible = false;
}
uxPagingControl.NumberOfPages = (int)Math.Ceiling((double)totalItems / uxPagingControl.ItemsPerPages);
setCustomDateDisplay();
}