private void BtnBuyProductMostBought_Click(object sender, RoutedEventArgs e)
{
SachDTO item = (SachDTO)((Button)sender).DataContext;
bool check = false;
int countBooksBought = 0;
listChiTietHoaDon.ForEach(i =>
{
countBooksBought += i.SoLuong;
if (i.Sach.MaSach == item.MaSach)
{
i.SoLuong++;
check = true;
}
});
if (check == false)
{
var chiTietHoaDon = new ChiTietHoaDonBanSachDTO();
chiTietHoaDon.Sach = item;
chiTietHoaDon.SoLuong = 1;
listChiTietHoaDon.Add(chiTietHoaDon);
}
countBooksBought++;
countProductBuy.Badge = countBooksBought;
Global.BookBoughtBills = listChiTietHoaDon;
}
private void BtnRemoveFromShoppingCart_Click(object sender, RoutedEventArgs e)
{
ChiTietHoaDonBanSachDTO item = (ChiTietHoaDonBanSachDTO)((Button)sender).DataContext;
// MessageBox.Show(item.TenSach);
if (listChiTietHoaDon.Count <= 0)
{
countProductBuy.Badge = 0;
ShoppingCart_Empty.Visibility = Visibility.Visible;
ShoppingCart_NoEmprty.Visibility = Visibility.Collapsed;
}
else
{
int countBooksBought = 0;
double sumPrice = 0;
listChiTietHoaDon.ForEach(i =>
{
countBooksBought += i.SoLuong;
sumPrice += i.SoLuong * i.Sach.DonGiaBan;
if (i.Sach.MaSach == item.Sach.MaSach)
{
countBooksBought -= i.SoLuong;
sumPrice -= i.SoLuong * i.Sach.DonGiaBan;
}
});
listChiTietHoaDon.RemoveAll(i => (i.Sach.MaSach == item.Sach.MaSach));
countProductBuy.Badge = countBooksBought;
ListViewProductsBought.ItemsSource = new List <ChiTietHoaDonBanSachDTO>();
ListViewProductsBought.ItemsSource = listChiTietHoaDon;
Label_SummaryPriceOfBill.Content = sumPrice;
Global.BookBoughtBills = listChiTietHoaDon;
}
}
public static List <ChiTietHoaDonBanSachDTO> loadByMaHoaDon(string MaHoaDon)
{
string sCommand = "Select* from ChiTietHoaDonBanSach where MaHoaDon = " + MaHoaDon;
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
List <ChiTietHoaDonBanSachDTO> listChiTiet = new List <ChiTietHoaDonBanSachDTO>();
for (int i = 0; i < n; i++)
{
ChiTietHoaDonBanSachDTO chiTiet = new ChiTietHoaDonBanSachDTO();
chiTiet.MaHoaDon = int.Parse(dt.Rows[i]["MaHoaDon"].ToString());
chiTiet.Sach.MaSach = int.Parse(dt.Rows[i]["MaSach"].ToString());
chiTiet.SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString());
listChiTiet.Add(chiTiet);
}
DataProvider.closeConnection(con);
return(listChiTiet);
}
public static List <ChiTietHoaDonBanSachDTO> copyList(List <ChiTietHoaDonBanSachDTO> listChiTietHoaDon)
{
var newList = new List <ChiTietHoaDonBanSachDTO>();
for (int i = 0; i < listChiTietHoaDon.Count; i++)
{
ChiTietHoaDonBanSachDTO chiTiet = new ChiTietHoaDonBanSachDTO();
chiTiet.MaHoaDon = listChiTietHoaDon[i].MaHoaDon;
chiTiet.Sach = new SachDTO(listChiTietHoaDon[i].Sach);
chiTiet.SoLuong = listChiTietHoaDon[i].SoLuong;
chiTiet.TongDonGia = listChiTietHoaDon[i].TongDonGia;
newList.Add(chiTiet);
}
return(newList);
}
public static bool insertChiTietHoaDon(ChiTietHoaDonBanSachDTO chiTiet)
{
string sCommand = string.Format(@"insert into ChiTietHoaDonBanSach(MaHoaDon,MaSach,SoLuong) values({0},{1},{2})", chiTiet.MaHoaDon, chiTiet.Sach.MaSach, chiTiet.SoLuong);
con = DataProvider.openConnection();
bool result;
try
{
result = DataProvider.executeNonQuery(sCommand, con);
DataProvider.closeConnection(con);
}
catch
{
result = false;
DataProvider.closeConnection(con);
}
return(result);
}
private void Combobox_countBookBought_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ChiTietHoaDonBanSachDTO item = (ChiTietHoaDonBanSachDTO)((ComboBox)sender).DataContext; //Ở đây không dùng messagebox được. muốn test thì gán giá trị vào label nào đó test
int countBooksBought = 0;
double sumPrice = 0;
listChiTietHoaDon.ForEach(i => {
if (i.Sach.MaSach == item.Sach.MaSach)
{
i.SoLuong = item.SoLuong;
}
countBooksBought += i.SoLuong;
sumPrice = sumPrice + i.SoLuong * i.Sach.DonGiaBan;
i.TongDonGia = i.Sach.DonGiaBan * i.SoLuong;
});
countProductBuy.Badge = countBooksBought;
// ListViewProductsBought.ItemsSource = new List<ChiTietHoaDonBanSachDTO>();
ListViewProductsBought.ItemsSource = listChiTietHoaDon;
Label_SummaryPriceOfBill.Content = sumPrice;
}
public static ChiTietHoaDonBanSachDTO loadOneDetail(string MaHoaDon)
{
string sCommand = "select top 1 * from ChiTietHoaDonBanSach where MaHoaDon = " + MaHoaDon;
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
ChiTietHoaDonBanSachDTO chiTiet = new ChiTietHoaDonBanSachDTO();
chiTiet.MaHoaDon = int.Parse(dt.Rows[0]["MaHoaDon"].ToString());
chiTiet.Sach.MaSach = int.Parse(dt.Rows[0]["MaSach"].ToString());
chiTiet.SoLuong = int.Parse(dt.Rows[0]["SoLuong"].ToString());
DataProvider.closeConnection(con);
return(chiTiet);
}
public static bool insertChiTietHoaDon(ChiTietHoaDonBanSachDTO chiTiet)
{
return(ChiTietHoaDonBanSachDAO.insertChiTietHoaDon(chiTiet));
}
