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); }
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); } }
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>()); } }
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); } }
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); } }