TheDocGiaDTO GetData()
{
string name = txtName.Text;
string address = txtAddress.Text;
string email = txtEmail.Text;
DateTime dtBirth = dtpBirth.Value;
LoaiDocGiaDTO loaidocgia = (LoaiDocGiaDTO)cmbType.SelectedItem;
TheDocGiaDTO result = new TheDocGiaDTO();
if (dgv.CurrentRow != null)
{
result.MaThe = ((TheDocGiaDTO)dgv.CurrentRow.DataBoundItem).MaThe;
result.NgayLapThe = (DateTime)dgv.CurrentRow.Cells["NgayLapThe"].Value;
result.NgayHetHan = (DateTime)dgv.CurrentRow.Cells["NgayHetHan"].Value;
}
result.HoTen = name;
result.DiaChi = address;
result.Email = email;
result.NgaySinh = dtBirth;
result.LoaiDocGia = loaidocgia;
return(result);
}
public bool Xoa(TheDocGiaDTO tdgDTO)
{
string query = @"DELETE DOCGIA WHERE MADG = @MADG ";
object[] para = new object[] { tdgDTO.Madg };
return(DataProvider.Instance.excuteNonQuery(query, para));
}
public bool Sua(TheDocGiaDTO tdgDTO)
{
string query = @"UPDATE DOCGIA SET MALOAIDG = @MALOAIDG , HOTEN = @HOTEN , NGAYSINH = @NGAYSINH , DIACHI = @DIACHI , EMAIL = @EMAIL WHERE MADG = @MADG ";
object[] para = new object[] { tdgDTO.Maloaidg, tdgDTO.Hoten, tdgDTO.Ngaysinh, tdgDTO.Diachi, tdgDTO.Email, tdgDTO.Madg };
return(DataProvider.Instance.excuteNonQuery(query, para));
}
private void SuaPhieuMuon_GUI()
{
PhieuMuonDTO phieuMuonDTO = new PhieuMuonDTO();
SachDTO sachDTO = new SachDTO();
TheDocGiaDTO theDG = new TheDocGiaDTO();
GetPhieuMuon_Data_From_GUI(phieuMuonDTO);
theDG.Madg = phieuMuonDTO.Madg;
int flag = 0;
foreach (string ma in ListMaSach)
{
sachDTO.Masach = ma;
bool updateSach = sachBus.UpdateData(sachDTO);
if (updateSach)
{
flag = 1;
}
}
bool result = phieuMuonBus.SuaPhieuMuon(phieuMuonDTO);
bool resultDG = theDGBus.UpdateSoSachMuon(theDG, intTongSoSachDangChon);
if (result && resultDG && flag == 1)
{
//SACH SOLUONG VA LUOT MUON
MessageBox.Show("ĐÃ CẬP NHẬT PHIẾU MƯỢN THÀNH CÔNG!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("ĐÃ CÓ LỖI XẢY RA, VUI LÒNG KIỂM TRA LẠI", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Them(TheDocGiaDTO tdgDTO)
{
string query = @"INSERT INTO DOCGIA (MADG, MALOAIDG, HOTEN, NGAYSINH, DIACHI, EMAIL, NGAYLAPTHE, NGAYHETHAN, SOSACHDANGMUON, TONGTIENNO, LUOTMUON) VALUES( @MADG , @MALOAIDG , @HOTEN , @NGAYSINH , @DIACHI , @EMAIL , @NGAYLAPTHE , @NGAYHETHAN , @SOSACHDANGMUON , @TONGTIENNO , @LUOTMUON )";
object[] para = new object[] { tdgDTO.Madg, tdgDTO.Maloaidg, tdgDTO.Hoten, tdgDTO.Ngaysinh, tdgDTO.Diachi, tdgDTO.Email, tdgDTO.Ngaylapthe, tdgDTO.Ngayhethan, tdgDTO.Sosachdangmuon, tdgDTO.Tongtienno, tdgDTO.Luotmuon };
return(DataProvider.Instance.excuteNonQuery(query, para));
}
public bool UpdateSachDangMuon_XoaPM(TheDocGiaDTO tdgDTO, int SoSachMuon)
{
string query = @"UPDATE DOCGIA SET SOSACHDANGMUON = SOSACHDANGMUON - " + SoSachMuon.ToString();
query += " WHERE MADG = @MADG ";
object[] para = new object[] { tdgDTO.Madg };
return(DataProvider.Instance.excuteNonQuery(query, para));
}
public void MapDataDGFromGUI(ref TheDocGiaDTO tdgDTO, TextBoxX txtMaDG, TextBoxX txtHoTen, DateTimeInput dtpNgaySinh, TextBoxX txtDiaChi, TextBoxX txtEmail)
{
tdgDTO.Madg = txtMaDG.Text;
tdgDTO.Hoten = txtHoTen.Text;
tdgDTO.Ngaysinh = dtpNgaySinh.Value;
tdgDTO.Diachi = txtDiaChi.Text;
tdgDTO.Email = txtEmail.Text;
tdgDTO.Ngaylapthe = DateTime.Now;
}
private void btnThem_Click(object sender, EventArgs e)
{
TheDocGiaDTO thedocgia = GetData();
new TheDocGiaBUS().Insert(thedocgia);
BindingList <TheDocGiaDTO> bl = (BindingList <TheDocGiaDTO>)dgv.DataSource;
bl.Add(thedocgia);
MessageBox.Show("Đã thêm");
}
public bool Them(TheDocGiaDTO tdgDTO, QDLoaiDocGiaDTO ldgDTO, int thoiHanThe, List <string> listQD)
{
GetMaLoaiDGFromLoaiDG(tdgDTO, ldgDTO);
//CheckDataPanelDGInValid(tdgDTO, ldgDTO);
tdgDTO.Luotmuon = 0;
tdgDTO.Ngayhethan = tdgDTO.Ngaylapthe.AddMonths(thoiHanThe);
tdgDTO.Sosachdangmuon = 0;
tdgDTO.Tongtienno = 0;
tdgDTO.Luotmuon = 0;
return(tdgDAL.Them(tdgDTO));
}
public void Update(TheDocGiaDTO dto)
{
string sql = "update TheDocGia set "
+ "HoTen = '" + dto.HoTen + "', "
+ "DiaChi = '" + dto.DiaChi + "', "
+ "Email = '" + dto.Email + "', "
+ "NgaySinh = '" + dto.NgaySinh.ToShortDateString() + "', "
+ "NgayLapThe = '" + dto.NgayLapThe.ToShortDateString() + "', "
+ "NgayHetHan = '" + dto.NgayHetHan.ToShortDateString() + "', "
+ "MaLoaiDocGia = '" + dto.LoaiDocGia.MaLoaiDocGia + "' "
+ "where MaThe = " + dto.MaThe + "";
executeNonQuery(sql);
}
public void Insert(TheDocGiaDTO dto)
{
string sql = "insert into TheDocGia(HoTen, DiaChi, Email, NgaySinh, NgayLapThe, NgayHetHan, MaLoaiDocGia) values ('"
+ dto.HoTen + "','"
+ dto.DiaChi + "','"
+ dto.Email + "','"
+ dto.NgaySinh.ToShortDateString() + "','"
+ dto.NgayLapThe.ToShortDateString() + "','"
+ dto.NgayHetHan.ToShortDateString() + "','"
+ dto.LoaiDocGia.MaLoaiDocGia + "')";
executeNonQuery(sql);
sql = "select @@IDENTITY";
dto.MaThe = (int)executeScalar(sql);
}
public void GetMaLoaiDGFromLoaiDG(TheDocGiaDTO tdgDTO, QDLoaiDocGiaDTO ldgDTO)
{
Dictionary <string, string> temp = new Dictionary <string, string>();
DataTable data = ldgDAL.LoadBangLoaiDG();
for (int i = 0; i < data.Rows.Count; ++i)
{
// key: Ten loai doc gia - value: Ma loai doc gia
temp.Add(data.Rows[i][1].ToString(), data.Rows[i][0].ToString());
}
if (temp.ContainsKey(ldgDTO.Loaidg))
{
tdgDTO.Maloaidg = temp[ldgDTO.Loaidg];
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dgv.CurrentRow != null)
{
TheDocGiaDTO thedocgia = GetData();
new TheDocGiaBUS().Delete(thedocgia);
BindingList <TheDocGiaDTO> bl = (BindingList <TheDocGiaDTO>)dgv.DataSource;
bl.RemoveAt(dgv.CurrentRow.Index);
MessageBox.Show("Đã xóa");
}
else
{
MessageBox.Show("Chọn 1 dòng để xóa");
}
}
public bool CheckQuyDinhDG(TheDocGiaDTO tdgDTO, List <string> listQD)
{
if (listQD[0] == "" || listQD[1] == "" || listQD[2] == "")// TuoiToiThieu - TuoiToiDa - ThoiHanThe
{
MessageBox.Show("Cần bổ sung quy định trước", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
int tuoiDG = DateTime.Today.Year - tdgDTO.Ngaysinh.Year;
if (tuoiDG < int.Parse(listQD[0].ToString()) || tuoiDG > int.Parse(listQD[1].ToString()))
{
MessageBox.Show("Tuổi độc giả không đạt quy định");
return(false);
}
return(true);
}
public bool CheckDataPanelDGInValid(TheDocGiaDTO tdgDTO, QDLoaiDocGiaDTO ldgDTO)
{
//if (tdgDTO.Ngaysinh = null)
// return true;
if (tdgDTO.Ngaysinh.Year == 1 || tdgDTO.Ngaysinh > DateTime.Today)
{
MessageBox.Show("Ngày sinh không hợp lệ", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (ldgDTO.Loaidg == "")
{
MessageBox.Show("Chưa nhập loại độc giả", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
return(true);
}
public void Sua(ref DataGridViewX dgvDG, ref TextBoxX txtMaDG, ref TextBoxX txtHoTen, ref DateTimeInput dtpNgaySinh, ref TextBoxX txtDiaChi, ref TextBoxX txtEmail, ref ComboBoxEx cbxLoaiDG, ref DateTimeInput dtpNgayLapThe, ref DateTimeInput dtpNgayHetHan, ref TextBoxX txtSoSachDangMuon, ref TextBoxX txtTongTienNo, ref TextBoxX txtTuoiToiThieu, ref TextBoxX txtTuoiToiDa, ref ComboBoxEx cbxTimKiemDG, ref TextBoxX txtThoiHanThe, QDLoaiDocGiaBUS ldgBUS, TheDocGiaBUS tdgBUS, QuyDinhDocGiaBUS qddgBUS)
{
TheDocGiaDTO tdgDTO = new TheDocGiaDTO();
QDLoaiDocGiaDTO ldgDTO = new QDLoaiDocGiaDTO();
tdgBUS.MapDataDGFromGUI(ref tdgDTO, txtMaDG, txtHoTen, dtpNgaySinh, txtDiaChi, txtEmail);
ldgBUS.MapDataLDGFromGUIDG(ref ldgDTO, cbxLoaiDG);
//MapDataDGFromGUI(tdgDTO);
//MapDataLDGFromGUIDG(ldgDTO);
if (tdgBUS.Sua(tdgDTO, ldgDTO) == true)
{
MessageBox.Show("Cập nhật thành công");
tdgBUS.LoadTabQLDG(ref dgvDG, ref txtMaDG, ref txtHoTen, ref dtpNgaySinh, ref txtDiaChi, ref txtEmail, ref cbxLoaiDG, ref dtpNgayLapThe, ref dtpNgayHetHan, ref txtSoSachDangMuon, ref txtTongTienNo, ref txtTuoiToiThieu, ref txtTuoiToiDa, ref cbxTimKiemDG, ref txtThoiHanThe, ldgBUS, tdgBUS, qddgBUS);
}
else
{
MessageBox.Show("Cập nhật không thành công", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Them(ref DataGridViewX dgvDG, ref TextBoxX txtMaDG, ref TextBoxX txtHoTen, ref DateTimeInput dtpNgaySinh, ref TextBoxX txtDiaChi, ref TextBoxX txtEmail, ref ComboBoxEx cbxLoaiDG, ref DateTimeInput dtpNgayLapThe, ref DateTimeInput dtpNgayHetHan, ref TextBoxX txtSoSachDangMuon, ref TextBoxX txtTongTienNo, ref TextBoxX txtTuoiToiThieu, ref TextBoxX txtTuoiToiDa, ref ComboBoxEx cbxTimKiemDG, ref TextBoxX txtThoiHanThe, QDLoaiDocGiaBUS ldgBUS, TheDocGiaBUS tdgBUS, QuyDinhDocGiaBUS qddgBUS)
{
TheDocGiaDTO tdgDTO = new TheDocGiaDTO();
QDLoaiDocGiaDTO ldgDTO = new QDLoaiDocGiaDTO();
tdgBUS.MapDataDGFromGUI(ref tdgDTO, txtMaDG, txtHoTen, dtpNgaySinh, txtDiaChi, txtEmail);
ldgBUS.MapDataLDGFromGUIDG(ref ldgDTO, cbxLoaiDG);
//this.MapDataDGFromGUI(tdgDTO);
//this.MapDataLDGFromGUIDG(ldgDTO);
//if (IsDataPanelDGInValid(tdgDTO, ldgDTO))
// MessageBox.Show("Kiểm tra lại dữ liệu", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
List <string> listQuyDinh = new List <string>()
{
txtTuoiToiThieu.Text, txtTuoiToiDa.Text, txtThoiHanThe.Text
};
if (tdgBUS.IsTrungKhopKhoaChinh(tdgDTO.Madg, dgvDG))
{
return;
}
if (tdgBUS.CheckDataPanelDGInValid(tdgDTO, ldgDTO) == false)
{
return;
}
if (tdgBUS.CheckQuyDinhDG(tdgDTO, listQuyDinh) == false)
{
return;
}
if (tdgBUS.Them(tdgDTO, ldgDTO, int.Parse(txtThoiHanThe.Text), listQuyDinh))
{
MessageBox.Show("Thêm thành công");
tdgBUS.LoadTabQLDG(ref dgvDG, ref txtMaDG, ref txtHoTen, ref dtpNgaySinh, ref txtDiaChi, ref txtEmail, ref cbxLoaiDG, ref dtpNgayLapThe, ref dtpNgayHetHan, ref txtSoSachDangMuon, ref txtTongTienNo, ref txtTuoiToiThieu, ref txtTuoiToiDa, ref cbxTimKiemDG, ref txtThoiHanThe, ldgBUS, tdgBUS, qddgBUS);
}
else
{
MessageBox.Show("Thêm không thành công", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected override object GetDataFromDataRow(System.Data.DataRow dr)
{
TheDocGiaDTO dto = new TheDocGiaDTO();
dto.HoTen = (string)dr["HoTen"];
dto.MaThe = (int)dr["MaThe"];
dto.DiaChi = (string)dr["DiaChi"];
dto.Email = (string)dr["Email"];
dto.NgaySinh = (DateTime)dr["NgaySinh"];
dto.NgayLapThe = (DateTime)dr["NgayLapThe"];
dto.NgayHetHan = (DateTime)dr["NgayHetHan"];
LoaiDocGiaDTO temp = new LoaiDocGiaDTO();
temp.MaLoaiDocGia = (int)dr["MaLoaiDocGia"];
temp.TenLoaiDocGia = lstLoaiDocGiaDTO[lstLoaiDocGiaDTO.IndexOf(temp)].TenLoaiDocGia;
dto.LoaiDocGia = temp;
return(dto);
}
public bool editFormDocGiaAndUser(TheDocGiaDTO thedocgia)
{
try
{
using (var db = new QuanLyThuVienEntities())
{
var Edit = (from a in db.THEDOCGIAs
where a.IDDocGia.Equals(thedocgia.IDDocGia)
select a).FirstOrDefault();
if (Edit == null)
{
return(false);
}
Edit.HoTenDG = thedocgia.HoTenDG;
Edit.DiaChiDG = thedocgia.DiaChiDG;
Edit.EmailDG = thedocgia.EmailDG;
Edit.NgaySinhDG = thedocgia.NgaySinhDG;
Edit.NgayLapThe = thedocgia.NgayLapThe;
Edit.IDLoaiDG = thedocgia.IDLoaiDocGia;
Edit.NgayHetHan = thedocgia.NgayHetHan;
Edit.TongNo = thedocgia.TongNo;
db.SaveChanges();
var EditUser = (from a in db.USERS
where a.IDDocGia.Equals(thedocgia.IDDocGia)
select a).FirstOrDefault();
if (EditUser == null)
{
return(false);
}
EditUser.Pwd = thedocgia.Password;
EditUser.UserName = thedocgia.UserName;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (dgv.CurrentRow != null)
{
TheDocGiaDTO thedocgia = GetData();
new TheDocGiaBUS().Update(thedocgia);
BindingList <TheDocGiaDTO> bl = (BindingList <TheDocGiaDTO>)dgv.DataSource;
TheDocGiaDTO tdg = bl[dgv.CurrentRow.Index];
dgv.CurrentRow.Cells["HoTen"].Value = thedocgia.HoTen;
dgv.CurrentRow.Cells["LoaiDocGia"].Value = thedocgia.LoaiDocGia;
dgv.CurrentRow.Cells["NgayLapThe"].Value = thedocgia.NgayLapThe;
dgv.CurrentRow.Cells["DiaChi"].Value = thedocgia.DiaChi;
dgv.CurrentRow.Cells["Email"].Value = thedocgia.Email;
MessageBox.Show("Đã sửa");
}
else
{
MessageBox.Show("Chọn 1 dòng để sửa");
}
}
public void Xoa(ref DataGridViewX dgvDG, ref TextBoxX txtMaDG, ref TextBoxX txtHoTen, ref DateTimeInput dtpNgaySinh, ref TextBoxX txtDiaChi, ref TextBoxX txtEmail, ref ComboBoxEx cbxLoaiDG, ref DateTimeInput dtpNgayLapThe, ref DateTimeInput dtpNgayHetHan, ref TextBoxX txtSoSachDangMuon, ref TextBoxX txtTongTienNo, ref ComboBoxEx cbxTimKiemDG, TheDocGiaBUS tdgBUS)
{
if (dgvDG.RowCount != 0)
{
TheDocGiaDTO tdgDTO = new TheDocGiaDTO();
foreach (DataGridViewRow row in dgvDG.SelectedRows)
{
tdgDTO.Madg = row.Cells["MADG"].Value.ToString();
tdgBUS.Xoa(tdgDTO);
}
tdgBUS.LoadDgvDG(ref dgvDG, tdgBUS);
if (dgvDG.RowCount != 0)
{
tdgBUS.GetDataWhenClickDGVDG(dgvDG.Rows[0], ref txtMaDG, ref txtHoTen, ref dtpNgaySinh, ref txtDiaChi, ref txtEmail, ref cbxLoaiDG, ref dtpNgayLapThe, ref dtpNgayHetHan, ref txtSoSachDangMuon, ref txtTongTienNo);
}
}
//Sau khi delete
if (dgvDG.RowCount == 0)
{
tdgBUS.ResetSTT();
tdgBUS.ClearPanelDG(tdgBUS, ref txtMaDG, ref txtHoTen, ref dtpNgaySinh, ref txtDiaChi, ref txtEmail, ref cbxLoaiDG, ref dtpNgayLapThe, ref dtpNgayHetHan, ref txtSoSachDangMuon, ref txtTongTienNo, ref cbxTimKiemDG);
}
}
public void Delete(TheDocGiaDTO dto)
{
string sql = "delete from TheDocGia where MaThe = " + dto.MaThe + "";
executeNonQuery(sql);
}
public bool Sua(TheDocGiaDTO tdgDTO, QDLoaiDocGiaDTO ldgDTO)
{
GetMaLoaiDGFromLoaiDG(tdgDTO, ldgDTO);
return(tdgDAL.Sua(tdgDTO));
}
public void Insert(TheDocGiaDTO dto)
{
dto.NgayLapThe = DateTime.Now.Date;
dto.NgayHetHan = dto.NgayLapThe.AddMonths(6).Date;
((TheDocGiaDAO)dp).Insert(dto);
}
public void Delete(TheDocGiaDTO dto)
{
((TheDocGiaDAO)dp).Delete(dto);
}
public void Update(TheDocGiaDTO dto)
{
((TheDocGiaDAO)dp).Update(dto);
}
public void TheDocGia_Delete(TheDocGiaDTO dto)
{
TheDocGiaDAO dao = new TheDocGiaDAO();
dao.Delete(dto);
}
public void TheDocGia_Update(TheDocGiaDTO dto)
{
TheDocGiaDAO dao = new TheDocGiaDAO();
dao.Update(dto);
}
public void TheDocGia_Insert(ref TheDocGiaDTO dto)
{
TheDocGiaDAO dao = new TheDocGiaDAO();
dao.Insert(dto);
}
// Edit Form DocGia and User
public void editFormDocGiaAndUser(TheDocGiaDTO thedocgia)
{
this._TheDocGiaBUS.editFormDocGiaAndUser(thedocgia);
}
