private void btnBookUpdate_Update_Click(object sender, EventArgs e) { Sach_DTO sach_DTO = new Sach_DTO { MaSach = lblBookUpdate_ID.Text, TenSach = txtBookUpdate_TitleOfBook.Text, MaDauSach = lblBookUpdate_TitleID.Text, TenTacGia = txtBookUpdate_Author.Text, TenNhaXuatBan = txtBookUpdate_Publisher.Text, SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()), NamXuatBan = int.Parse(txtBookUpdate_PublicDate.Text), DonGia = decimal.Parse(txtBookUpdate_Prices.Text), TrangThai = true }; DauSach_DTO dauSach_DTO = new DauSach_DTO { MaDauSach = lblBookUpdate_TitleID.Text, TenDauSach = txtBookUpdate_TitleOfBook.Text, MaTheLoai = comBookUpdate_Category.SelectedValue.ToString(), TrangThai = true }; DauSach_BUS dauSach_BUS = new DauSach_BUS(); if (dauSach_BUS.SuaDauSach(dauSach_DTO) == true) { Sach_BUS sach_BUS = new Sach_BUS(); if (sach_BUS.SuaSach(sach_DTO) == true) { CTNhapSach_BUS cTNhapSach_BUS = new CTNhapSach_BUS(); CTNhapSach_DTO cTNhapSach_DTO = cTNhapSach_BUS.TimCTNhapSachTheoMaSach(lblBookUpdate_ID.Text); cTNhapSach_DTO.SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()); cTNhapSach_DTO.DonGia = double.Parse(txtBookUpdate_Prices.Text); if (cTNhapSach_BUS.SuaCTNhapSach(cTNhapSach_DTO) == true) { NhapSach_BUS nhapSach_BUS = new NhapSach_BUS(); NhapSach_DTO nhapSach_DTO = nhapSach_BUS.TimNhapSachTheoMaNhap(cTNhapSach_DTO.MaNhap); nhapSach_DTO.ThanhTien = double.Parse(txtBookUpdate_Prices.Text) * int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()); if (nhapSach_BUS.SuaNhapSach(nhapSach_DTO) == true) { frmSuccess frm_Success = new frmSuccess(2); frm_Success.ShowDialog(); this.Hide(); } } } } else { frmFailed frm_Failed = new frmFailed(2); frm_Failed.Show(); } }
private void btnBookAdd_Add_Click(object sender, EventArgs e) { Sach_DTO sachDTO = new Sach_DTO(); sachDTO.MaSach = lblBook_ID.Text; sachDTO.TenSach = txtBookAdd_TitleOfBook.Text; sachDTO.MaDauSach = lblBook_SeriesOfBook.Text; sachDTO.TenTacGia = txtBookAdd_Author.Text; sachDTO.TenNhaXuatBan = txtBookAdd_Publisher.Text; sachDTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()); sachDTO.NamXuatBan = int.Parse(txtBookAdd_PublicDate.Text); sachDTO.DonGia = decimal.Parse(txtBookAdd_Prices.Text); sachDTO.TrangThai = true; DauSach_DTO dauSachDTO = new DauSach_DTO(); dauSachDTO.MaDauSach = lblBook_SeriesOfBook.Text; dauSachDTO.TenDauSach = txtBookAdd_TitleOfBook.Text; dauSachDTO.MaTheLoai = comBook_Category.SelectedValue.ToString(); dauSachDTO.TrangThai = true; CTNhapSach_DTO cTNhapSach_DTO = new CTNhapSach_DTO(); cTNhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach(); cTNhapSach_DTO.MaSach = lblBook_ID.Text; cTNhapSach_DTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()); cTNhapSach_DTO.DonGia = double.Parse(txtBookAdd_Prices.Text); cTNhapSach_DTO.TrangThai = true; NhapSach_DTO nhapSach_DTO = new NhapSach_DTO(); nhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach(); nhapSach_DTO.MaNV = DoAn.frmLOGIN.MaNV; nhapSach_DTO.NgayNhap = DateTime.Now; nhapSach_DTO.ThanhTien = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()) * double.Parse(txtBookAdd_Prices.Text); nhapSach_DTO.TrangThai = true; if (dauSach_BUS.ThemDauSach(dauSachDTO) == true) { if (sach_BUS.ThemSachMotDongSach(sachDTO) == true) { if (nhapSach_BUS.ThemNhapSach(nhapSach_DTO) == true) { if (cTNhapSach_BUS.ThemCTNhapSach(cTNhapSach_DTO) == true) { frmSuccess frmSuccess = new frmSuccess(1); frmSuccess.ShowDialog(); this.Hide(); } } } else { frmFailed frmFailed = new frmFailed(1); frmFailed.ShowDialog(); } } }
public NhapSach_DTO TimNhapSachTheoMaNhap(string MaNhap) { NhapSach_DTO nhapSach_DTO = new NhapSach_DTO(); //tim 1 nhan vien theo ma nhan vien NhapSach nhapSach = data.NhapSaches.SingleOrDefault( u => u.MaNhap == MaNhap && u.TrangThai.Value == true); // đỗ dữ liệu từ nhân viên trong database sang nhân viên dto de chuyen di nhapSach_DTO.MaNhap = nhapSach.MaNhap; nhapSach_DTO.MaNV = nhapSach.MaNV; nhapSach_DTO.NgayNhap = (DateTime)nhapSach.NgayNhap; nhapSach_DTO.ThanhTien = double.Parse(nhapSach.ThanhTien.ToString()); return(nhapSach_DTO); }
public bool SuaNhapSach(NhapSach_DTO nhapSach_DTO) { try { NhapSach nhapSach = data.NhapSaches.SingleOrDefault(u => u.MaNhap == nhapSach_DTO.MaNhap); nhapSach.MaNhap = nhapSach_DTO.MaNhap; nhapSach.MaNV = nhapSach_DTO.MaNV; nhapSach.NgayNhap = nhapSach_DTO.NgayNhap; nhapSach.ThanhTien = decimal.Parse(nhapSach_DTO.ThanhTien.ToString()); data.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool ThemNhapSach(NhapSach_DTO nhapSach_DTO) { try { NhapSach nhapSach = new NhapSach(); nhapSach.MaNhap = nhapSach_DTO.MaNhap; nhapSach.MaNV = nhapSach_DTO.MaNV; nhapSach.NgayNhap = nhapSach_DTO.NgayNhap; nhapSach.ThanhTien = (decimal)nhapSach_DTO.ThanhTien; nhapSach.TrangThai = true; data.NhapSaches.Add(nhapSach); data.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool SuaNhapSach(NhapSach_DTO nhapSach_DTO) { return(nhapSach_DAO.SuaNhapSach(nhapSach_DTO)); }
public bool ThemNhapSach(NhapSach_DTO nhapSach_DTO) { return(nhapSach_DAO.ThemNhapSach(nhapSach_DTO)); }