public static void addUser()
{
AddInformation addInformation = new AddInformation();
string fname;
string lname;
int pNumber;
Presentation.Adduser();
Console.Write("Skriv in förnamn: ");
fname = Console.ReadLine();
Console.Write("Skriv in efternamn: ");
lname = Console.ReadLine();
do
{
Console.Write("Skriv in personnummer: ");
} while (!int.TryParse(Console.ReadLine(), out pNumber) || pNumber < 0);
//string addUserQuery = "INSERT INTO member (firstname, lastname, socialsecuritynumber) VALUES(" + "'" + fname + "'" + "," + "'" + lname + "'" + "," + "'" + pNumber + "'" + ")";
string addUserQuery = "INSERT INTO member (firstname, lastname, socialsecuritynumber) VALUES ( " + "'" + fname + "'" + "," + "'" + lname + "'" + "," + "'" + pNumber + "'" + ")";
SQLconnection.con(addUserQuery);
Console.Clear();
Presentation.UserIsAdded();
Program.ContinueOnKeyPressed();
Program.Menu();
}
public static void EditUserInfo()
{
AddInformation addInfo = new AddInformation();
Presentation.EditUsers();
ShowUser.ShowUsers();
Console.WriteLine("Välj vem du vill editera: ");
string userEdit = Console.ReadLine();
Console.Write("Skriv in ett nytt förnamn: ");
string fName = Console.ReadLine();
Console.Write("Skriv in ett nytt efternamn: ");
string lName = Console.ReadLine();
Console.Write("Skriv in ett nytt personnummer: ");
string pNumber = Console.ReadLine();
string editUserQuery = "UPDATE member SET firstname='" + fName + "'" + ", lastname='" + lName + "'" + ", socialsecuritynumber= '" + pNumber + "'" + " WHERE memberID='" + userEdit + "'";
SQLconnection.addBoatconn(editUserQuery);
Console.WriteLine("Medlemen är ändrad");
Console.ReadLine();
}
public static void AddBoatToMember()
{
AddInformation addInfo = new AddInformation();
Presentation.EditUsers();
Console.WriteLine("Vill du lägga till båt? J/N");
string userInput = Console.ReadLine();
if (userInput == "J" || userInput == "j")
{
ShowUser.ShowUsers();
Console.WriteLine("Hos vem?");
int userChoice = int.Parse(Console.ReadLine());
Console.WriteLine("Hur lång är båten ");
string boatLength = Console.ReadLine();
Console.WriteLine("Vad vill du lägga till för båt?");
Console.WriteLine("1.Segelbåt 2.Motorseglare 3.Motorbåt 4.Kajak/Kanot 5.Övrigt");
string boatType = Console.ReadLine();
string addUserQuery = "INSERT INTO boat (memberID, boattypeID, boatlength) VALUES ( " + "'" + userChoice + "'" + "," + "'" + boatType + "'" + "," + "'" + boatLength + "'" + ")";
SQLconnection.addBoatconn(addUserQuery);
Console.WriteLine("Båten tillagd");
Console.ReadLine();
//Skriv in "WHERE USER = userChoice för att lägga till eller ersätta en båt.
}
}
public static void SpecificUserInfo()
{
AddInformation addInfo = new AddInformation();
Console.Write("Vill du visa ytterligare information om användarna? j / n: ");
string userChoice = (Console.ReadLine());
if (userChoice == "j" || userChoice == "J")
{
int specificUser = Program.Index("Välj vem du vill visa mer information om: ");
//int SelectedUser = int.Parse(Console.ReadLine());
Console.WriteLine("------------------");
Console.WriteLine("Användare");
Console.WriteLine("------------------");
Console.WriteLine("Förnamn: {0}", addInfo.FirstNameList[specificUser]);
Console.WriteLine("Efteramn: {0}", addInfo.LastNameList[specificUser]);
Console.WriteLine("Personnummer: {0}", addInfo.SocialSecurityNumber[specificUser]);
Console.WriteLine("Medlemsnummer: {0}", addInfo.IDNumber[specificUser]);
Console.WriteLine("Båttyp: {0}", addInfo.BoatTypeList[specificUser]);
Console.WriteLine("Båtlängd: {0}", addInfo.BoatLengthList[specificUser]);
Program.ContinueOnKeyPressed();
Console.Clear();
}
else
{
Console.Clear();
Program.Menu();
}
}
public static void ShowCompleteUser()
{
AddInformation addInfo = new AddInformation();
string callProcedure = "CALL `memberlist`();";
SQLconnection.Procedure(callProcedure);
}
//Metod som används för att kontrollera att avändaren inte skriver in fel saker i programmet vid val
public static int Index(string str)
{
AddInformation addInfo = new AddInformation();
int index;
do
{
Console.Write(str);
} while (!int.TryParse(Console.ReadLine(), out index) || index < 0 || index > addInfo.FirstNameList.Count - 1);
return(index);
}