public ColumnChartViewModel()
{
this.SneakersDetail = new ObservableCollection <ColumnChartModel>();
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "Adidas", ItemsCount = 25
});
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "Nike", ItemsCount = 17
});
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "Reebok", ItemsCount = 30
});
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "Fila", ItemsCount = 18
});
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "Puma", ItemsCount = 10
});
SneakersDetail.Add(new ColumnChartModel()
{
Brand = "TATA", ItemsCount = 21
});
}
public ViewModel()
{
this.SneakersDetail = new ObservableCollection <Model>();
SneakersDetail.Add(new Model()
{
Brand = "Adidas", ItemsCount = 30, ItemsCount1 = 20
});
SneakersDetail.Add(new Model()
{
Brand = "Nike", ItemsCount = 27, ItemsCount1 = 14
});
SneakersDetail.Add(new Model()
{
Brand = "Reebok", ItemsCount = 44, ItemsCount1 = 20
});
SneakersDetail.Add(new Model()
{
Brand = "Fila", ItemsCount = 28, ItemsCount1 = 10
});
SneakersDetail.Add(new Model()
{
Brand = "Puma", ItemsCount = 20, ItemsCount1 = 8
});
}
public void ViewModel()
{
this.SneakersDetail = new ObservableCollection <Model>();
if (TuNgayDatePicker.SelectedDate != null && DenNgayDatePicker.SelectedDate != null)
{
SneakersDetail.Clear();
var dataCate = db.Categories.Select(p => p).ToList();
for (int i = 0; i < dataCate.Count; i++)
{
Nullable <int> IDCate = dataCate[i].IDCategory;
var QuantityResult = (from od in db.OrderDetails
join p in db.Products on od.ProductID equals p.IDProduct
where p.CategoryID == IDCate && od.CreatedAt >= TuNgay && od.CreatedAt <= DenNgay
select od.QuantityOrderDetail).Sum();
if (QuantityResult != null)
{
SneakersDetail.Add(new Model()
{
NCategory = dataCate[i].NameCategory, ItemsCount = (int)QuantityResult
});
}
else
{
SneakersDetail.Add(new Model()
{
NCategory = dataCate[i].NameCategory, ItemsCount = 0
});
}
}
NotifyChange("SneakersDetail");
}
}
public MVVMBindingViewModel()
{
var date = new DateTime(2018, 1, 1);
this.SneakersDetail = new ObservableCollection <MVVMBindingModel>();
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(0), Rainfall = 22.86
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(1), Rainfall = 70.866
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(2), Rainfall = 183.642
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(3), Rainfall = 85.09
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(4), Rainfall = 66.294
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(5), Rainfall = 52.07
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(6), Rainfall = 96.52
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(7), Rainfall = 94.234
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(8), Rainfall = 111.252
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(9), Rainfall = 130.81
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(10), Rainfall = 159.512
});
SneakersDetail.Add(new MVVMBindingModel()
{
Month = date.AddMonths(11), Rainfall = 91.694
});
}
public SneakerDetails()
{
this.SneakersDetail = new ObservableCollection <Sneaker>();
SneakersDetail.Add(new Sneaker()
{
Brand = "Adidas", NoOfItems = 25
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Nike", NoOfItems = 17
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Reebok", NoOfItems = 34
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Fila", NoOfItems = 18
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Puma", NoOfItems = 10
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Fastrack", NoOfItems = 27
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Yepme", NoOfItems = 17
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Zovi", NoOfItems = 10
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Woodland", NoOfItems = 22
});
ResourceFac = new ResourceFactory();
AdornmentInfo = new ChartAdornmentInfo();
AdornmentInfo.ShowLabel = true;
AdornmentInfo.Symbol = ChartSymbol.Ellipse;
AdornmentInfo.LabelTemplate = ResourceFac.labelTemplate19;
}
public StepAreaChartViewModel()
{
this.SneakersDetail = new ObservableCollection <StepAreaChartModel>();
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Adidas", ItemsCount = 416, ItemsCount1 = 180
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Nike", ItemsCount = 490, ItemsCount1 = 240
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Reebok", ItemsCount = 470, ItemsCount1 = 370
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Fila", ItemsCount = 500, ItemsCount1 = 200
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Puma", ItemsCount = 449, ItemsCount1 = 229
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "New Balance", ItemsCount = 470, ItemsCount1 = 210
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Asics", ItemsCount = 437, ItemsCount1 = 337
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Skechers", ItemsCount = 458, ItemsCount1 = 258
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Bata", ItemsCount = 500, ItemsCount1 = 300
});
SneakersDetail.Add(new StepAreaChartModel()
{
Brand = "Burberry", ItemsCount = 473, ItemsCount1 = 173
});
//SneakersDetail.Add(new StepAreaChartModel() { Brand = "VF Corporation", ItemsCount = 520, ItemsCount1 = 220 });
}
public SneakerDetails()
{
this.SneakersDetail = new ObservableCollection <Sneaker>();
SneakersDetail.Add(new Sneaker()
{
Brand = "Adidas", ItemsCount = 25
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Nike", ItemsCount = 17
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Reebok", ItemsCount = 34
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Fila", ItemsCount = 18
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Puma", ItemsCount = 10
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Fastrack", ItemsCount = 27
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Yepme", ItemsCount = 17
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Zovi", ItemsCount = 10
});
SneakersDetail.Add(new Sneaker()
{
Brand = "Woodland", ItemsCount = 22
});
}
public ViewModel()
{
this.SneakersDetail = new ObservableCollection <Model>();
if (TrangThongKe.KieuThongKe == 0)
{
int YearXet = TrangThongKe.Year;
int MonthXet = TrangThongKe.Month;
DateTime DateXet = new DateTime(YearXet, MonthXet, 1);
int DaysOfMonthXet = DateTime.DaysInMonth(YearXet, MonthXet);
for (int i = 1; i <= DaysOfMonthXet; ++i)
{
DateTime date = new DateTime(YearXet, MonthXet, i);
double DoanhThu = 0;
var db = new MyDatabaseEntities();
foreach (var DH in db.DonHangs.ToList())
{
DateTime ngayTao = (DateTime)DH.NgayTao;
if (ngayTao.Day == date.Day && ngayTao.Month == date.Month && ngayTao.Year == date.Year)
{
DoanhThu += (double)DH.TongGiaTriBan - (double)DH.TongGiaTriNhap;
}
}
SneakersDetail.Add(new Model()
{
Brand = "" + i, ItemsCount = DoanhThu / 1000000
});
}
}
else if (TrangThongKe.KieuThongKe == 1)
{
int YearXet = TrangThongKe.Year;
for (int i = 1; i <= 12; ++i)
{
DateTime datestart = new DateTime(YearXet, i, 1);
DateTime dateEnd;
if (i + 1 > 12)
{
dateEnd = new DateTime(YearXet + 1, i, 1);
}
else
{
dateEnd = new DateTime(YearXet, i + 1, 1);
}
double DoanhThu = 0;
var db = new MyDatabaseEntities();
foreach (var DH in db.DonHangs.ToList())
{
if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd)
{
DoanhThu += (double)DH.TongGiaTriBan - (double)DH.TongGiaTriNhap;
}
}
SneakersDetail.Add(new Model()
{
Brand = "" + i, ItemsCount = DoanhThu / 1000000
});
}
}
else if (TrangThongKe.KieuThongKe == 2)
{
int YearXet = TrangThongKe.Year;
int i = 1;
while (true)
{
DateTime datestart = new DateTime(YearXet, i, 1);
DateTime dateEnd;
if (i == 10)
{
dateEnd = new DateTime(YearXet + 1, 1, 1);
}
else
{
dateEnd = new DateTime(YearXet, i + 3, 1);
}
double DoanhThu = 0;
var db = new MyDatabaseEntities();
foreach (var DH in db.DonHangs.ToList())
{
if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd)
{
DoanhThu += (double)DH.TongGiaTriBan / 1000000 - (double)DH.TongGiaTriNhap / 1000000;
}
}
if (i == 1)
{
SneakersDetail.Add(new Model()
{
Brand = "Quý " + 1, ItemsCount = DoanhThu
});
i = 4;
}
else if (i == 4)
{
SneakersDetail.Add(new Model()
{
Brand = "Quý " + 2, ItemsCount = DoanhThu
});
i = 7;
}
else if (i == 7)
{
SneakersDetail.Add(new Model()
{
Brand = "Quý " + 3, ItemsCount = DoanhThu
});
i = 10;
}
else if (i == 10)
{
SneakersDetail.Add(new Model()
{
Brand = "Quý " + 4, ItemsCount = DoanhThu
});
break;
}
}
}
else if (TrangThongKe.KieuThongKe == 3)
{
int YearNow = DateTime.Now.Year;
for (int i = 2015; i <= YearNow; ++i)
{
DateTime datestart = new DateTime(i, 1, 1);
DateTime dateEnd = new DateTime(i + 1, 1, 1);;
double DoanhThu = 0;
var db = new MyDatabaseEntities();
foreach (var DH in db.DonHangs.ToList())
{
if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd)
{
DoanhThu += (double)DH.TongGiaTriBan - (double)DH.TongGiaTriNhap;
}
}
SneakersDetail.Add(new Model()
{
Brand = "" + i, ItemsCount = DoanhThu / 1000000
});
}
}
else if (TrangThongKe.KieuThongKe == 4)
{
DateTime datestart = TrangThongKe.DateStart;
DateTime dateEnd = TrangThongKe.DateEnd;
DateTime dateNow = datestart;
while (true)
{
double DoanhThu = 0;
var db = new MyDatabaseEntities();
foreach (var DH in db.DonHangs.ToList())
{
DateTime temp = (DateTime)DH.NgayTao;
if (temp.Month == dateNow.Month && temp.Year == dateNow.Year && temp.Day == dateNow.Day)
{
DoanhThu += (double)DH.TongGiaTriBan - (double)DH.TongGiaTriNhap;
}
}
SneakersDetail.Add(new Model()
{
Brand = dateNow.ToShortDateString(), ItemsCount = DoanhThu / 1000000
});
dateNow = dateNow.AddDays(1);
if (dateNow == dateEnd)
{
break;
}
}
}
}
