Esempio n. 1
0
 public SelectList GetMilitary()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        military          = _db.Militarys.ToList();
         SelectList MilitarylistItems = new SelectList(military, "MilitaryID", "MilitaryName");
         return(MilitarylistItems);
     }
 }
Esempio n. 2
0
 public SelectList GetZone()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        Zone      = _db.Addresss.ToList();
         SelectList ZoneItems = new SelectList(Zone, "Zone", "Zone");
         return(ZoneItems);
     }
 }
Esempio n. 3
0
 public SelectList GetCertificate()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        certificate          = _db.Certificates.ToList();
         SelectList CertificatelistItems = new SelectList(certificate, "CertificateID", "CertificateName");
         return(CertificatelistItems);
     }
 }
Esempio n. 4
0
 public SelectList GetDep1()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        dep           = _db.Dep1s.ToList();
         SelectList Dep1listItems = new SelectList(dep, "Dep1ID", "Dep1Name");
         return(Dep1listItems);
     }
 }
Esempio n. 5
0
 public SelectList GetTitle()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        title          = _db.Titless.ToList();
         SelectList titlelistItems = new SelectList(title, "TitleID", "TitleName");
         return(titlelistItems);
     }
 }
Esempio n. 6
0
 public SelectList GetHighestedu()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        highestedu          = _db.Highestedus.ToList();
         SelectList HighestedulistItems = new SelectList(highestedu, "HighestID", "HighestName");
         return(HighestedulistItems);
     }
 }
Esempio n. 7
0
 public SelectList GetGraduation()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        graduation          = _db.Graduations.ToList();
         SelectList GraduationlistItems = new SelectList(graduation, "GraduationID", "GraduationName");
         return(GraduationlistItems);
     }
 }
Esempio n. 8
0
 public SelectList GetRelationship()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        relationship          = _db.Relationships.ToList();
         SelectList RelationshiplistItems = new SelectList(relationship, "RelationshipID", "RelationshipName");
         return(RelationshiplistItems);
     }
 }
Esempio n. 9
0
 public SelectList GetWorkingHR()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        workingHR          = _db.WorkingHRs.ToList();
         SelectList WorkingHRlistItems = new SelectList(workingHR, "WorkingHRID", "WorkingHRName");
         return(WorkingHRlistItems);
     }
 }
Esempio n. 10
0
 public SelectList GetWelfare()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        welfare          = _db.Welfares.ToList();
         SelectList WelfarelistItems = new SelectList(welfare, "WelfareID", "WelfareName");
         return(WelfarelistItems);
     }
 }
Esempio n. 11
0
 public SelectList GetSend()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        send          = _db.Sends.ToList();
         SelectList SendlistItems = new SelectList(send, "SendID", "SendName");
         return(SendlistItems);
     }
 }
Esempio n. 12
0
 public SelectList GetMarriage()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        marriage          = _db.Marriages.ToList();
         SelectList MarriagelistItems = new SelectList(marriage, "MarriageID", "MarriageName");
         return(MarriagelistItems);
     }
 }
Esempio n. 13
0
 public SelectList GetStatus()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        status          = _db.Statuss.ToList();
         SelectList StatuslistItems = new SelectList(status, "StatusID", "StatusName");
         return(StatuslistItems);
     }
 }
Esempio n. 14
0
 public SelectList GetHire()
 {
     using (CGHContext _db = new CGHContext())
     {
         var        hire          = _db.Hires.ToList();
         SelectList hirelistItems = new SelectList(hire, "HireID", "HireName");
         return(hirelistItems);
     }
 }
Esempio n. 15
0
        public SelectList GetUserID()
        {
            using (CGHContext _db = new CGHContext())
            {
                var UserID = _db.UsersTables.ToList();


                SelectList UserItem = new SelectList(UserID, "UserID", "UserName");
                return(UserItem);
            }
        }
Esempio n. 16
0
        public SelectList GetBoss()
        {
            using (CGHContext _db = new CGHContext())
            {
                var boss = _db.Hrs.Where(x => x.Manager == true).ToList();


                SelectList BossItem = new SelectList(boss, "MemberID", "Name");
                return(BossItem);
            }
        }
Esempio n. 17
0
        public SelectList GetManager()
        {
            using (CGHContext _db = new CGHContext())
            {
                var Manager = _db.Hrs.Where(x => x.Manager == true && x.Status == 1).ToList();


                SelectList ManagerItem = new SelectList(Manager, "MemberID", "Name");
                return(ManagerItem);
            }
        }
Esempio n. 18
0
        public SelectList GetBuyCategory()
        {
            using (CGHContext _db = new CGHContext())
            {
                var BuyCategory = _db.BuyCategorys.Where(u => u.Enable.Equals(true)).ToList();


                SelectList BuyCategorysItem = new SelectList(BuyCategory, "BuyCategoryID", "BuyCategoryName");
                return(BuyCategorysItem);
            }
        }
Esempio n. 19
0
        public SelectList GetBuyerUnit()
        {
            using (CGHContext _db = new CGHContext())
            {
                var BuyerUnit = _db.BuyerUnits.Where(u => u.Enable.Equals(true)).ToList();


                SelectList BuyerUnitItem = new SelectList(BuyerUnit, "BuyerUniID", "BuyerUnitName");
                return(BuyerUnitItem);
            }
        }
Esempio n. 20
0
        public SelectList GetAdd()
        {
            using (CGHContext _db = new CGHContext())
            {
                var result = (from p in _db.Addresss
                              orderby p.ID
                              select p.City).ToList().Distinct();



                SelectList AddItems = new SelectList(result);
                return(AddItems);
            }
        }