public string Update(ChucVu obj) { myData.ChucVus.Update(obj); myData.SaveChanges(); return(null); }
public List <ChucVu> ViewChucVu(string sql) { try { List <ChucVu> list = new List <ChucVu>(); SqlDataReader dr = p.View(sql); if (dr != null) { string MaCV; string TenChucVu; while (dr.Read()) { MaCV = dr.GetString(0); TenChucVu = dr.GetString(1); ChucVu cv = new ChucVu(MaCV, TenChucVu); list.Add(cv); } } return(list); } catch (SqlException p) { throw p; } }
public string Add(ChucVu obj) { myData.ChucVus.Add(obj); myData.SaveChanges(); return(null); }
private void txtMaNhanVien_TextChanged(object sender, EventArgs e) { if (dataListNhanVien.SelectedCells.Count > 0) { String id1 = dataListNhanVien.SelectedCells[0].OwningRow.Cells["MaChucVu"].Value.ToString(); ChucVu cv = NhanVienDAO.Instance.getChucVuByMa(id1); cboChucVu.SelectedItem = cv; int index2 = -1; int i = 0; foreach (ChucVu item in cboChucVu.Items) { if (item.MaChucVu == cv.MaChucVu) { index2 = i; break; } i++; } cboChucVu.SelectedIndex = index2; } }
private void txbHD_TextChanged(object sender, EventArgs e) { if (dtgvHopDong.SelectedCells.Count > 0) { int maChucVu = (int)dtgvHopDong.SelectedCells[0].OwningRow.Cells["MaChucVu"].Value; int maNV = (int)dtgvHopDong.SelectedCells[0].OwningRow.Cells["MaNV"].Value; ChucVu chucVu = ChucVuDAO.Instance.LayChucVuByMa(maChucVu); NhanVien nhanVien = NhanVienDAO.Instance.LayNhanVienByMa(maNV); cmbChucVu.SelectedItem = chucVu; int index = -1; int i = 0; foreach (ChucVu item in cmbChucVu.Items) { if (item.MaChucVu == chucVu.MaChucVu) { index = i; break; } i++; } int index1 = -1; int j = 0; foreach (NhanVien item in cbMaNV.Items) { if (item.MaNV == nhanVien.MaNV) { index1 = j; break; } j++; } cbMaNV.SelectedIndex = index1; cmbChucVu.SelectedIndex = index; } }
public static string strMaNVOld, strHoOld, strTenOld; // gia tri ho ten luc moi tim, dung de so sanh khi nhap phong TH ng dung sua thong tin sau khi tim duoc cnvc // se duoc gan khi double click nv o gridview ds public ThoiBoNhiem() { InitializeComponent(); oDonVi = new DonVi(); oChucVu = new ChucVu(); oThoiNhiem = new Business.HDQD.ThoiNhiem(); }
public ActionResult Delete(List <ChucVu> chucVus) { try { db.Configuration.ValidateOnSaveEnabled = false; var checkIsChecked = chucVus.Where(x => x.IsChecked == true).FirstOrDefault(); if (checkIsChecked == null) { this.AddNotification("Vui lòng chọn chức vụ để xóa!", NotificationType.ERROR); return(RedirectToAction("Index")); } foreach (var item in chucVus) { if (item.IsChecked == true) { int maChucVu = item.MaChucVu; ChucVu chucVu = db.ChucVus.Where(x => x.MaChucVu == maChucVu).SingleOrDefault(); if (chucVu != null) { chucVu.TrangThai = false; db.SaveChanges(); } } } return(RedirectToAction("Index")); } catch { this.AddNotification("Không thể xóa vì chức vụ này đã và đang được sử dụng!", NotificationType.ERROR); return(RedirectToAction("Index")); } }
public ActionResult ThemMoiNhanVien(ChucVu std) { ChucVuModel chucVuModel = new ChucVuModel(); ViewBag.ChucVu = chucVuModel.GetData(); return(View()); }
public void AddChucVu(ChucVu chucvu) { using (conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand command = conn.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "InsertUpdateChucVu"; command.Parameters.Add("@MaChucVu", SqlDbType.VarChar, 20).Value = chucvu.MaChucVu; command.Parameters.Add("@TenChucVu", SqlDbType.VarChar, 20).Value = chucvu.TenChucVu; command.Parameters.Add("@Action", SqlDbType.VarChar, 10).Value = "Insert"; try { command.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { command.Dispose(); conn.Dispose(); } } }
public IActionResult Update([FromBody] ChucVu item) { if (item == null || item.MA_CV != item.MA_CV) { return(BadRequest()); } var db = client.GetDatabase(DBName); var collection = db.GetCollection <ChucVu>("CHUC_VU"); var query = collection.AsQueryable <ChucVu>().ToList(); var result = query.FirstOrDefault(c => c.MA_CV == item.MA_CV); if (result == null) { return(NotFound()); } var filter = Builders <ChucVu> .Filter.Eq("MA_CV", item.MA_CV); var update = Builders <ChucVu> .Update.Set(s => s.TEN_CV, item.TEN_CV).Set(s => s.LUONG_CV, item.LUONG_CV); collection.UpdateOne(filter, update); return(CreatedAtRoute("GetChucVu", new { ma = item.MA_CV }, item)); }
public List <ChucVu> LayChucVu() { List <ChucVu> ListChucVu = new List <ChucVu>(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from dbo.ChucVu"; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ChucVu cv = new ChucVu(); cv.MaChucVu = reader.GetInt32(0); if (!reader.IsDBNull(1)) { cv.TenChucVu = reader.GetString(1); } else { cv.TenChucVu = "Chưa có thông tin"; } ListChucVu.Add(cv); } reader.Close(); return(ListChucVu); }
public static QuanLyNhanVienPhuCap ToDTO(NhanVien nhanVien, ChiTietNhanVien chiTietNhanVien, PhongBan phongBan, ChucVu chucVu, NhanVienPhuCap nhanVienPhuCap) { if (nhanVienPhuCap == null) { nhanVienPhuCap = new NhanVienPhuCap(); } if (chiTietNhanVien == null) { chiTietNhanVien = new ChiTietNhanVien(); } if (phongBan == null) { phongBan = new PhongBan(); } if (chucVu == null) { chucVu = new ChucVu(); } return(new QuanLyNhanVienPhuCap() { NhanVienId = nhanVien.NhanVienId, HoNhanVien = nhanVien.HoNhanVien, TenNhanVien = nhanVien.TenNhanVien, PhongBanId = phongBan.PhongBanId, TenPhongBan = phongBan.TenPhongBan, ChucVuId = chucVu.ChucVuId, TenChucVu = chucVu.TenChucVu, HinhAnh = chiTietNhanVien.HinhAnh, NhanVienPhuCapId = nhanVienPhuCap.NhanVienPhuCapId, }); }
private void btnSuaQuyen_Click(object sender, EventArgs e) { try { using (var k = new AppCode.QuanCafe()) { var cv = new ChucVu() { IDChucVu = txtIDCV.Text, TenChucVu = txtTenCV.Text, MoTa = txtMoTaCV.Text }; var kq = k.SuaCV(cv); if (kq == true) { LoadDSCV(); MessageBox.Show("Sửa thành công", "Thông báo ", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } else { MessageBox.Show("Sửa thất bại", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } } } catch { return; } }
public async Task <IActionResult> Edit(string id, [Bind("MaCV,Ten")] ChucVu chucVu) { if (id != chucVu.MaCV) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(chucVu); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ChucVuExists(chucVu.MaCV)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(chucVu)); }
public static List <QuanLyNhanVienPhuCap> ToListNVPCDTOs(List <NhanVien> nhanViens, List <ChiTietNhanVien> chiTietNhanViens, List <PhongBan> phongBans, List <ChucVu> chucVus, List <NhanVienPhuCap> nhanVienPhuCaps, string NhanVienIdToKen, List <Account> accounts, string PhuCapId) { NhanVien nv = nhanViens.Find(x => x.NhanVienId == NhanVienIdToKen); Account ac = accounts.Find(x => x.AccountId == NhanVienIdToKen); List <QuanLyNhanVienPhuCap> listNVDA = new List <QuanLyNhanVienPhuCap>(); foreach (NhanVienPhuCap nhanVienPhuCap in nhanVienPhuCaps) { if (nhanVienPhuCap.PhuCapId != PhuCapId) { continue; } PhongBan phongBan = null; ChucVu chucVu = null; ChiTietNhanVien chiTietNhanVien = null; NhanVien nhanVien = nhanViens.Find(x => x.NhanVienId == nhanVienPhuCap.NhanVienId); //Quyền của nhân viên được xem hay ko if (nhanVien.PhongBanId != nv.PhongBanId && ac.Quyen == 1) { continue; } if (nhanVien != null) { phongBan = phongBans.Find(x => x.PhongBanId == nhanVien.PhongBanId); chucVu = chucVus.Find(x => x.ChucVuId == nhanVien.ChucVuId); chiTietNhanVien = chiTietNhanViens.Find(x => x.ChiTietNhanVienId == nhanVien.NhanVienId); } listNVDA.Add(ToDTO(nhanVien, chiTietNhanVien, phongBan, chucVu, nhanVienPhuCap)); } return(listNVDA); }
public async Task <ActionResult <ChucVu> > PostChucVu(ChucVu chucVu) { _context.ChucVu.Add(chucVu); await _context.SaveChangesAsync(); return(CreatedAtAction("GetChucVu", new { id = chucVu.IdchucVu }, chucVu)); }
public async Task <IActionResult> PutChucVu(int id, ChucVu chucVu) { if (id != chucVu.IdchucVu) { return(BadRequest()); } _context.Entry(chucVu).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ChucVuExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// Thuc thi thu tuc sua thong tin chuc vu /// </summary> /// <param name="chucVu"></param> public void ExcuteProc(ChucVu chucVu) { //SqlConnection conn = DBUtils.GetDBConnection(); SqlConnection conn = new SqlConnection("Server=.;Database=QuanLyNhanSu;Integrated Security=true"); // conn.ConnectionString = "Server=.;Database=QuanLyNhanSu;Integrated Security=true"; //Trusted_Connection=true"; try { conn.Open(); SqlCommand cmd = new SqlCommand("EditChucVu", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maChucVuCu", SqlDbType.Char, 10)).Value = this.MaChucVuCu; cmd.Parameters.Add(new SqlParameter("@maChucVu", SqlDbType.Char, 10)).Value = chucVu.MaChucVu; cmd.Parameters.Add(new SqlParameter("@tenChucVu", SqlDbType.Text)).Value = chucVu.TenChucVu; //excute proc cmd.ExecuteNonQuery(); } catch (Exception e) { throw; } finally { conn.Close(); conn.Dispose(); } }
private void btnLuu_Click(object sender, EventArgs e) { using (DataClasses1DataContext data = new DataClasses1DataContext()) { if (TrangThai == "them") { ChucVu ChucVu = new ChucVu(); ChucVu.TenChucVu = txtTenChucVu.Text; data.ChucVus.InsertOnSubmit(ChucVu); data.SubmitChanges(); loadDgvChucVu(); ClearAll(); MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } if (TrangThai == "sua") { int MaChucVu = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoChucVu").ToString()); ChucVu ChucVu = data.ChucVus.Where(t => t.MaSoChucVu == MaChucVu).FirstOrDefault(); ChucVu.TenChucVu = txtTenChucVu.Text; data.SubmitChanges(); loadDgvChucVu(); ClearAll(); MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } TrangThaiBanDau(); }
public static List <QuanLyNhanVien> ToListNVPBDTOs(List <NhanVien> nhanViens, List <ChiTietNhanVien> chiTietNhanViens, List <PhongBan> phongBans, List <ChucVu> chucVus, List <NhanVienCongViec> nhanVienCongViecs, List <CongViec> congViecs, List <HopDong> hopDongs, List <Account> accounts, string id) { List <QuanLyNhanVien> listNVPB = new List <QuanLyNhanVien>(); foreach (NhanVien nhanVien in nhanViens) { //Tìm từng đứa một để chuyển qua DTO đưa lên cho người dùng xem if (nhanVien.TrangThai == 0 || nhanVien.PhongBanId != id) { continue; } ChiTietNhanVien chiTietNhanVien = chiTietNhanViens.Find(x => x.ChiTietNhanVienId == nhanVien.NhanVienId); PhongBan phongBan = phongBans.Find(x => x.PhongBanId == nhanVien.PhongBanId); ChucVu chucVu = chucVus.Find(x => x.ChucVuId == nhanVien.ChucVuId); //Tìm công việc hiện tại ứng với nhân viên NhanVienCongViec nhanVienCongViec = nhanVienCongViecs.Find(x => x.NhanVienId == nhanVien.NhanVienId && x.NgayKetThuc == null); CongViec congViec = null; if (nhanVienCongViec != null) { congViec = congViecs.Find(x => x.CongViecId == nhanVienCongViec.CongViecId); } //Tìm hợp đồng hiện tại ứng với nhân viên HopDong hopDong = hopDongs.Find(x => x.NhanVienId == nhanVien.NhanVienId && x.TrangThai == 1); Account account = accounts.Find(x => x.AccountId == nhanVien.NhanVienId); //Chuyển thành DTO listNVPB.Add(ToDTO(nhanVien, chiTietNhanVien, phongBan, chucVu, congViec, hopDong, account)); } return(listNVPB); }
public void AddProc(ChucVu chucvu) { SqlConnection conn = new SqlConnection("Server=.;Database=QuanLyNhanSu;Integrated Security=true"); try { conn.Open(); //Console.WriteLine("haha"); string query = "insert into CHUCVU(MaCV, TenCV) values (@MaCV, @TenCV)"; SqlCommand cmd = new SqlCommand(query, conn); //cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaCV", SqlDbType.Char, 10)).Value = chucvu.MaChucVu; cmd.Parameters.Add(new SqlParameter("@TenCV", SqlDbType.Text)).Value = chucvu.TenChucVu; cmd.ExecuteNonQuery(); } catch (Exception e) { throw; } finally { conn.Close(); conn.Dispose(); } }
/// <summary> /// lấy danh sách chức vụ /// </summary> /// <returns> dataset</returns> //public DataSet GetListChucVu() //{ // using (conn) // { // if (conn.State != ConnectionState.Open) // conn.Open(); // SqlCommand command = conn.CreateCommand(); // command.CommandType = CommandType.StoredProcedure; // command.CommandText = "getAllChucVu"; // SqlDataAdapter adapter = new SqlDataAdapter(command); // DataSet dataset = new DataSet(); // adapter.Fill(dataset); // return dataset; // } //} public List <ChucVu> GetListChucVu() { List <ChucVu> list = new List <ChucVu>(); using (conn = new SqlConnection(connString)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand command = conn.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "getAllChucVu"; SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable dt = new DataTable(); adapter.Fill(dt); ChucVu hs; foreach (DataRow dr in dt.Rows) { hs = new ChucVu(); hs.MaChucVu = Convert.ToString(dr["MaChucVu"]); hs.TenChucVu = Convert.ToString(dr["TenChucVu"]); list.Add(hs); } } return(list); }
// GET: ChucVuController/Delete/5 public ActionResult Delete(int id) { var model = new ChucVu(); model = database.ChucVus.Where(x => x.Idcv == id).FirstOrDefault(); return(View(model)); }
public ActionResult Delete(int id, ChucVu chucVu) { chucVu = database.ChucVus.Where(x => x.Idcv == id).FirstOrDefault(); database.Remove(chucVu); database.SaveChanges(); return(RedirectToAction("Index")); }
private void Add_DoanVien_Click(object sender, RoutedEventArgs e) { Add = true; Add_DoanVien.IsEnabled = false; Mod_DoanVien.IsEnabled = false; SQLiteConnection sqlite_conn = new SQLiteConnection("Data source = QuanLyDoanVien.db"); SQLiteCommand sqlite_com = new SQLiteCommand(); sqlite_conn.Open(); sqlite_com = sqlite_conn.CreateCommand(); sqlite_com.CommandText = "SELECT Max(ID) FROM DoanVien"; MaDoanVien.Text = (Convert.ToInt32(sqlite_com.ExecuteScalar()) + 1).ToString(); HoVaTen.IsEnabled = NgaySinh.IsEnabled = QueQuan.IsEnabled = GioiTinh.IsEnabled = ChiDoan.IsEnabled = ChucVu.IsEnabled = ToDanPho.IsEnabled = PhuongXa.IsEnabled = QuanHuyen.IsEnabled = TinhThanh.IsEnabled = NgayVaoDang.IsEnabled = NgayVaoDoan.IsEnabled = TinhTrang.IsEnabled = CMND.IsEnabled = Email.IsEnabled = DienThoai.IsEnabled = DanToc.IsEnabled = TonGiao.IsEnabled = HoanCanh.IsEnabled = TrinhDo.IsEnabled = true; HoVaTen.Clear(); NgaySinh.Clear(); QueQuan.Clear(); GioiTinh.Clear(); ChiDoan.Clear(); ChucVu.Clear(); ToDanPho.Clear(); PhuongXa.Clear(); QuanHuyen.Clear(); TinhThanh.Clear(); NgayVaoDang.Clear(); NgayVaoDoan.Clear(); TinhTrang.Clear(); CMND.Clear(); Email.Clear(); DienThoai.Clear(); DanToc.Clear(); TonGiao.Clear(); HoanCanh.Clear(); TrinhDo.Clear(); }
public ActionResult SuaChucVu(ChucVu cv) { ChucVu chucVu = data.ChucVus.ToList().Find(n => n.MaCV == cv.MaCV); if (ModelState.IsValid) { if (chucVu.PhuCap == null) { chucVu.TenChucVu = cv.TenChucVu; chucVu.ThoiGianThuViec = cv.ThoiGianThuViec; chucVu.MucLuongThuViec = cv.MucLuongThuViec; chucVu.MucLuongCT = cv.MucLuongCT; cv.PhuCap = 0; data.SubmitChanges(); return(RedirectToAction("ChucVu")); } else { chucVu.TenChucVu = cv.TenChucVu; chucVu.ThoiGianThuViec = cv.ThoiGianThuViec; chucVu.MucLuongThuViec = cv.MucLuongThuViec; chucVu.MucLuongCT = cv.MucLuongCT; chucVu.PhuCap = cv.PhuCap; data.SubmitChanges(); return(RedirectToAction("ChucVu")); } } else { ModelState.AddModelError(" ", "Sửa thất bại"); } return(View()); }
public ActionResult ThemMoi(ChucVu ds) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return(RedirectToAction("Index", "Login")); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "tcv") { if (ModelState.IsValid) { ds.XoaTam = false; db.ChucVus.InsertOnSubmit(ds); db.SubmitChanges(); } } } return(RedirectToAction("Index", "QuanlyChucvu")); } }
public string DeleteChucvu(ChucVu position) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "xcv") { ChucVu p = db.ChucVus.SingleOrDefault(n => n.IdChucVu == position.IdChucVu); p.XoaTam = true; try { UpdateModel(p); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền xóa"); }
public List <ChucVu> GetData() { try { List <ChucVu> dsChucVu = new List <ChucVu>(); DataTable dt = dataProvider.ExecuteQuery("Proc_ChucVu_GetData", null, null); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ChucVu chucVu = new ChucVu(); chucVu.MaChucVu = String.IsNullOrEmpty(row["MaChucVu"].ToString()) ? 0 : int.Parse(row["MaChucVu"].ToString()); chucVu.TenChucVu = String.IsNullOrEmpty(row["TenChucVu"].ToString()) ? "" : row["TenChucVu"].ToString(); dsChucVu.Add(chucVu); } return(dsChucVu); } else { return(new List <ChucVu>()); } } catch (Exception ex) { return(new List <ChucVu>()); } }
public IHttpActionResult PutChucVu(byte id, ChucVu chucVu) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != chucVu.ID) { return(BadRequest()); } db.Entry(chucVu).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ChucVuExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public bool themChucVu(ChucVu chucvu) { try { ChucVu cv = new ChucVu {MaChucVu = chucvu.MaChucVu, TenChucVu = chucvu.TenChucVu, HeSoCV = chucvu.HeSoCV}; db.ChucVus.Add(cv); db.SaveChanges(); } catch { return false; } return true; }
public bool Suachucvu(ChucVu chucvu) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { ChucVu cv = csdl.ChucVus.SingleOrDefault(n => n.MaChucVu == chucvu.MaChucVu); cv.TenChucVu = chucvu.TenChucVu; cv.HeSoCV = chucvu.HeSoCV; csdl.SaveChanges(); } catch { return false; } return true; }
public bool BizTimKiem(ChucVu chucvu) { return _dalchucvu.Suachucvu(chucvu); }
public bool ThemCV(ChucVu chucvu) { return _dalchucvu.themChucVu(chucvu); }