protected void ChangePasswordLinkButton_Click(object sender, EventArgs e)
{
ErrorLabel.Visible = false;
SuccessLabel.Visible = false;
using (PlexingFleetDataContext context = new PlexingFleetDataContext(ConnectionString))
{
var user = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterId);
if (user != null)
{
if (FormsAuthentication.HashPasswordForStoringInConfigFile(OldPasswordTextBox.Text, "md5") == user.Password)
{
if (NewPasswordTextBox.Text != ConfirmPasswordTextBox.Text || NewPasswordTextBox.Text.Length < 6)
{
ErrorLabel.Visible = true;
return;
}
user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(NewPasswordTextBox.Text, "md5");
context.SubmitChanges();
SuccessLabel.Visible = true;
return;
}
else
{
ErrorLabel.Visible = true;
}
}
}
}
protected void PlexGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditPlex")
{
int plexId = e.CommandArgument.ToString().ToInt();
Response.Redirect(string.Format("{0}?PlexId={1}", PageReferrer.Page_FC_SelectMembers, plexId));
}
else if (e.CommandName == "DeletePlex")
{
int plexId = e.CommandArgument.ToString().ToInt();
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
Plex p = context.Plexes.FirstOrDefault(x => x.PlexId == plexId);
if (p != null)
{
context.Plexes.DeleteOnSubmit(p);
context.SubmitChanges();
}
FillPlexes();
}
}
}
private void UpdateFleet()
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
if (PlexId.HasValue)
{
Plex plex = context.Plexes.FirstOrDefault(x => x.PlexId == PlexId);
plex.Participants = GetPilots();
}
else
{
Fleet fleet = context.Fleets.FirstOrDefault(x => x.FcId == CharacterId);
if (fleet == null)
{
fleet = new Fleet()
{
FcId = CharacterId, Participants = GetPilots()
};
context.Fleets.InsertOnSubmit(fleet);
}
else
{
fleet.Participants = GetPilots();
}
}
context.SubmitChanges();
}
}
protected void UsersGridView_RowCommand(object sender, CommandEventArgs e)
{
if (e.CommandName == "EditCharacter")
{
Response.Redirect(string.Format("{0}?CharacterId={1}&Origin={2}", PageReferrer.Page_Admin_EditUser, e.CommandArgument.ToString(), GetOrigin()));
}
else if (e.CommandName == "DeleteCharacter")
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(ConnectionString))
{
int characterId = e.CommandArgument.ToString().ToInt();
var roles = context.PlexUserRoles.FirstOrDefault(x => x.CharacterId == characterId);
if (roles != null && roles.Roles.Contains("Super"))
{
return;
}
context.PlexUsers.DeleteOnSubmit(context.PlexUsers.FirstOrDefault(x => x.CharacterId == characterId));
context.SubmitChanges();
DoSearch(SearchTextBox.Text);
}
}
}
protected void AddPlexLinkButton_Click(object sender, EventArgs e)
{
int plexInfoId = PlexInfoDropDownList.SelectedValue.ToInt();
Plex plex;
if (PlexCorpDropDownList.SelectedValue.ToInt() != CorpId)
{
plex = new Plex()
{
FCId = CharacterId, PlexInfoId = plexInfoId, PlexingDate = DateTime.UtcNow, PlexingPeriodId = GetPlexingPeriodId(PlexCorpDropDownList.SelectedValue.ToInt()), Participants = GetPilots(), CorpId = int.Parse(PlexCorpDropDownList.SelectedValue)
};
}
else
{
plex = new Plex()
{
FCId = CharacterId, PlexInfoId = plexInfoId, PlexingDate = DateTime.UtcNow, PlexingPeriodId = PlexingPeriodId, Participants = GetPilots(), CorpId = int.Parse(PlexCorpDropDownList.SelectedValue)
};
}
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
context.Plexes.InsertOnSubmit(plex);
context.SubmitChanges();
}
FillPlexes();
}
protected void EndPeriodLinkButton_Click(object sender, EventArgs e)
{
CalculatePayout(true);
using (PlexingFleetDataContext context = new PlexingFleetDataContext(ConnectionString))
{
PlexingPeriod period = context.PlexingPeriods.FirstOrDefault(x => x.PlexingPeriodId == PlexingPeriodId);
if (period != null)
{
period.ToDate = DateTime.Now;
}
context.SubmitChanges();
ShowEndPeriodButton(false);
}
}
private void CalculatePayout(bool savePayout)
{
double payout = PayoutTextBox.Text.ToDouble() * 1000000;
double percent = CorpTaxTextBox.Text.ToDouble();
double payoutAfterTax = payout * (1 - (percent / 100));
double tax = (payout - payoutAfterTax);
double points = GetPoints(PlexingPeriodId);
IskPerPoint = payout / points;
IskPerPointAfterTax = payoutAfterTax / points;
TotalPayoutLabel.Text = FormatMillions(Math.Round((payoutAfterTax / 1000000), 2).ToString());
TaxLabel.Text = FormatMillions(Math.Round(tax / 1000000, 0).ToString());
IskPerPointLabel.Text = FormatMillions(Math.Round(IskPerPoint / 1000000, 3).ToString());
IskPerPointAfterTaxLabel.Text = FormatMillions(Math.Round(IskPerPointAfterTax / 1000000, 3).ToString());
TaxUpdatePanel.Update();
TotalPayOutUpdatePanel.Update();
IskPerPointAfterTaxUpdatePanel.Update();
if (savePayout)
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(ConnectionString))
{
PlexingPeriod period = context.PlexingPeriods.FirstOrDefault(x => x.PlexingPeriodId == PlexingPeriodId);
if (period != null)
{
period.PayoutSum = payout;
period.CorpTax = CorpTaxTextBox.Text.ToDouble();
period.Points = points;
period.IskPerPoint = IskPerPoint;
period.IskPerPointAfterTax = IskPerPointAfterTax;
context.SubmitChanges();
}
}
}
}
private bool CreateCorp(PlexingFleetDataContext context)
{
Rule rule = context.Rules.FirstOrDefault(x => x.Id.Value == CorpId);
if (rule == null)
{
rule = new Rule()
{
Id = CorpId,
RuleName = CorpName,
Allowed = true,
};
context.Rules.InsertOnSubmit(rule);
}
else
{
if (rule.Allowed.HasValue && !rule.Allowed.Value)
{
return(false);
}
}
Corp corp = new Corp()
{
CorpId = this.CorpId,
CorpName = this.CorpName,
CorpTag = this.CorpTickerTextBox.Text,
AllianceId = this.AllianceId == 0 ? -1 : this.AllianceId,
AllianceName = this.AllianceName,
AllianceTag = this.AllianceTickerTextBox.Text,
Enabled = true
};
context.Corps.InsertOnSubmit(corp);
context.SubmitChanges();
return(true);
}
protected void UpdateLinkButton_Click(object sender, EventArgs e)
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(ConnectionString))
{
PlexUser user = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterIdLabel.Text.ToInt());
user.Enabled = !BannedCheckBox.Checked;
if (user.CorpId != CorporationDropDownList.SelectedValue.ToInt())
{
var corp = context.Corps.FirstOrDefault(x => x.CorpId == CorporationDropDownList.SelectedValue.ToInt());
if (corp != null)
{
user.CorpId = corp.CorpId;
user.AllianceId = corp.AllianceId;
user.CorpName = corp.CorpName;
user.AllianceName = corp.AllianceName;
}
}
if (NewPasswordTextBox.Text.Trim() != string.Empty && NewPasswordTextBox.Text == ConfirmPasswordTextBox.Text)
{
user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(NewPasswordTextBox.Text, "md5");
}
PlexUserRole role = context.PlexUserRoles.FirstOrDefault(x => x.CharacterId == CharacterIdLabel.Text.ToInt());
SetPermission(context, role, SuperAdminCheckBox.Checked, "Super");
SetPermission(context, role, AdministratorCheckBox.Checked, "Admin");
SetPermission(context, role, AllianceCheckBox.Checked, "Alliance");
SetPermission(context, role, CorporationCheckBox.Checked, "Corporation");
context.SubmitChanges();
}
Response.Redirect(string.Format("{0}?{1}=1", PageReferrer.Page_Admin_Users, Origin));
}
protected void PlexingPeriodInfoGridView_RowCommand(object sender, CommandEventArgs e)
{
if (e.CommandName == "EditPlex")
{
Response.Redirect(string.Format("{0}?PlexId={1}&ReturnUrl={2}&PlexingPeriodId={3}&CharacterName={4}", PageReferrer.Page_FC_SelectMembers, e.CommandArgument.ToString(), PageReferrer.Page_User_PlexingPeriod, PlexingPeriodId, CharName));
}
else if (e.CommandName == "DeletePlex")
{
int plexId = e.CommandArgument.ToString().ToInt();
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
Plex p = context.Plexes.FirstOrDefault(x => x.PlexId == plexId);
if (p != null)
{
p.Participants = p.Participants.Replace(string.Format("{0}, ", CharName), "").Replace(string.Format(", {0}", CharName), "");
p.Participants = p.Participants.Replace(CharName, "");
if (string.IsNullOrEmpty(p.Participants.Trim()))
{
context.Plexes.DeleteOnSubmit(p);
}
context.SubmitChanges();
}
if (SelectedDate.HasValue)
{
FillPlexingPeriodDateData(PlexingPeriodId, SelectedDate.Value);
}
else
{
FillPlexingPeriodData(PlexingPeriodId);
}
}
}
}
protected void RegisterLinkButton_Click(object sender, EventArgs e)
{
PasswordMismatchLabel.Visible = false;
if (PasswordTextBox.Text != ConfirmPasswordTextBox.Text || PasswordTextBox.Text.Trim().Length < 6)
{
PasswordMismatchLabel.Visible = true;
return;
}
else
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
PlexUser plexUser = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterId);
if (plexUser != null)
{
ShowRegistryInformation(false, "Your character have already been registered.");
//User already exists, dont register again
return;
}
else
{
plexUser = new PlexUser();
};
plexUser.CharacterId = CharacterId;
plexUser.CharacterName = CharacterName;
plexUser.CorpId = CorpId;
plexUser.CorpName = CorpName;
plexUser.AllianceId = AllianceId;
plexUser.AllianceName = AllianceName;
plexUser.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(PasswordTextBox.Text, "md5");
plexUser.Enabled = true;
context.PlexUsers.InsertOnSubmit(plexUser);
Corp corp = context.Corps.FirstOrDefault(x => x.CorpId == CorpId);
//Check to see if the person registring belongs to a corp that have not previously been added
if (corp == null)
{
corp = new Corp()
{
CorpId = CorpId,
CorpName = CorpName,
AllianceId = AllianceId,
AllianceName = AllianceName,
Enabled = false
};
context.Corps.InsertOnSubmit(corp);
}
context.SubmitChanges();
Response.Redirect(PageReferrer.Page_Login);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoginButton.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
if (EveTrusted)
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
var user = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterId);
if (user != null)
{
UsernameTextBox.Text = CharacterName;
if (user.AllianceId != AllianceId || user.CorpId != CorpId)
{
Corp corp = context.Corps.FirstOrDefault(x => x.CorpId == CorpId);
if (corp == null)
{
Response.Redirect(PageReferrer.Page_Anonymous_AccessRequest);
}
//If the user have switched alliance and/or corporation update the database with the new information.
user.AllianceId = AllianceId;
user.AllianceName = AllianceName;
user.CorpId = CorpId;
user.CorpName = CorpName;
//corp = context.Corps.FirstOrDefault(x => x.CorpId == CorpId);
//The user have switched to a new corp that have not been registered yet
if (corp == null)
{
corp = new Corp();
corp.CorpId = CorpId;
corp.CorpName = CorpName;
corp.AllianceId = AllianceId;
corp.AllianceName = AllianceName;
corp.CorpTag = CorpName.Length > 5 ? CorpName.Substring(0, 5) : CorpName;
corp.AllianceTag = AllianceName.Length > 5 ? AllianceName.Substring(0, 5) : AllianceName;
context.Corps.InsertOnSubmit(corp);
}
context.SubmitChanges();
}
ShowLogin(true);
return;
}
else
{
Response.Redirect(PageReferrer.Page_Register);
}
}
}
else
{
RememberMeCheckBox.Visible = false;
RememberMeCheckBox.Checked = false;
//ShowLogin(false);
}
}
}
protected void PlexingPeriodInfoGridView_RowCommand(object sender, CommandEventArgs e)
{
if (e.CommandName == "EditPlex")
{
Response.Redirect(string.Format("{0}?PlexId={1}&ReturnUrl={2}&PlexingPeriodId={3}&CharacterName={4}", PageReferrer.Page_FC_SelectMembers, e.CommandArgument.ToString(), PageReferrer.Page_User_PlexingPeriod, PlexingPeriodId, CharName));
}
else if (e.CommandName == "DeletePlex")
{
int plexId = e.CommandArgument.ToString().ToInt();
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
Plex p = context.Plexes.FirstOrDefault(x => x.PlexId == plexId);
if (p != null)
{
p.Participants = p.Participants.Replace(string.Format("{0}, ", CharName), "").Replace(string.Format(", {0}", CharName), "");
p.Participants = p.Participants.Replace(CharName, "");
if (string.IsNullOrEmpty(p.Participants.Trim()))
context.Plexes.DeleteOnSubmit(p);
context.SubmitChanges();
}
if (SelectedDate.HasValue)
{
FillPlexingPeriodDateData(PlexingPeriodId, SelectedDate.Value);
}
else
{
FillPlexingPeriodData(PlexingPeriodId);
}
}
}
}
private void CreateUser(PlexingFleetDataContext context, bool newCorp)
{
PlexUser user = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterId);
if (user == null)
{
user = new PlexUser()
{
CharacterId = this.CharacterId,
CharacterName = this.CharacterName,
AllianceId = this.AllianceId,
CorpId = this.CorpId,
AllianceName = this.AllianceName,
CorpName = this.CorpName,
Password = FormsAuthentication.HashPasswordForStoringInConfigFile(PasswordTextBox.Text.Trim(), "md5"),
Enabled = true
};
context.PlexUsers.InsertOnSubmit(user);
if (newCorp)
{
PlexUserRole role = new PlexUserRole()
{
CharacterId = this.CharacterId,
Roles = "Corporation"
};
context.PlexUserRoles.InsertOnSubmit(role);
}
}
else
{
//Only do this if the user enabled.
if (user.Enabled)
{
user.AllianceId = this.AllianceId;
user.CorpId = this.CorpId;
user.AllianceName = this.AllianceName;
user.CorpName = this.CorpName;
if (newCorp)
{
var userRoles = context.PlexUserRoles.FirstOrDefault(x => x.CharacterId == CharacterId);
//If no roles were found then add the one registring the corp admin rights for that corp.
if (userRoles == null)
{
PlexUserRole role = new PlexUserRole();
role.CharacterId = CharacterId;
role.Roles = "Corporation";
context.PlexUserRoles.InsertOnSubmit(role);
}
else
{
//Only add the corporation role if it is missing.
if (!userRoles.Roles.Contains("Corporation"))
{
userRoles.Roles += ",Corporation";
}
}
}
}
else
{
user.AllianceId = this.AllianceId;
user.CorpId = this.CorpId;
user.AllianceName = this.AllianceName;
user.CorpName = this.CorpName;
}
}
context.SubmitChanges();
}
protected void RegisterLinkButton_Click(object sender, EventArgs e)
{
PasswordMismatchLabel.Visible = false;
if (PasswordTextBox.Text != ConfirmPasswordTextBox.Text || PasswordTextBox.Text.Trim().Length < 6)
{
PasswordMismatchLabel.Visible = true;
return;
}
else
{
using (PlexingFleetDataContext context = new PlexingFleetDataContext(WebConfigurationManager.ConnectionStrings["PlexManagerConnectionString"].ConnectionString))
{
PlexUser plexUser = context.PlexUsers.FirstOrDefault(x => x.CharacterId == CharacterId);
if (plexUser != null)
{
ShowRegistryInformation(false, "Your character have already been registered.");
//User already exists, dont register again
return;
}
else
{
plexUser = new PlexUser();
};
plexUser.CharacterId = CharacterId;
plexUser.CharacterName = CharacterName;
plexUser.CorpId = CorpId;
plexUser.CorpName = CorpName;
plexUser.AllianceId = AllianceId;
plexUser.AllianceName = AllianceName;
plexUser.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(PasswordTextBox.Text, "md5");
plexUser.Enabled = true;
context.PlexUsers.InsertOnSubmit(plexUser);
Corp corp = context.Corps.FirstOrDefault(x => x.CorpId == CorpId);
//Check to see if the person registring belongs to a corp that have not previously been added
if (corp == null)
{
corp = new Corp()
{
CorpId = CorpId,
CorpName = CorpName,
AllianceId = AllianceId,
AllianceName = AllianceName,
Enabled = false
};
context.Corps.InsertOnSubmit(corp);
}
context.SubmitChanges();
Response.Redirect(PageReferrer.Page_Login);
}
}
}