private string RenderOrdersRegGraph(DateTime dateFrom, DateTime dateTo)
{
var listSumForReg = OrderStatisticsService.GetOrdersRegGroupByDay(_groupFormatString, dateFrom, dateTo, true, _paied, _statusId);
var listSumForUnReg = OrderStatisticsService.GetOrdersRegGroupByDay(_groupFormatString, dateFrom, dateTo, false, _paied, _statusId);
var dataReg = "";
var dataUnReg = "";
switch (_groupBy)
{
case EGroupDateBy.Day:
dataReg = GetByDays(listSumForReg, dateFrom, dateTo);
dataUnReg = GetByDays(listSumForUnReg, dateFrom, dateTo);
break;
case EGroupDateBy.Week:
dataReg = GetByWeeks(listSumForReg, dateFrom, dateTo);
dataUnReg = GetByWeeks(listSumForUnReg, dateFrom, dateTo);
break;
case EGroupDateBy.Month:
dataReg = GetByMonths(listSumForReg, dateFrom, dateTo);
dataUnReg = GetByMonths(listSumForUnReg, dateFrom, dateTo);
break;
}
return(String.Format("[{{label: '{0}', data:[{1}]}}, {{label: '{2}', data:[{3}]}}]",
Resource.Admin_Statistics_Registered, dataReg,
Resource.Admin_Statistics_UnRegistered, dataUnReg));
}
protected void Page_Load(object sender, EventArgs e)
{
pnSales.Width = Width;
//pnSalesChart.Width = Convert.ToInt32(Width);
//pnProfitChart.Width = Convert.ToInt32(Width);
prog = OrderStatisticsService.GetMonthProgress();
}
protected string RenderJGData()
{
var result = new StringBuilder();
Dictionary <DateTime, decimal> sums = OrderStatisticsService.GetOrdersSumByDays(minDate, maxDate);
Dictionary <DateTime, decimal> profits = OrderStatisticsService.GetOrdersProfitByDays(minDate, maxDate);
if (sums == null)
{
return("");
}
for (DateTime i = minDate; i < maxDate; i = i.AddDays(1))
{
decimal sum = 0;
decimal profit = 0;
if (sums.ContainsKey(i))
{
sum = sums[i];
}
if (profits.ContainsKey(i))
{
profit = profits[i];
}
result.AppendFormat("['{0}', {1}, {2}],", i.ToString("dd.MM"), sum.ToString(System.Globalization.CultureInfo.InvariantCulture), profit.ToString(System.Globalization.CultureInfo.InvariantCulture));
}
result.Remove(result.ToString().LastIndexOf(','), 1);
return(result.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
var plannedSales = OrderStatisticsService.SalesPlan;
sales = OrderStatisticsService.GetMonthProgress().Key;
planPercent = Math.Round(sales / (plannedSales / 100));
}
protected string RenderBigOrdersChartData()
{
DateTime minDate = DateTime.Now.AddMonths(-1).Date;
DateTime maxDate = DateTime.Now.AddDays(2).Date;
var result = new StringBuilder();
Dictionary <DateTime, decimal> sums = OrderStatisticsService.GetOrdersSumByDays(minDate, maxDate);
Dictionary <DateTime, decimal> profits = OrderStatisticsService.GetOrdersProfitByDays(minDate, maxDate);
if (sums == null)
{
return("");
}
string[] monthsArr = Resources.Resource.Admin_Charts_Months.Split(',');
for (DateTime i = minDate.Date; i < maxDate;)
{
decimal sum = 0;
decimal profit = 0;
if (sums.ContainsKey(i))
{
sum = sums[i];
}
if (profits.ContainsKey(i))
{
profit = profits[i];
}
result.AppendFormat("['{0}', {1}, {2}],", i.Date.ToString("dd.MM"), sum.ToString(System.Globalization.CultureInfo.InvariantCulture), profit.ToString(System.Globalization.CultureInfo.InvariantCulture));
i = i.AddDays(1);
}
result.Remove(result.ToString().LastIndexOf(','), 1);
return(result.ToString());
}
protected string RenderJGData()
{
var result = new StringBuilder();
Dictionary <DateTime, decimal> sums = OrderStatisticsService.GetOrdersSumByPeriod(minDate, maxDate);
Dictionary <DateTime, decimal> profits = OrderStatisticsService.GetOrdersProfitByPeriod(minDate, maxDate);
if (sums == null)
{
return("");
}
string[] monthsArr = Resources.Resource.Admin_Charts_Months.Split(',');
for (var i = new DateTime(minDate.AddMonths(1).Year, minDate.AddMonths(1).Month, 1); i < maxDate;)
{
decimal sum = 0;
decimal profit = 0;
if (sums.ContainsKey(i))
{
sum = sums[i];
}
if (profits.ContainsKey(i))
{
profit = profits[i];
}
result.AppendFormat("[{0}, {1}, {2}],", monthsArr[i.Month - 1], sum.ToString(System.Globalization.CultureInfo.InvariantCulture), profit.ToString(System.Globalization.CultureInfo.InvariantCulture));
i = i.AddMonths(1);
}
result.Remove(result.ToString().LastIndexOf(','), 1);
return(result.ToString());
}
public OrderStatistic GetSingle(String orderIdAsString)
{
Int32 orderId = Int32.Parse(orderIdAsString);
ValidateOrderExists(orderId);
return(OrderStatisticsService.GetStatistic(orderId));
}
protected string RenderDataByMonths(DateTime date)
{
var listProfit = OrderStatisticsService.GetOrdersProfitByDays(date, Now);
var listSum = OrderStatisticsService.GetOrdersSumByDays(date, Now);
return(String.Format("[{{label: '{0}', data:[{1}]}}, {{label: '{2}', data:[{3}]}}]",
Resource.Admin_Chart_Profit, GetByMonths(listProfit, date, Now),
Resource.Admin_Default_Orders, GetByMonths(listSum, date, Now)));
}
private string RenderTopCities()
{
var shippings = OrderStatisticsService.GetTopCities();
if (shippings.Count >= 10)
{
var pshippingStat = shippings.Take(9).ToList();
pshippingStat.Add(new KeyValuePair <string, int>(Resource.Admin_Statistics_Others, shippings.Skip(9).Sum(x => x.Value)));
shippings = pshippingStat;
}
return(String.Format("[{0}]",
shippings.Aggregate("",
(current, shipping) =>
current + string.Format("{{ label: \"{0}\", data:{1}}},", shipping.Key, shipping.Value))));
}
private string RenderTopPayments()
{
var payments = OrderStatisticsService.GetTopPayments();
if (payments.Count >= 10)
{
var paymentStat = payments.Take(9).ToList();
paymentStat.Add(new KeyValuePair <string, int>(Resource.Admin_Statistics_Others, payments.Skip(9).Sum(x => x.Value)));
payments = paymentStat;
}
return(String.Format("[{0}]",
payments.Aggregate("",
(current, payment) =>
current +
string.Format("{{ label: \"{0}\", data:{1}}},", payment.Key, payment.Value))));
}
protected string RenderJGData()
{
var result = new StringBuilder();
Dictionary <DateTime, int> data = OrderStatisticsService.GetOrdersCountByPeriod(minDate, maxDate);
if (data == null)
{
return(string.Empty);
}
string[] monthsArr = Resources.Resource.Admin_Charts_Months.Split(',');
for (var i = new DateTime(minDate.AddMonths(1).Year, minDate.AddMonths(1).Month, 1); i < maxDate;)
{
result.AppendFormat("[{0}, {1}],", monthsArr[i.Month - 1], data.ContainsKey(i) ? data[i] : 0);
i = i.AddMonths(1);
}
result.Remove(result.ToString().LastIndexOf(','), 1);
return(result.ToString());
}
public bool SaveData()
{
bool isValid = true;
float sales = 0;
float profit = 0;
if (float.TryParse(txtSalesPlan.Text.Replace(" ", ""), out sales) && sales > 0 && float.TryParse(txtProfitPlan.Text.Replace(" ", ""), out profit) && profit > 0)
{
OrderStatisticsService.SetProfitPlan(sales, profit);
}
else
{
ErrMessage += Resource.Admin_CommonSettings_ProfitError;
isValid = false;
}
LoadData();
return(isValid);
}
public new void SaveData()
{
float sales;
float profit;
StringHelper.GetMoneyFromString(txtPlan.Text, out sales);
StringHelper.GetMoneyFromString(txtPlaPribl.Text, out profit);
OrderStatisticsService.SetProfitPlan(sales, profit);
SettingsOrderConfirmation.AmountLimitation = chbCheakProductCount.Checked;
float minimalOrderPrice;
float minimalPriceCertificate;
float maximalPriceCertificate;
StringHelper.GetMoneyFromString(txtMinOrderPrice.Text, out minimalOrderPrice);
SettingsOrderConfirmation.MinimalOrderPrice = minimalOrderPrice;
StringHelper.GetMoneyFromString(txtMinPriceGift.Text, out minimalPriceCertificate);
SettingsOrderConfirmation.MinimalPriceCertificate = minimalPriceCertificate;
StringHelper.GetMoneyFromString(txtMaxPriceGift.Text, out maximalPriceCertificate);
SettingsOrderConfirmation.MaximalPriceCertificate = maximalPriceCertificate;
SettingsBank.Address = txtCompanyAddress.Text;
SettingsBank.CompanyName = txtCompanyName.Text;
SettingsBank.INN = txtInn.Text;
SettingsBank.KPP = txtKPP.Text;
SettingsBank.RS = txtRachetniChet.Text;
SettingsBank.BankName = txtBankName.Text;
SettingsBank.KS = txtKorrecpChet.Text;
SettingsBank.BIK = txtBik.Text;
if (fuPechat.HasFile)
{
FileHelpers.CreateDirectory(FoldersHelper.GetPathAbsolut(FolderType.Pictures));
FileHelpers.DeleteFile(FoldersHelper.GetPathAbsolut(FolderType.Pictures, SettingsBank.StampImageName));
SettingsBank.StampImageName = fuPechat.FileName;
fuPechat.SaveAs(FoldersHelper.GetPathAbsolut(FolderType.Pictures, fuPechat.FileName));
}
}
protected void Page_Load(object sender, EventArgs e)
{
var result = new StringBuilder();
var data = OrderStatisticsService.GetShippingMethodRating();
if (data == null)
{
dataRow = "";
}
else
{
int total = data.Sum(kv => kv.Value);
foreach (KeyValuePair <string, int> kv in data)
{
GdataRow += string.Format("['{0}', {1}],", kv.Key, kv.Value);
methods += String.Format("'{0}',", kv.Key);
result.AppendFormat("[{0}],", kv.Value);
percents += string.Format("'{0}',", ((decimal)kv.Value / (decimal)total).ToString("P"));
}
if (!string.IsNullOrEmpty(GdataRow))
{
GdataRow = GdataRow.TrimEnd(',');
}
if (!string.IsNullOrEmpty(methods))
{
methods = methods.TrimEnd(new char[] { ',' });
}
if (!string.IsNullOrEmpty(percents))
{
percents = percents.TrimEnd(new char[] { ',' });
}
if (result.Length > 0)
{
result.Remove(result.ToString().LastIndexOf(','), 1);
}
dataRow = result.ToString();
}
}
private string RenderOrdersCountGraph(DateTime dateFrom, DateTime dateTo)
{
var listSum = OrderStatisticsService.GetOrdersCountGroupByDay(_groupFormatString, dateFrom, dateTo, _paied, _statusId);
var data = "";
switch (_groupBy)
{
case EGroupDateBy.Day:
data = GetByDays(listSum, dateFrom, dateTo);
break;
case EGroupDateBy.Week:
data = GetByWeeks(listSum, dateFrom, dateTo);
break;
case EGroupDateBy.Month:
data = GetByMonths(listSum, dateFrom, dateTo);
break;
}
return(String.Format("[{{label: '{0}', data:[{1}]}}]", Resource.Admin_Statistics_OrdersByCount, data));
}
private void LoadTopProductsBySum()
{
lvProductsBySum.DataSource = OrderStatisticsService.GetTopProductsBySum();
lvProductsBySum.DataBind();
}
private void LoadTopCustomers()
{
lvCustomers.DataSource = OrderStatisticsService.GetTopCustomersBySumPrice();
lvCustomers.DataBind();
}
public ICollection <OrderStatistic> GetCollection()
{
return(OrderStatisticsService.GetAllStatistics());
}
