private void btn_add_Click(object sender, EventArgs e) { try { var dausach = new DauSach(); dausach.Ten = txt_name.Text; dausach.TheLoaiID = Convert.ToInt32(cbb_category.SelectedValue); dausach.TacGiaID = Convert.ToInt32(cbb_author.SelectedValue); dausach.TomTat = txt_summary.Text; dausach.TaiBan = Convert.ToInt32(txt_republish.Text); dausach.NhaSanXuatID = Convert.ToInt32(cbb_producer.SelectedValue); dausach.SoLuongTong = Convert.ToInt32(txt_sumnumber.Text); dausach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); _context.DauSach.Add(dausach); _context.SaveChanges(); for (int i = 1; i <= Convert.ToInt32(txt_sumnumber.Text); i++) { var cuonsach = new CuonSach(); cuonsach.MaVach = "MV" + dausach.ID + i; cuonsach.DauSachID = dausach.ID; cuonsach.TinhTrang = 2; _context.CuonSach.Add(cuonsach); } var phieunhap = new PhieuNhapDauSach(); phieunhap.DauSachID = dausach.ID; phieunhap.NgayNhap = DateTime.Now; phieunhap.SoLuongCuonSach = dausach.SoLuongTong; _context.PhieuNhapDauSach.Add(phieunhap); _context.SaveChanges(); txt_name.Text = null; txt_republish.Text = null; txt_summary.Text = null; txt_sumnumber.Text = null; form_qlds = new QuanLyDauSach(); form_qlds.Refresh(); form_qlds.Refresh_DataGridView(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_save_Click(object sender, EventArgs e) { try { var cuonsach_id = label_id.Text; int soluong_dausach = Convert.ToInt32(label_sumnumber.Text); if (cuonsach_id != "mới") { int id = Convert.ToInt32(cuonsach_id); var cuonsach = _context.CuonSach.Where(i => i.ID.Equals(id)).FirstOrDefault(); cuonsach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); } else { var cuonsach = new CuonSach(); cuonsach.MaVach = txt_key.Text; cuonsach.DauSachID = DauSachID; cuonsach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); _context.CuonSach.Add(cuonsach); var dausach = _context.DauSach.Where(i => i.ID.Equals(DauSachID)).FirstOrDefault(); dausach.SoLuongTong = dausach.SoLuongTong + 1; soluong_dausach = dausach.SoLuongTong; var phieunhap = new PhieuNhapDauSach(); phieunhap.DauSachID = dausach.ID; phieunhap.NgayNhap = DateTime.Now; phieunhap.SoLuongCuonSach = 1; _context.PhieuNhapDauSach.Add(phieunhap); } _context.SaveChanges(); label_sumnumber.Text = soluong_dausach.ToString(); Refresh_DataGridView(); label_id.Text = "mới"; txt_key.ReadOnly = false; txt_key.Text = null; //label_defaultMV.Text = "MV" + DauSachID.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }