private void OKButton_Click(object sender, RoutedEventArgs e)
{
var phone = PhoneTextBox.Text;
var name = NameTextBox.Text;
var dob = DoBTextBox.Text;
var email = EmailTextBox.Text;
if (phone == "" || name == "" || dob == "" || email == "")
{
MessageBox.Show("Chưa điền đủ thông tin khách hàng");
}
else
{
var date = new DateTime();
date = Convert.ToDateTime(dob);
//them khach hang vao db
var db = new QuanLyCuaHangBanSachEntities();
db.KhachHangs.Add(new KhachHang()
{
TenKH = name, Email = email, NgaySinh = date, SDT_KH = phone, TongGiaoDich = 0
});
db.SaveChanges();
this.DialogResult = true;
}
}
public static bool CheckPhone(string phone, QuanLyCuaHangBanSachEntities db)
{
bool check = false;
var customer = from khachhang in db.KhachHangs
where khachhang.SDT_KH == phone
select khachhang;
if (customer.ToList().Count > 0)
{
check = true;
}
return(check);
}
public static bool checkMaHoaDon(string maHD, QuanLyCuaHangBanSachEntities db)
{
bool isNotValid = false;
var maHoaDon = Int32.Parse(maHD);
var hoadon = from hd in db.HoaDons
where hd.MaHD == maHoaDon
select hd;
if (hoadon.ToList().Count > 0)
{
isNotValid = true;
}
return(isNotValid);
}
public static bool CheckOut(BindingList <DonHang> books, List <Sach> booksInDatabase, QuanLyCuaHangBanSachEntities db, List <KhachHang> customer)
{
//luu xuong hoa don
var total = getTotal(books);
var tax = getTax(total);
String maHoaDon;
do
{
Random generator = new Random();
maHoaDon = generator.Next(0, 999999).ToString("D6");
} while (checkMaHoaDon(maHoaDon, db));
string customerPhone = null;
if (customer.Count != 0)
{
customerPhone = customer[0].SDT_KH;
//luu tong giao dich cua khach hang
customer[0].TongGiaoDich += (decimal)total;
}
db.HoaDons.Add(new HoaDon()
{
MaHD = Int32.Parse(maHoaDon), NgayLap = DateTime.Now, KhachHang = customerPhone, TongGiaTriHD = (decimal)total, Tax = (decimal)tax
});
//luu xuong chi tiet hoa don
foreach (var book in books)
{
db.ChiTietHoaDons.Add(new ChiTietHoaDon()
{
HoaDon = Int32.Parse(maHoaDon), MaSachMua = book.MaSach, SoLuongMua = book.SoLuong, TongTien = (decimal)(book.SoLuong * book.GiaTien)
});
}
//luu lai du lieu so luong sach
for (int i = 0; i < books.Count; i++)
{
for (int j = 0; j < booksInDatabase.Count; j++)
{
if (books[i].MaSach == booksInDatabase[j].MaSach)
{
booksInDatabase[j].SoLuong -= books[i].SoLuong;
}
}
}
db.SaveChanges();
return(true);
}
public DataProvider()
{
DB = new QuanLyCuaHangBanSachEntities();
}
