/// <summary> /// /// </summary> /// <param name="siteId"></param> /// <param name="userId"></param> /// <param name="status"></param> /// <param name="userType"></param> /// <returns></returns> public void AddUserToSite(long siteId, long userId, bool isEnabled) { awSiteUser usr = new awSiteUser(); //check if it is already exist, if it is update the current one var users = from f in _context.awSiteUsers where f.userId.Equals(userId) && f.siteId.Equals(siteId) select f; if (users != null && users.ToList().Count > 0) { UpdateUserInSite(siteId, userId, isEnabled); return; } usr.siteUserId = AWAPI_Common.library.MiscLibrary.CreateUniqueId(); usr.siteId = siteId; usr.userId = userId; usr.isEnabled = isEnabled; usr.joinDate = DateTime.Now; usr.lastBuildDate = DateTime.Now; usr.createDate = DateTime.Now; _context.awSiteUsers.InsertOnSubmit(usr); _context.SubmitChanges(); }
/// <summary> /// /// </summary> /// <param name="siteId"></param> /// <param name="userId"></param> /// <param name="isEnabled"></param> public void UpdateUserInSite(long siteId, long userId, bool isEnabled) { awSiteUser usr = _context.awSiteUsers. FirstOrDefault(st => st.siteId.Equals(siteId) && st.userId.Equals(userId)); if (usr == null) { return; } usr.isEnabled = isEnabled; usr.lastBuildDate = DateTime.Now; _context.SubmitChanges(); }
/// <summary> /// /// </summary> /// <param name="siteId"></param> /// <param name="userId"></param> /// <returns></returns> public awSiteUser GetUserFromSite(long siteId, long userId) { awSiteUser siteUser = _context.awSiteUsers.FirstOrDefault(su => su.siteId.Equals(siteId) && su.userId.Equals(userId)); return(siteUser); }