コード例 #1
0
ファイル: frmDang_Nhap.cs プロジェクト: 1760005/Quan_Ly_Thi
 //Đăng Nhập
 private void btnLogin_Click(object sender, EventArgs e)
 {
     if (BUS_Tai_Khoan.Kiem_tra_Tai_Khoan(txtUserName.Text, txtPassWord.Text))
     {
         this.Hide();
         if (BUS_Tai_Khoan.Quyen(txtUserName.Text).Contains("HS"))
         {
             Hoc_Sinhh hoc_Sinh = BUS_Tai_Khoan.layThongTinTaiKhoan(txtUserName.Text) as Hoc_Sinhh;
             frmHoc_Sinh.hs = hoc_Sinh;
             frmHoc_Sinh hs = new frmHoc_Sinh();
             hs.ShowDialog();
         }
         else if (BUS_Tai_Khoan.Quyen(txtUserName.Text).Contains("AD"))
         {
             Tai_khoan tk = BUS_Tai_Khoan.layThongTinTaiKhoan(txtUserName.Text) as Tai_khoan;
             frmAdmin.tk = tk;
             frmAdmin admin = new frmAdmin();
             admin.ShowDialog();
         }
         else if (BUS_Tai_Khoan.Quyen(txtUserName.Text).Contains("GV"))
         {
             Giao_Vienn tk = BUS_Tai_Khoan.layThongTinTaiKhoan(txtUserName.Text) as Giao_Vienn;
             frmGiao_Vien.giaoVien = tk;
             frmGiao_Vien admin = new frmGiao_Vien();
             admin.ShowDialog();
         }
         txtPassWord.Clear();
         txtUserName.Clear();
     }
 }
コード例 #2
0
ファイル: DAO_Tai_Khoan.cs プロジェクト: 1760005/Quan_Ly_Thi
        public static Tai_khoan layThongTinTaiKhoan(string taiKhoan)
        {
            using (var qlttn = new QLTTNDataContext())
            {
                var thongTin = qlttn.NGUOIDUNGs.Where(nd => nd.TaiKhoan.Equals(taiKhoan))
                               .Select(nd => new { nd }).Single();


                if (thongTin.nd.MaPhanQuyen.Equals("AD        "))
                {
                    Adminn ad = new Adminn();
                    ad.Ho_Ten    = thongTin.nd.HoTen;
                    ad.Ngay_Sinh = thongTin.nd.NgaySinh.Value;
                    ad.Tai_Khoan = thongTin.nd.TaiKhoan;
                    ad.CMND_TCC  = thongTin.nd.CMND_TCC;
                    return(ad);
                }
                else if (thongTin.nd.MaPhanQuyen.Equals("GV        "))
                {
                    var thongTinn = qlttn.NGUOIDUNGs
                                    .Join(qlttn.KHOIs, nd => nd.MaKhoi, k => k.MaKhoi,
                                          (nd, k) => new { nd, k.TenKhoi })
                                    .Where(nd => nd.nd.TaiKhoan.Equals(taiKhoan))
                                    .Select(nd => new { nd }).Single();

                    Giao_Vienn gv = new Giao_Vienn();
                    gv.Tai_Khoan = thongTinn.nd.nd.TaiKhoan;
                    gv.Ho_Ten    = thongTinn.nd.nd.HoTen;
                    gv.CMND_TCC  = thongTinn.nd.nd.CMND_TCC;
                    gv.Ngay_Sinh = thongTinn.nd.nd.NgaySinh.Value;
                    gv.SDT       = thongTinn.nd.nd.SoDienThoai;
                    gv.Email     = thongTinn.nd.nd.Email;
                    gv.Khoi      = thongTinn.nd.TenKhoi;
                    return(gv);
                }
                else
                {
                    var thongTinn = qlttn.NGUOIDUNGs
                                    .Join(qlttn.LOPHOCs, nd => nd.MaLop, lh => lh.MaLop,
                                          (nd, lh) => new { nd, lh })
                                    .Join(qlttn.KHOIs, nd => nd.lh.MaKhoi, k => k.MaKhoi,
                                          (nd, k) => new { nd, k.TenKhoi })
                                    .Where(nd => nd.nd.nd.TaiKhoan.Equals(taiKhoan))
                                    .Select(nd => new { nd }).Single();

                    Hoc_Sinhh hs = new Hoc_Sinhh();
                    hs.Tai_Khoan = thongTinn.nd.nd.nd.TaiKhoan;
                    hs.Ho_Ten    = thongTinn.nd.nd.nd.HoTen;
                    hs.CMND_TCC  = thongTinn.nd.nd.nd.CMND_TCC;
                    hs.Ngay_Sinh = thongTinn.nd.nd.nd.NgaySinh.Value;
                    hs.SDT       = thongTinn.nd.nd.nd.SoDienThoai;
                    hs.Email     = thongTinn.nd.nd.nd.Email;
                    hs.Khoi      = thongTinn.nd.TenKhoi;
                    hs.Lop       = thongTinn.nd.nd.lh.TenLop;
                    return(hs);
                }
            }
        }
コード例 #3
0
ファイル: BUS_Admin.cs プロジェクト: 1760005/Quan_Ly_Thi
 public static void UpdateTeacher(Giao_Vienn Teacher, string Teacher_User_Account)
 {
     if (Teacher.Tai_Khoan == Teacher_User_Account)
     {
         DAO_Admin.UpdateTeacher(Teacher);
         MessageBox.Show("Update Success");
     }
     MessageBox.Show("You Can't Change The Name Account Of User!");
 }
コード例 #4
0
ファイル: frmAdmin.cs プロジェクト: 1760005/Quan_Ly_Thi
        private void btnUpdate_teacher_Click(object sender, EventArgs e)
        {
            Giao_Vienn Teacher = new Giao_Vienn()
            {
                Ho_Ten    = txtFull_name_teacher.Text,
                Tai_Khoan = txtUserName_teacher.Text,
                Mat_Khau  = txtUserName_teacher.Text,
                CMND_TCC  = txtCMND_TCC_teacher.Text,
                Lop       = null,
                Khoi      = listGrades[Grade_CBB.SelectedIndex].GradeID,
                Email     = txtMail_teacher.Text,
                SDT       = txtSDT_teacher.Text,
                Ngay_Sinh = DateTime.Parse(dtTeacher_Picker.Value.ToString())
            };

            BUS_Admin.UpdateTeacher(Teacher, Teacher_User_Account);
        }
コード例 #5
0
ファイル: DAO_Admin.cs プロジェクト: 1760005/Quan_Ly_Thi
        public static void UpdateTeacher(Giao_Vienn Teacher)
        {
            using (var dataContext = new QLTTNDataContext())
            {
                var data = dataContext.NGUOIDUNGs.Where(nd => nd.TaiKhoan.Equals(Teacher.Tai_Khoan)).Select(nd => nd).Single();


                data.TaiKhoan    = Teacher.Tai_Khoan;
                data.MatKhau     = Teacher.Mat_Khau;
                data.MaKhoi      = Teacher.Khoi;
                data.MaLop       = Teacher.Lop;
                data.HoTen       = Teacher.Ho_Ten;
                data.CMND_TCC    = Teacher.CMND_TCC;
                data.NgaySinh    = Teacher.Ngay_Sinh;
                data.SoDienThoai = Teacher.SDT;
                data.Email       = Teacher.Email;

                dataContext.SubmitChanges();
            }
        }
コード例 #6
0
ファイル: DAO_Admin.cs プロジェクト: 1760005/Quan_Ly_Thi
        public static void InsertTeacherWithLinq(Giao_Vienn Teacher)
        {
            using (QLTTNDataContext dataContext = new QLTTNDataContext())
            {
                NGUOIDUNG newUser = new NGUOIDUNG()
                {
                    TaiKhoan    = Teacher.Tai_Khoan,
                    MatKhau     = Teacher.Mat_Khau,
                    MaKhoi      = Teacher.Khoi,
                    MaLop       = Teacher.Lop,
                    HoTen       = Teacher.Ho_Ten,
                    CMND_TCC    = Teacher.CMND_TCC,
                    NgaySinh    = Teacher.Ngay_Sinh,
                    SoDienThoai = Teacher.SDT,
                    Email       = Teacher.Email,
                    MaPhanQuyen = "GV"
                };

                dataContext.NGUOIDUNGs.InsertOnSubmit(newUser);
                dataContext.SubmitChanges();
            }
        }
コード例 #7
0
ファイル: frmAdmin.cs プロジェクト: 1760005/Quan_Ly_Thi
 private void btnAdd_teacher_Click(object sender, EventArgs e)
 {
     if (ValidateChildren(ValidationConstraints.Enabled))
     {
         Giao_Vienn Teacher = new Giao_Vienn()
         {
             Ho_Ten    = txtFull_name_teacher.Text,
             Tai_Khoan = txtUserName_teacher.Text,
             Mat_Khau  = txtUserName_teacher.Text,
             CMND_TCC  = txtCMND_TCC_teacher.Text,
             Khoi      = listGrades[Grade_CBB.SelectedIndex].GradeID,
             Lop       = null,
             Email     = txtMail_teacher.Text,
             SDT       = txtSDT_teacher.Text,
             Ngay_Sinh = DateTime.Parse(dtTeacher_Picker.Value.ToString())
         };
         BUS_Admin.InsertTeacher(Teacher);
         MessageBox.Show("Add Teacher Success!");
     }
     MessageBox.Show("Add Teacher Failed!");
     return;
 }
コード例 #8
0
 static public bool capNhatNguoiDungVaoDB(Giao_Vienn nd)
 {
     using (QLTTNDataContext qlttn = new QLTTNDataContext())
     {
         try
         {
             var nguoiDung = qlttn.NGUOIDUNGs.Where(ndd => ndd.TaiKhoan.Equals(nd.Tai_Khoan));
             foreach (var ndd in nguoiDung)
             {
                 ndd.HoTen       = nd.Ho_Ten;
                 ndd.CMND_TCC    = nd.CMND_TCC;
                 ndd.NgaySinh    = nd.Ngay_Sinh;
                 ndd.SoDienThoai = nd.SDT;
                 ndd.Email       = nd.Email;
             }
             qlttn.SubmitChanges();
             return(true);
         }
         catch
         {
             return(false);
         }
     }
 }
コード例 #9
0
ファイル: BUS_Giao_Vien.cs プロジェクト: 1760005/Quan_Ly_Thi
 static public bool capNhatNguoiDungVaoDB(Giao_Vienn nd)
 {
     return(DAO_Giao_Vien.capNhatNguoiDungVaoDB(nd));
 }
コード例 #10
0
ファイル: BUS_Admin.cs プロジェクト: 1760005/Quan_Ly_Thi
 public static void InsertTeacher(Giao_Vienn Teacher)
 {
     DAO_Admin.InsertTeacherWithLinq(Teacher);
 }