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