private void onClick(object sender, EventArgs e)
{
string s = (sender as Button).ID;
DatabaseSingleton.getInstance().DeleteFavour(s);
Response.Redirect("User.aspx");
}
protected void Create_Click(object sender, EventArgs e)
{
string curEmail = DatabaseSingleton.getInstance().getEmail();
string name = favourname.Text;
if (curEmail == null)
{
WarnLog.Visible = true;
WarnLog.Text = "You need to log in to create a favour";
}
else if (DatabaseSingleton.getInstance().favourExists(curEmail, name))
{
WarnLog.Visible = true;
WarnLog.Text = "This favour already exists";
}
else
{
WarnLog.Visible = false;
string desc = Descr.Text;
string cat = Category.Text;
System.Diagnostics.Debug.WriteLine(DatabaseSingleton.getInstance().CreateFavour(curEmail, name, 0, cat, desc, null));
favourname.Text = "";
Descr.Text = "";
}
}
public async Task RunAsync()
{
DiscordClient client = new DiscordClient(new DiscordConfiguration {
LogLevel = LogLevel.Info,
Token = _shibaConfig.Token,
TokenType = TokenType.Bot,
UseInternalLogHandler = true
});
CommandsNextModule commandsNext = client.UseCommandsNext(new CommandsNextConfiguration {
CaseSensitive = false,
EnableDefaultHelp = false,
EnableMentionPrefix = true,
CustomPrefixPredicate = GetPrefixPositionAsync
});
client.MessageCreated -= commandsNext.HandleCommandsAsync;
commandsNext.RegisterCommands(typeof(Main).Assembly);
new CommandErroredEvent(ref client);
new MessageCreateEvent(ref client);
DatabaseSingleton.Connect(_shibaConfig);
await client.ConnectAsync();
await Task.Delay(-1);
}
protected void Page_Load(object sender, EventArgs e)
{
List <string> details = DatabaseSingleton.getInstance().getUserDetails();
fullName.Text = details.ElementAt(0);
address.Text = details.ElementAt(1);
postcode.Text = details.ElementAt(2);
}
protected void ChangeDets_Click(object sender, EventArgs e)
{
string Name = fullName.Text;
string Address = address.Text;
string Postcode = postcode.Text;
DatabaseSingleton.getInstance().editDetails(Name, Address, Postcode);
}
private void refreshTable()
{
var planRideDetails = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideStatus_.Contains("Waiting") || x.RideStatus_.Contains("In Progress")).ToList();
EventTable.ItemsSource = planRideDetails;
var rideDetails = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideStatus_.Equals("Actived")).ToList();
EventTable.ItemsSource = rideDetails;
}
private void refreshTable()
{
var data = (from x in DatabaseSingleton.GetInstance().Advertisements.Where(x => x.AdvertisementStatus != "Deleted")
select new {
AdvertisementID = x.AdvertisementID,
AdvertisementDescription = x.AdvertisementDescription,
AdvertisementDeadline = x.Deadline,
EmployeeID = x.EmployeeID
}).ToList();
adsTable.ItemsSource = data;
}
protected void Button1_Click(object sender, EventArgs e)
{
List <string>[] favourslist;
if (County.Text == "All")
{
favourslist = DatabaseSingleton.getInstance().DisplayFavours();
}
else
{
favourslist = DatabaseSingleton.getInstance().DisplayCountyFavours(County.Text);
}
displayData(favourslist);
}
private void onClick(object sender, EventArgs e)
{
if (DatabaseSingleton.getInstance().getEmail() != null)
{
LogWarn.Visible = false;
string s = (sender as Button).ID;
int comma = s.IndexOf(",");
DatabaseSingleton.getInstance().claimFavour(s.Substring(comma + 1), s.Substring(0, comma), true);
Response.Redirect("Default.aspx");
}
else
{
LogWarn.Visible = true;
}
}
protected void CreateUser_Click(object sender, EventArgs e)
{
switch (DatabaseSingleton.getInstance().Register(Email.Text, Password.Text, Address.Text, Postcode.Text, Name.Text, County.Text))
{
case "success":
EmailWarn.Visible = false;
Response.Redirect("../Welcome.aspx");
break;
case "existingemail":
EmailWarn.Text = "That email is already in use";
EmailWarn.Visible = true;
break;
default:
EmailWarn.Text = "Sorry we encountered a problem with our servers";
EmailWarn.Visible = true;
break;
}
}
private void displayCurrentUserFavours()
{
if (DatabaseSingleton.getInstance().getEmail() != null)
{
Table favours = new Table();
List <string>[] favourslist = DatabaseSingleton.getInstance().CurrentUserFavours();
for (int i = 0; i < favourslist[0].Count; i++)
{
TableRow fav = new TableRow();
TableCell a = new TableCell();
a.Text = favourslist[0].ElementAt(i);
fav.Cells.Add(a);
TableCell b = new TableCell();
b.Text = favourslist[1].ElementAt(i);
fav.Cells.Add(b);
TableCell c = new TableCell();
c.Text = favourslist[2].ElementAt(i);
fav.Cells.Add(c);
TableCell delete = new TableCell();
Button btn = new Button();
btn.Text = "Delete";
btn.ID = favourslist[0].ElementAt(i);
btn.Click += new System.EventHandler(onClick);
delete.Controls.Add(btn);
fav.Cells.Add(delete);
favours.Rows.Add(fav);
}
userFavours.Controls.Add(favours);
}
else
{
Response.Redirect("Account/Login");
}
}
protected void LogIn(object sender, EventArgs e)
{
switch (DatabaseSingleton.getInstance().Login(Email.Text, Password.Text))
{
case "credfail":
DatabaseSingleton.getInstance().Logout();
LogWarn.Text = "Your email or password combination was incorrect.";
LogWarn.Visible = true;
break;
case "confail":
DatabaseSingleton.getInstance().Logout();
LogWarn.Text = "Sorry we encountered a problem with the server.";
LogWarn.Visible = true;
break;
default:
LogWarn.Visible = false;
Response.Redirect("../Welcome.aspx");
break;
}
}
private void ViewAllRide_Checked(object sender, RoutedEventArgs e)
{
var rideDetails = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideStatus_.Equals("Actived")).ToList();
EventTable.ItemsSource = rideDetails;
}
private void RefreshTable()
{
IngredientTable.ItemsSource = DatabaseSingleton.GetInstance().Ingredients.Where(x => x.IngredientStatus != "Deleted").ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
displayData(DatabaseSingleton.getInstance().getUserLeaders());
}
private void LoadTableData()
{
var attractionDetails = DatabaseSingleton.GetInstance().Attractions.ToList();
attractionTable.ItemsSource = attractionDetails;
}
protected void mech_Click(object sender, ImageClickEventArgs e)
{
List <string>[] favourslist = DatabaseSingleton.getInstance().DisplayCatFavours(County.Text, "Mechanical");
displayData(favourslist);
}
private void RefreshTable()
{
EventTable.ItemsSource = DatabaseSingleton.GetInstance().FundRequests.Where(x => x.FundStatus.Contains("Pending")).ToList();
}
private void refreshTable()
{
var data = DatabaseSingleton.GetInstance().TicketTransactions.Where(x => x.TransactionStauts != "Deleted").ToList();
TicketTransactionTable.ItemsSource = data;
}
private void refreshTableResponse()
{
var data = DatabaseSingleton.GetInstance().FundRequests.ToList();
EventTable.ItemsSource = data;
}
private void refreshTablePurchasing()
{
var data = DatabaseSingleton.GetInstance().PurchaseRequests.ToList();
EventTable.ItemsSource = data;
}
private void ViewRidePlan_Checked(object sender, RoutedEventArgs e)
{
var planRideDetails = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideStatus_.Contains("Waiting") || x.RideStatus_.Contains("In Progress")).ToList();
EventTable.ItemsSource = planRideDetails;
}
protected void Page_Load(object sender, EventArgs e)
{
List <string>[] favourslist = DatabaseSingleton.getInstance().DisplayFavours();
displayData(favourslist);
}
private void refreshTableRide()
{
var requestRideDetails = DatabaseSingleton.GetInstance().RequestRides.Where(x => x.RideStatus_.Contains("Pending")).ToList();
EventTable.ItemsSource = requestRideDetails;
}
private void AttractionRadioButton_Checked(object sender, RoutedEventArgs e)
{
var requestAttractionDetails = DatabaseSingleton.GetInstance().RequestAttractions.ToList();
EventTable.ItemsSource = requestAttractionDetails;
}
private void LoadTableData()
{
var rideDetails = DatabaseSingleton.GetInstance().Rides.ToList();
rideTable.ItemsSource = rideDetails;
}
private void refreshTableAttraction()
{
var requestAttractionDetails = DatabaseSingleton.GetInstance().RequestAttractions.Where(x => x.AttractionStatus.Contains("Pending")).ToList();
EventTable.ItemsSource = requestAttractionDetails;
}
protected void Page_Load(object sender, EventArgs e)
{
WelcomeText.Text = DatabaseSingleton.getInstance().getUserWelcome();
}
