public void DeleteBoats(int userChoice, int userBoatChoice)
{
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
sqlConnection.DeleteBoatSQL(showBoatQuery);
string deleteBoatQuery = "CALL `deleteBoat`" + "(" + userBoatChoice + ");";
sqlConnection.DeleteBoatSQL(deleteBoatQuery);
}
public static void EditBoats()
{
ShowUser.ShowUsers();
Console.WriteLine("");
Console.Write("Vilken medlem vill du ändra en båt hos: ");
int userChoice = int.Parse(Console.ReadLine());
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
SQLconnection.DeleteBoatSQL(showBoatQuery);
Console.WriteLine("Vilken båt vill ändra..?");
int userBoatChoice = int.Parse(Console.ReadLine());
Console.WriteLine("Ange nya båtvärden..");
Console.WriteLine("Ny båtlängd:");
string newBoatLength = Console.ReadLine();
Console.WriteLine("Ange en ny båttyp:");
Console.WriteLine("1.Segelbåt 2.Motorseglare 3.Motorbåt 4.Kajak/Kanot 5.Övrigt");
string newBoatype = Console.ReadLine();
string editBoatQuery = "UPDATE boat SET boattypeID='" + newBoatype + "'" + ", boatlength='" + newBoatLength + "'" + " WHERE boatID='" + userBoatChoice + "'";
SQLconnection.con(editBoatQuery);
Console.Clear();
Presentation.BoatIsEdited();
Program.ContinueOnKeyPressed();
}
public void EditBoats(int userChoice, int userBoatChoice, string newBoatLength, string newBoatype)
{
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
sqlConnection.DeleteBoatSQL(showBoatQuery);
string editBoatQuery = "UPDATE boat SET boattypeID='" + newBoatype + "'" + ", boatlength='" + newBoatLength + "'" + " WHERE boatID='" + userBoatChoice + "'";
sqlConnection.AddUserAndEditBoatSQL(editBoatQuery);
}
public static void DeleteUsers()
{
Presentation.DeletePresentation();
ShowUser.ShowUsers();
Console.WriteLine("Vilken användare vill du ta bort?: ");
int deleteChoice = int.Parse(Console.ReadLine());
string deleteMemberQuery = "CALL `deleteMember`" + "(" + deleteChoice + ");";
SQLconnection.DeleteBoatSQL(deleteMemberQuery);
Console.WriteLine("Nu är medlemmen borttagen");
}
public static void DeleteUsers()
{
Presentation.DeletePresentation();
ShowUser.ShowUsers();
Console.WriteLine("");
Console.Write("Vilken användare vill du ta bort?: ");
int deleteChoice = int.Parse(Console.ReadLine());
string deleteMemberQuery = "CALL `deleteMember`" + "(" + deleteChoice + ");";
SQLconnection.DeleteBoatSQL(deleteMemberQuery);
Console.Clear();
Presentation.UserIsDeleted();
Program.ContinueOnKeyPressed();
}
public static void DeleteBoats()
{
ShowUser.ShowUsers();
Console.WriteLine("Vilken medlem vill du ta bort en båt hos..?");
int userChoice = int.Parse(Console.ReadLine());
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
SQLconnection.DeleteBoatSQL(showBoatQuery);
Console.WriteLine("Vilken båt vill du ta bort..?");
int userBoatChoice = int.Parse(Console.ReadLine());
string deleteBoatQuery = "CALL `deleteBoat`" + "(" + userBoatChoice + ");";
SQLconnection.DeleteBoatSQL(deleteBoatQuery);
Console.WriteLine("Nu är din båt borttagen din jävla sexiga hukk!");
}
public static void DeleteBoats()
{
ShowUser.ShowUsers();
Console.WriteLine("Vilken medlem vill du ta bort en båt hos..?");
int userChoice = int.Parse(Console.ReadLine());
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
SQLconnection.DeleteBoatSQL(showBoatQuery);
Console.WriteLine("Vilken båt vill du ta bort..?");
int userBoatChoice = int.Parse(Console.ReadLine());
string deleteBoatQuery = "CALL `deleteBoat`" + "(" + userBoatChoice + ");";
SQLconnection.DeleteBoatSQL(deleteBoatQuery);
Console.Clear();
Presentation.BoatIsDeleted();
Program.ContinueOnKeyPressed();
}
public void DeleteUsers(int deleteChoice)
{
string deleteMemberQuery = "CALL `deleteMember`" + "(" + deleteChoice + ");";
sqlConnection.DeleteBoatSQL(deleteMemberQuery);
}