public static IEnumerable <ProjectMember> FindByProjectID(int id, MembershipStatus status)
{
List <ProjectMember> milestones = new List <ProjectMember>();
MySqlConnection c = getConnection();
MySqlCommand cmd = c.CreateCommand();
c.Open();
cmd.CommandText = @"SELECT * FROM empprojects where ProjID = @ProjID";
if (status == MembershipStatus.Current)
{
cmd.CommandText += " AND EndDate IS NULL;";
}
else if (status == MembershipStatus.Ended)
{
cmd.CommandText += " AND EndDate IS NOT NULL;";
}
cmd.Prepare();
cmd.Parameters.AddWithValue("@ProjID", id);
cmd.CommandType = System.Data.CommandType.Text;
MySqlDataReader dr = cmd.ExecuteReader();
ProjectMember p = new ProjectMember();
while (dr.Read())
{
p = FillProjectMember(dr);
milestones.Add(p);
}
c.Close();
return(milestones);
}
/// <summary>
/// Get a random quest for a guild from appropriate subset.
/// </summary>
public Quest GetGuildQuest(FactionFile.GuildGroups guildGroup, MembershipStatus status, int factionId, int rep)
{
#if UNITY_EDITOR // Reload every time when in editor
LoadQuestLists();
#endif
List <QuestData> guildQuests;
if (guilds.TryGetValue(guildGroup, out guildQuests))
{
// Modifications for Temple dual membership status
MembershipStatus tplMemb = (guildGroup == FactionFile.GuildGroups.HolyOrder && status != MembershipStatus.Nonmember) ? MembershipStatus.Member : status;
// Underworld guilds don't expel and continue to offer std quests below zero reputation
rep = ((guildGroup == FactionFile.GuildGroups.DarkBrotherHood || guildGroup == FactionFile.GuildGroups.GeneralPopulace) && rep < 0) ? 0 : rep;
List <QuestData> pool = new List <QuestData>();
foreach (QuestData quest in guildQuests)
{
if ((status == (MembershipStatus)quest.membership || tplMemb == (MembershipStatus)quest.membership) &&
(status == MembershipStatus.Nonmember || (rep >= quest.minRep && (!quest.unitWildC || rep < quest.minRep + 10))))
{
pool.Add(quest);
}
}
return(SelectQuest(pool, factionId));
}
return(null);
}
public static IEnumerable<ProjectMember> FindByProjectID(int id, MembershipStatus status)
{
List<ProjectMember> milestones = new List<ProjectMember>();
MySqlConnection c = getConnection();
MySqlCommand cmd = c.CreateCommand();
c.Open();
cmd.CommandText = @"SELECT * FROM empprojects where ProjID = @ProjID";
if (status == MembershipStatus.Current)
{
cmd.CommandText += " AND EndDate IS NULL;";
}
else if (status == MembershipStatus.Ended)
{
cmd.CommandText += " AND EndDate IS NOT NULL;";
}
cmd.Prepare();
cmd.Parameters.AddWithValue("@ProjID", id);
cmd.CommandType = System.Data.CommandType.Text;
MySqlDataReader dr = cmd.ExecuteReader();
ProjectMember p = new ProjectMember();
while (dr.Read())
{
p = FillProjectMember(dr);
milestones.Add(p);
}
c.Close();
return milestones;
}
/// <summary>
/// Gets a pool of elligible quests for a guild to offer.
/// </summary>
public List <QuestData> GetGuildQuestPool(FactionFile.GuildGroups guildGroup, MembershipStatus status, int factionId, int rep, int rank)
{
#if UNITY_EDITOR // Reload every time when in editor
LoadQuestLists();
#endif
// Create one-time quest list if not already created
if (oneTimeQuestsAccepted == null)
{
oneTimeQuestsAccepted = new List <string>();
}
List <QuestData> guildQuests;
if (guilds.TryGetValue(guildGroup, out guildQuests))
{
// Modifications for Temple dual membership status
MembershipStatus tplMemb = (guildGroup == FactionFile.GuildGroups.HolyOrder && status != MembershipStatus.Nonmember) ? MembershipStatus.Member : status;
List <QuestData> pool = new List <QuestData>();
foreach (QuestData quest in guildQuests)
{
if ((status == (MembershipStatus)quest.membership || tplMemb == (MembershipStatus)quest.membership) &&
(status == MembershipStatus.Nonmember || (quest.minReq < 10 && quest.minReq <= rank) || (quest.minReq >= 10 && quest.minReq <= rep)))
{
if ((!quest.adult || DaggerfallUnity.Settings.PlayerNudity) && !(quest.oneTime && oneTimeQuestsAccepted.Contains(quest.name)))
{
pool.Add(quest);
}
}
}
return(pool);
}
return(null);
}
private static string ErrorCodeToString(MembershipStatus createStatus)
{
switch (createStatus)
{
case MembershipStatus.DuplicateUserName:
return("User name already exists. Please enter a different user name.");
case MembershipStatus.DuplicateEmail:
return("A user name for that e-mail address already exists. Please enter a different e-mail address.");
case MembershipStatus.InvalidPassword:
return("The password provided is invalid. Please enter a valid password value.");
case MembershipStatus.InvalidEmail:
return("The e-mail address provided is invalid. Please check the value and try again.");
case MembershipStatus.InvalidAnswer:
return("The password retrieval answer provided is invalid. Please check the value and try again.");
case MembershipStatus.InvalidQuestion:
return("The password retrieval question provided is invalid. Please check the value and try again.");
case MembershipStatus.InvalidUserName:
return("The user name provided is invalid. Please check the value and try again.");
case MembershipStatus.ProviderError:
return("The authentication provider returned an error. Please verify your entry and try again. If the problem persists, please contact your system administrator.");
case MembershipStatus.UserRejected:
return("The user creation request has been canceled. Please verify your entry and try again. If the problem persists, please contact your system administrator.");
default:
return("An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator.");
}
}
public static bool Login(out MembershipStatus status, out User user, string username, string password, bool rememberMe = false)
{
if (ValidateUser(out status, out user, username, password))
{
CreateTicket(user, rememberMe);
return(true);
}
return(false);
}
public async Task ChangeStatusProjectUser(Guid projectId, Guid userId, MembershipStatus newMembershipStatus)
{
var item = await _context.ProjectsUsers
.Where(x => x.ProjectId == projectId && x.UserId == userId)
.FirstOrDefaultAsync();
item.Status = newMembershipStatus;
_context.ProjectsUsers.Update(item);
await _context.SaveChangesAsync();
}
public async Task <Response> AddUserToCompany(Guid companyId, Guid userId, MembershipStatus membershipStatus)
{
var companyUser = await _companiesUsersRepository.GetCompanyUser(companyId, userId);
if (companyUser == null)
{
await _companiesUsersRepository.AddCompanyUser(companyId, userId, membershipStatus);
}
return(new Response());
}
public Membership(Customer owner, MembershipType membershipType, MembershipStatus membershipStatus) : this(owner.Session)
{
if (owner == null)
{
throw new ArgumentNullException("Customer");
}
Owner = owner;
MembershipType = membershipType;
MembershipStatus = membershipStatus;
}
public async Task ChangeStatusCompanyUser(Guid companyId, Guid userId, MembershipStatus newMembershipStatus)
{
var item = await _context.CompaniesUsers
.Where(x => x.CompanyId == companyId && x.UserId == userId)
.FirstOrDefaultAsync();
item.Status = newMembershipStatus;
_context.CompaniesUsers.Update(item);
await _context.SaveChangesAsync();
}
public static bool ValidateUser(out MembershipStatus status, out User user, string username, string password)
{
status = MembershipStatus.InvalidCredential;
user = AccessRepository.GetUserByName(username);
if (user != null && ValidatePassword(user, password))
{
status = MembershipStatus.Logged;
}
return(status.GetBooleanValue());
}
public async Task AddProjectUser(Guid projectId, Guid userId, MembershipStatus membershipStatus)
{
var item = new ProjectUserModel
{
ProjectId = projectId,
UserId = userId,
Status = membershipStatus,
CreatedDate = DateTime.UtcNow
};
_context.ProjectsUsers.Add(item);
await _context.SaveChangesAsync();
}
public async Task <ActionResult> EditMembership(MembershipStatus model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
model.Id = User.Identity.GetUserId();
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("EditMembership"));
}
public async Task AddTeamUser(Guid teamId, Guid userId, MembershipStatus membershipStatus)
{
var item = new TeamUserModel
{
TeamId = teamId,
UserId = userId,
Status = membershipStatus,
CreatedDate = DateTime.UtcNow
};
_context.TeamsUsers.Add(item);
await _context.SaveChangesAsync();
}
public async Task <Response> AddUserToTeam(Guid teamId, Guid userId, MembershipStatus membershipStatus)
{
var team = await _teamsRepository.GetById(teamId);
await AddUserToCompany(team.CompanyId, userId, membershipStatus);
var teamUser = await _teamsUsersRepository.GetTeamUser(teamId, userId);
if (teamUser == null)
{
await _teamsUsersRepository.AddTeamUser(teamId, userId, membershipStatus);
}
return(new Response());
}
public async Task AddRangeTeamUser(Guid teamId, IEnumerable <Guid> userIds, MembershipStatus membershipStatus)
{
var items = userIds.Select(userId => new TeamUserModel
{
TeamId = teamId,
UserId = userId,
Status = membershipStatus,
CreatedDate = DateTime.UtcNow
})
.ToList();
_context.TeamsUsers.AddRange(items);
await _context.SaveChangesAsync();
}
public async Task <Response> AddUserToProject(Guid projectId, Guid userId, MembershipStatus membershipStatus)
{
var project = await _projectsRepository.GetById(projectId);
await AddUserToTeam(project.TeamId, userId, membershipStatus);
var projectUser = await _projectsUsersRepository.GetProjectUser(projectId, userId);
if (projectUser == null)
{
await _projectsUsersRepository.AddProjectUser(projectId, userId, membershipStatus);
}
return(new Response());
}
protected override void GetQuest()
{
// Just exit if this NPC already involved in an active quest
// If quest conditions are complete the quest system should pickup ending
if (QuestMachine.Instance.IsLastNPCClickedAnActiveQuestor(guild))
{
CloseWindow();
return;
}
// Get member status, including temple specific statuses
MembershipStatus status = guild.IsMember() ? MembershipStatus.Member : MembershipStatus.Nonmember;
if (guild.IsMember() && guildGroup == FactionFile.GuildGroups.HolyOrder)
{
status = (MembershipStatus)Enum.Parse(typeof(MembershipStatus), ((Temple)guild).Deity.ToString());
}
// Get the faction id for affecting reputation on success/failure
int factionId = GetFactionIdForGuild();
// Set up a pool of available quests.
QuestListsManager questListsManager = GameManager.Instance.QuestListsManager;
questPool = GameManager.Instance.QuestListsManager.GetGuildQuestPool(guildGroup, status, factionId, guild.GetReputation(playerEntity), guild.Rank);
// Show the quest selection list if that feature has been enabled.
if (DaggerfallUnity.Settings.GuildQuestListBox)
{
loadedQuests.Clear();
TextFile.Token[] tokens = DaggerfallUnity.Instance.TextProvider.CreateTokens(
TextFile.Formatting.JustifyCenter,
TextManager.Instance.GetText(textDatabase, "gettingQuests1"),
TextManager.Instance.GetText(textDatabase, "gettingQuests2"));
DaggerfallMessageBox gettingQuestsBox = new DaggerfallMessageBox(DaggerfallUI.UIManager, this);
gettingQuestsBox.ClickAnywhereToClose = true;
gettingQuestsBox.SetTextTokens(tokens);
gettingQuestsBox.OnClose += GettingQuestsBox_OnClose;
gettingQuestsBox.Show();
}
else
{
// Select a quest at random from appropriate pool
offeredQuest = questListsManager.SelectQuest(questPool, factionId);
OfferQuest();
}
}
protected override void GetQuest()
{
// Just exit if this NPC already involved in an active quest
// If quest conditions are complete the quest system should pickup ending
if (QuestMachine.Instance.IsLastNPCClickedAnActiveQuestor(guild))
{
CloseWindow();
return;
}
// Get member status, including temple specific statuses
MembershipStatus status = guild.IsMember() ? MembershipStatus.Member : MembershipStatus.Nonmember;
if (guild.IsMember() && guildGroup == FactionFile.GuildGroups.HolyOrder)
{
status = (MembershipStatus)Enum.Parse(typeof(MembershipStatus), ((Temple)guild).Deity.ToString());
}
// Get the faction id for affecting reputation on success/failure
int factionId = (guildGroup == FactionFile.GuildGroups.HolyOrder || guildGroup == FactionFile.GuildGroups.KnightlyOrder) ? buildingFactionId : guildManager.GetGuildFactionId(guildGroup);
// Select a quest at random from appropriate pool
offeredQuest = GameManager.Instance.QuestListsManager.GetGuildQuest(guildGroup, status, factionId, guild.GetReputation(playerEntity), guild.Rank);
if (offeredQuest != null)
{
// Log offered quest
Debug.LogFormat("Offering quest {0} from Guild {1} affecting factionId {2}", offeredQuest.QuestName, guildGroup, offeredQuest.FactionId);
// Offer the quest to player, setting external context provider to guild if a member
if (guild.IsMember())
{
offeredQuest.ExternalMCP = guild;
}
DaggerfallMessageBox messageBox = QuestMachine.Instance.CreateMessagePrompt(offeredQuest, (int)QuestMachine.QuestMessages.QuestorOffer);
if (messageBox != null)
{
messageBox.OnButtonClick += OfferQuest_OnButtonClick;
messageBox.Show();
}
}
else
{
ShowFailGetQuestMessage();
}
}
/// <summary>
/// Get a random quest for a guild from appropriate subset.
/// </summary>
public Quest GetGuildQuest(FactionFile.GuildGroups guildGroup, MembershipStatus status, int factionId, int rep)
{
#if UNITY_EDITOR // Reload every time when in editor
LoadQuestLists();
#endif
List <QuestData> guildQuests;
if (guilds.TryGetValue(guildGroup, out guildQuests))
{
MembershipStatus tplMemb = (guildGroup == FactionFile.GuildGroups.HolyOrder && status != MembershipStatus.Nonmember) ? MembershipStatus.Member : status;
List <QuestData> pool = new List <QuestData>();
foreach (QuestData quest in guildQuests)
{
if ((status == (MembershipStatus)quest.membership || tplMemb == (MembershipStatus)quest.membership) &&
(rep >= quest.minRep || status == MembershipStatus.Nonmember) &&
(!quest.unitWildC || rep < quest.minRep + 10))
{
pool.Add(quest);
}
}
Debug.Log("Quest pool has " + pool.Count);
// Choose random quest from pool and try to parse it
if (pool.Count > 0)
{
QuestData questData = pool[UnityEngine.Random.Range(0, pool.Count)];
try
{
return(LoadQuest(questData, factionId));
}
catch (Exception ex)
{ // Log exception
DaggerfallUnity.LogMessage("Exception during quest compile: " + ex.Message, true);
}
}
}
return(null);
}
public MembershipException(MembershipStatus statusCode)
{
StatusCode = statusCode;
}
public static bool CanModerate(this MembershipStatus self)
{
return(self == MembershipStatus.Admin);
}
public IndividualInfo(String id,
String acct_id,
String lastname,
String firstname,
String middlename,
String salutation,
String email,
DateTime birthdate,
Gender gender,
String primary_contact,
String billing_street,
String billing_city,
String billing_state,
String billing_zip,
String shipping_street,
String shipping_city,
String shipping_state,
String shipping_zip,
HouseholdRole role,
String church,
String referredby,
Plan plan,
String membership_id,
String membership_no,
MembershipStatus mem_status,
DateTime membership_start_date,
String ssn,
String individual_id,
String legacy_ind_id,
DateTime membership_cancel_date,
DateTime membership_ind_start_date,
float x10k_sharing_monthly_fee)
{
strID = id;
strAccountID = acct_id;
strLastName = lastname;
strFirstName = firstname;
strMiddleName = middlename;
strSalutation = salutation;
strEmail = email;
dtBirthDate = birthdate;
IndividualGender = gender;
HouseholdPrimaryContact = primary_contact;
IndividualHouseholdRole = role;
strBillingStreetAddress = billing_street;
strBillingCity = billing_city;
strBillingState = billing_state;
strBillingZip = billing_zip;
strShippingStreetAddress = shipping_street;
strShippingCity = shipping_city;
strShippingState = shipping_state;
strShippingZip = shipping_zip;
strChurch = church;
strReferredBy = referredby;
IndividualPlan = plan;
strMembershipID = membership_id;
strMembershipNo = membership_no;
membershipStatus = mem_status;
dtMembershipStartDate = membership_start_date;
strSSN = ssn;
strIndividualID = individual_id;
strLegacyIndividualID = legacy_ind_id;
dtMembershipCancelledDate = membership_cancel_date;
dtMembershipIndStartDate = membership_ind_start_date;
X10K_Sharing_Monthly_Fee = x10k_sharing_monthly_fee;
}
/// <summary>
/// Get a random quest for a guild from appropriate subset.
/// </summary>
public Quest GetGuildQuest(FactionFile.GuildGroups guildGroup, MembershipStatus status, int factionId, int rep, int rank)
{
List <QuestData> pool = GetGuildQuestPool(guildGroup, status, factionId, rep, rank);
return(SelectQuest(pool, factionId));
}
public MembershipException(MembershipStatus status)
{
StatusCode = status;
}
public MembershipException(MembershipStatus status, string message, Exception inner)
: base(message, inner)
{
StatusCode = status;
}
public TeamDisplay(string teamName, MembershipStatus status, long Id)
{
this.TeamName = teamName;
this.Status = status;
this.Id = Id;
}
public UpdateMembershipStatusCommand(string userIdToUpdate, int teamId, MembershipStatus newStatus)
{
UserIdToUpdate = userIdToUpdate;
TeamId = teamId;
NewStatus = newStatus;
}
protected override void Seed(PICECAR.Models.ApplicationDbContext context)
{
string[] roles =
{
"Administrator",
"Secretary",
"User"
};
RoleStore <IdentityRole> roleStore = new RoleStore <IdentityRole>(context);
RoleManager <IdentityRole> roleManager = new RoleManager <IdentityRole>(roleStore);
IdentityRole identityRole;
// Add a default roles
foreach (string role in roles)
{
if (!context.Roles.Any(r => r.Name == role))
{
identityRole = new IdentityRole {
Name = role
};
roleManager.Create(identityRole);
}
}
// Adds a default account
string[,] users =
{
{ "*****@*****.**", "Admin@123", "Administrator" },
{ "*****@*****.**", "Admin@123", "Secretary" },
{ "*****@*****.**", "Admin@123", "User" }
};
string email;
for (var i = 0; i < users.Length / 3; i++)
{
email = users[i, 0];
// Add the account if it does not exist
if (!context.Users.Any(u => u.Email == email))
{
var store = new UserStore <ApplicationUser>(context);
var manager = new UserManager <ApplicationUser>(store);
var user = new ApplicationUser
{
Email = email,
UserName = email
};
manager.Create(user, users[i, 1]);
manager.AddToRole(user.Id, users[i, 2]);
var pInfo = new PersonalInfo
{
Id = user.Id,
FirstName = "First",
MiddleName = "Middle",
LastName = "Last"
};
context.PersonalInfos.AddOrUpdate(pInfo);
var mInfo = new MembershipInfo
{
Id = user.Id
};
context.MembershipInfos.AddOrUpdate(mInfo);
var profession = new Profession
{
Id = user.Id
};
context.Professions.AddOrUpdate(profession);
var membershipStatus = new MembershipStatus
{
Id = user.Id
};
context.MembershipStatuses.AddOrUpdate(membershipStatus);
var chapter = new Chapter
{
Id = user.Id
};
context.Chapters.AddOrUpdate(chapter);
context.SaveChanges();
}
}
}
public static bool IsInvited(this MembershipStatus self)
{
return(self == MembershipStatus.Invited);
}
public override int GetHashCode()
{
int hash = 1;
if (ResourceName.Length != 0)
{
hash ^= ResourceName.GetHashCode();
}
if (id_ != null)
{
hash ^= Id.GetHashCode();
}
if (readOnly_ != null)
{
hash ^= ReadOnly.GetHashCode();
}
if (name_ != null)
{
hash ^= Name.GetHashCode();
}
if (description_ != null)
{
hash ^= Description.GetHashCode();
}
if (MembershipStatus != 0)
{
hash ^= MembershipStatus.GetHashCode();
}
if (integrationCode_ != null)
{
hash ^= IntegrationCode.GetHashCode();
}
if (membershipLifeSpan_ != null)
{
hash ^= MembershipLifeSpan.GetHashCode();
}
if (sizeForDisplay_ != null)
{
hash ^= SizeForDisplay.GetHashCode();
}
if (SizeRangeForDisplay != 0)
{
hash ^= SizeRangeForDisplay.GetHashCode();
}
if (sizeForSearch_ != null)
{
hash ^= SizeForSearch.GetHashCode();
}
if (SizeRangeForSearch != 0)
{
hash ^= SizeRangeForSearch.GetHashCode();
}
if (Type != 0)
{
hash ^= Type.GetHashCode();
}
if (ClosingReason != 0)
{
hash ^= ClosingReason.GetHashCode();
}
if (AccessReason != 0)
{
hash ^= AccessReason.GetHashCode();
}
if (AccountUserListStatus != 0)
{
hash ^= AccountUserListStatus.GetHashCode();
}
if (eligibleForSearch_ != null)
{
hash ^= EligibleForSearch.GetHashCode();
}
if (eligibleForDisplay_ != null)
{
hash ^= EligibleForDisplay.GetHashCode();
}
if (userListCase_ == UserListOneofCase.CrmBasedUserList)
{
hash ^= CrmBasedUserList.GetHashCode();
}
if (userListCase_ == UserListOneofCase.SimilarUserList)
{
hash ^= SimilarUserList.GetHashCode();
}
hash ^= (int)userListCase_;
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public GroupMembersQuery WithStatus(MembershipStatus status)
{
Status = status;
return(this);
}
public TeamDisplay(string teamName, MembershipStatus status, long Id)
{
this.TeamName = teamName;
this.Status = status;
this.Id = Id;
}
private static string ErrorCodeToString(MembershipStatus createStatus) {
switch (createStatus) {
case MembershipStatus.DuplicateUserName:
return "User name already exists. Please enter a different user name.";
case MembershipStatus.DuplicateEmail:
return "A user name for that e-mail address already exists. Please enter a different e-mail address.";
case MembershipStatus.InvalidPassword:
return "The password provided is invalid. Please enter a valid password value.";
case MembershipStatus.InvalidEmail:
return "The e-mail address provided is invalid. Please check the value and try again.";
case MembershipStatus.InvalidAnswer:
return "The password retrieval answer provided is invalid. Please check the value and try again.";
case MembershipStatus.InvalidQuestion:
return "The password retrieval question provided is invalid. Please check the value and try again.";
case MembershipStatus.InvalidUserName:
return "The user name provided is invalid. Please check the value and try again.";
case MembershipStatus.ProviderError:
return "The authentication provider returned an error. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
case MembershipStatus.UserRejected:
return "The user creation request has been canceled. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
default:
return "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
}
}
public static bool IsBanned(this MembershipStatus self)
{
return(self == MembershipStatus.Banned);
}
