void FiterView(int i, int j)
{
if (j == 1)
{
UserControlView.Children.Clear();
HidenView();
hidden1.Width = 0;
hidden4.Visibility = Visibility.Visible;
hidden4.Width = Double.NaN;
ChiTiet.Visibility = Visibility.Visible;
ChiTiet.MaSanPham = i;
ChiTiet.MaNguoiDung = Loged;
UserControlView.Children.Add(ChiTiet);
}
if (j == 2)
{
if (Loged == "")
{
MessageBox.Show("Cần đăng nhập để mua sản phẩm", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
int MaSp = i;
using (var BH = new Models.BanLapTopEntities())
{
if (TonTaiHang(MaSp))
{
var sql = BH.DonHangTemps.Where(m => m.MaSP == MaSp).Single() as DonHangTemp;
int SLMua = sql.SoLuongMua + 1;
sql.SoLuongMua = SLMua;
sql.ThanhTien = sql.ThanhTien + GiaSP(MaSp);
BH.SaveChanges();//lưu thay doi
}
else
{
var sql = new DonHangTemp();
sql.SoLuongMua = 1;
sql.MaDonHang = MaDonHangNext();
sql.MaKhacHang = Loged;
sql.TenKhachHang = NameUser(Loged);
sql.MaSP = MaSp;
sql.TenSP = NameProduct(MaSp);
sql.GiaSP = GiaSP(MaSp);
sql.HinhSP = ImageProduct(MaSp);
sql.ThanhTien = GiaSP(MaSp);
BH.DonHangTemps.Add(sql);
BH.SaveChanges();//lưu thay doi
}
}
}
}
}
private void btnXoa_Click(object sender, RoutedEventArgs e)
{
int ID = (ListGioHang.SelectedItem as HangSanXuat).MaHangSX;
if (ConKinhDoanh(ID))
{
MessageBox.Show("Vẫn Còn Sản Phẩm Thuộc Hãng Này => Không Thể Xóa", "Delete Selected", MessageBoxButton.OK, MessageBoxImage.Stop);
}
else if (MessageBox.Show("Are you sure ?", "Delete Selected", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.HangSanXuats.Where(m => m.MaHangSX == ID).Single() as HangSanXuat;
sql.ConKinhDoanh = false;
BH.SaveChanges();
}
Load();
}
catch (Exception)
{
MessageBox.Show("Vẫn Còn Sản Phẩm Thuộc Hãng Này => Không Thể Xóa", "Delete Selected", MessageBoxButton.OK, MessageBoxImage.Stop);
}
}
}
private void btnthanhtoan_Click(object sender, RoutedEventArgs e)
{
if (ListGioHang.Items.Count > 0)
{
using (var BH = new Models.BanLapTopEntities())
{
foreach (var i in LaySTT())
{
if (KiemTraConHang(LayMaSp(i)) == false)
{
var Name = (from lt in BH.DonHangTemps
where lt.STT == i
select lt.TenSP).SingleOrDefault();
var SL = (from lt in BH.DonHangTemps
where lt.STT == i
select lt.SoLuongMua).SingleOrDefault();
MessageBox.Show("LapTop " + Name + " Số Tồn Kho < " + SL + " Cái", "Không Đủ Mặt Hàng Cần Mua", MessageBoxButton.OK, MessageBoxImage.Hand);
return;
}
}
var sql = new HoaDon();
sql.MaKhachHang = (from t in BH.DonHangTemps
select t.MaKhacHang).FirstOrDefault();
sql.NgayLap = DateTime.Now;
sql.TongTien = Convert.ToDecimal((from h in BLT.DonHangTemps
select h.ThanhTien).Sum().ToString());
sql.DaThanhToan = false;
BH.HoaDons.Add(sql);
BH.SaveChanges();//lưu thay doi
foreach (var i in LaySTT())
{
using (var BL = new Models.BanLapTopEntities())
{
var ChiTiet = new ChiTietHoaDon();
ChiTiet = LoopData(i);
BL.ChiTietHoaDons.Add(ChiTiet);
BL.SaveChanges();//lưu thay doi
UpdateSoLuongSP(LayMaSp(i));
}
}
BH.Database.ExecuteSqlCommand("TRUNCATE TABLE DonHangTemp");
Load();
MessageBox.Show("Thanh Toán Thành Công", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Asterisk);
Cart?.Invoke("2");
}
}
}
private void UpdateSoLuongSP(int MaSP)
{
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.SanPhams.Where(m => m.MaSP == MaSP).Single() as SanPham;
int SLB = SoLuongMua(MaSP);
sql.SoLuongBan = sql.SoLuongBan + SLB;
sql.SoLuongTon = sql.SoLuongTon - SLB;
BH.SaveChanges();//lưu thay doi
}
}
private void Mua_Click(object sender, RoutedEventArgs e)
{
if (Loged == "")
{
MessageBox.Show("Cần đăng nhập để mua sản phẩm", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
Button temp = sender as Button;
SanPham D = temp.DataContext as SanPham;
int MaSp = D.MaSP;
using (var BH = new Models.BanLapTopEntities())
{
if (TonTaiHang(MaSp))
{
var sql = BH.DonHangTemps.Where(m => m.MaSP == MaSp).Single() as DonHangTemp;
int SLMua = sql.SoLuongMua + 1;
sql.SoLuongMua = SLMua;
sql.ThanhTien = sql.ThanhTien + GiaSP(MaSp);
BH.SaveChanges();//lưu thay doi
}
else
{
var sql = new DonHangTemp();
sql.SoLuongMua = 1;
sql.MaDonHang = MaDonHangNext();
sql.MaKhacHang = Loged;
sql.TenKhachHang = NameUser(Loged);
sql.MaSP = MaSp;
sql.TenSP = NameProduct(MaSp);
sql.GiaSP = GiaSP(MaSp);
sql.HinhSP = ImageProduct(MaSp);
sql.ThanhTien = GiaSP(MaSp);
BH.DonHangTemps.Add(sql);
BH.SaveChanges();//lưu thay doi
}
}
}
}
private void btnBuy_Click(object sender, RoutedEventArgs e)
{
if (MaNguoiDung == "")
{
MessageBox.Show("Cần đăng nhập để mua sản phẩm", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
int SLM = Convert.ToInt32(txtSL.Value);
int MaSp = MaSanPham;
using (var BH = new Models.BanLapTopEntities())
{
if (TonTaiHang(MaSp))
{
var sql = BH.DonHangTemps.Where(m => m.MaSP == MaSp).Single() as DonHangTemp;
int SLMua = sql.SoLuongMua + SLM;
sql.SoLuongMua = SLMua;
sql.ThanhTien = sql.ThanhTien + (GiaSP(MaSp) * SLM);
BH.SaveChanges();//lưu thay doi
}
else
{
var sql = new DonHangTemp();
sql.SoLuongMua = SLM;
sql.MaDonHang = MaDonHangNext();
sql.MaKhacHang = MaNguoiDung;
sql.TenKhachHang = NameUser(MaNguoiDung);
sql.MaSP = MaSp;
sql.TenSP = NameProduct(MaSp);
sql.HinhSP = ImageProduct(MaSp);
sql.GiaSP = GiaSP(MaSp);
sql.ThanhTien = GiaSP(MaSp);
BH.DonHangTemps.Add(sql);
BH.SaveChanges();//lưu thay doi
}
}
}
}
private void btnxoa_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are you sure ?", "Delete Selected", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
int ID = (ListGioHang.SelectedItem as SanPham).MaSP;
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.SanPhams.Where(m => m.MaSP == ID).Single() as SanPham;
sql.ConKinhDoanh = false;
BH.SaveChanges();
}
Load();
}
}
private void btnChuyenThanhToan_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Xác Nhận ?", "Giao Hàng", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
int ID = (ListGioHang.SelectedItem as HoaDon).MaHoaDon;
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.HoaDons.Where(m => m.MaHoaDon == ID).Single() as HoaDon;
sql.DaThanhToan = true;
BH.SaveChanges();
}
Load();
}
}
private int LayMaSP(object sender, RoutedEventArgs e)
{
Button temp = sender as Button;
SanPham D = temp.DataContext as SanPham;
int NumberView = D.LuotXem + 1;
int Id = D.MaSP;
BLT = new Models.BanLapTopEntities();
var sql = BLT.SanPhams.Where(m => m.MaSP == Id).FirstOrDefault();
sql.LuotXem = NumberView;
BLT.SaveChanges();//lưu thây đổi lượt xem
return(Id);
}
private void btnxoa_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are you sure ?", "Delete Products", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
int ID = (ListGioHang.SelectedItem as DonHangTemp).STT;
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.DonHangTemps.Where(m => m.STT == ID).Single() as DonHangTemp;
BH.DonHangTemps.Remove(sql);
BH.SaveChanges();
}
Load();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text == "" || DuongDan == "")
{
MessageBox.Show("Chưa Điền Đầy Đủ Thông Tin", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
// string folderpath = System.IO.Directory.GetParent(Environment.CurrentDirectory).Parent.FullName + "\\ContactImages\\";
string folderpath = Directory.GetParent(AppDomain.CurrentDomain.BaseDirectory) + "\\Image\\";
string FileName = txtName.Text + "." + LayDuoi(DuongDan);
if (!Directory.Exists(folderpath))
{
DirectoryInfo di = Directory.CreateDirectory(folderpath);
di.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
}
string filePath = folderpath + System.IO.Path.GetFileName(FileName);
var HSX = new HangSanXuat {
MaHangSX = LayMaHSX(), TenHangSX = txtName.Text, Logo = @"pack://siteoforigin:,,,/Image\" + FileName
};
using (var BanHang = new Models.BanLapTopEntities())
{
BanHang.HangSanXuats.Add(HSX);
if (BanHang.SaveChanges() > 0)
{
if (!File.Exists(filePath))
{
System.IO.File.Copy(DuongDan, filePath, true);
}
MessageBox.Show("Success!");
Img.Source = null;
txtUri.Clear();
txtName.Clear();
Load();
}
else
{
MessageBox.Show("Error Please record");
}
}
}
}
private void ListGioHang_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
DonHangTemp D = ListGioHang.SelectedItem as DonHangTemp;
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.DonHangTemps.Where(m => m.MaSP == D.MaSP).Single() as DonHangTemp;
sql.SoLuongMua = D.SoLuongMua;
sql.ThanhTien = D.SoLuongMua * D.GiaSP;
BH.SaveChanges();//lưu thay doi
if (KiemTraConHang(D.MaSP) == false)
{
MessageBox.Show("LapTop " + D.TenSP + " Số Tồn Kho < " + D.SoLuongMua + " Cái", "Không Đủ Mặt Hàng", MessageBoxButton.OK, MessageBoxImage.Hand);
}
Load();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (txtAdd.Text.Length <= 5)
{
MessageBox.Show("Loại Sản Phẩm Chưa Nhập hoặc không chính xác", "?????", MessageBoxButton.OK, MessageBoxImage.Hand);
}
else
{
using (var BH = new Models.BanLapTopEntities())
{
var sql = new LoaiSanPham();
sql.MaLoaiSP = GetMaLoaiSP();
sql.TenLoaiSP = txtAdd.Text;
BH.LoaiSanPhams.Add(sql);
BH.SaveChanges();//lưu thay doi
txtAdd.Clear();
}
Load();
}
}
private void btnThemSP_Click(object sender, RoutedEventArgs e)
{
if (Compelete())
{
// string folderpath = System.IO.Directory.GetParent(Environment.CurrentDirectory).Parent.FullName + "\\ContactImages\\";
string folderpath = Directory.GetParent(AppDomain.CurrentDomain.BaseDirectory) + "\\Images\\";
string FileName = txtNameSP.Text + "." + LayDuoi(DuongDan);
if (!Directory.Exists(folderpath))
{
DirectoryInfo di = Directory.CreateDirectory(folderpath);
di.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
}
string filePath = folderpath + System.IO.Path.GetFileName(FileName);
string MoTaNgan = txtMoTaNgan.Text;
string CauHinh = txtCauHinh.Text;
string ChiTiet = txtChiTiet.Text;
var NewSP = new SanPham {
TenSP = txtNameSP.Text.Trim(), GiaSP = Convert.ToDecimal(txtGiaSP.Text), LuotXem = 0, SoLuongBan = 0, SoLuongTon = (int)udNhapKho.Value, NgayNhapKho = DateTime.Now, MoTaNgan = @MoTaNgan, CauHinh = @CauHinh, MoTa = @ChiTiet, XuatXu = txtXuatSu.Text.Trim(), MaLoaiSP = Convert.ToInt32(cbLoaiSP.SelectedValue), MaHangSX = Convert.ToInt32(cbHangSX.SelectedValue), HinhSP = @"pack://siteoforigin:,,,/Images\" + FileName
};
using (var BanHang = new Models.BanLapTopEntities())
{
BanHang.SanPhams.Add(NewSP);
if (BanHang.SaveChanges() > 0)
{
if (!File.Exists(filePath))
{
System.IO.File.Copy(DuongDan, filePath, true);
}
MessageBox.Show("Success!");
Clears();
}
else
{
MessageBox.Show("Error Please record");
}
}
}
}
private void btnSua_Click(object sender, RoutedEventArgs e)
{
LoaiSanPham D = ListGioHang.SelectedItem as LoaiSanPham;
if (D.TenLoaiSP.Length <= 5)
{
MessageBox.Show("Loại Sản Phẩm Chưa Nhập hoặc không chính xác", "?????", MessageBoxButton.OK, MessageBoxImage.Hand);
}
else
{
if (MessageBox.Show("Are you sure ?", "Save Selected", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
int ID = (ListGioHang.SelectedItem as LoaiSanPham).MaLoaiSP;
using (var BH = new Models.BanLapTopEntities())
{
var sql = BH.LoaiSanPhams.Where(m => m.MaLoaiSP == ID).Single() as LoaiSanPham;
sql.TenLoaiSP = D.TenLoaiSP;
BH.SaveChanges();
}
Load();
}
}
}