private static void DeleteCriteria(MembersDataContext dc, SavedResumeSearchEntity entity)
{
if (entity.ResumeSearchCriteriaSetEntity != null)
{
// Need to check that there are no other searches or executions that are using this criteria.
if (!IsCriteriaOwnedByOtherSearch(dc, entity.ResumeSearchCriteriaSetEntity.id, entity.id) && !IsCriteriaOwnedByExecution(dc, entity.ResumeSearchCriteriaSetEntity.id))
{
dc.ResumeSearchCriteriaEntities.DeleteAllOnSubmit(entity.ResumeSearchCriteriaSetEntity.ResumeSearchCriteriaEntities);
dc.ResumeSearchCriteriaSetEntities.DeleteOnSubmit(entity.ResumeSearchCriteriaSetEntity);
}
}
}
private IEnumerable <MemberSearchExecution> GetMemberSearchExecutions(MembersDataContext dc, IEnumerable <Guid> ownerIds, Range range)
{
dc.LoadOptions = ExecutionLoadOptions;
if (range.Skip != 0)
{
return(range.Take != null
? GetMemberSearchExecutionsByOwnersSkipTakeQuery(dc, new SplitList <Guid>(ownerIds).ToString(), range, _criteriaPersister)
: GetMemberSearchExecutionsByOwnersSkipQuery(dc, new SplitList <Guid>(ownerIds).ToString(), range, _criteriaPersister));
}
return(range.Take != null
? GetMemberSearchExecutionsByOwnersTakeQuery(dc, new SplitList <Guid>(ownerIds).ToString(), range, _criteriaPersister)
: GetMemberSearchExecutionsByOwnersQuery(dc, new SplitList <Guid>(ownerIds).ToString(), _criteriaPersister));
}
private IEnumerable <Member> GetMembers(MembersDataContext dc, IEnumerable <Guid> ids, Range range)
{
dc.LoadOptions = MemberLoadOptions;
ids = ids.Distinct();
if (range.Skip == 0)
{
return(range.Take != null
? GetMembersTakeQuery(dc, new SplitList <Guid>(ids).ToString(), range, _locationQuery)
: GetMembersQuery(dc, new SplitList <Guid>(ids).ToString(), _locationQuery));
}
return(range.Take != null
? GetMembersSkipTakeQuery(dc, new SplitList <Guid>(ids).ToString(), range, _locationQuery)
: GetMembersSkipQuery(dc, new SplitList <Guid>(ids).ToString(), range, _locationQuery));
}
protected void butRegister_Click(object sender, EventArgs e)
{
if (IsValid)
{
MembersDataContext memberData = new MembersDataContext();
int Result = memberData.MemberRegister(txtUsername.Text, txtPassword.Text, txtFirstName.Text, txtLastName.Text, txtEmail.Text);
if (Result == -1)
{
lblMessage.Text = "Username Already Registered";
}
else
{
FormsAuthentication.RedirectFromLoginPage(Result.ToString(), false);
}
}
}
protected int Authenticate(string Username, string Password)
{
MembersDataContext memberData = new MembersDataContext();
int Result = memberData.MemberAuthenticate(Username, Password);
if (Result == -1)
{
throw new Exception("Invalid Username");
}
if (Result == -2)
{
throw new Exception("Invalid Password");
}
return Result;
}
private static SavedResumeSearchEntity GetSavedResumeSearchEntity(MembersDataContext dc, Guid id)
{
dc.LoadOptions = SearchLoadOptions;
return(GetSavedResumeSearchEntityQuery(dc, id));
}
private IEnumerable <Member> GetMembers(MembersDataContext dc, string fullName)
{
dc.LoadOptions = MemberLoadOptions;
return(GetMembersByNameQuery(dc, fullName, _locationQuery));
}
private IEnumerable <Member> GetMembers(MembersDataContext dc, IEnumerable <Guid> ids)
{
dc.LoadOptions = MemberLoadOptions;
return(GetMembersQuery(dc, new SplitList <Guid>(ids.Distinct()).ToString(), _locationQuery));
}
private Member GetMemberByEmailAddress(MembersDataContext dc, string emailAddress)
{
dc.LoadOptions = MemberLoadOptions;
return(GetMemberByEmailAddressQuery(dc, emailAddress, _locationQuery));
}
private Member GetMember(MembersDataContext dc, Guid id)
{
dc.LoadOptions = MemberLoadOptions;
return(GetMemberQuery(dc, id, _locationQuery));
}
private static MemberEntity GetMemberEntity(MembersDataContext dc, Guid id)
{
dc.LoadOptions = MemberLoadOptions;
return(GetMemberEntityQuery(dc, id));
}
private MemberSearch GetMemberSearch(MembersDataContext dc, Guid id)
{
dc.LoadOptions = SearchLoadOptions;
return(GetMemberSearchQuery(dc, id, _criteriaPersister));
}
private IEnumerable <MemberSearchExecution> GetMemberSearchExecutions(MembersDataContext dc, Guid ownerId)
{
dc.LoadOptions = ExecutionLoadOptions;
return(GetMemberSearchExecutionsQuery(dc, ownerId, _criteriaPersister));
}
private MemberSearchExecution GetMemberSearchExecution(MembersDataContext dc, Guid id)
{
dc.LoadOptions = ExecutionLoadOptions;
return(GetMemberSearchExecutionQuery(dc, id, _criteriaPersister));
}
private MemberSearch GetMemberSearch(MembersDataContext dc, Guid ownerId, string name)
{
dc.LoadOptions = SearchLoadOptions;
return(GetMemberSearchByNameQuery(dc, ownerId, name, _criteriaPersister));
}
private IEnumerable <MemberSearch> GetMemberSearches(MembersDataContext dc, Guid ownerId)
{
dc.LoadOptions = SearchLoadOptions;
return(GetMemberSearchesByOwnerQuery(dc, ownerId, _criteriaPersister));
}
private IEnumerable <MemberSearch> GetMemberSearches(MembersDataContext dc, IEnumerable <Guid> ids)
{
dc.LoadOptions = SearchLoadOptions;
return(GetMemberSearchesQuery(dc, new SplitList <Guid>(ids).ToString(), _criteriaPersister));
}
