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