Ejemplo n.º 1
0
        public int DeletePersonnelRelationshipByUserID(string userID)
        {
            int count = 0;
            PersonnelRelationshipDataContext db = new PersonnelRelationshipDataContext();
            var user = from c in db.PersonnelRelationship where c.UserID == userID select c;

            if (user.Count() > 0)
            {
                db.PersonnelRelationship.DeleteAllOnSubmit(user);
                count = db.PersonnelRelationship.Where(c => c.UserID == userID).Count();
            }
            return(count);
        }
Ejemplo n.º 2
0
        public PersonnelRelationship GetPersonnelRelationship(string UserId)
        {
            PersonnelRelationshipDataContext db = new PersonnelRelationshipDataContext();

            if (db.PersonnelRelationship.Count() > 0)
            {
                var user = db.PersonnelRelationship.Single(c => c.UserID == UserId);
                return(user);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 3
0
        public IList <PersonnelRelationship> GetPersonnelRelationship()
        {
            PersonnelRelationshipDataContext    db     = new PersonnelRelationshipDataContext();
            IEnumerable <PersonnelRelationship> attInd = from c in db.PersonnelRelationship select c;

            if (attInd != null)
            {
                return(attInd.ToList <PersonnelRelationship>());
            }
            else
            {
                return(new List <PersonnelRelationship>());
            }
        }
Ejemplo n.º 4
0
        public int InsertAttentionIndustry(PersonnelRelationship perRe)
        {
            PersonnelRelationshipDataContext db = new PersonnelRelationshipDataContext();

            try
            {
                db.PersonnelRelationship.InsertOnSubmit(perRe);
                db.SubmitChanges();
                return(int.Parse(perRe.UserID.ToString()));
            }
            catch
            {
                return(0);
            }
        }
Ejemplo n.º 5
0
        public int UpdatePersonnelRelationshipfoByUserID(PersonnelRelationship attInd)
        {
            PersonnelRelationshipDataContext db = new PersonnelRelationshipDataContext();

            try
            {
                var result = (from item in db.PersonnelRelationship where item.UserID == attInd.UserID select item).Single();
                result.GUserID = attInd.GUserID;
                result.IndID   = attInd.IndID;
                result.objType = attInd.objType;
                db.SubmitChanges();
                return(int.Parse(result.UserID.ToString()));
            }
            catch
            {
                return(0);
            }
        }