Пример #1
0
        /// <summary>
        /// Delete Nhan vien
        /// </summary>
        /// <param name="ID"></param>
        public bool Delete(int manv)
        {
            using (QLDLEntities db = new QLDLEntities())
            {
                if ((db.PHIEUXUATHANGs.Where(p => p.NGUOIXUAT == manv).Count() > 0) ||
                    (db.PHIEUTHUTIENs.Where(p => p.NGUOITHU == manv).Count() > 0))
                {
                    return(false);
                }
                else
                {
                    List <TAIKHOAN> li = db.TAIKHOANs.Where(p => p.MANV == manv).ToList();
                    foreach (TAIKHOAN item in li)
                    {
                        db.TAIKHOANs.Remove(item);
                    }
                    db.SaveChanges();

                    NHANVIEN nv = db.NHANVIENs.Single(p => p.MANV == manv);
                    db.NHANVIENs.Remove(nv);
                    db.SaveChanges();
                    return(true);
                }
            }
        }
Пример #2
0
        /// <summary>
        /// Insert Nhanvien into database
        /// </summary>
        /// <param name="dl"></param>
        /// <returns></returns>
        public bool Insert(string ten, DateTime ngay, string dc, int macv, string acc, string pass)
        {
            using (QLDLEntities db = new QLDLEntities())
            {
                NHANVIEN nv = new NHANVIEN()
                {
                    TENNV    = ten,
                    NGAYSINH = ngay,
                    DIACHI   = dc,
                    MACHUCVU = macv
                };
                db.NHANVIENs.Add(nv);
                db.SaveChanges();

                TAIKHOAN tk = new TAIKHOAN()
                {
                    TENDANGNHAP = acc,
                    PASSWORD    = pass,
                    MANV        = db.NHANVIENs.Single(p => p.TENNV == ten && p.NGAYSINH == ngay && p.MACHUCVU == macv).MANV
                };
                db.TAIKHOANs.Add(tk);
                db.SaveChanges();
                return(true);
            }
        }
Пример #3
0
 /// <summary>
 /// Change max-number of SONOTOIDA in LOAIDL
 /// </summary>
 /// <param name="maloaidl"></param>
 /// <param name="sonotoida"></param>
 /// <returns></returns>
 public bool ChangeMaxNumOfTienNo(int maloaidl, int sonotoida)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         LOAIDL loaidl = db.LOAIDLs.Where(p => p.MALOAI == maloaidl).Single();
         loaidl.SONOTOIDA = sonotoida;
         db.SaveChanges();
         return(true);
     }
 }
Пример #4
0
 /// <summary>
 /// insert a record into table DVT- increament number of DVT
 /// </summary>
 /// <param name="tendvt"></param>
 /// <returns></returns>
 public bool InsertDVT(string tendvt)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         DVT dvt = new DVT();
         dvt.DVT1 = tendvt;
         db.DVTs.Add(dvt);
         db.SaveChanges();
         return(true);
     }
 }
Пример #5
0
 /// <summary>
 /// Change max-number of DAILY in QUAN
 /// </summary>
 /// <param name="maquan"></param>
 /// <param name="sodailytoida"></param>
 /// <returns></returns>
 public bool ChangeNumOfDaily(int maquan, int sodailytoida)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         QUAN quan = db.QUANs.Where(p => p.MAQUAN == maquan).Single();
         quan.SODLTOIDA = sodailytoida;
         db.SaveChanges();
         //change succeed
         return(true);
     }
 }
Пример #6
0
 /// <summary>
 /// insert a record into table MATHANG- increament number of MATHANG
 /// </summary>
 /// <param name="tenhang"></param>
 /// <param name="tendvt"></param>
 /// <param name="dongia"></param>
 /// <returns></returns>
 public bool InsertMATHANG(string tenhang, int madvt, int dongia)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         MATHANG mh = new MATHANG();
         mh.TENHANG = tenhang;
         mh.MADVT   = madvt;
         mh.DONGIA  = dongia;
         db.MATHANGs.Add(mh);
         db.SaveChanges();
         return(true);
     }
 }
Пример #7
0
 /// <summary>
 /// insert a record into table LOAIDL- increament number of LOAIDL
 /// </summary>
 /// <param name="tenloai"></param>
 /// <param name="sonotoida"></param>
 /// <returns></returns>
 public bool InsertLoaiDL(string tenloai, int sonotoida)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         LOAIDL dl = new LOAIDL();
         dl.TENLOAI   = tenloai;
         dl.SONOTOIDA = sonotoida;
         db.LOAIDLs.Add(dl);
         db.SaveChanges();
         //insert suceed
         return(true);
     }
 }
Пример #8
0
 /// <summary>
 /// Update NHANVIEN
 /// </summary>
 /// <param name="dl"></param>
 /// <returns></returns>
 public bool Update(NHANVIEN nhanvien)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         NHANVIEN nv = db.NHANVIENs.Where(p => p.MANV == nhanvien.MANV).Single();
         nv.TENNV = nhanvien.TENNV;
         //nv.NGAYSINH = nhanvien.NGAYSINH;
         //nv.DIACHI = nhanvien.DIACHI;
         //nv.MACHUCVU = nhanvien.MACHUCVU;
         db.SaveChanges();
         return(true);
     }
 }
Пример #9
0
        /// <summary>
        /// Get all DVT's name and show upto ComboBox
        /// </summary>
        /// <returns></returns>
        public ObservableCollection <DVT> GetAllDVT()
        {
            ObservableCollection <DVT> li = new ObservableCollection <DVT>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.DVTs.Select(p => p);
                foreach (var item in l)
                {
                    li.Add(item as DVT);
                }
                return(li);
            }
        }
Пример #10
0
        /// <summary>
        /// Get all LAOIDAILY's name and show upto ComboBox
        /// </summary>
        /// <returns></returns>
        public ObservableCollection <LOAIDL> GetAllLoaiDL()
        {
            ObservableCollection <LOAIDL> li = new ObservableCollection <LOAIDL>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.LOAIDLs.Select(p => p);
                foreach (var item in l)
                {
                    li.Add(item as LOAIDL);
                }
                return(li);
            }
        }
Пример #11
0
        /// <summary>
        /// Get all QUAN's name and show upto ComboBox
        /// </summary>
        /// <returns></returns>
        public ObservableCollection <QUAN> GetAllQuan()
        {
            ObservableCollection <QUAN> li = new ObservableCollection <QUAN>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.QUANs.Select(p => p);
                foreach (var item in l)
                {
                    li.Add(item as QUAN);
                }
                return(li);
            }
        }
Пример #12
0
        /// <summary>
        /// Get all DaiLy's name and show upto ComboBox
        /// </summary>
        /// <returns></returns>
        public ObservableCollection <DAILY> GetAllDaiLy()
        {
            ObservableCollection <DAILY> li = new ObservableCollection <DAILY>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.DAILies.Select(p => p);
                foreach (var item in l)
                {
                    li.Add(item as DAILY);
                }
                return(li);
            }
        }
Пример #13
0
        /// <summary>
        /// get all CHUC VU
        /// </summary>
        /// <returns></returns>
        public ObservableCollection <CHUCVU> GetAllCV()
        {
            ObservableCollection <CHUCVU> li = new ObservableCollection <CHUCVU>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.CHUCVUs.Select(p => p);
                foreach (var item in l)
                {
                    li.Add(item as CHUCVU);
                }
                return(li);
            }
        }
Пример #14
0
 /// <summary>
 /// delete a record into table DVT - descreament number of DVT
 /// </summary>
 /// <param name="madvt"></param>
 /// <returns></returns>
 public bool DeleteDVT(int madvt)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         if (db.MATHANGs.Where(p => p.MADVT == madvt).Count() <= 0)
         {
             DVT dvt = db.DVTs.Where(p => p.MADVT == madvt).Single();
             db.DVTs.Remove(dvt);
             db.SaveChanges();
             return(true);
         }
         return(false);
     }
 }
Пример #15
0
        /// <summary>
        /// Get worker by name
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN> GetAllNV(string name)
        {
            ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN> li = new ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.vwCHUCVU_NHANVIEN_TAIKHOAN.Where(p => p.TENNV.Contains(name));
                foreach (var item in l)
                {
                    li.Add(item as vwCHUCVU_NHANVIEN_TAIKHOAN);
                }
                return(li);
            }
        }
Пример #16
0
 /// <summary>
 /// delete a record into table MATHANG - descreament number of MATHANG
 /// </summary>
 /// <param name="mamh"></param>
 /// <returns></returns>
 public bool DeleteMATHANG(int mamh)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         if (db.CTPXes.Where(p => p.MAHANG == mamh).Count() <= 0)
         {
             MATHANG mh = db.MATHANGs.Where(p => p.MAHANG == mamh).Single();
             db.MATHANGs.Remove(mh);
             db.SaveChanges();
             return(true);
         }
         return(false);
     }
 }
Пример #17
0
        /// <summary>
        /// Search NHan vien from database and display it to GUI
        /// Load if nhanvien's search condition equal empty string
        /// </summary>
        public ObservableCollection <NHANVIEN> Search(int macv, string ten, string dc)
        {
            ObservableCollection <NHANVIEN> li = new ObservableCollection <NHANVIEN>();

            using (QLDLEntities db = new QLDLEntities())
            {
                var l = db.NHANVIENs.Where(p => p.MACHUCVU == macv && p.TENNV.Contains(ten) &&
                                           p.DIACHI.Contains(dc));
                foreach (var item in l)
                {
                    li.Add(item as NHANVIEN);
                }
                return(li);
            }
        }
Пример #18
0
 /// <summary>
 /// delete a record into table LOAIDL - descreament number of LOAIDL
 /// </summary>
 /// <param name="loaidl"></param>
 /// <returns></returns>
 public bool DeleteLAOIDL(int loaidl)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         if (db.DAILies.Where(p => p.LOAIDL == loaidl).Count() <= 0)
         {
             LOAIDL ldl = db.LOAIDLs.Where(p => p.MALOAI == loaidl).Single();
             db.LOAIDLs.Remove(ldl);
             db.SaveChanges();
             //delete succeed
             return(true);
         }
         //delete false
         return(false);
     }
 }