private void btnSua_Click(object sender, EventArgs e)
{
s _dg = new DocGia();
_dg.HoTen = txt_HoTen.Text;
_dg.MaDocGia = txt_MTV.Text;
if (rdoBtnNam.Checked == true)
{
_dg.GioiTinh = "Nam ";
}
else if (rdoBtnNu.Checked == true)
{
_dg.GioiTinh = "Nữ ";
}
if (dateNamSinh.Text == "")
{
_dg.NamSinh = DateTime.Now;
}
else
{
_dg.NamSinh = dateNamSinh.DateTime;
}
_dg.DiaChi = txt_DiaChi.Text;
tvBUS.sua(_dg);
lb_ThanhCong.Visible = true;
}
public void XoaDG(string id)
{
DocGia dg = qltvDB.DocGias.FirstOrDefault(s => s.MaDocGia.Equals(id));
qltvDB.DocGias.DeleteOnSubmit(dg);
qltvDB.SubmitChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("DocGiaID,TenDocGia,Email,NgaySinh,DiaChi,NgayLapThe,SLSachDaMuon,NgayHetHan,LoaiDocGiaID")] DocGia docGia)
{
if (id != docGia.DocGiaID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(docGia);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DocGiaExists(docGia.DocGiaID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["LoaiDocGiaID"] = new SelectList(_context.LoaiDocGia, "LoaiDocGiaID", "TenDocGia", docGia.LoaiDocGiaID);
return(View(docGia));
}
/// <summary>
/// lấy độc giả bằng mã độc giả
/// </summary>
/// <param name="id">mã độc giả</param>
/// <returns></returns>
public DocGia getDocGiaById(int id)
{
String sql = @"SELECT [MaDG]
,[HoTenDG]
,[EmailDG]
,[GioiTinhDG]
,[NgaysinhDG]
,[DiachiDG]
,[DienthoaiDG]
,[NgayLamThe]
,[NgayHetHan]
,[HoatDong]
FROM [ThuVien].[dbo].[DocGia] WHERE [MaDG]=" + id;
DataTable table = dbcnn.getdata(sql);
DocGia newdg = new DocGia();
if (table.Rows.Count == 1)
{
newdg.MaDG = (int)table.Rows[0]["MaDG"];
newdg.HoTenDG = (String)table.Rows[0]["HoTenDG"];
newdg.EmailDG = (String)table.Rows[0]["EmailDG"];
newdg.GioiTinhDG = (bool)table.Rows[0]["GioiTinhDG"];
newdg.NgaysinhDG = (DateTime)table.Rows[0]["NgaysinhDG"];
newdg.DiachiDG = (String)table.Rows[0]["DiachiDG"];
newdg.DienthoaiDG = (String)table.Rows[0]["DienthoaiDG"];
newdg.NgayLamThe = (DateTime)table.Rows[0]["NgayLamThe"];
newdg.NgayHetHan = (DateTime)table.Rows[0]["NgayHetHan"];
newdg.HoatDong = (bool)table.Rows[0]["HoatDong"];
return newdg;
}
return null;
}
private void btCapNhat_Click(object sender, EventArgs e)
{
if (btnCapNhat.Text == "OK")
{
DocGia dg = new DocGia();
dg.IDDocGia = int.Parse(txtID.Text);
dg.MaDocGia = txtMaDocGia.Text;
dg.HoTen = txtHoTen.Text;
dg.NgaySinh = Convert.ToDateTime(txtNgaySinh.Text);
dg.IDLop = Convert.ToInt32(cbLop.SelectedValue);
dg.DiaChi = txtDiaChi.Text;
dg.DienThoai = txtDienThoai.Text;
dg.Email = txtEmail.Text;
dg.NgayLapThe = Convert.ToDateTime(txtNgayLapThe.Text);
dg.Lock = chkLock.Checked;
if (DocGia.CapNhat(dg))
{
Enable_Controls(false);
btnCapNhat.Text = "Cập nhật";
btnTaoMoi.Enabled = btnXoaBo.Enabled = true;
ctCapNhat.Enabled = ctTaoMoi.Enabled = ctXoaBo.Enabled = ctchondoituong.Enabled = true;
MessageBox.Show("Cập nhật thông tin độc giả thành công");
}
}
else
{
Enable_Controls(true);
btnCapNhat.Text = "OK";
btnTaoMoi.Enabled = btnXoaBo.Enabled = false;
ctCapNhat.Enabled = ctTaoMoi.Enabled = ctXoaBo.Enabled = ctchondoituong.Enabled = false;
}
}
private void saveDocGiaDB(object sender, EventArgs e)
{
DocGia docGia = new DocGia();
if (txtBoxMaDocGia.Text.Length == 0)
{
MessageBox.Show("Mã độc giả không được trống");
return;
}
if (txtBoxThemTenDocGia.Text.Length == 0)
{
MessageBox.Show("Mã độc giả không được trống");
return;
}
docGia.maDocGia = Int32.Parse(txtBoxMaDocGia.Text);
docGia.tenDocGia = txtBoxThemTenDocGia.Text;
docGia.donVi = txtBoxThemDonVi.Text;
docGia.ngaySinh = dateTimeNgaySinh.Text.Length != 0
? DateTime.Parse(dateTimeNgaySinh.Text) : DateTime.Now;
docGia.sdt = txtBoxThemSdt.Text.Length != 0
? Int32.Parse(txtBoxThemSdt.Text) : 0;
docGia.queQuan = txtBoxThemQuequan.Text;
if (!docGiaBLL.ThemDocGia(docGia))
{
MessageBox.Show("Độc giả này bị trùng mã độc giả trong Database");
return;
}
Close();
}
public async Task <IActionResult> Edit(int id, [Bind("Id,TenDg,GioiTinh,NgaySinh,Cmnd,DiaChi,Sdt,SoLanViPham,NgayDangKy,Username,Password,TrangThai")] DocGia docGia)
{
if (id != docGia.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(docGia);
await _context.SaveChangesAsync();
TempData["notice"] = "Successfully edit";
TempData["docgia"] = docGia.TenDg;
}
catch (DbUpdateConcurrencyException)
{
if (!DocGiaExists(docGia.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(docGia));
}
public List <DocGia> getAll(string Top, string Where, string Order)
{
List <DocGia> lst = new List <DocGia>();
string selectQuery = "select ";
if (Top.Length != 0)
{
selectQuery += "Top " + Top;
}
selectQuery += "* ";
selectQuery += "from tb_DocGia ";
if (Where.Length != 0)
{
selectQuery += "Where " + Where;
}
if (Order.Length != 0)
{
selectQuery += "Order by " + Order;
}
using (SqlCommand cmd = new SqlCommand(selectQuery, openConnection()))
{
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
DocGia obj = new DocGia();
obj.DocGiaIDataReader(dr);
lst.Add(obj);
}
dr.Close();
}
return(lst);
}
public DocGia getDocGia(DataRow row)
{
DocGia docgia = new DocGia();
docgia.ma = row["ma"].ToString().Trim();
docgia.ten = row["ten"].ToString().Trim();
docgia.diachi = row["diachi"].ToString().Trim();
docgia.gioitinh = bool.Parse(row["gioitinh"].ToString().Trim());
docgia.hoatdong = bool.Parse(row["hoatdong"].ToString().Trim());
DateTime datetime = new DateTime();
if (DateTime.TryParse(row["ngaysinh"].ToString().Trim(), out datetime))
{
docgia.ngaysinh = datetime;
}
if (DateTime.TryParse(row["ngaylamthe"].ToString().Trim(), out datetime))
{
docgia.ngaylamthe = datetime;
}
if (DateTime.TryParse(row["ngayhethan"].ToString().Trim(), out datetime))
{
docgia.ngayhethan = datetime;
}
return(docgia);
}
private void ssbtnSuaDG_Click(object sender, EventArgs e)
{
if (KiemTra())
{
DocGia dg = new DocGia();
dg.ma = docgia.ma;
dg.ten = txtTenDocGia.Text.ToString().Trim();
dg.ngaysinh = DateTime.Parse(dtpNgaySinh.Text.ToString().Trim());
dg.diachi = rtbDiaChi.Text.ToString().Trim();
dg.ngaylamthe = DateTime.Parse(dtpNgayLamThe.Text.ToString().Trim());
dg.ngayhethan = DateTime.Parse(dtpNgayHetHan.Text.ToString().Trim());
if (rdbNam.Checked)
{
dg.gioitinh = true;
}
else
{
dg.gioitinh = false;
}
if (rdbTrue.Checked)
{
dg.hoatdong = true;
}
else
{
dg.hoatdong = false;
}
if (control.editReader(dg))
{
this.Close();
this.Main.Visible = true;
}
}
}
private void xoaDocGia(object sender, EventArgs e)
{
if (listViewDocGia.SelectedItems.Count > 0)
{
ListViewItem lvi = listViewDocGia.SelectedItems[0];
DocGia docGia = lvi.Tag as DocGia;
if (docGiaBLL.HienThiListSachDangMuon(docGia.maDocGia).Count != 0)
{
MessageBox.Show("Độc giả này đang mượn sách nên không xóa được");
}
else
{
// Huynh xoa doc gia
if (docGiaBLL.XoaDocGia(docGia) == 0)
{
MessageBox.Show("Độc Giả không tồn tại");
}
else
{
MessageBox.Show("Xóa độc giả thành công");
}
}
}
else
{
MessageBox.Show("Bạn phải chọn 1 độc giả");
}
}
// GET: DocGia_59132942/Create
public ActionResult Create()
{
DocGia dg = new DocGia();
ViewBag.MaLoaiDG = new SelectList(db.LoaiDocGias, "MaLoaiDG", "TenLoaiDG");
return(View(dg));
}
public void Update(DocGia _dg)
{
string sql = string.Format("update DOCGIA set HoTen = N'{0}', GioiTinh = N'{1}', NamSinh = '{2}', DiaChi = N'{3}' where MaDocGia = '{4}'",
_dg.HoTen, _dg.GioiTinh, _dg.NamSinh, _dg.DiaChi, _dg.MaDocGia);
Excute(sql);
}
public ActionResult DeleteConfirmed(string id)
{
DocGia docGia = db.DocGias.Find(id);
db.DocGias.Remove(docGia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddDG(DocGia d)
{
using (DHP_07Entities db = new DHP_07Entities())
{
db.DocGias.Add(d);
db.SaveChanges();
}
}
private void txtMaDGTk_TextChanged(object sender, EventArgs e)
{
DocGiaDAO dg = new DocGiaDAO();
DocGia d = dg.GetNameDG(txtMaDGTk.Text);
txtTenDGtk.Text = d.HoTen;
txtMsvtk.Text = d.MaSV.ToString();
}
public static int Delete_DG(DocGia a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@madg", a.MaDG),
};
return(DataProvider.ExecuteNonQuery("Delete_DG", para));
}
public ActionResult Delete([Bind(Include = "IDDocGia, TenDocGia, DiaChi, NgaySinh, SoDienThoai, Email, CMND, NgayLap, TinhTrang, TongTienPhat")] DocGia dg)
{
DocGia s = db.DocGias.Find(dg.IDDocGia);
db.DocGias.Remove(s);
db.SaveChanges();
return(RedirectToAction("DSDocGia"));
}
public bool Delete(DocGia entity)
{
var model = _context.DocGias.Find(entity.Id);
_context.DocGias.Remove(model);
_context.SaveChanges();
return(true);
}
public void ThemPhieu(PhieuMuon pm, Sach sa, DocGia dg, Thuthu tt)
{
string maphieu = "PM" + DateTime.Now.ToString("yyMMdd");
StreamWriter fwrite = File.AppendText(txtfile);
fwrite.WriteLine();
fwrite.Write(maphieu + "#" + dg.MaDocGia + "#" + sa.MaSach + "#" + pm.SoLuongMuon + "#" + pm.NgayMuon + "#" + pm.ThoiGianMuon + "#" + tt.MaThuThu);
fwrite.Close();
}
/// <summary>
/// cập nhật thông tin đọc giả vào database
/// </summary>
public static bool SetDocGia(DocGia docGia)
{
bool result;
using (var db = new LiteDatabase(DatabasePath)) {
result = db.GetCollection <DocGia>("DocGia").Update(docGia);
}
return(result);
}
public bool ThemDocGia(DocGia docGia)
{
using (QLThuVienEntities ThuVienDS = new QLThuVienEntities())
{
ThuVienDS.DocGias.Add(docGia);
ThuVienDS.SaveChanges();
}
return(true);
}
//Kiểm tra maThe nhận được từ browser có bằng với MaThe trong db ko?
//Sau đó gán vào đối tượng docGia sử dụng model DocGia
//GET: PhieuMuon/DocGia/?maThe=dg1
public JsonResult DocGia(string maThe)
{
DocGia docGia = db.DocGia.Where(c => c.MaThe == maThe).FirstOrDefault(); //lấy 1 record và gán vào model độc giả
return(new JsonResult()
{
Data = docGia, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public bool Sua(DocGia dg)
{
if (string.IsNullOrEmpty(dg.MaDocGia))
{
return(false);
}
dgDao.Update(dg);
return(true);
}
private void gridSachMuon_SelectedItemChanged(object sender, DevExpress.Xpf.Grid.SelectedItemChangedEventArgs e)
{
try
{
SachMuonModel select = gridSachMuon.SelectedItem as SachMuonModel;
MuonSach sach = sachMuonControll.GetById(select.MaMuon);
_txtmamuon.Text = sach.MaMuon.ToString();
_txtsoluongmuon.Text = sach.SoLuongMuon.ToString();
_txttiencoc.Text = sach.TienCoc.ToString();
_datemuon.Text = sach.NgayMuon.ToString("MM/dd/yyyy");
_datetra.Text = sach.NgayHen.ToString("MM/dd/yyyy");
_checkdatra.IsChecked = sach.DaTra;
if (sach.MaDocGia != null)
{
try
{
DocGia selected = _cbbtendocgia.SelectedItem as DocGia;
List <DocGia> cboxList = _cbbtendocgia.ItemsSource as List <DocGia>;
selected = cboxList.SingleOrDefault(m => m.MaDocGia == sach.MaDocGia);
_cbbtendocgia.SelectedItem = selected;
}
catch (Exception)
{
_cbbtendocgia.SelectedItem = null;
}
}
else
{
_cbbtendocgia.SelectedItem = null;
}
if (sach.Sach != null)
{
try
{
Sach selected = _cbbtensach.SelectedItem as Sach;
List <Sach> cboxList = _cbbtensach.ItemsSource as List <Sach>;
selected = cboxList.SingleOrDefault(m => m.MaSach == sach.MaSach);
_cbbtensach.SelectedItem = selected;
}
catch (Exception)
{
_cbbtensach.SelectedItem = null;
}
}
else
{
_cbbtensach.SelectedItem = null;
}
List <string> ma = new List <string>();
ma = sachMuonControll.GetListMaDocGia(sach.MaSach);
gridDocgia.ItemsSource = docGiaControll.GetDocGiaByListMa(ma);
gridDocgia.RefreshData();
}
catch
{ }
}
public void ThemDG(DocGia dg)
{
string madg = "DG" + DateTime.Now.ToString("yyMMdd");
StreamWriter fwrite = File.AppendText(txtfile);
fwrite.WriteLine();
fwrite.Write(madg + "#" + dg.TenDocgia + "#" + dg.NgaySinhDocGia + "#" + dg.GioiTinhDocGia + "#" + dg.DiaChiDocGia + "#" + dg.SDTDocGia + "#" + dg.CMNDDocGia);
fwrite.Close();
}
public ActionResult Edit([Bind(Include = "SoThe,HoTen,NgaySinh,GioiTinh,ChoOHienTai,NgayCapThe,HanDungThe")] DocGia docGia)
{
if (ModelState.IsValid)
{
db.Entry(docGia).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(docGia));
}
public bool CapNhatDocGia(DocGia docGia)
{
using (QLThuVienEntities ThuVienDS = new QLThuVienEntities())
{
var dGia = ThuVienDS.DocGias.Find(docGia.MaDocGia);
dGia = docGia;
ThuVienDS.SaveChanges();
}
return(true);
}
public void Setup()
{
this.nv = new NhanVien("NV22", "Lương Văn Mai", "0904356578");
this.dg = new DocGia("DG19", "Nguy?n Van A", "371 Nguy?n Ki?m", "0125487282", "");
this.s = new Sach("SA12", "Hoa Hồng đen", "TG05", "TL02", 1965, "Mới");
this.tl = new TheLoai("TL10", "Thơ ngụ ngôn");
this.tg = new TacGia("TG09", "Nguyễn Ái Quốc", "");
this.pm = new PhieuMuon("PM05", "2018-01-12", "DG02", "NV02");
this.pt = new PhieuTra("PT02", "2018-06-30", "DG01", "NV01");
}
public void DelDG(DocGia d)
{
using (DHP_07Entities db = new DHP_07Entities())
{
var l1 = db.DocGias
.Single(p => p.MSSV == d.MSSV);
db.DocGias.Remove(l1);
db.SaveChanges();
}
}
public ActionResult ThemDocGia([Bind(Include = "IDDocGia, TenDocGia, DiaChi, NgaySinh, SoDienThoai, Email, CMND, NgayLap, TinhTrang, TongTienPhat")] DocGia dg)
{
dg.IDDocGia = "";
dg.TinhTrang = 1;
dg.TongTienPhat = 0;
dg.NgayLap = DateTime.Today;
db.DocGias.Add(dg);
db.SaveChanges();
return(RedirectToAction("DSDocGia"));
}
/// <summary>
/// lấy table độc giả
/// </summary>
/// <returns></returns>
public List<DocGia> getListDocGia()
{
String sql = @"SELECT [MaDG]
,[HoTenDG]
,[EmailDG]
,[GioiTinhDG]
,[NgaysinhDG]
,[DiachiDG]
,[DienthoaiDG]
,[NgayLamThe]
,[NgayHetHan]
,[HoatDong]
FROM [ThuVien].[dbo].[DocGia]";
DataTable table = dbcnn.getdata(sql);
List<DocGia> listDG = new List<DocGia>();
foreach (DataRow row in table.Rows)
{
DocGia newdg = new DocGia();
newdg.MaDG = (int) row["MaDG"];
newdg.HoTenDG = (String)row["HoTenDG"];
newdg.EmailDG = (String)row["EmailDG"];
newdg.GioiTinhDG = (bool)row["GioiTinhDG"];
newdg.NgaysinhDG = (DateTime)row["NgaysinhDG"];
newdg.DiachiDG = (String)row["DiachiDG"];
newdg.DienthoaiDG = (String)row["DienthoaiDG"];
newdg.NgayLamThe = (DateTime)row["NgayLamThe"];
newdg.NgayHetHan = (DateTime)row["NgayHetHan"];
newdg.HoatDong = (bool)row["HoatDong"];
listDG.Add(newdg);
}
return listDG;
}
/// <summary>
/// chèn độc giả vào csdl
/// </summary>
/// <param name="dg">Độc Giả</param>
/// <returns></returns>
public bool insertDocGia(DocGia dg)
{
String sql = @"INSERT INTO [dbo].[DocGia]
([HoTenDG]
,[EmailDG]
,[GioiTinhDG]
,[NgaysinhDG]
,[DiachiDG]
,[DienthoaiDG]
,[NgayLamThe]
,[NgayHetHan]
,[HoatDong])
VALUES
(N'" + dg.HoTenDG + @"'
,N'" + dg.EmailDG + @"'
," + Convert.ToInt16(dg.GioiTinhDG) + @"
,'" + dg.NgaysinhDG + @"'
,N'" + dg.DiachiDG + @"'
,N'" + dg.DienthoaiDG + @"'
,'" + dg.NgayHetHan + @"'
,'"+dg.NgayHetHan+@"'
,"+Convert.ToInt16(dg.HoatDong) +")";
return dbcnn.ThucThiSQL(sql);
}
/// <summary>
/// update độc giả trong csdl
/// </summary>
/// <param name="dg">Độc giả</param>
/// <returns></returns>
public bool updateDocGia(DocGia dg)
{
String sql = @"UPDATE [dbo].[DocGia]
SET [HoTenDG] = N'" + dg.HoTenDG + @"'
,[EmailDG] = N'" + dg.EmailDG + @"'
,[GioiTinhDG] = " + Convert.ToInt16(dg.GioiTinhDG) + @"
,[NgaysinhDG] = N'" + dg.NgaysinhDG + @"'
,[DiachiDG] = N'" + dg.DiachiDG + @"'
,[DienthoaiDG] = N'" + dg.DienthoaiDG + @"'
,[NgayLamThe] = N'" + dg.NgayLamThe + @"'
,[NgayHetHan] = N'" + dg.NgayHetHan + @"'
,[HoatDong] ="+Convert.ToInt16(dg.HoatDong)+@"
WHERE [MaDG]=" + dg.MaDG;
return dbcnn.ThucThiSQL(sql);
}
/// <summary>
/// xóa độc giả
/// </summary>
/// <param name="dg"></param>
/// <returns></returns>
public bool deleteDocGia(DocGia dg)
{
String sql = @"DELETE FROM [dbo].[DocGia]
WHERE [MaDG]=" + dg.MaDG;
return dbcnn.ThucThiSQL(sql);
}
