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();
}
}
}
