private void btnXacNhanThemSanPham_Click(object sender, RoutedEventArgs e) { //Kiem Tra Form Rỗng if ("" == txtTenSanPham.Text || "" == txtGiaNhap.Text || "" == txtGiaBan.Text || "" == txtSoLuong.Text || cmbHangSanXuat.SelectedIndex == -1 || cmbMucDich.SelectedIndex == -1) { MessageBox.Show("Vui Lòng Không Để Trống"); return; } if (Int32.Parse(txtSoLuong.Text) < 0 || Int32.Parse(txtGiaBan.Text) < 0 || Int32.Parse(txtGiaNhap.Text) < 0) { MessageBox.Show("Vui Lòng Kiểm Tra Lại Giá Trị Nhập"); return; } if (bitmapImageSanPham == null) { MessageBox.Show("Vui Lòng Chọn Ảnh Hiện Thị"); return; } var db = new MyDatabaseEntities(); //Convert Ảnh byte[] imageData = new byte[bitmapImageSanPham.StreamSource.Length]; bitmapImageSanPham.StreamSource.Seek(0, System.IO.SeekOrigin.Begin); bitmapImageSanPham.StreamSource.Read(imageData, 0, imageData.Length); //Tim ID Loai San Pham int ID_LoaiSanPham = -1; foreach (var value in db.LoaiSanPhams.ToList()) { if (cmbHangSanXuat.SelectedValue.ToString() == value.HangSanXuat && cmbMucDich.SelectedValue.ToString() == value.MucDich) { ID_LoaiSanPham = value.ID; break; } } // Lay Gia Tri Hien Thi int CheckHienThi = cbHienThi.IsChecked == true ? 1 : 0; db.SanPhams.Add(new SanPham() { HinhAnh = imageData, Ten = txtTenSanPham.Text, LoaiSanPham_ID = ID_LoaiSanPham, GiaNhap = Int32.Parse(txtGiaNhap.Text), GiaBan = Int32.Parse(txtGiaBan.Text), HienThi = CheckHienThi, SoLuong = Int32.Parse(txtSoLuong.Text) }); db.SaveChanges(); MessageBox.Show("Thêm Thành Công"); txtTenSanPham.Text = ""; txtGiaNhap.Text = ""; txtGiaBan.Text = ""; txtSoLuong.Text = ""; cmbHangSanXuat.SelectedIndex = -1; cmbMucDich.SelectedIndex = -1; img_SanPham.Source = new BitmapImage(new Uri("images/device-camera-icon.png", UriKind.Relative)); bitmapImageSanPham = null; }
private void btnXoa_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Bạn Chắc Chắn Muốn Xóa Chứ ?", "Thông Báo", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { var db = new MyDatabaseEntities(); var Element = db.SanPhams.Find(ID_OFItemSelected); Element.HienThi = 0; db.SaveChanges(); DanhSachSanPham.LoadSanPham(); // Load Lai Hien Thi Danh Sach San Pham NavigationService.GoBack(); } }
public void LoadListView() { MyDatabaseEntities db = new MyDatabaseEntities(); foreach (var value in db.DonHangs.ToList()) { DonHangHienThi x = new DonHangHienThi(); if (value.TinhTrang == 0) { x.TinhTrang = new BitmapImage(new Uri(@"images/cancel-button.png", UriKind.Relative)); } else { x.TinhTrang = new BitmapImage(new Uri(@"images/checking-mark-circle.png", UriKind.Relative)); } if (value.LoaiThanhDon == 0) { x.LoaiDonHang = new BitmapImage(new Uri(@"images/online-shopping-cart.png", UriKind.Relative)); } else if (value.LoaiThanhDon == 1) { x.LoaiDonHang = new BitmapImage(new Uri(@"images/delivery-truck.png", UriKind.Relative)); } else { x.LoaiDonHang = new BitmapImage(new Uri(@"images/coins.png", UriKind.Relative)); } if (value.KhachHang_CMND != null) { x.CMND = value.KhachHang_CMND; x.HoTen = value.KhachHang.HoTen; x.SDT = value.KhachHang.SDT; x.DiaChi = value.KhachHang.DiaChi; x.TienConLai = string.Format("{0:0,0}", value.TienConLaiPhaiTra); } else { x.TienConLai = "0"; } x.ID = value.ID; x.Ngay = (DateTime)value.NgayTao; x.TongTien = string.Format("{0:0,0}", value.TongGiaTriBan); ListDHHT.data.Add(x); } ltDonHang.ItemsSource = ListDHHT.data; }
public void LoadComboBox() { var db = new MyDatabaseEntities(); cmbHangSanXuat.Items.Clear(); foreach (var value in db.LoaiSanPhams.ToList()) { if (cmbHangSanXuat.Items.IndexOf(value.HangSanXuat) == -1) { cmbHangSanXuat.Items.Add(value.HangSanXuat); } } }
private void btnExcelXNLoaiSanPham_Click(object sender, RoutedEventArgs e) { if (txtPathLoaiSanPham.Text == "") { MessageBox.Show("Vui Lòng Chọn Đường Dẫn", "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error); return; } var db = new MyDatabaseEntities(); try { Excel excel = new Excel(txtPathLoaiSanPham.Text, 1); for (int i = 1;; ++i) { string value_HangSanXuat = excel.ReadCell(i, 0); string value_MucDich = excel.ReadCell(i, 1); if (value_HangSanXuat == "") { break; } //Kiểm Tra Tồn Tại bool CheckTonTai = false; foreach (LoaiSanPham loaiSanPham in db.LoaiSanPhams.ToList()) { if (loaiSanPham.HangSanXuat == value_HangSanXuat && loaiSanPham.MucDich == value_MucDich) { CheckTonTai = true; break; } } if (CheckTonTai == false) { db.LoaiSanPhams.Add(new LoaiSanPham() { HangSanXuat = value_HangSanXuat, MucDich = value_MucDich }); db.SaveChanges(); } } } catch { MessageBox.Show("File Không Hợp Lệ", "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error); } MessageBox.Show("Thêm Thành Công"); }
private void btnXacNhanSuaSanPham_Click(object sender, RoutedEventArgs e) { //Kiem Tra Form Rỗng if ("" == txtTenSanPham.Text || "" == txtGiaNhap.Text || "" == txtGiaBan.Text || "" == txtSoLuong.Text || cmbHangSanXuat.SelectedIndex == -1 || cmbMucDich.SelectedIndex == -1) { MessageBox.Show("Vui Lòng Không Để Trống"); return; } if (Int32.Parse(txtSoLuong.Text) < 0 || Int32.Parse(txtGiaBan.Text) < 0 || Int32.Parse(txtGiaNhap.Text) < 0) { MessageBox.Show("Vui Lòng Kiểm Tra Lại Giá Trị Nhập"); return; } var db = new MyDatabaseEntities(); var element = db.SanPhams.Find(ID_OFItemSelected); //Convert Ảnh byte[] imageData = new byte[bitmapImageSanPham.StreamSource.Length]; bitmapImageSanPham.StreamSource.Seek(0, System.IO.SeekOrigin.Begin); bitmapImageSanPham.StreamSource.Read(imageData, 0, imageData.Length); //Tim ID Loai San Pham int ID_LoaiSanPham = -1; foreach (var value in db.LoaiSanPhams.ToList()) { if (cmbHangSanXuat.SelectedValue.ToString() == value.HangSanXuat && cmbMucDich.SelectedValue.ToString() == value.MucDich) { ID_LoaiSanPham = value.ID; break; } } // Lay Gia Tri Hien Thi element.HinhAnh = imageData; element.Ten = txtTenSanPham.Text; element.LoaiSanPham_ID = ID_LoaiSanPham; element.GiaNhap = Int32.Parse(txtGiaNhap.Text); element.GiaBan = Int32.Parse(txtGiaBan.Text); element.SoLuong = Int32.Parse(txtSoLuong.Text); db.SaveChanges(); MessageBox.Show("Sữa Thành Công"); DanhSachSanPham.LoadSanPham(); // Load Lai Sau Khi Sua }
static public void LoadSanPham() { List <SanPhamHienThi> data = new List <SanPhamHienThi>(); var db = new MyDatabaseEntities(); var listDatabaseSanPham = db.SanPhams.ToList(); int CountPhanTuHienThi = 0; for (int i = 0; i < listDatabaseSanPham.Count; ++i) { var element = listDatabaseSanPham[i]; if (element.HienThi == 1) { if (CountPhanTuHienThi >= TrangHienTai * SoPhanTuTrenMotTrang && CountPhanTuHienThi < (TrangHienTai * SoPhanTuTrenMotTrang) + SoPhanTuTrenMotTrang) { //Convert Ảnh System.IO.MemoryStream ms = new System.IO.MemoryStream(element.HinhAnh); ms.Seek(0, System.IO.SeekOrigin.Begin); BitmapImage newBitmapImage = new BitmapImage(); newBitmapImage.BeginInit(); newBitmapImage.StreamSource = ms; newBitmapImage.EndInit(); //Add Element data.Add(new SanPhamHienThi() { ID = element.ID, Name = element.Ten, PathImage = newBitmapImage, Price = string.Format("{0:0,0} VND", (int)element.GiaBan) }); } ++CountPhanTuHienThi; } } MaxTrang = (int)Math.Ceiling((double)CountPhanTuHienThi / SoPhanTuTrenMotTrang); if (data.Count >= 1) { for (int i = 12 - data.Count; i > 0; --i) { data.Add(new SanPhamHienThi() { ID = -1 }); } } ltSanPham_Temp.ItemsSource = data; }
private void cmbHangSanXuat_SelectionChanged(object sender, SelectionChangedEventArgs e) { // Khong Xu Ly if (cmbHangSanXuat.SelectedIndex == -1) { return; } var db = new MyDatabaseEntities(); cmbMucDich.Items.Clear(); foreach (var value in db.LoaiSanPhams.ToList()) { if (cmbHangSanXuat.SelectedValue.ToString() == value.HangSanXuat) { cmbMucDich.Items.Add(value.MucDich); } } }
private void btnThanhToan_Click(object sender, RoutedEventArgs e) { int ID_HD_Load = TrangDonHang.IDofItemSelected; var db = new MyDatabaseEntities(); DonHang x = db.DonHangs.Find(ID_HD_Load); x.TinhTrang = 1; db.SaveChanges(); foreach (var value in ListDHHT.data) { if (value.ID == x.ID) { value.TinhTrang = new BitmapImage(new Uri(@"images/checking-mark-circle.png", UriKind.Relative)); break; } } MessageBox.Show("Thành Công"); btnThanhToan.Visibility = Visibility.Hidden; }
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; } } } }
public ViewModelHinhTronHinhTron() { this.Tax = new List <ModelHinhTron>(); var db = new MyDatabaseEntities(); if (TrangThongKe.KieuThongKe == 0) { int YearXet = TrangThongKe.Year; int MonthXet = TrangThongKe.Month; int DayXet = TrangThongKe.Day; //Tong SLL SP int TongSLDaBan = 0; List <GioHang> data = new List <GioHang>(); foreach (var DH in db.DonHangs.ToList()) { DateTime dateTime = (DateTime)DH.NgayTao; if (dateTime.Year == YearXet && dateTime.Month == MonthXet && dateTime.Day == DayXet) { foreach (var GH in db.GioHangs.ToList()) { if (DH.GioHang.ID == GH.ID) { data.Add(GH); TongSLDaBan += (int)GH.SoLuong; } } } } for (int i = 0; i < data.Count; ++i) { if (data[i].SanPham_ID == 0) { continue; } int TongSL = (int)data[i].SoLuong; for (int j = i + 1; j < data.Count; ++j) { if (data[i].SanPham_ID == data[j].SanPham_ID) { TongSL += (int)data[j].SoLuong; data[j].SanPham_ID = 0; } } Tax.Add(new ModelHinhTron() { Category = data[i].SanPham.Ten, Percentage = (double)TongSL * 100 / TongSLDaBan }); } } else if (TrangThongKe.KieuThongKe == 1) { int YearXet = TrangThongKe.Year; int MonthXet = TrangThongKe.Month; //Tong SLL SP int TongSLDaBan = 0; List <GioHang> data = new List <GioHang>(); foreach (var DH in db.DonHangs.ToList()) { DateTime dateTime = (DateTime)DH.NgayTao; if (dateTime.Year == YearXet && dateTime.Month == MonthXet) { foreach (var GH in db.GioHangs.ToList()) { if (DH.GioHang.ID == GH.ID) { data.Add(GH); TongSLDaBan += (int)GH.SoLuong; } } } } for (int i = 0; i < data.Count; ++i) { if (data[i].SanPham_ID == 0) { continue; } int TongSL = (int)data[i].SoLuong; for (int j = i + 1; j < data.Count; ++j) { if (data[i].SanPham_ID == data[j].SanPham_ID) { TongSL += (int)data[j].SoLuong; data[j].SanPham_ID = 0; } } Tax.Add(new ModelHinhTron() { Category = data[i].SanPham.Ten, Percentage = (double)TongSL * 100 / TongSLDaBan }); } } else if (TrangThongKe.KieuThongKe == 2) { int YearXet = TrangThongKe.Year; int QuyXet = TrangThongKe.Quy; int MonthStart = -1; int MonthEnd = -1; if (QuyXet == 1) { MonthStart = 1; MonthEnd = 3; } else if (QuyXet == 2) { MonthStart = 4; MonthEnd = 6; } else if (QuyXet == 3) { MonthStart = 7; MonthEnd = 9; } else if (QuyXet == 4) { MonthStart = 10; MonthEnd = 12; } //Tong SLL SP int TongSLDaBan = 0; List <GioHang> data = new List <GioHang>(); foreach (var DH in db.DonHangs.ToList()) { DateTime dateTime = (DateTime)DH.NgayTao; if (dateTime.Year == YearXet && dateTime.Month >= MonthStart && dateTime.Month <= MonthEnd) { foreach (var GH in db.GioHangs.ToList()) { if (DH.GioHang.ID == GH.ID) { data.Add(GH); TongSLDaBan += (int)GH.SoLuong; } } } } for (int i = 0; i < data.Count; ++i) { if (data[i].SanPham_ID == 0) { continue; } int TongSL = (int)data[i].SoLuong; for (int j = i + 1; j < data.Count; ++j) { if (data[i].SanPham_ID == data[j].SanPham_ID) { TongSL += (int)data[j].SoLuong; data[j].SanPham_ID = 0; } } Tax.Add(new ModelHinhTron() { Category = data[i].SanPham.Ten, Percentage = (double)TongSL * 100 / TongSLDaBan }); } } else if (TrangThongKe.KieuThongKe == 3) { int YearXet = TrangThongKe.Year; //Tong SLL SP int TongSLDaBan = 0; List <GioHang> data = new List <GioHang>(); foreach (var DH in db.DonHangs.ToList()) { DateTime dateTime = (DateTime)DH.NgayTao; if (dateTime.Year == YearXet) { foreach (var GH in db.GioHangs.ToList()) { if (DH.GioHang.ID == GH.ID) { data.Add(GH); TongSLDaBan += (int)GH.SoLuong; } } } } for (int i = 0; i < data.Count; ++i) { if (data[i].SanPham_ID == 0) { continue; } int TongSL = (int)data[i].SoLuong; for (int j = i + 1; j < data.Count; ++j) { if (data[i].SanPham_ID == data[j].SanPham_ID) { TongSL += (int)data[j].SoLuong; data[j].SanPham_ID = 0; } } Tax.Add(new ModelHinhTron() { Category = data[i].SanPham.Ten, Percentage = (double)TongSL * 100 / TongSLDaBan }); } } else if (TrangThongKe.KieuThongKe == 4) { DateTime datestart = TrangThongKe.DateStart; DateTime dateEnd = TrangThongKe.DateEnd; DateTime dateNow = datestart; //Tong SLL SP int TongSLDaBan = 0; List <GioHang> data = new List <GioHang>(); foreach (var DH in db.DonHangs.ToList()) { DateTime dateTime = (DateTime)DH.NgayTao; if (dateTime >= datestart && dateTime <= dateEnd) { foreach (var GH in db.GioHangs.ToList()) { if (DH.GioHang.ID == GH.ID) { data.Add(GH); TongSLDaBan += (int)GH.SoLuong; } } } } for (int i = 0; i < data.Count; ++i) { if (data[i].SanPham_ID == 0) { continue; } int TongSL = (int)data[i].SoLuong; for (int j = i + 1; j < data.Count; ++j) { if (data[i].SanPham_ID == data[j].SanPham_ID) { TongSL += (int)data[j].SoLuong; data[j].SanPham_ID = 0; } } Tax.Add(new ModelHinhTron() { Category = data[i].SanPham.Ten, Percentage = (double)TongSL * 100 / TongSLDaBan }); } } }
private void btnExcelXNSanPham_Click(object sender, RoutedEventArgs e) { if (txtPathSanPham.Text == "") { MessageBox.Show("Vui Lòng Chọn Đường Dẫn", "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error); return; } var db = new MyDatabaseEntities(); try { Excel excel = new Excel(txtPathSanPham.Text, 1); for (int i = 1; ; ++i) { string value_Ten = excel.ReadCell(i, 0); if (value_Ten == "") { break; } string value_LinkAnh = excel.ReadCell(i, 1); string value_HangSanXuat = excel.ReadCell(i, 2); string value_MucDich = excel.ReadCell(i, 3); string value_GiaNhap = excel.ReadCell(i, 4); string value_GiaBan = excel.ReadCell(i, 5); string value_SoLuong = excel.ReadCell(i, 6); //Convert Ảnh string PathFolder = txtPathSanPham.Text.Substring(0, txtPathSanPham.Text.LastIndexOf('\\')); bitmapImageSanPham = new BitmapImage(); bitmapImageSanPham.BeginInit(); bitmapImageSanPham.StreamSource = System.IO.File.OpenRead(PathFolder + "\\" + value_LinkAnh); bitmapImageSanPham.EndInit(); byte[] imageData = new byte[bitmapImageSanPham.StreamSource.Length]; bitmapImageSanPham.StreamSource.Seek(0, System.IO.SeekOrigin.Begin); bitmapImageSanPham.StreamSource.Read(imageData, 0, imageData.Length); //Kiểm Tra Tồn Tại bool CheckTonTai = false; int IDLoaiSanPhamTonTai = -1; foreach (LoaiSanPham loaiSanPham in db.LoaiSanPhams.ToList()) { if (loaiSanPham.HangSanXuat == value_HangSanXuat && loaiSanPham.MucDich == value_MucDich) { CheckTonTai = true; IDLoaiSanPhamTonTai = loaiSanPham.ID; break; } } if (CheckTonTai == false) { db.LoaiSanPhams.Add(new LoaiSanPham() { HangSanXuat = value_HangSanXuat, MucDich = value_MucDich }); db.SaveChanges(); db.SanPhams.Add(new SanPham() { Ten = value_Ten, HinhAnh = imageData, LoaiSanPham_ID = db.LoaiSanPhams.ToList()[db.LoaiSanPhams.ToList().Count - 1].ID, GiaNhap = Int32.Parse(value_GiaNhap), GiaBan = Int32.Parse(value_GiaBan), SoLuong = Int32.Parse(value_SoLuong), HienThi = 1 }); db.SaveChanges(); } else { db.SanPhams.Add(new SanPham() { Ten = value_Ten, HinhAnh = imageData, LoaiSanPham_ID = IDLoaiSanPhamTonTai, GiaNhap = Int32.Parse(value_GiaNhap), GiaBan = Int32.Parse(value_GiaBan), SoLuong = Int32.Parse(value_SoLuong), HienThi = 1 }); db.SaveChanges(); } } } catch { MessageBox.Show("File Không Hợp Lệ", "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error); return; } MessageBox.Show("Thêm Thành Công"); }
public TrangHoaDon() { InitializeComponent(); //Add ComboLoaiHoaDoan cmbLoaiHoaDon.Items.Add("Trực Tiếp"); // 0 cmbLoaiHoaDon.Items.Add("Giao Hàng"); // 1 cmbLoaiHoaDon.Items.Add("Đặt Cọc"); // 2 cmbLoaiHoaDon.SelectedIndex = 0; //Load Thong tin Don Hang int ID_HD_Load = TrangDonHang.IDofItemSelected; var db = new MyDatabaseEntities(); DonHang x = db.DonHangs.Find(ID_HD_Load); if (x.TinhTrang == 1) { btnThanhToan.Visibility = Visibility.Hidden; } lblTongTien.Content = string.Format("{0:0,0}", x.TongGiaTriBan); txtTienDatCoc.Text = string.Format("{0:0,0}", (x.TongGiaTriBan - x.TienConLaiPhaiTra)); if (x.MaKhuyenMai != null) { txtMaKhuyenMai.Text = x.MaKhuyenMai.Ten; if (x.MaKhuyenMai.Loai == "Tiền Cố Định") { lblKhuyenMai.Content = string.Format("- {0:0,0}", Int32.Parse(x.MaKhuyenMai.GiaTri)); lblTongGiaTri.Content = string.Format("{0:0,0}", (x.TongGiaTriBan + Int32.Parse(x.MaKhuyenMai.GiaTri))); } else { float GiaTriKM = float.Parse(x.MaKhuyenMai.GiaTri); float PhanChia = (1 - GiaTriKM / 100); lblTongGiaTri.Content = string.Format("{0:0,0}", ((float)x.TongGiaTriBan / PhanChia)); lblKhuyenMai.Content = string.Format("- {0:0,0}", ((float)x.TongGiaTriBan / PhanChia) * GiaTriKM / 100); } } else { lblTongGiaTri.Content = lblTongTien.Content; } cmbLoaiHoaDon.SelectedIndex = (int)x.LoaiThanhDon; if (x.KhachHang_CMND != null) { txtCMND.Text = x.KhachHang_CMND; txtHoTen.Text = x.KhachHang.HoTen; txtSDT.Text = x.KhachHang.SDT; txtDiaChi.Text = x.KhachHang.DiaChi; } //Load ltGioHang List <SanPhamGioHangHienThi> Temp = new List <SanPhamGioHangHienThi>(); foreach (var value in db.GioHangs) { if (x.GioHang.ID == value.ID) { SanPham SP = db.SanPhams.Find(value.SanPham_ID); //Convert Ảnh System.IO.MemoryStream ms = new System.IO.MemoryStream(SP.HinhAnh); ms.Seek(0, System.IO.SeekOrigin.Begin); BitmapImage newBitmapImage = new BitmapImage(); newBitmapImage.BeginInit(); newBitmapImage.StreamSource = ms; newBitmapImage.EndInit(); Temp.Add(new SanPhamGioHangHienThi() { PathImage = newBitmapImage, Name = SP.Ten, Price = string.Format("{0}", (int)SP.GiaBan), Count = value.SoLuong.ToString() }); } } ltGioHang.ItemsSource = Temp; }
public ViewModelKhachHang() { this.DataPoints = new ObservableCollection <ModelKhachHang>(); 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 TongNhap = 0; double TongBan = 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) { TongNhap = (double)DH.TongGiaTriNhap; TongBan = (double)DH.TongGiaTriBan; } } DataPoints.Add(new ModelKhachHang() { TimeXet = i.ToString(), TienNhap = TongNhap / 1000000, TienBan = TongBan / 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 TongNhap = 0; double TongBan = 0; var db = new MyDatabaseEntities(); foreach (var DH in db.DonHangs.ToList()) { if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd) { TongNhap += (double)DH.TongGiaTriNhap; TongBan += (double)DH.TongGiaTriBan; } } DataPoints.Add(new ModelKhachHang() { TimeXet = i.ToString(), TienNhap = TongNhap / 1000000, TienBan = TongBan / 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 TongNhap = 0; double TongBan = 0; var db = new MyDatabaseEntities(); foreach (var DH in db.DonHangs.ToList()) { if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd) { TongNhap += (double)DH.TongGiaTriNhap; TongBan += (double)DH.TongGiaTriBan; } } if (i == 1) { DataPoints.Add(new ModelKhachHang() { TimeXet = "Quý 1", TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); i = 4; } else if (i == 4) { DataPoints.Add(new ModelKhachHang() { TimeXet = "Quý 2", TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); i = 7; } else if (i == 7) { DataPoints.Add(new ModelKhachHang() { TimeXet = "Quý 3", TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); i = 10; } else if (i == 10) { DataPoints.Add(new ModelKhachHang() { TimeXet = "Quý 4", TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); 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 TongNhap = 0; double TongBan = 0; var db = new MyDatabaseEntities(); foreach (var DH in db.DonHangs.ToList()) { if (DH.NgayTao >= datestart && DH.NgayTao < dateEnd) { TongNhap += (double)DH.TongGiaTriNhap; TongBan += (double)DH.TongGiaTriBan; } } DataPoints.Add(new ModelKhachHang() { TimeXet = i.ToString(), TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); } } else if (TrangThongKe.KieuThongKe == 4) { DateTime datestart = TrangThongKe.DateStart; DateTime dateEnd = TrangThongKe.DateEnd; DateTime dateXet = datestart; while (true) { double TongNhap = 0; double TongBan = 0; var db = new MyDatabaseEntities(); foreach (var DH in db.DonHangs.ToList()) { DateTime ngayTao = (DateTime)DH.NgayTao; if (ngayTao.Day == dateXet.Day && ngayTao.Month == dateXet.Month && ngayTao.Year == dateXet.Year) { TongNhap = (double)DH.TongGiaTriNhap; TongBan = (double)DH.TongGiaTriBan; } } DataPoints.Add(new ModelKhachHang() { TimeXet = dateXet.ToShortDateString(), TienNhap = TongNhap / 1000000, TienBan = TongBan / 1000000, }); dateXet = dateXet.AddDays(1); if (dateXet == dateEnd) { break; } } } }