Пример #1
0
        public ActionResult XemThongtin(string id, int idtkb)
        {
            if (Session["Login"] == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            else
            {
                GIANGVIEN b = (GIANGVIEN)Session["Login"];
                ViewBag.name = b.TEN;

                if (b.ROLE == 1 || b.ROLE == 2)
                {
                    var a  = data.DIEMDANHs.Where(x => x.MASINHVIEN.Equals(id) && x.IDTKB == idtkb);
                    var b1 = data.DIEMDANHs.Where(x => x.MASINHVIEN.Equals(id) && x.IDTKB == idtkb).FirstOrDefault();
                    ViewBag.tensv = b1.SINHVIEN.TEN;
                    ViewBag.tenmh = b1.TKB.MONHOC.TENMONHOC;
                    return(View(a));
                }
                else
                {
                    return(RedirectToAction("Message", new { tenaction = "Không thể truy cập" }));
                }
            }
        }
Пример #2
0
 public int insert(string magv, string tengv, int gioitinh, DateTime ngaysinh, string diachi, string sdt, string email, string trinhdo, string bangcap, DateTime ngayvaolam, double heso)
 {
     try
     {
         using (QLTTEntities qltt = new QLTTEntities())
         {
             GIANGVIEN x = new GIANGVIEN()
             {
                 MAGV     = magv,
                 TENGV    = tengv,
                 GIOITINH = gioitinh,
                 NGSINH   = ngaysinh,
                 DIACHI   = diachi,
                 SDT      = sdt,
                 EMAIL    = email,
                 TRINHDO  = trinhdo,
                 BANGCAP  = bangcap,
                 NGAYVL   = ngayvaolam,
                 HESO     = heso
             };
             qltt.GIANGVIENs.Add(x);
             qltt.SaveChanges();
         }
         return(1);
     }
     catch
     {
         return(0);
     }
 }
Пример #3
0
        public DataTable get(string code)
        {
            using (QLTTEntities qltt = new QLTTEntities())
            {
                GIANGVIEN gv = qltt.GIANGVIENs.Where(p => p.MAGV == code).FirstOrDefault();
                if (gv != null)
                {
                    DataTable rtnTable = new DataTable();
                    rtnTable.Columns.Add("MAGV", typeof(string));
                    rtnTable.Columns.Add("TENGV", typeof(string));
                    rtnTable.Columns.Add("GIOITINH", typeof(int));
                    rtnTable.Columns.Add("NGSINH", typeof(DateTime));
                    rtnTable.Columns.Add("DIACHI", typeof(string));
                    rtnTable.Columns.Add("SDT", typeof(string));
                    rtnTable.Columns.Add("EMAIL", typeof(string));
                    rtnTable.Columns.Add("TRINHDO", typeof(string));
                    rtnTable.Columns.Add("BANGCAP", typeof(string));
                    rtnTable.Columns.Add("NGAYVL", typeof(DateTime));
                    rtnTable.Columns.Add("HESO", typeof(double));

                    rtnTable.Rows.Add(gv.MAGV, gv.TENGV, gv.GIOITINH, gv.NGSINH, gv.DIACHI, gv.SDT, gv.EMAIL, gv.TRINHDO, gv.BANGCAP, gv.NGAYVL, gv.HESO);
                    return(rtnTable);
                }
            }
            return(null);
        }
Пример #4
0
 public int update(string magv, string tengv, int gioitinh, DateTime ngaysinh, string diachi, string sdt, string email, string trinhdo, string bangcap, DateTime ngayvaolam, double heso)
 {
     try
     {
         using (QLTTEntities qltt = new QLTTEntities())
         {
             GIANGVIEN gv = qltt.GIANGVIENs.Where(p => p.MAGV == magv).FirstOrDefault();
             if (gv != null)
             {
                 gv.TENGV    = tengv;
                 gv.GIOITINH = gioitinh;
                 gv.NGSINH   = ngaysinh;
                 gv.DIACHI   = diachi;
                 gv.SDT      = sdt;
                 gv.EMAIL    = email;
                 gv.TRINHDO  = trinhdo;
                 gv.BANGCAP  = bangcap;
                 gv.NGAYVL   = ngayvaolam;
                 gv.HESO     = heso;
                 qltt.SaveChanges();
                 return(1);
             }
             return(0);
         }
     }
     catch
     {
         return(0);
     }
 }
Пример #5
0
        public ActionResult TeacherCheckIn(int id, string idmonhoc, string tenmonhoc)
        {
            if (Session["Login"] == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            else
            {
                GIANGVIEN b = (GIANGVIEN)Session["Login"];

                if (b.ROLE == 2)
                {
                    var a = data.NHOMs;
                    ViewBag.a         = id;
                    ViewBag.b         = b.ID;
                    ViewBag.idmonhoc  = idmonhoc;
                    ViewBag.tenmonhoc = tenmonhoc;
                    return(View(a));
                }
                else
                {
                    return(RedirectToAction("Message", new { tenaction = "Không thể truy cập form điểm danh" }));
                }
            }
        }
Пример #6
0
        public static bool InsertAndTaiKhoan(GIANGVIEN _giangvien, TAIKHOAN taiKhoan)
        {
            try
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    taiKhoan.LOAITAIKHOAN = LoaiTaiKhoanLogic.Select(taiKhoan.LoaiTaiKhoanId ?? 0);
                    taiKhoan.TenDangNhap  = taiKhoan.TenDangNhap.ToLower();
                    taiKhoan.IsRemove     = 0;
                    taiKhoan.MatKhau      = O2S_Common.EncryptAndDecrypt.MD5EncryptAndDecrypt.Encrypt(taiKhoan.MatKhau, true);
                    Database.TAIKHOANs.InsertOnSubmit(taiKhoan);
                    Database.SubmitChanges();

                    _giangvien.CreatedDate = DateTime.Now;
                    _giangvien.CreatedBy   = GlobalSettings.UserCode;
                    _giangvien.CreatedLog  = GlobalSettings.SessionMyIP;
                    _giangvien.IsRemove    = 0;
                    _giangvien.TaiKhoanId  = taiKhoan.TaiKhoanId;
                    Database.GIANGVIENs.InsertOnSubmit(_giangvien);
                    Database.SubmitChanges();
                    _giangvien.MaGiangVien = string.Format("{0}{1:D5}", "GV", _giangvien.GiangVienId);
                    Database.SubmitChanges();
                    ts.Complete();
                    return(true);
                }
            }
            catch (Exception ex)
            {
                return(false);

                O2S_Common.Logging.LogSystem.Error(ex);
            }
        }
Пример #7
0
        public IHttpActionResult PostGIANGVIEN(GIANGVIEN gIANGVIEN)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.GIANGVIENs.Add(gIANGVIEN);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (GIANGVIENExists(gIANGVIEN.MaGV))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = gIANGVIEN.MaGV }, gIANGVIEN));
        }
Пример #8
0
        public static bool Update(GIANGVIEN _hocVien, TAIKHOAN taiKhoan = null)
        {
            try
            {
                var hocVienCu = SelectSigleTheoKhoaKhoa(_hocVien.GiangVienId);

                hocVienCu.TenGiangVien      = _hocVien.TenGiangVien;
                hocVienCu.GioiTinh          = _hocVien.GioiTinh;
                hocVienCu.Sdt               = _hocVien.Sdt;
                hocVienCu.Email             = _hocVien.Email;
                hocVienCu.NgaySinh          = _hocVien.NgaySinh;
                hocVienCu.DiaChi            = _hocVien.DiaChi;
                hocVienCu.NgayBatDauLamViec = _hocVien.NgayBatDauLamViec;
                hocVienCu.GhiChu            = _hocVien.GhiChu;
                hocVienCu.ModifiedDate      = DateTime.Now;
                hocVienCu.ModifiedBy        = GlobalSettings.UserCode;
                hocVienCu.ModifiedLog       = GlobalSettings.SessionMyIP;
                Database.SubmitChanges();
                if (taiKhoan != null)
                {
                    TaiKhoanLogic.Update(taiKhoan);
                }
                return(true);
            }
            catch (Exception ex)
            {
                return(false);

                O2S_Common.Logging.LogSystem.Error(ex);
            }
        }
Пример #9
0
        public static GIANGVIEN GetGiangVienByMa(string maGV)
        {
            if (Program.KetNoi() == 0)
            {
                return(null);
            }
            SqlDataReader myReader;

            myReader = Program.ExecSqlDataReader(string.Format(KeyConst.Lenh.GetGiangVienByMa, maGV.Trim()));
            if (myReader == null)
            {
                return(null);
            }
            myReader.Read();
            GIANGVIEN gv = new GIANGVIEN
            {
                MAGV  = myReader.GetString(0),
                HO    = myReader.GetString(1),
                TEN   = myReader.GetString(2),
                HOCVI = myReader.GetString(3),
                MAKH  = myReader.GetString(4),
                EMAIL = myReader.GetString(5)
            };

            myReader.Close();
            return(gv);
        }
Пример #10
0
 public void Put(int id, [FromBody] GIANGVIEN GIANGVIEN)
 {
     using (QLGVEntities db = new QLGVEntities())
     {
         var s = db.GIANGVIENs.SingleOrDefault(x => x.MaGV == id);
         if (s != null)
         {
             s.MaGV           = GIANGVIEN.MaGV;
             s.MaBM           = GIANGVIEN.MaBM;
             s.TenGV          = GIANGVIEN.TenGV;
             s.ChucVu         = GIANGVIEN.ChucVu;
             s.NgaySinh       = GIANGVIEN.NgaySinh;
             s.Email          = GIANGVIEN.Email;
             s.GioiTinh       = GIANGVIEN.GioiTinh;
             s.SDT            = GIANGVIEN.SDT;
             s.DiaChi         = GIANGVIEN.DiaChi;
             s.MonHocPhuTrach = GIANGVIEN.MonHocPhuTrach;
             s.TrinhDoHocVan  = GIANGVIEN.TrinhDoHocVan;
             db.SaveChanges();
         }
         else
         {
         }
     }
 }
Пример #11
0
 private void LoadPanelControl(GIANGVIEN _giangvien = null)
 {
     try
     {
         if (_giangvien == null)
         {
             ResetPanelControl();
         }
         else
         {
             txtMaHV.Text                = _giangvien.MaGiangVien;
             txtHoTen.Text               = _giangvien.TenGiangVien;
             dateNgaySinh.Value          = _giangvien.NgaySinh != null ? (DateTime)_giangvien.NgaySinh : dateNgaySinh.MaxDate;
             cboGioiTinh.Text            = _giangvien.GioiTinh;
             txtDiaChi.Text              = _giangvien.DiaChi;
             txtSDT.Text                 = _giangvien.Sdt;
             txtEmail.Text               = _giangvien.Email;
             dateNgayBatDauLamViec.Value = _giangvien.NgayBatDauLamViec != null ? (DateTime)_giangvien.NgayBatDauLamViec : DateTime.Now;
             txtGhiChu.Text              = _giangvien.GhiChu;
             txtTenDangNhap.Text         = _giangvien.TAIKHOAN.IsRemove != 1 ? _giangvien.TAIKHOAN.TenDangNhap : string.Empty;
             txtMatKhau.Text             = _giangvien.TAIKHOAN.IsRemove != 1 ? O2S_Common.EncryptAndDecrypt.MD5EncryptAndDecrypt.Decrypt(_giangvien.TAIKHOAN.MatKhau, true) : string.Empty;
         }
     }
     catch (Exception ex)
     {
         ResetPanelControl();
         LockAndUnlockPanelControl(false);
         O2S_Common.Logging.LogSystem.Error(ex);
     }
 }
Пример #12
0
        private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            GIANGVIEN gv = new GIANGVIEN();

            gv.MAGV      = txtMaGv.Text.Trim();
            gv.HOTEN     = txtHoten.Text.Trim();
            gv.MADONVI   = cbo_madv.SelectedValue.ToString();
            gv.TRINHDO   = txtTrinhdo.Text.Trim();
            gv.CHUYENMON = txtchuyemon.Text.Trim();
            int them = lqGiaovien.themGiangvien(gv);

            if (them == 1)
            {
                MessageBox.Show("Thêm thành công");
                loadGiaoVien();
            }
            else if (them == 0)
            {
                MessageBox.Show("Thêm thất bại");
                return;
            }
            else
            {
                MessageBox.Show("Giáo viên đã tồn tại.Vui lòng kt lại");
            }
        }
Пример #13
0
        public IHttpActionResult PutGIANGVIEN(int id, GIANGVIEN gIANGVIEN)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != gIANGVIEN.MaGV)
            {
                return(BadRequest());
            }

            db.Entry(gIANGVIEN).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!GIANGVIENExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #14
0
 private void btThem_Click(object sender, EventArgs e)
 {
     if (ktKhoa(textBoxX1.Text) > 0)
     {
         MessageBox.Show("Trùng mã");
         return;
     }
     else
     {
         GIANGVIEN gv = new GIANGVIEN();
         gv.magv      = textBoxX1.Text;
         gv.tengv     = textBoxX2.Text;
         gv.dienthoai = textBoxX3.Text;
         gv.diachi    = textBoxX6.Text;
         if (radioButton1.Checked == true)
         {
             gv.gioitinh = radioButton1.Text;
         }
         else
         {
             gv.gioitinh = radioButton2.Text;
         }
         gv.trinhdo    = textBoxX5.Text;
         gv.ngayvaolam = dateTimeInput1.Value;
         qlthi.GIANGVIENs.InsertOnSubmit(gv);
         ClearGroup(panelEx1.Controls);
         MessageBox.Show("Thêm thành công");
     }
 }
        public ActionResult DangNhapGV(FormCollection collection)
        {
            var acc = collection["account"];
            var mk  = collection["pass"];

            if (String.IsNullOrEmpty(acc))
            {
                ViewData["loi1"] = "Không được bỏ trống tài khoản";
            }
            else if (String.IsNullOrEmpty(mk))
            {
                ViewData["loi1"] = "Không được bỏ trống mật khẩu !!";
            }
            else
            {
                GIANGVIEN gv = db.GIANGVIENs.SingleOrDefault(n => n.TaiKhoan == acc && n.MatKhau == mk);
                if (gv != null)
                {
                    Session[SesAdmin] = gv;
                    return(RedirectToAction("Index", "GiangVien"));
                }
                else
                {
                    ViewBag.ThongBao = "Tài khoản hoặc mật khẩu không đúng";
                }
            }
            return(View());
        }
Пример #16
0
        public async Task <IActionResult> PutGIANGVIEN([FromRoute] string id, [FromBody] GIANGVIEN gIANGVIEN)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != gIANGVIEN.MAGV)
            {
                return(BadRequest());
            }

            _context.Entry(gIANGVIEN).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!GIANGVIENExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Пример #17
0
        public DataTable getGianngVien_All()
        {
            GIANGVIEN gVien = new GIANGVIEN();

            DAL_GIANGVIEN dao = new DAL_GIANGVIEN();

            return(dao.getTeacher_All());
        }
Пример #18
0
 public bool Insert(GIANGVIEN GiangVien)
 {
     if (baseFunctions.Add(GiangVien) > 0)
     {
         return(true);
     }
     return(false);
 }
Пример #19
0
 public bool Update(GIANGVIEN GiangVien)
 {
     if (baseFunctions.Update(GiangVien) > 0)
     {
         return(true);
     }
     return(false);
 }
Пример #20
0
        public DataTable getGianngVien_LastCode()
        {
            GIANGVIEN gVien = new GIANGVIEN();

            DAL_GIANGVIEN dao = new DAL_GIANGVIEN();

            return(dao.getGingVien_LastCode());
        }
Пример #21
0
        public DataTable getGianngVien_ByID(int gVId)
        {
            GIANGVIEN gVien = new GIANGVIEN();

            gVien.GIV_ID = gVId;
            DAL_GIANGVIEN dao = new DAL_GIANGVIEN();

            return(dao.getDsTeacher_ByID(gVien));
        }
Пример #22
0
        public DataTable getGianngVien_ByName(string gVName)
        {
            GIANGVIEN gVien = new GIANGVIEN();

            gVien.GIV_Name = gVName;
            DAL_GIANGVIEN dao = new DAL_GIANGVIEN();

            return(dao.getDsTeacher_ByID(gVien));
        }
        private void frmThayDoiThongTinGV_Load(object sender, EventArgs e)
        {
            GIANGVIEN gv = GiangVien.Select(GlobalSettings.UserID);

            txtMaGV.Text     = gv.MaGV;
            txtTenGV.Text    = gv.TenGV;
            cboGioiTinh.Text = gv.GioiTinhGV;
            txtEmail.Text    = gv.EmailGV;
            txtSDT.Text      = gv.SdtGV;
        }
 public ActionResult AddGV(GIANGVIEN gv)
 {
     if (ModelState.IsValid)
     {
         db.GIANGVIENs.InsertOnSubmit(gv);
         db.SubmitChanges();
         return(RedirectToAction("GV"));
     }
     return(View(gv));
 }
Пример #25
0
        public void delete(int gVID)
        {
            GIANGVIEN gVien = new GIANGVIEN();

            gVien.GIV_ID = gVID;

            DAL_GIANGVIEN dao = new DAL_GIANGVIEN();

            dao.delete(gVien);
        }
Пример #26
0
        public IHttpActionResult GetGIANGVIEN(int id)
        {
            GIANGVIEN gIANGVIEN = db.GIANGVIENs.Find(id);

            if (gIANGVIEN == null)
            {
                return(NotFound());
            }

            return(Ok(gIANGVIEN));
        }
        public ActionResult KhoaHocTheoGiangVien(int giangvien)
        {
            GIANGVIEN giangVien = db.GIANGVIENs.SingleOrDefault(n => n.MaGV == giangvien);

            if (giangVien != null)
            {
                return(View(giangVien));
            }

            return(View());
        }
        public ActionResult Xoagv(int id)
        {
            GIANGVIEN gv = db.GIANGVIENs.SingleOrDefault(n => n.MaGV == id);

            ViewBag.MaGV = gv.MaGV;
            if (gv == null)
            {
                Response.StatusCode = 404;
                return(null);
            }
            return(View(gv));
        }
Пример #29
0
        public async Task <IActionResult> PostGIANGVIEN([FromBody] GIANGVIEN gIANGVIEN)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            _context.GIANGVIEN.Add(gIANGVIEN);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetGIANGVIEN", new { id = gIANGVIEN.MAGV }, gIANGVIEN));
        }
Пример #30
0
        public void layGiangVienByTenDangNhap()
        {
            GIANGVIEN gv = linqGv.getGiangVienByTenDangNhap(NguoiDung.TenDangNhap);

            if (gv != null)
            {
                GiangVien = linqGv.getGiangVienByTenDangNhap(NguoiDung.TenDangNhap);
            }
            else
            {
                return;
            }
        }