private void btnThem_Click(object sender, EventArgs e) { if (KiemTra() == "") { NhaXuatBanDTO NXB = new NhaXuatBanDTO(); NXB.MaNXB = txtMaNXB.Text; NXB.TenNXB = txtTenNXB.Text; NXB.DiaChi = txtDiaChi.Text; NXB.DienThoai = txtDienThoai.Text; if (NhaXuatBanBUS.ThemNXB(NXB) == true) { txtMaNXB.Text = NhaXuatBanBUS.GetIDNXB(); txtTenNXB.ResetText(); txtDiaChi.ResetText(); txtDienThoai.ResetText(); LoadData(); } else { MessageBox.Show("Thêm thất bại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(string.Format("{0}", KiemTra()), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnLuu_Click(object sender, EventArgs e) { try { NhaXuatBanDTO nxb = new NhaXuatBanDTO(); nxb.MaNXB = manxb; nxb.Ten = txtTen.Text.Trim(); nxb.Website = txtWebsite.Text.Trim(); nxb.Email = txtEmail.Text.Trim(); nxb.GhiChu = txtGhiChu.Text.Trim(); if (nxbBUS.Sua(nxb)) { MessageBox.Show("Cập nhật nhà xuất bản thành công!"); } else { MessageBox.Show("Cập nhật nhà xuất bản không thành công!"); } this.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public NhaXuatBanDTO LayTenNhaXuatBan(int maNXB) { NhaXuatBanDTO nxb = null; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Select * from NHAXUATBAN where MaNXB = ?"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@MaNXB", OleDbType.Integer); command.Parameters["@MaNXB"].Value = maNXB; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { nxb = new NhaXuatBanDTO(); nxb.MaNXB = (int)reader["MaNXB"]; nxb.TenNXB = (string)reader["TenNXB"]; } reader.Close(); connection.Close(); return(nxb); }
public NhaXuatBanDTO LayTenNhaXuatBan(int maNXB) { NhaXuatBanDAO nxbDAO = new NhaXuatBanDAO(); NhaXuatBanDTO nxbDTO = null; nxbDTO = nxbDAO.LayTenNhaXuatBan(maNXB); return(nxbDTO); }
public void SuaNhaXuatBan(NhaXuatBanDTO nhaXuatBanDto) { var nhaXuatBan = _nhaXuatBanRepository.GetBy(nhaXuatBanDto.MaNXB); nhaXuatBanDto.MappingNhaXuatBan(nhaXuatBan); _nhaXuatBanRepository.Update(nhaXuatBan); }
public bool Sua(NhaXuatBanDTO nxbDTO) { if (nxbDTO.Ten == "") { throw new Exception("Chưa nhập tên nhà xuất bản!"); } return(nxbDAO.Sua(nxbDTO)); }
public static NhaXuatBan MappingNhaXuatBan(this NhaXuatBanDTO nhaXuatBanDto) { return(new NhaXuatBan { MaNXB = nhaXuatBanDto.MaNXB, TenNXB = nhaXuatBanDto.TenNXB }); }
private void frmCapNhatNXB_Load(object sender, EventArgs e) { NhaXuatBanDTO nxb = nxbBUS.LayNhaXuatBanTheoMa(manxb); txtMaNXB.Text = manxb.ToString(); txtTen.Text = nxb.Ten; txtWebsite.Text = nxb.Website; txtEmail.Text = nxb.Email; txtGhiChu.Text = nxb.GhiChu; }
private void btnCapNhat_Click(object sender, EventArgs e) { NhaXuatBanDTO NXB = new NhaXuatBanDTO(); NXB.MaNXB = ((NhaXuatBanDTO)cmbNXB.SelectedItem).MaNXB; NXB.TenNXB = txtNXB.Text; NhaXuatBanBUS.Modify(NXB); QuanLyNXB_Load(sender, e); }
private void btnThem_Click(object sender, EventArgs e) { if (txtThemTenNXB.Text.Length == 0) { MessageBox.Show("Bạn Chưa Nhập Tên Nhà Xuất Bản!", "Cảnh báo!"); } else { NhaXuatBanDTO NXB = new NhaXuatBanDTO(); NXB.TenNXB = txtThemTenNXB.Text; NhaXuatBanBUS.Insert(NXB); MessageBox.Show("Thêm thành công!", "Thông báo!"); this.Close(); } }
public static void Insert(NhaXuatBanDTO NXB) { OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Insert into NHAXUATBAN(TenNXB) values(?)"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@TenNXB", OleDbType.VarWChar); command.Parameters["@TenNXB"].Value = NXB.TenNXB; command.ExecuteNonQuery(); command.CommandText = "select @@IDENTITY"; NXB.MaNXB = (int)command.ExecuteScalar(); connection.Close(); }
public bool Them(NhaXuatBanDTO nxbDTO) { conn.Open(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.StoredProcedure; com.CommandText = "SP_ThemNXB"; com.Connection = conn; com.Parameters.Add("@ten", SqlDbType.NVarChar).Value = nxbDTO.Ten; com.Parameters.Add("@website", SqlDbType.VarChar).Value = nxbDTO.Website; com.Parameters.Add("@email", SqlDbType.VarChar).Value = nxbDTO.Email; com.Parameters.Add("@ghichu", SqlDbType.NText).Value = nxbDTO.GhiChu; int kq = com.ExecuteNonQuery(); conn.Close(); return(kq > 0); }
public IActionResult Index(string sortOrder, string searchString, int pageIndex = 1) { int pageSize = 8; int count; var nhaXuatBans = nhaXuatBanService.GetNhaXuatBans(sortOrder, searchString, pageIndex, pageSize, out count); var nhaXuatBanNew = new NhaXuatBanDTO(); var nhaXuatBanVM = new NhaXuatBanIndexVm() { NhaXuatBans = new PaginatedList <NhaXuatBanDTO>(nhaXuatBans, count, pageIndex, pageSize), SearchString = searchString, SortOrder = sortOrder, nhaXuatBan = nhaXuatBanNew }; return(View(nhaXuatBanVM)); }
private void btnSua_Click(object sender, EventArgs e) { NhaXuatBanDTO NXB = new NhaXuatBanDTO(); NXB.MaNXB = txtMaNXB.Text; NXB.TenNXB = txtTenNXB.Text; NXB.DiaChi = txtDiaChi.Text; NXB.DienThoai = txtDienThoai.Text; if (NhaXuatBanBUS.SuaNXB(NXB) == true) { LoadData(); } else { MessageBox.Show("Cập nhật thất bại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static bool Modify(NhaXuatBanDTO NXB) { bool result = false; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Update NHAXUATBAN set TenNXB = ? where MaNXB = ?"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@TenNXB", OleDbType.VarWChar); command.Parameters.Add("@MaNXB", OleDbType.Integer); command.Parameters["@TenNXB"].Value = NXB.TenNXB; command.Parameters["@MaNXB"].Value = NXB.MaNXB; int row = command.ExecuteNonQuery(); if (row > 0) { result = true; } return(result); }
public static IList GetList() { ArrayList arrList = new ArrayList(); NhaXuatBanDTO NXB = null; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Select * from NHAXUATBAN"; OleDbCommand command = new OleDbCommand(cmdText, connection); OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { NXB = new NhaXuatBanDTO(); NXB.MaNXB = (int)reader["MaNXB"]; NXB.TenNXB = (string)reader["TenNXB"]; arrList.Add(NXB); } reader.Close(); connection.Close(); return(arrList); }
private void btnLuu_Click(object sender, EventArgs e) { try { NhaXuatBanDTO nxbDTO = new NhaXuatBanDTO(); nxbDTO.Ten = txtTen.Text.Trim(); nxbDTO.Website = txtWebsite.Text.Trim(); nxbDTO.Email = txtEmail.Text.Trim(); nxbDTO.GhiChu = txtGhiChu.Text.Trim(); if (nxbBUS.Them(nxbDTO)) { MessageBox.Show("Thêm thành công!"); } else { MessageBox.Show("Thêm không thành công!"); } this.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public NhaXuatBanDTO LayNhaXuatBanTheoMa(int manxb) { conn.Open(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.StoredProcedure; com.CommandText = "SP_LayNXBTheoMa"; com.Connection = conn; com.Parameters.Add("@manxb", SqlDbType.Int).Value = manxb; NhaXuatBanDTO nxb = new NhaXuatBanDTO(); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { nxb.MaNXB = manxb; nxb.Ten = (string)dr["Ten"]; nxb.Website = (string)dr["Website"]; nxb.Email = (string)dr["Email"]; nxb.GhiChu = (string)dr["GhiChu"]; } conn.Close(); return(nxb); }
public static bool SuaNXB(NhaXuatBanDTO NXB) { try { SqlConnection con = DataProvider.Connection(); SqlCommand cmd = new SqlCommand("sp_SuaNXB", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@manxb", SqlDbType.NChar); cmd.Parameters.Add("@tennxb", SqlDbType.NVarChar); cmd.Parameters.Add("@diachi", SqlDbType.NVarChar); cmd.Parameters.Add("@dienthoai", SqlDbType.NChar); cmd.Parameters["@manxb"].Value = NXB.MaNXB; cmd.Parameters["@tennxb"].Value = NXB.TenNXB; cmd.Parameters["@diachi"].Value = NXB.DiaChi; cmd.Parameters["@dienthoai"].Value = NXB.DienThoai; cmd.ExecuteNonQuery(); con.Close(); return(true); } catch { return(false); } }
public static void MappingNhaXuatBan(this NhaXuatBanDTO nhaXuatBanDto, NhaXuatBan nhaXuatBan) { nhaXuatBan.MaNXB = nhaXuatBanDto.MaNXB; nhaXuatBan.TenNXB = nhaXuatBanDto.TenNXB; }
public void ThemNhaXuatBan(NhaXuatBanDTO nhaXuatBanDto) { var nhaXuatBan = nhaXuatBanDto.MappingNhaXuatBan(); _nhaXuatBanRepository.Add(nhaXuatBan); }
private void frmCapNhatSach_Load(object sender, EventArgs e) { try { cmbTenTG.DataSource = TacGiaBUS.GetList(); cmbTenTG.DisplayMember = "TenTG"; cmbTenTG.ValueMember = "MaTG"; cmbNhaXuatBan.DataSource = NhaXuatBanBUS.GetList(); cmbNhaXuatBan.DisplayMember = "TenNXB"; cmbNhaXuatBan.ValueMember = "MaNXB"; cmbLoaiSach.DataSource = TheLoaiBUS.GetList(); cmbLoaiSach.DisplayMember = "TenTheLoai"; cmbLoaiSach.ValueMember = "MaLoai"; cmbNgonNgu.DataSource = NgonNguBUS.GetList(); cmbNgonNgu.DisplayMember = "TenNgonNgu"; cmbNgonNgu.ValueMember = "MaNgonNgu"; int maSach = TimKiemSach.MaSach; SachBUS sachBUS = new SachBUS(); SachDTO sachDTO = null; sachDTO = sachBUS.Search_MaSach(maSach); tbxTenSach.Text = sachDTO.TenSach; txtSoTrang.Text = sachDTO.SoTrang.ToString(); TacGiaBUS tacgiaBUS = new TacGiaBUS(); TacGiaDTO tacgiaDTO = null; tacgiaDTO = tacgiaBUS.LayTenTacGia(sachDTO.MaTacGia); cmbTenTG.Text = tacgiaDTO.TenTG; NhaXuatBanBUS nxbBUS = new NhaXuatBanBUS(); NhaXuatBanDTO nxbDTO = null; nxbDTO = nxbBUS.LayTenNhaXuatBan(sachDTO.MaNXB); cmbNhaXuatBan.Text = nxbDTO.TenNXB; NgonNguBUS nnBUS = new NgonNguBUS(); NgonNguDTO nnDTO = null; nnDTO = nnBUS.LayTenNgonNgu(sachDTO.MaNgonNgu); cmbNgonNgu.Text = nnDTO.TenNgonNgu; TheLoaiBUS tlBUS = new TheLoaiBUS(); TheLoaiDTO tlDTO = null; tlDTO = tlBUS.LayTenTheLoai(sachDTO.MaTheLoai); cmbLoaiSach.Text = tlDTO.TenTheLoai; if (sachDTO.TrangThai == 0) { cmbTinhTrang.Text = "Chưa mượn"; } else { cmbTinhTrang.Text = "Đã mượn"; } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public static bool ThemNXB(NhaXuatBanDTO NXB) { return(NhaXuatBanDAO.ThemNXB(NXB)); }
public static void Insert(NhaXuatBanDTO NXB) { NhaXuatBanDAO.Insert(NXB); }
public static void Modify(NhaXuatBanDTO NXB) { NhaXuatBanDAO.Modify(NXB); }
public static bool SuaNXB(NhaXuatBanDTO NXB) { return(NhaXuatBanDAO.SuaNXB(NXB)); }
private void btnLuuNXB_Click(object sender, EventArgs e) { if (isThemNXB) { try { NhaXuatBanDTO nxbDTO = new NhaXuatBanDTO(); nxbDTO.Ten = txtTenNXB.Text.Trim(); nxbDTO.Website = txtWebsiteNXB.Text.Trim(); nxbDTO.Email = txtEmailNXB.Text.Trim(); nxbDTO.GhiChu = txtGhiChuNXB.Text.Trim(); if (nxbBUS.Them(nxbDTO)) { MessageBox.Show("Thêm thành công!"); } else { MessageBox.Show("Thêm không thành công!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { bdsNhaXuatBan.DataSource = nxbBUS.LayDanhSach(); isThemNXB = false; btnLuuNXB.Visible = false; pnlChucNangNXB.Enabled = true; pnlControlNXB.Enabled = false; resetControlNXB(); bdsCBONhaXuatBan.DataSource = nxbBUS.LayDanhSach(); } } if (isSuaNXB) { try { NhaXuatBanDTO nxbDTO = new NhaXuatBanDTO(); nxbDTO.MaNXB = Convert.ToInt32(txtMaNXB.Text); nxbDTO.Ten = txtTenNXB.Text.Trim(); nxbDTO.Website = txtWebsiteNXB.Text.Trim(); nxbDTO.Email = txtEmailNXB.Text.Trim(); nxbDTO.GhiChu = txtGhiChuNXB.Text.Trim(); if (nxbBUS.Sua(nxbDTO)) { MessageBox.Show("Sửa thành công!"); } else { MessageBox.Show("Sửa không thành công!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { bdsNhaXuatBan.DataSource = nxbBUS.LayDanhSach(); bdsCBONhaXuatBan.DataSource = nxbBUS.LayDanhSach(); isSuaNXB = false; btnLuuNXB.Visible = false; pnlChucNangNXB.Enabled = true; pnlControlNXB.Enabled = false; //resetControlNXB(); } } }