private void Button_Click_2(object sender, RoutedEventArgs e)
{
ChiTietPhieuNhapSach ctpn = (ChiTietPhieuNhapSach)comboBoxMaSach.SelectedItem;
int soluongnhap = int.Parse(textBoxSoLuong.Text);
if (soluongnhap >= soLuongNhapToiThieu && ctpn.SoLuongTon < soLuongTonDeNhapToiDa)
{
ctpn.SoLuong = soluongnhap;
ctpn.DonGiaNhap = decimal.Parse(textBoxDonGiaNhap.Text);
list.Add(ctpn);
comboBoxList.Remove(ctpn);
comboBoxMaSach.SelectedIndex = -1;
ClearAllTextBox();
decimal sum = 0;
foreach (var x in list)
{
sum += x.ThanhTien;
}
textBoxTongTien.Text = sum.ToString();
}
else
{
MessageBox.Show("Không thỏa điều kiện để nhập sách");
}
}
protected void InitComboBoxList()
{
List <long> maSachList = new List <long>();
string query = "SELECT MaSach FROM SACH";
using (SqlCommand cmd = new SqlCommand(query, QuanLyNhaSach.MainWindow.sqlConnection))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
maSachList.Add((long)reader[0]);
}
}
}
}
if (maSachList.Count > 0)
{
foreach (var x in maSachList)
{
using (SqlCommand cmd = new SqlCommand("EXEC spSupportLapPhieuNhapSach " + x, QuanLyNhaSach.MainWindow.sqlConnection))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
ChiTietPhieuNhapSach ctpn = new ChiTietPhieuNhapSach();
bool readFlag = false;
while (reader.Read())
{
if (readFlag)
{
ctpn.TacGia += "; " + (string)reader[2];
}
else
{
ctpn.MaSach = x;
ctpn.TenSach = (string)reader[0];
ctpn.TheLoai = (string)reader[1];
ctpn.TacGia = (string)reader[2];
ctpn.SoLuongTon = (int)reader[3];
readFlag = true;
}
}
comboBoxList.Add(ctpn);
}
}
}
}
}
else
{
MessageBox.Show("Không có dữ liệu sách");
}
}
private void comboBoxMaSach_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (comboBoxMaSach.SelectedIndex >= 0)
{
ChiTietPhieuNhapSach ctpn = (ChiTietPhieuNhapSach)comboBoxMaSach.SelectedItem;
textBoxTenSach.Text = ctpn.TenSach;
textBoxTheLoai.Text = ctpn.TheLoai;
textBoxTacGia.Text = ctpn.TacGia;
textBoxSoLuongTon.Text = ctpn.SoLuongTon.ToString();
textBoxSoLuong.Text = textBoxDonGiaNhap.Text = "0";
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ChiTietPhieuNhapSach ctpn = (ChiTietPhieuNhapSach)dataGrid.SelectedItem;
comboBoxList.Add(ctpn);
list.Remove(ctpn);
decimal sum = 0;
foreach (var x in list)
{
sum += x.ThanhTien;
}
textBoxTongTien.Text = sum.ToString();
}