private void btnLuu_Click(object sender, EventArgs e) { using (DataClasses1DataContext data = new DataClasses1DataContext()) { if (TrangThai == "them") { QuocTich QuocTich = new QuocTich(); QuocTich.TenQuocGia = txtTenQuocGia.Text; data.QuocTiches.InsertOnSubmit(QuocTich); data.SubmitChanges(); loadDgvQuocTich(); ClearAll(); MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } if (TrangThai == "sua") { int MaQuocGia = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaQuocGia").ToString()); QuocTich QuocTich = data.QuocTiches.Where(t => t.MaQuocGia == MaQuocGia).FirstOrDefault(); QuocTich.TenQuocGia = txtTenQuocGia.Text; data.SubmitChanges(); loadDgvQuocTich(); ClearAll(); MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } TrangThaiBanDau(); }
public bool Insert(QuocTich quocTich) { try { string query = "SELECT * FROM QuocTich"; SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection); table = GetData(); DataRow row = table.NewRow(); row["tenQuocTich"] = quocTich.TenQuocTich; table.Rows.Add(row); SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter); dataAdapter.Update(table); return(true); } catch { return(false); } }
private void btnSave_Click(object sender, EventArgs e) { if (txtTenQuocTich.Text == "") { MessageBox.Show("Dữ liệu nhập chưa đủ."); errorProvider.SetError(txtTenQuocTich, "Chưa điền tên."); } else { QuocTich quoctich = new QuocTich(); if (chucnang == 1) { quoctich.TenQuocTich = txtTenQuocTich.Text; if (bUS_QuocTich.Insert(quoctich)) { //------------Ghi log NhatKyHoatDong nhatKy = new NhatKyHoatDong(); nhatKy.NguoiDungId = Const.CurrentUser.NguoiDungId; nhatKy.NoiDung = "Thêm thành công quốc tịch " + txtTenQuocTich.Text + " vào hệ thống"; nhatKy.ThaoTac = "Tạo"; nhatKy.ThoiGian = DateTime.Now; nhatKy.ChucNang = "Quốc tịch"; Const.NhatKyHoatDong.Insert(nhatKy); //------------------- MessageBox.Show("Thêm dữ liệu thành công.", "Thông báo."); } else { MessageBox.Show("Thêm dữ liệu lỗi.", "Thông báo."); } } if (chucnang == 2) { quoctich.QuocTichId = int.Parse(txtMaQuocTich.Text); quoctich.TenQuocTich = txtTenQuocTich.Text; if (bUS_QuocTich.Update(quoctich)) { //------------Ghi log NhatKyHoatDong nhatKy = new NhatKyHoatDong(); nhatKy.NguoiDungId = Const.CurrentUser.NguoiDungId; nhatKy.NoiDung = "Cập nhập thành công quốc tịch " + txtTenQuocTich.Text + " vào hệ thống"; nhatKy.ThaoTac = "Cập nhập"; nhatKy.ThoiGian = DateTime.Now; nhatKy.ChucNang = "Quốc tịch"; Const.NhatKyHoatDong.Insert(nhatKy); //------------------- MessageBox.Show("Cập nhật dữ liệu thành công.", "Thông báo."); } else { MessageBox.Show("cập nhật dữ liệu lỗi.", "Thông báo."); } } reset(); } }
protected void grvQuocTich_DeleteCommand(object sender, GridCommandEventArgs e) { var iDQuocTich = (e.Item as GridDataItem).GetDataKeyValue("IDQuocTich").ToString(); int id = Convert.ToInt32(iDQuocTich); QuocTich qt = _entities.QuocTiches.Where(q => q.IDQuocTich == id).First(); _entities.QuocTiches.DeleteObject(qt); _entities.SaveChanges(); }
protected void grvQuocTich_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; var iDQuocTich = Convert.ToInt32(item.GetDataKeyValue("IDQuocTich").ToString()); QuocTich qt = _entities.QuocTiches.Where(q => q.IDQuocTich == iDQuocTich).First(); qt.NgayCapNhat = DateTime.Now; qt.NguoiCapNhat = idNhanVien; item.UpdateValues(qt); _entities.SaveChanges(); }
public void UpdateQuocTich(QuocTich quocTichUpdate) { try { QuocTich quocTich = context.QuocTiches.Where(x => x.MaQuocTich == quocTichUpdate.MaQuocTich).Single <QuocTich>(); quocTich.TenQuocTich = quocTichUpdate.TenQuocTich; context.SaveChanges(); } catch (Exception e) { MessageBox.Show(e.Message); } }
public void DeleteQuocTich(int maQuocTich) { try { QuocTich quocTich = context.QuocTiches.Where(x => x.MaQuocTich == maQuocTich).Single <QuocTich>(); context.QuocTiches.Remove(quocTich); context.SaveChanges(); } catch (Exception e) { throw e; } }
protected void grvQuocTich_InsertCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; Hashtable values = new Hashtable(); item.ExtractValues(values); QuocTich qt = new QuocTich(); qt.NgayTao = qt.NgayCapNhat = DateTime.Now; qt.NguoiTao = qt.NguoiCapNhat = idNhanVien; item.UpdateValues(qt); _entities.AddToQuocTiches(qt); _entities.SaveChanges(); }
public int AddQuocTich(QuocTich quocTich) { try { context.QuocTiches.Add(quocTich); context.SaveChanges(); int maQuocTich = quocTich.MaQuocTich; return(maQuocTich); } catch (Exception e) { throw e; } }
public async Task <IActionResult> PostQuocTich([FromBody] QuocTich quoctich) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var user = User.Identity.Name; var userId = Utilities.GetUserId(this.User); quoctich.NgayNhap = DateTime.Now; quoctich.NguoiNhap = user; _context.QuocTichs.Add(quoctich); await _context.SaveChangesAsync(); return(CreatedAtAction("GetQuocTich", new { id = quoctich.QuocTichId }, quoctich)); }
private void btnXoa_Click(object sender, EventArgs e) { using (DataClasses1DataContext data = new DataClasses1DataContext()) { DialogResult r; r = MessageBox.Show("Bạn có muốn xóa quốc tịch này", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { try { string maQuocGia = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaQuocGia").ToString(); QuocTich qt = data.QuocTiches.Where(t => t.MaQuocGia == int.Parse(maQuocGia)).FirstOrDefault(); data.QuocTiches.DeleteOnSubmit(qt); data.SubmitChanges(); loadDgvQuocTich(); } catch { MessageBox.Show("Bạn không thể xóa trường dữ liệu này vì có dữ liệu liên quan", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } TrangThaiBanDau(); }
public bool Update(QuocTich quocTich) { try { string query = "SELECT * FROM QuocTich"; SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection); table = GetData(); table.PrimaryKey = new DataColumn[] { table.Columns[0] }; DataRow row = table.Rows.Find(quocTich.QuocTichId); if (row != null) { row["tenQuocTich"] = quocTich.TenQuocTich; } SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter); dataAdapter.Update(table); return(true); } catch { return(false); } }
public async Task <IActionResult> PutQuocTich([FromRoute] int id, [FromBody] QuocTich quoctich) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != quoctich.QuocTichId) { return(BadRequest()); } var user = User.Identity.Name; var userId = Utilities.GetUserId(this.User); quoctich.NgaySua = DateTime.Now; quoctich.NguoiSua = user; _context.Entry(quoctich).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!QuocTichExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void btnThucHien_Click(object sender, EventArgs e) { switch (temp) { case (int)LuaChon.QuocTich: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { QuocTich quocTich = new QuocTich(); quocTich.TenQuocTich = table.Rows[i][1].ToString(); bUS_QuocTich.Insert(quocTich); } } dgvImport.DataSource = bUS_QuocTich.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.TonGiao: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { TonGiao tonGiao = new TonGiao(); tonGiao.TenTonGiao = table.Rows[i][1].ToString(); bUS_TonGiao.Insert(tonGiao); } } dgvImport.DataSource = bUS_TonGiao.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.VatTu: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { VatTu vattu = new VatTu(); vattu.VatTuId = table.Rows[i][0].ToString(); vattu.TenVatTu = table.Rows[i][1].ToString(); vattu.MoTa = table.Rows[i][2].ToString(); vattu.SoLuong = int.Parse(table.Rows[i][3].ToString()); vattu.GhiChu = table.Rows[i][4].ToString(); bUS_VatTu.Insert(vattu); } } dgvImport.DataSource = bUS_TonGiao.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.TinhThanh: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { TinhThanh tinhthanh = new TinhThanh(); tinhthanh.TenTinhThanh = table.Rows[i][1].ToString(); bUS_TinhThanh.Insert(tinhthanh); } } dgvImport.DataSource = bUS_TinhThanh.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.Phong: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { Phong phong = new Phong(); phong.PhongId = table.Rows[i][0].ToString(); phong.DayNhaId = int.Parse(table.Rows[i][1].ToString()); phong.LoaiPhongId = int.Parse(table.Rows[i][2].ToString()); phong.TenPhong = table.Rows[i][3].ToString(); phong.Tang = int.Parse(table.Rows[i][4].ToString()); phong.GiaPhong = decimal.Parse(table.Rows[i][5].ToString()); bUS_Phong.Insert(phong); } } dgvImport.DataSource = bUS_Phong.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.Lop: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { Lop lop = new Lop(); lop.LopId = int.Parse(table.Rows[i][0].ToString()); lop.TenLop = table.Rows[i][1].ToString(); lop.DonViId = int.Parse(table.Rows[i][2].ToString()); bUS_Lop.Insert(lop); } } dgvImport.DataSource = bUS_Lop.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.DayNha: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { DayNha dayNha = new DayNha(); dayNha.TenDayNha = table.Rows[i][1].ToString(); dayNha.GhiChu = table.Rows[i][2].ToString(); bUS_DayNha.Insert(dayNha); } } dgvImport.DataSource = bUS_DayNha.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.DonVi: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { DonVi donVi = new DonVi(); donVi.TenDonVi = table.Rows[i][1].ToString(); donVi.DiaChi = table.Rows[i][2].ToString(); donVi.Sdt = table.Rows[i][3].ToString(); donVi.GhiChu = table.Rows[i][4].ToString(); bUS_DonVi.Insert(donVi); } } dgvImport.DataSource = bUS_DonVi.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.LoiViPham: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { LoiViPham loiViPham = new LoiViPham(); loiViPham.TenLoiViPham = table.Rows[i][1].ToString(); loiViPham.NoiDung = table.Rows[i][2].ToString(); loiViPham.HinhThucXuLy = table.Rows[i][3].ToString(); loiViPham.GhiChu = table.Rows[i][4].ToString(); bUS_LoiViPham.Insert(loiViPham); } } dgvImport.DataSource = bUS_LoiViPham.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.LoaiDoiTuong: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { LoaiDoiTuong loaiDoiTuong = new LoaiDoiTuong(); loaiDoiTuong.TenLoaiDoiTuong = table.Rows[i][1].ToString(); bUS_LoaiDoiTuong.Insert(loaiDoiTuong); } } dgvImport.DataSource = bUS_LoaiDoiTuong.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.LoaiPhong: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { LoaiPhong loaiPhong = new LoaiPhong(); loaiPhong.TenLoaiPhong = table.Rows[i][1].ToString(); loaiPhong.SoLuongtoiDa = int.Parse(table.Rows[i][2].ToString()); loaiPhong.GiaLoaiPhong = decimal.Parse(table.Rows[i][3].ToString()); bUS_LoaiPhong.Insert(loaiPhong); } } dgvImport.DataSource = bUS_LoaiPhong.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.NguoiDung: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { NguoiDung nguoiDung = new NguoiDung(); nguoiDung.TenDangNhap = table.Rows[i][1].ToString(); nguoiDung.MatKhau = table.Rows[i][2].ToString(); nguoiDung.TenDayDu = table.Rows[i][3].ToString(); nguoiDung.Sdt = table.Rows[i][4].ToString(); nguoiDung.DiaChi = table.Rows[i][5].ToString(); bUS_NguoiDung.Insert(nguoiDung); } } dgvImport.DataSource = bUS_NguoiDung.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case (int)LuaChon.DanToc: if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { DanToc danToc = new DanToc(); danToc.TenDanToc = table.Rows[i][1].ToString(); bUS_DanToc.Insert(danToc); } } dgvImport.DataSource = bUS_DanToc.GetData(); dgvImport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; default: break; } }