protected void gvShareKeys_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e == null)
{
throw new ArgumentNullException(nameof(e));
}
ShareKey sk = ShareKey.ShareKeyWithID(e.Keys[0].ToString());
if (sk == null)
{
throw new InvalidOperationException("Unknown key: " + e.Keys[0].ToString());
}
sk.Name = (string)e.NewValues["Name"] ?? String.Empty;
sk.CanViewCurrency = (bool)e.NewValues["CanViewCurrency"];
sk.CanViewTotals = (bool)e.NewValues["CanViewTotals"];
sk.CanViewFlights = (bool)e.NewValues["CanViewFlights"];
sk.CanViewAchievements = (bool)e.NewValues["CanViewAchievements"];
sk.CanViewVisitedAirports = (bool)e.NewValues["CanViewVisitedAirports"];
if (sk.FCommit())
{
gvShareKeys.EditIndex = -1;
RefreshSharekeys();
}
else
{
e.Cancel = true;
}
}
protected void btnCreateShareLink_Click(object sender, EventArgs e)
{
ShareKey sk = new ShareKey(Page.User.Identity.Name)
{
Name = txtShareLinkName.Text,
CanViewCurrency = ckShareLinkCurrency.Checked,
CanViewFlights = ckShareLinkFlights.Checked,
CanViewTotals = ckShareLinkTotals.Checked,
CanViewAchievements = ckShareLinkAchievements.Checked,
CanViewVisitedAirports = ckShareLinkAirports.Checked
};
try
{
sk.FCommit();
txtShareLinkName.Text = string.Empty;
ckShareLinkCurrency.Checked = ckShareLinkFlights.Checked = ckShareLinkTotals.Checked = ckShareLinkAchievements.Checked = ckShareLinkAirports.Checked = true;
gvShareKeys.EditIndex = -1;
RefreshSharekeys();
}
catch (MyFlightbookValidationException ex)
{
lblShareKeyErr.Text = ex.Message;
}
}
/// <summary>
/// Returns a sharekey with the specified ID (guid). CAN RETURN NULL IF NOT FOUND
/// </summary>
/// <param name="szID">The id of the sharekey to find</param>
/// <returns>The sharekey, or null</returns>
public static ShareKey ShareKeyWithID(string szID)
{
DBHelper dbh = new DBHelper("SELECT * FROM sharekeys WHERE GUID=?guid");
ShareKey sk = null;
dbh.ReadRow(
(comm) => { comm.Parameters.AddWithValue("guid", szID); },
(dr) => { sk = new ShareKey(dr); });
return(sk);
}
protected void gvShareKeys_RowCommand(object sender, CommandEventArgs e)
{
if (e == null)
{
throw new ArgumentNullException(nameof(e));
}
if (String.Compare(e.CommandName, "_Delete", StringComparison.OrdinalIgnoreCase) == 0)
{
ShareKey sk = ShareKey.ShareKeyWithID(e.CommandArgument.ToString());
if (sk != null)
{
sk.FDelete();
RefreshSharekeys();
}
}
}
protected void RefreshSharekeys()
{
gvShareKeys.DataSource = ShareKey.ShareKeysForUser(Page.User.Identity.Name);
gvShareKeys.DataBind();
}