public List <CachThanhToan> LoadAll()
{
var db = new QuanLyCuaHangEntities();
var cachThanhToans = db.CachThanhToans.ToList();
return(cachThanhToans);
}
public List <KhachHang> LoadAll()
{
var db = new QuanLyCuaHangEntities();
var khachHangs = db.KhachHangs.ToList();
return(khachHangs);
}
public SanPham FindByID(int i)
{
var db = new QuanLyCuaHangEntities();
var sp = db.SanPhams.Find(i);
return(sp);
}
public List <KhuyenMai> LoadAll()
{
var db = new QuanLyCuaHangEntities();
var khuyenMais = db.KhuyenMais.ToList();
return(khuyenMais);
}
public List <DonHang> LoadAll()
{
var db = new QuanLyCuaHangEntities();
var donHangs = db.DonHangs.ToList();
return(donHangs);
}
public List <TaiKhoan> LoadAll()
{
var db = new QuanLyCuaHangEntities();
var TaiKhoan = db.TaiKhoans.ToList();
return(TaiKhoan);
}
public List <SanPham> LoadAll()
{
List <SanPham> sanPhams = new List <SanPham>();
var db = new QuanLyCuaHangEntities();
sanPhams = db.SanPhams.ToList();
return(sanPhams);
}
public List <LoaiSanPham> LoadAll()
{
List <LoaiSanPham> LoaiSanPhams = new List <LoaiSanPham>();
var db = new QuanLyCuaHangEntities();
LoaiSanPhams = db.LoaiSanPhams.ToList();
return(LoaiSanPhams);
}
public List <DonHang> FindByID(int i)
{
List <DonHang> query;
using (var db = new QuanLyCuaHangEntities())
{
query = db.DonHangs.Where(s => s.MaDongHang == i).ToList();
}
return(query);
}
private void TimKiem_Button_Click(object sender, RoutedEventArgs e)
{
var db = new QuanLyCuaHangEntities();
var dsSpTk = new List <SanPham>();
if (LoaiSP_ComboBox.SelectedIndex != 0)
{
db.LoaiSanPhams.ToList();
dsSP = db.SanPhams.Where(s => s.LoaiSanPham.TenLoaiSanPham.Contains(LoaiSP_ComboBox.SelectedItem.ToString())).ToList();
}
if (Gia_ComboBox.SelectedIndex != 0)
{
dsSP.Sort(new SpGiaComparer());
if (Gia_ComboBox.SelectedIndex == 1)
{
for (int i = 0; i < dsSP.Count(); i++)
{
if (dsSP[i].GiaBan > 1000000)
{
dsSP.Remove(dsSP[i]);
i--;
}
}
}
if (Gia_ComboBox.SelectedIndex == 2)
{
for (int i = 0; i < dsSP.Count(); i++)
{
if (dsSP[i].GiaBan < 1000000 && dsSP[i].GiaBan > 3000000)
{
dsSP.Remove(dsSP[i]);
i--;
}
}
}
if (Gia_ComboBox.SelectedIndex == 3)
{
for (int i = 0; i < dsSP.Count(); i++)
{
if (dsSP[i].GiaBan < 3000000)
{
dsSP.Remove(dsSP[i]);
i--;
}
}
}
}
DanhSachSPDataGrid.ItemsSource = dsSP;
}
public bool AddLoaiSanPham(LoaiSanPham loaiSanPham)
{
try
{
var db = new QuanLyCuaHangEntities();
db.LoaiSanPhams.Add(loaiSanPham);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
public bool AddKhuyenMai(KhuyenMai khuyenMai)
{
try
{
var db = new QuanLyCuaHangEntities();
db.KhuyenMais.Add(khuyenMai);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
public bool DeleteSanPham(SanPham sanPham)
{
try
{
var db = new QuanLyCuaHangEntities();
db.SanPhams.Remove(sanPham);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
public bool AddKhachHang(KhachHang khachHang)
{
try
{
var db = new QuanLyCuaHangEntities();
db.KhachHangs.Add(khachHang);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
public bool AddDonHang(DonHang donHang)
{
try
{
var db = new QuanLyCuaHangEntities();
db.DonHangs.Add(donHang);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
private void LoaiSP_ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var db = new QuanLyCuaHangEntities();
if (LoaiSP_ComboBox.SelectedIndex != 0)
{
db.LoaiSanPhams.ToList();
dsSP = db.SanPhams.Where(s => s.LoaiSanPham.TenLoaiSanPham.Contains(LoaiSP_ComboBox.SelectedItem.ToString())).ToList();
}
else
{
Page_Loaded(null, null);
}
SanPhamListView.ItemsSource = dsSP;
}
public bool EditDonHang(DonHang donHang)
{
try
{
var db = new QuanLyCuaHangEntities();
var donHang1 = db.DonHangs.Find(donHang.MaDongHang, donHang.MaSanPham);
donHang1.TinhTrang = donHang.TinhTrang;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
private void ThemKM_Button_Click(object sender, RoutedEventArgs e)
{
try
{
var db = new QuanLyCuaHangEntities();
KhuyenMai_Bus khuyenMai_Bus = new KhuyenMai_Bus();
KhuyenMai km = new KhuyenMai();
km.MaKhuyenMai = MaKM_TextBox.Text;
km.TenKhuyenMai = TenKM_TextBox.Text;
km.MucKhuyenMai = int.Parse(MucKM_TextBox.Text);
khuyenMai_Bus.AddKhuyenMai(km);
db.SaveChanges();
MessageBox.Show("Thêm mã khuyến mãi thành công!");
MaKM_TextBox.Text = "";
TenKM_TextBox.Text = "";
MucKM_TextBox.Text = "";
}
catch (Exception)
{
MessageBox.Show("Thêm không thành công vui lòng kiểm tra lại");
}
DanhSachKMDataGrid_Loaded(null, null);
}
public bool EditSanPham(SanPham sanPham)
{
try
{
var db = new QuanLyCuaHangEntities();
var sanPham1 = db.SanPhams.Find(sanPham.MaSanPham);
sanPham1.GiaBan = sanPham.GiaBan;
sanPham1.GiaGoc = sanPham.GiaGoc;
sanPham1.HinhAnh = sanPham.HinhAnh;
sanPham1.MaLoaiSanPham = sanPham.MaLoaiSanPham;
sanPham1.SoLuongConLai = sanPham.SoLuongConLai;
sanPham1.TenSanPham = sanPham.TenSanPham;
sanPham1.isDelete = sanPham.isDelete;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
}
return(false);
}
private void ThanhToan_Button_Click(object sender, RoutedEventArgs e)
{
var KH = new KhachHang();
int kiemTra = 1;
int km = 100;
var DH = new DonHang();
var db = new QuanLyCuaHangEntities();
DsKH = db.KhachHangs.ToList();
DsDH = db.DonHangs.ToList();
//try
//{
if (CachThanhToan_ComboBox.SelectedIndex == 1 && (DC_TextBox.Text == "" || SDT_TextBox.Text == ""))
{
MessageBox.Show("Bạn phải nhập số điện thoại và địa chỉ để chuyển hàng");
kiemTra = 0;
}
else
{
KH.TenKhachHang = TenKH_TextBox.Text;
KH.SoDienThoai = SDT_TextBox.Text;
KH.DiaChi = DC_TextBox.Text;
//KH.isDelete = false;
KhachHang_Bus khachHang_Bus = new KhachHang_Bus();
khachHang_Bus.AddKhachHang(KH);
var a = khachHang_Bus.LoadAll();
DH.MaKhachHang = KH.MaKhachHang;
if (MaKM_TextBox.Text != "")
{
KhuyenMai_Bus khuyenMai_Bus = new KhuyenMai_Bus();
var KMs = khuyenMai_Bus.LoadAll();
if (KMs != null)
{
for (int i = 0; i < KMs.Count(); i++)
{
if (MaKM_TextBox.Text == KMs[i].MaKhuyenMai)
{
km = KMs[i].MucKhuyenMai;
}
}
}
DH.MaKhuyenMai = MaKM_TextBox.Text;
}
DH.CachThanhToan = CachThanhToan_ComboBox.SelectedIndex + 1;
if (DH.CachThanhToan == 2)
{
DH.TinhTrang = 2;
}
else
{
DH.TinhTrang = 1;
}
DH.ThoiGian = DateTime.Now;
for (int i = 0; i < datas.Count(); i++)
{
DonHang_Bus donHangs = new DonHang_Bus();
DH.MaDongHang = donHangs.LoadAll().Count() - i;
DH.MaSanPham = datas[i].maSP;
DH.Gia = datas[i].GiaBan * km / 100;
DH.SoLuong = datas[i].SoLuong;
SanPham_Bus sanPham_Bus = new SanPham_Bus();
var sanpham = sanPham_Bus.FindByID(DH.MaSanPham);
if (sanpham.SoLuongConLai >= DH.SoLuong)
{
sanpham.SoLuongConLai -= DH.SoLuong;
sanPham_Bus.EditSanPham(sanpham);
DonHang_Bus donHang_Bus = new DonHang_Bus();
donHang_Bus.AddDonHang(DH);
kiemTra = 1;
}
else
{
MessageBox.Show("Sản phẩm " + datas[i].TenSP + " không đủ vui lòng xem lại");
kiemTra = 0;
break;
}
}
if (kiemTra == 1)
{
MessageBox.Show("Giao dịch thành công!");
datas.Clear();
sanPhams.Clear();
Page_Loaded(null, null);
DanhSachSPDataGrid_Loaded(null, null);
CachThanhToan_ComboBox.SelectedIndex = -1;
TenKH_TextBox.Text = "";
DC_TextBox.Text = "";
SDT_TextBox.Text = "";
TongTien_TextBlock.Text = "";
}
}
//catch (Exception)
//{
// MessageBox.Show("Giao dịch k thành công!");
//}
}
