Example #1
0
        public string Update(ChucVu obj)
        {
            myData.ChucVus.Update(obj);
            myData.SaveChanges();

            return(null);
        }
Example #2
0
 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;
     }
 }
Example #3
0
        public string Add(ChucVu obj)
        {
            myData.ChucVus.Add(obj);
            myData.SaveChanges();

            return(null);
        }
Example #4
0
        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;
            }
        }
Example #5
0
 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;
     }
 }
Example #6
0
 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();
 }
Example #7
0
        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"));
            }
        }
Example #8
0
        public ActionResult ThemMoiNhanVien(ChucVu std)
        {
            ChucVuModel chucVuModel = new ChucVuModel();

            ViewBag.ChucVu = chucVuModel.GetData();
            return(View());
        }
Example #9
0
 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();
         }
     }
 }
Example #10
0
        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));
        }
Example #11
0
        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);
        }
Example #12
0
        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));
        }
Example #15
0
        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();
            }
        }
Example #19
0
 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);
        }
Example #21
0
        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();
            }
        }
Example #22
0
        /// <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();
        }
Example #26
0
        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");
        }
Example #29
0
 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>());
     }
 }
Example #30
0
        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);
 }