private void btnXoa_Click(object sender, EventArgs e) { DialogResult xoa = MessageBox.Show("Đồng ý xóa?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (xoa == DialogResult.Yes) { try { var context = new Dtb_NhaSachContext(); var delete = new Sach() { //Stt = int.Parse(this.dgvBook.CurrentRow.Cells[0].Value.ToString().Trim()), MaSach = this.dgvBook.CurrentRow.Cells[1].Value.ToString().Trim(), }; context.Remove <Sach>(delete); context.SaveChanges(); refreshControl(); sapXep(); loadDgvBook(); MessageBox.Show("Xóa thành công!!!!"); } catch { MessageBox.Show("đã xảy ra lỗi. vui lòng thử lại!"); return; } } }
public void addTblCthd() { var context = new Dtb_NhaSachContext(); for (int i = 0; i < this.dgv1.Rows.Count - 1; i++) { var maSach = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.MaSach).FirstOrDefault(); var getSohd = context.Hoadons.Select(s => s.SoHd).Max(); var cthd = new Chitiethoadon() { MaSach = maSach.Trim(), SoHd = getSohd, SoLuongBan = int.Parse(this.dgv1.Rows[i].Cells[2].Value.ToString().Trim()), ThanhTien = double.Parse(this.dgv1.Rows[i].Cells[5].Value.ToString().Trim()), GiamGia = double.Parse(this.dgv1.Rows[i].Cells[4].Value.ToString().Trim()), GiaSauGiam = double.Parse(this.dgv1.Rows[i].Cells[6].Value.ToString().Trim()), DonGia = double.Parse(this.dgv1.Rows[i].Cells[3].Value.ToString().Trim()), }; context.Chitiethoadons.Add(cthd); context.SaveChanges(); } }
public void addTblHD() { var context = new Dtb_NhaSachContext(); var maNv = context.Nhanviens.Where(s => s.TenNv.Trim() == this.cbbTenNv.Text.Trim()) .Select(s => new { s.MaNv }).FirstOrDefault().MaNv.Trim(); var getSohd = context.Hoadons.Select(s => s.SoHd).Max(); var getMatv = context.Thanhviens.Where(s => s.TenTv.Trim() == this.txtTenKh.Text.Trim()) .Select(s => s.MaTv).FirstOrDefault(); var addHd = new Hoadon() { SoHd = getSohd + 1, MaNv = maNv, NgayBan = DateTime.Now, TenKh = this.txtTenKh.Text.Trim(), MaTv = getMatv, TongTien = double.Parse(this.txtTongCong.Text.Trim()), }; context.Hoadons.Add(addHd); context.SaveChanges(); }
public void trungSach() { if (this.dgv1.Rows.Count > 1) { for (int i = 0; i < this.dgv1.Rows.Count - 1; i++) { if (this.cbbTenSach.Text.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) { DialogResult congDon = MessageBox.Show("Sách đã có trong hóa đơn bạn có muốn thay thế?", "Chú ý" , MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (congDon == DialogResult.Yes) { var context = new Dtb_NhaSachContext(); double donGia = context.Saches.Where(s => s.TenSach.Trim() == this.cbbTenSach.Text.Trim()) .Select(s => s.GiaBan).FirstOrDefault(); double giamGia = double.Parse(this.txtGiamGia.Text.Trim()); double thanhTien = donGia * int.Parse(this.txtSoLuong.Text.Trim()); double giaSaugiam = thanhTien - thanhTien * giamGia / 100; this.dgv1.Rows[i].Cells[2].Value = this.txtSoLuong.Text.Trim(); this.dgv1.Rows[i].Cells[4].Value = this.txtGiamGia.Text.Trim(); this.dgv1.Rows[i].Cells[5].Value = thanhTien; this.dgv1.Rows[i].Cells[6].Value = giaSaugiam; return; } } } addRow(); } else { addRow(); } }
private void btnSuaThongTin_Click(object sender, EventArgs e) { var context = new Dtb_NhaSachContext(); this.dgv1.CurrentRow.Cells[1].Value = this.cbbTenSach.Text.Trim(); this.dgv1.CurrentRow.Cells[2].Value = this.txtSoLuong.Text.Trim(); double donGia = context.Saches.Where(s => s.TenSach.Trim() == this.cbbTenSach.Text.Trim()) .Select(s => s.GiaBan).FirstOrDefault(); this.dgv1.CurrentRow.Cells[3].Value = donGia; this.dgv1.CurrentRow.Cells[4].Value = this.txtGiamGia.Text.Trim(); double giamGia = double.Parse(this.txtGiamGia.Text.Trim()); double thanhTien = donGia * int.Parse(this.txtSoLuong.Text.Trim()); double giaSaugiam = thanhTien - thanhTien * giamGia / 100; this.dgv1.CurrentRow.Cells[5].Value = thanhTien; this.dgv1.CurrentRow.Cells[6].Value = giaSaugiam; this.btnXoaSach.Enabled = false; this.btnSuaThongTin.Enabled = false; this.btnThemSach.Enabled = true; refreshGroupB1(); tinhTien(); }
private void loadDgvBook() { var context = new Dtb_NhaSachContext(); #region load ds bằng linq var book = context.Saches .Join(context.Nxbs, s => s.MaNxb.Trim(), n => n.MaNxb.Trim(), (s, n) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, TenNxb = n.TenNxb, MaTl = s.MaTl, MaTg = s.MaTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }) .Join(context.Theloais, s => s.MaTl.Trim(), t => t.MaTl.Trim(), (s, t) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, TenTl = t.TenTl, TenNxb = s.TenNxb, MaTg = s.MaTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }) .Join(context.Tacgia, s => s.MaTg.Trim(), tg => tg.MaTg.Trim(), (s, tg) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, TenTl = s.TenTl, TenNxb = s.TenNxb, TenTg = tg.TenTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }).OrderBy(s => s.Stt).ToList(); this.dgvBook.DataSource = null; this.dgvBook.DataSource = book; #endregion customDgv(); }
public void loadcbb() { var context = new Dtb_NhaSachContext(); this.cbbTenSach.DataSource = context.Saches.Select(s => s.TenSach.Trim()).ToList(); this.cbbTenSach.Text = null; this.cbbTimKiemCthd.DataSource = context.Hoadons.Select(s => s.SoHd).ToList(); this.cbbTimKiemCthd.Text = null; this.cbbTenNv.DataSource = context.Nhanviens.Select(s => s.TenNv.Trim()).ToList(); this.cbbTenNv.Text = null; }
public void delCthd() { var context = new Dtb_NhaSachContext(); var list = context.Chitiethoadons.Where(s => s.SoHd == int.Parse(this.txtMahd.Text.Trim())).ToList(); foreach (var item in list) { context.Remove <Chitiethoadon>(item); context.SaveChanges(); } }
public void delHd() { var context = new Dtb_NhaSachContext(); var hd = new Hoadon() { SoHd = int.Parse(this.txtMahd.Text.Trim()), }; context.Remove <Hoadon>(hd); context.SaveChanges(); }
public void loadThongTinChung() { var context = new Dtb_NhaSachContext(); var hd = context.Hoadons.Where(s => s.SoHd == int.Parse(this.cbbTimKiemCthd.Text.Trim())).FirstOrDefault(); this.txtMahd.Text = this.cbbTimKiemCthd.Text.Trim(); this.dateTimePicker1.Value = DateTime.Parse(hd.NgayBan.ToString().Trim()); this.txtTenKh.Text = hd.TenKh.Trim(); this.cbbTenNv.Text = context.Nhanviens.Where(s => s.MaNv.Trim() == hd.MaNv.Trim()) .Select(s => s.TenNv).FirstOrDefault().ToString().Trim(); }
public void loadCbb() { var context = new Dtb_NhaSachContext(); this.cbbMs.DataSource = context.Saches.Select(s => s.MaSach.Trim()).ToList(); this.cbbMs.Text = null; this.cbbMtg.DataSource = context.Tacgia.Select(t => t.TenTg.Trim()).ToList(); this.cbbMtg.Text = null; this.cbbMtl.DataSource = context.Theloais.Select(t => t.TenTl.Trim()).ToList(); this.cbbMtl.Text = null; this.cbbnxb.DataSource = context.Nxbs.Select(n => n.TenNxb.Trim()).ToList(); this.cbbnxb.Text = null; }
public void loadMember() { var context = new Dtb_NhaSachContext(); var member = context.Thanhviens .Where(m => m.MaTv == m.MaTv) .ToList(); this.dgvMember.DataSource = member; this.dgvMember.Columns["MaTv"].HeaderText = "Mã thành viên"; this.dgvMember.Columns["TenTv"].HeaderText = "Tên"; this.dgvMember.Columns["NgaySinh"].HeaderText = "Ngày sinh"; this.dgvMember.Columns["Sdt"].HeaderText = "Số điện thoại"; this.dgvMember.Columns["DiaChi"].HeaderText = "Địa chỉ"; this.dgvMember.Columns["DiemTichLuy"].HeaderText = "Điểm tích lũy"; }
private void btnSua_Click(object sender, EventArgs e) { if (loiNhap() == true) { return; } var context = new Dtb_NhaSachContext(); if (this.txtManv.Text.Trim() != this.dgvEmploy.CurrentRow.Cells[0].Value.ToString().Trim()) { var cEmploy = context.Nhanviens .Where(s => s.MaNv.Trim() == this.txtManv.Text.Trim()) .Select(s => s.MaNv).ToList(); if (cEmploy.Count > 0) { this.errEmploy.SetError(this.txtManv, "Mã nhân viên không được trùng"); return; } else { this.errEmploy.SetError(this.txtManv, null); } } try { var edit = new Nhanvien() { MaNv = this.txtManv.Text.Trim(), }; edit.TenNv = this.txtTenNv.Text.Trim(); edit.NgSinh = this.dtpNgaySinh.Value; edit.DiaChi = this.txtDiaChi.Text.Trim(); edit.Luong = int.Parse(this.txtLuong.Text.Trim()); edit.Sdt = this.txtSdt.Text.Trim(); context.Update <Nhanvien>(edit); context.SaveChanges(); refreshControl(); loadEmploy(); } catch { MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!"); return; } }
private void btnXoa_Click(object sender, EventArgs e) { DialogResult xoa = MessageBox.Show("Đồng ý xóa?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (xoa == DialogResult.Yes) { var context = new Dtb_NhaSachContext(); var delete = new Thanhvien() { MaTv = int.Parse(this.dgvMember.CurrentRow.Cells[0].Value.ToString().Trim()), }; context.Remove <Thanhvien>(delete); context.SaveChanges(); refreshControl(); loadMember(); } }
private void login() { var context = new Dtb_NhaSachContext(); var taikhoan = new SqlParameter("@p0", this.txtTaiKhoan.Text); var matkhau = new SqlParameter("@p1", this.txtMatKhau.Text); var dangNhap = context.Taikhoans.FromSqlRaw("dangnhap @p0,@p1", taikhoan, matkhau).ToList(); if (dangNhap.Count == 1) { this.Hide(); frmMain formMain = new frmMain(); formMain.ShowDialog(); } else { MessageBox.Show("Tài khoản hoặc mật khẩu không chính xác"); } }
private void btnThem_Click(object sender, EventArgs e) { if (loiNhap() == true) { return; } var context = new Dtb_NhaSachContext(); var cEmploy = context.Nhanviens .Where(s => s.MaNv.Trim() == this.txtManv.Text.Trim()) .Select(s => s.MaNv).ToList(); if (cEmploy.Count > 0) { this.errEmploy.SetError(this.txtManv, "Mã nhân viên không được trùng"); return; } else { this.errEmploy.SetError(this.txtManv, null); } try { int i = this.dgvEmploy.Rows.Count; var nv = new Nhanvien() { MaNv = this.txtManv.Text.Trim(), TenNv = this.txtTenNv.Text.Trim(), Sdt = this.txtSdt.Text.Trim(), NgSinh = this.dtpNgaySinh.Value, DiaChi = this.txtDiaChi.Text.Trim(), Luong = int.Parse(this.txtLuong.Text.Trim()), }; context.Nhanviens.Add(nv); context.SaveChanges(); refreshControl(); loadEmploy(); } catch { MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!"); return; } }
private void loadEmploy() { var context = new Dtb_NhaSachContext(); var employ = context.Nhanviens .Where(n => n.MaNv == n.MaNv) .Select(n => new { n.MaNv, n.TenNv, n.NgSinh, n.DiaChi, n.Sdt, n.Luong }) .ToList(); this.dgvEmploy.DataSource = employ; this.dgvEmploy.Columns["MaNv"].HeaderText = "Mã nhân viên"; this.dgvEmploy.Columns["TenNv"].HeaderText = "Tên"; this.dgvEmploy.Columns["NgSinh"].HeaderText = "Ngày sinh"; this.dgvEmploy.Columns["DiaChi"].HeaderText = "Địa chỉ"; this.dgvEmploy.Columns["Sdt"].HeaderText = "Số điện thoại"; this.dgvEmploy.Columns["Luong"].HeaderText = "Lương"; }
public void addRow() { var context = new Dtb_NhaSachContext(); int stt = this.dgv1.Rows.Count; string tenSach = this.cbbTenSach.Text.Trim(); int soLuong = int.Parse(this.txtSoLuong.Text.Trim()); double donGia = context.Saches.Where(s => s.TenSach.Trim() == this.cbbTenSach.Text.Trim()) .Select(s => s.GiaBan).FirstOrDefault(); double giamGia = double.Parse(this.txtGiamGia.Text.Trim()); double thanhTien = donGia * soLuong; double giaSaugiam = thanhTien - thanhTien * giamGia / 100; this.dgv1.Rows.Add(stt, tenSach, soLuong, donGia, giamGia, thanhTien, giaSaugiam); }
private void LoadDtgv() { var context = new Dtb_NhaSachContext(); var showData = context.Hoadons .Where(h => h.SoHd == h.SoHd) .Select(h => new { h.SoHd, h.MaNv, h.NgayBan, h.TenKh, h.MaTv, h.TongTien }) .ToList(); this.dgvListBill.DataSource = showData; //Chỉnh tên cột this.dgvListBill.Columns["SoHd"].HeaderText = "Mã hóa đơn"; this.dgvListBill.Columns["Manv"].HeaderText = "Mã nhân viên"; this.dgvListBill.Columns["NgayBan"].HeaderText = "Ngày bán"; this.dgvListBill.Columns["TenKh"].HeaderText = "Tên khách hàng"; this.dgvListBill.Columns["MaTv"].HeaderText = "Mã thành viên"; this.dgvListBill.Columns["TongTien"].HeaderText = "Tổng tiền"; }
private void btnSua_Click(object sender, EventArgs e) { if (loiNhap()) { return; } var context = new Dtb_NhaSachContext(); var edit = new Thanhvien() { MaTv = int.Parse(this.dgvMember.CurrentRow.Cells[0].Value.ToString().Trim()), }; edit.TenTv = this.txtTentv.Text.Trim(); edit.NgaySinh = this.dtpNgaySinh.Value; edit.DiaChi = this.txtDiaChi.Text.Trim(); edit.DiemTichLuy = int.Parse(this.txtDiem.Text.Trim()); edit.Sdt = this.txtSdt.Text.Trim(); context.Update <Thanhvien>(edit); context.SaveChanges(); refreshControl(); loadMember(); }
private void frmBill_Load(object sender, EventArgs e) { if (cbbTimKiemCthd.Text.Trim() != "") { this.dgv1.Rows.Clear(); loadThongTinChung(); loadTtBanHang(); var context = new Dtb_NhaSachContext(); this.cbbTenSach.DataSource = context.Saches.Select(s => s.TenSach.Trim()).ToList(); this.cbbTenSach.Text = null; string cbb = this.cbbTimKiemCthd.Text.Trim(); this.cbbTimKiemCthd.DataSource = context.Hoadons.Select(s => s.SoHd).ToList(); this.cbbTimKiemCthd.Text = cbb; cbb = this.cbbTenNv.Text.Trim(); this.cbbTenNv.DataSource = context.Nhanviens.Select(s => s.TenNv.Trim()).ToList(); this.cbbTenNv.Text = cbb; } else { loadcbb(); } }
public void sapXep() { var context = new Dtb_NhaSachContext(); var sxSach = context.Saches.ToList(); int i = 1; foreach (var s in sxSach) { s.MaSach = s.MaSach; s.Stt = i; s.TenSach = s.TenSach; s.MaTg = s.MaTg; s.MaNxb = s.MaNxb; s.MaTl = s.MaTl; s.SoLuong = s.SoLuong; s.GiaBan = s.GiaBan; context.Update <Sach>(s); context.SaveChanges(); i++; } }
public void refreshSach() { var context = new Dtb_NhaSachContext(); for (int i = 0; i < this.dgv1.Rows.Count - 1; i++) { var MaSach = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.MaSach).FirstOrDefault(); var stt = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.Stt).FirstOrDefault(); var sl = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.SoLuong).FirstOrDefault(); var tenS = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.TenSach).FirstOrDefault(); var nxb = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.MaNxb).FirstOrDefault(); var tl = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.MaTl).FirstOrDefault(); var tg = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.MaTg).FirstOrDefault(); var gia = context.Saches.Where(s => s.TenSach.Trim() == this.dgv1.Rows[i].Cells[1].Value.ToString().Trim()) .Select(s => s.GiaBan).FirstOrDefault(); var refresh = new Sach() { MaSach = MaSach, }; refresh.Stt = stt; refresh.SoLuong = sl - int.Parse(this.dgv1.Rows[i].Cells[2].Value.ToString().Trim()); refresh.TenSach = tenS; refresh.MaNxb = nxb; refresh.MaTg = tg; refresh.MaTl = tl; refresh.GiaBan = gia; context.Saches.Update(refresh); context.SaveChanges(); } }
public void loadTtBanHang() { var context = new Dtb_NhaSachContext(); var cthd = context.Chitiethoadons.Where(s => s.SoHd == int.Parse(this.cbbTimKiemCthd.Text.Trim())) .OrderBy(s => s.MaSach).ToList(); int stt = 1; foreach (var item in cthd) { string tenSach = context.Saches.Where(s => s.MaSach.Trim() == item.MaSach.Trim()) .Select(s => s.TenSach).FirstOrDefault().ToString(); string soLuong = item.SoLuongBan.ToString().Trim(); string donGia = item.DonGia.ToString().Trim(); string giamGia = item.GiamGia.ToString().Trim(); string thanhTien = item.ThanhTien.ToString().Trim(); string giaSauGiam = item.GiaSauGiam.ToString().Trim(); string[] row = new string[] { stt.ToString().Trim(), tenSach, soLuong, donGia, giamGia, thanhTien, giaSauGiam }; dgv1.Rows.Add(row); stt++; } }
private void btnThem_Click(object sender, EventArgs e) { if (loiNhap()) { return; } var context = new Dtb_NhaSachContext(); int i = this.dgvMember.Rows.Count; var tv = new Thanhvien() { MaTv = int.Parse(this.dgvMember.Rows[i - 1].Cells[0].Value.ToString().Trim()) + 1, TenTv = this.txtTentv.Text.Trim(), Sdt = this.txtSdt.Text.Trim(), NgaySinh = this.dtpNgaySinh.Value, DiaChi = this.txtDiaChi.Text.Trim(), DiemTichLuy = int.Parse(this.txtDiem.Text.Trim()), }; context.Thanhviens.Add(tv); context.SaveChanges(); refreshControl(); loadMember(); }
private void btnFind_Click(object sender, EventArgs e) { var context = new Dtb_NhaSachContext(); var ms = new SqlParameter("@masach", this.cbbMs.Text.ToLower().Trim()); var ts = new SqlParameter("@tensach", this.txtTenSach.Text.ToLower().Trim()); var tl = new SqlParameter("@tentl", this.cbbMtl.Text.ToLower().Trim()); var n = new SqlParameter("@tennxb", this.cbbnxb.Text.ToLower().Trim()); var tg = new SqlParameter("@tentg", this.cbbMtg.Text.ToLower().Trim()); var resultRaw = context.Saches.FromSqlRaw("timkiemSach @masach, @tensach, @tentl, @tennxb, @tentg", ms, ts, tl, n, tg).ToList(); #region linq var result = resultRaw.Join(context.Tacgia, s => s.MaTg.Trim(), tg => tg.MaTg.Trim(), (s, tg) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, MaTl = s.MaTl, MaNxb = s.MaNxb, TenTg = tg.TenTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }).Join(context.Theloais, s => s.MaTl.Trim(), t => t.MaTl.Trim(), (s, t) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, TenTl = t.TenTl, MaNxb = s.MaNxb, TenTg = s.TenTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }).Join(context.Nxbs, f => f.MaNxb.Trim(), n => n.MaNxb.Trim(), (s, n) => new { Stt = s.Stt, MaSach = s.MaSach, TenSach = s.TenSach, TenTl = s.TenTl, TenNxb = n.TenNxb, TenTg = s.TenTg, SoLuong = s.SoLuong, GiaBan = s.GiaBan }) .OrderBy(s => s.Stt).ToList(); #endregion this.dgvBook.DataSource = null; this.dgvBook.DataSource = result; customDgv(); }
private void btnSua_Click(object sender, EventArgs e) { if (loiNhap()) { return; } #region nếu trùng khóa chính khác var context = new Dtb_NhaSachContext(); if (this.cbbMs.Text.Trim() != this.dgvBook.CurrentRow.Cells[1].Value.ToString().Trim()) { var cSach = context.Saches .Where(s => s.MaSach.Trim() == this.cbbMs.Text.Trim()) .Select(s => s.MaSach).ToList(); if (cSach.Count > 0) { this.errorProvider1.SetError(this.cbbMs, "Mã sách không được trùng"); return; } else { this.errorProvider1.SetError(this.cbbMs, null); } } #endregion try { var edit = new Sach() { //Stt = int.Parse(this.dgvBook.CurrentRow.Cells[0].Value.ToString().Trim()), MaSach = this.dgvBook.CurrentRow.Cells[1].Value.ToString().Trim(), }; var tg = context.Tacgia .Where(t => t.TenTg == this.cbbMtg.Text.Trim()) .Select(t => new { t.MaTg, }).FirstOrDefault().MaTg.Trim(); var nxb = context.Nxbs .Where(n => n.TenNxb == this.cbbnxb.Text.Trim()) .Select(n => new { n.MaNxb, }).FirstOrDefault().MaNxb.Trim(); var tl = context.Theloais .Where(t => t.TenTl == this.cbbMtl.Text.Trim()) .Select(t => new { t.MaTl, }).FirstOrDefault().MaTl.Trim(); edit.Stt = int.Parse(this.dgvBook.CurrentRow.Cells[0].Value.ToString().Trim()); edit.TenSach = this.txtTenSach.Text.Trim(); edit.SoLuong = int.Parse(this.txtSoLuong.Text.Trim()); edit.MaTl = tl; edit.MaTg = tg; edit.MaNxb = nxb; edit.GiaBan = int.Parse(this.txtGiaBan.Text.Trim()); context.Update <Sach>(edit); context.SaveChanges(); refreshControl(); loadDgvBook(); MessageBox.Show("Sửa thành công!!!!"); } catch { MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!"); return; } }
private void btnThem_Click(object sender, EventArgs e) { if (loiNhap()) { return; } #region nếu trùng khóa chính var context = new Dtb_NhaSachContext(); var cSach = context.Saches .Where(s => s.MaSach.Trim() == this.cbbMs.Text.Trim()) .Select(s => s.MaSach).ToList(); if (cSach.Count > 0) { this.errorProvider1.SetError(this.cbbMs, "Mã sách không được trùng"); return; } else { this.errorProvider1.SetError(this.cbbMs, null); } #endregion try { var tg = context.Tacgia .Where(t => t.TenTg == this.cbbMtg.Text.Trim()) .Select(t => new { t.MaTg, }).FirstOrDefault().MaTg.Trim(); var nxb = context.Nxbs .Where(n => n.TenNxb == this.cbbnxb.Text.Trim()) .Select(n => new { n.MaNxb, }).FirstOrDefault().MaNxb.Trim(); var tl = context.Theloais .Where(t => t.TenTl == this.cbbMtl.Text.Trim()) .Select(t => new { t.MaTl, }).FirstOrDefault().MaTl.Trim(); var addBook = new Sach() { Stt = context.Saches.Count() + 1, MaSach = this.cbbMs.Text.Trim(), TenSach = this.txtTenSach.Text.Trim(), SoLuong = int.Parse(this.txtSoLuong.Text.Trim()), MaTl = tl, MaTg = tg, MaNxb = nxb, GiaBan = int.Parse(this.txtGiaBan.Text.Trim()), }; context.Saches.Add(addBook); context.SaveChanges(); MessageBox.Show("Thêm thành công!!!"); refreshControl(); loadDgvBook(); } catch { MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!"); return; } }