public static void ShowCustomer()
{
Console.WriteLine("Hvilken kunde vil du se? (Vælg kunde nummer)");
int CustomerNumber = Convert.ToInt32(Console.ReadLine());
SQLCon.SelectCustomer("Select * from customer where id =(" + CustomerNumber + ")");
}
public static void Create()
{
Console.WriteLine("Vælg den kundes kundeNr du vil tilføje en bil til");
int idChoice = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Indtast bilens model");
string modelIN = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
Console.WriteLine("Indtast bilens mærke");
string brandIN = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
Console.WriteLine("Hvad er bilens registrerings nummer?");
string regIN = ErrorHandling.IsRegValid(Console.ReadLine());
Console.WriteLine("Hvor mange km har bilen kørt?");
int kmIN = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Hvilken type brandstof bruger bilen?");
string fuelIN = ErrorHandling.IsFuelValid(Console.ReadLine());
Console.WriteLine("Hvilket år er bilen fra?");
int yearIN = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
string fullStatement = "insert into Car (id, Model, Brand, RegNr, KiloMeter, Fuel, [Year]) values ((select id from customers where id =(" + idChoice + ")),'" + modelIN + "','" + brandIN + "','" + regIN + "', " + kmIN + ", '" + fuelIN + "', " + yearIN + ")";
SQLCon.Insert(fullStatement);
}
public static void AddCar()
{
Console.WriteLine("Tilføj en bil pr kunde (Kundes Id)");
int CostumerId = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Indtast bilens model");
string modelIN = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
Console.WriteLine("Indtast bilens mærke");
string brandIN = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
Console.WriteLine("Hvad er bilens registrerings nummer?");
string regIN = ErrorHandling.IsRegValid(Console.ReadLine());
Console.WriteLine("Hvor mange km har bilen kørt?");
int kmIN = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Hvilken type brandstof bruger bilen?");
string fuelIN = ErrorHandling.IsFuelValid(Console.ReadLine());
Console.WriteLine("Hvilket år er bilen fra?");
int yearIN = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
string fullSentence = "insert into Car (id, Model, Brand, RegNr, KiloMeter, Fuel, [Year]) values ((select id from customers where id =(" + CostumerId + ")),'" + modelIN + "','" + brandIN + "','" + regIN + "', " + kmIN + ", '" + fuelIN + "', " + yearIN + ")";
SQLCon.Update(fullSentence);
}
public static void WatchLibrary()
{
Console.WriteLine("Vælg bilens RegNr for at se alle bilens værkstedsbesøg");
string chooseCar = ErrorHandling.IsRegValid(Console.ReadLine());
SQLCon.SelectLibrary("select * from CarLibrary where RegNr = ('" + chooseCar + "')");
}
public static void WatchLog()
{
Console.WriteLine("Vælg bilens Registreringsnummer for at få vist værkstedsbesøg");
string chooseCar = ErrorHandling.IsRegValid(Console.ReadLine());
SQLCon.SelectLog("Select * from CarLog where RegNr = ('" + chooseCar + "')");
}
public static void ViewCarSorted()
{
Console.WriteLine("Vælg den bil du vil se 'RegNr'");
string CarRegNr = Console.ReadLine();
SQLCon.SelectCar("select * from Car where RegNr = ('" + CarRegNr + "')");
}
public static void Update()
{
Console.WriteLine("Vælg bil du vil rette (Reg-Nr)");
string chooseCar = ErrorHandling.IsRegValid(Console.ReadLine());
Console.WriteLine("Vælg hvad du vil rette");
Console.WriteLine("1. Km");
Console.WriteLine("2. Fuel");
string fullSentence;
int answerTwo = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
switch (answerTwo)
{
case 1:
Console.Write("Skriv din ændring: ");
int retKM = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
fullSentence = "update car set KiloMeter = ('" + retKM + "') where RegNr = ('" + chooseCar + "')";
SQLCon.Update(fullSentence);
break;
case 2:
Console.Write("Skriv din ændring: ");
string retFuel = ErrorHandling.IsFuelValid(Console.ReadLine());
fullSentence = "update car set Fuel = ('" + retFuel + "') where RegNr = ('" + chooseCar + "')";
SQLCon.Update(fullSentence);
break;
}
}
public static void Delete()
{
Console.WriteLine("Vælg kunde du vil slette (Kundeid)");
int delAnswer = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
string fullSentence = "delete from customers where id = ('" + delAnswer + "')";
SQLCon.Delete(fullSentence);
}
public static void Create()
{
Console.WriteLine("Vælg Bil du gerne vil have på værksted(RegNr)");
string regNrIN = ErrorHandling.IsRegValid(Console.ReadLine());
string fullSentence = "INSERT INTO CarLog VALUES ((SELECT RegNr FROM Car WHERE RegNr = ('" + regNrIN + "')), GETDATE())";
SQLCon.Insert(fullSentence);
}
public static void Delete()
{
Console.WriteLine("Vælg kunde du vil slette bil (Regnr)");
string delAnswer = ErrorHandling.IsRegValid(Console.ReadLine());
string fullSentence = "delete from car where RegNr = ('" + delAnswer + "')";
SQLCon.Delete(fullSentence);
}
public static void Delete()
{
Console.WriteLine("Vælg bil du vil slette(RegNr) fra værkstedet");
string delAnswer = ErrorHandling.IsRegValid(Console.ReadLine());
string insertSentence = "insert into CarLibary(RegNr, VisitDate, LeftDate) Values ((select RegNr from CarLog where RegNr = ('" + delAnswer + "')), (select VisitDate from CarLog where RegNr = ('" + delAnswer + "')), GETDATE())";
string fullSentence = "DELETE FROM CarLog WHERE RegNr = ('" + delAnswer + "')";
SQLCon.Insert(insertSentence);
SQLCon.Delete(fullSentence);
}
public static void Update()
{
Console.WriteLine("Vælg værkstedsbesøg du gerne vil rette (RegNr)");
string chooseCarLog = ErrorHandling.IsRegValid(Console.ReadLine());
string fullSentence;
int answerTwo = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Skriv din ændring");
string retRegNr = ErrorHandling.IsRegValid(Console.ReadLine());
fullSentence = "UPDATE CarLog SET RegNr = ('" + retRegNr + "') WHERE RegNr = ('" + chooseCarLog + "')";
SQLCon.Update(fullSentence);
}
public static void Create()
{
Console.WriteLine("Indtast kundens navn");
string kundeIN = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
Console.WriteLine("Adresse");
string addIN = ErrorHandling.IsAddressValid(Console.ReadLine());
Console.WriteLine("Indtast kundens alder");
int ageIN = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
string fullStatement = "insert into customers values ('" + kundeIN + "','" + addIN + "'," + ageIN + ", getdate())";
SQLCon.Insert(fullStatement);
}
public static void Update()
{
Console.WriteLine("Vælg kunde du vil rette (Kunde id)");
int chooseCustomer = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
Console.WriteLine("Vælg hvad du vil rette");
Console.WriteLine("1. Navn");
Console.WriteLine("2. Adresse");
Console.WriteLine("3. Alder");
string fullSentence;
int answerTwo = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
switch (answerTwo)
{
case 1:
Console.Write("Skriv din ændring: ");
string retNavn = ErrorHandling.BigStartLetters(ErrorHandling.IsNameValid(Console.ReadLine()));
fullSentence = "update customers set navn = ('" + retNavn + "') where id = ('" + chooseCustomer + "')";
SQLCon.Update(fullSentence);
break;
case 2:
Console.Write("Skriv din ændring: ");
string retAdr = ErrorHandling.IsAddressValid(Console.ReadLine());
fullSentence = "update customers set adr = ('" + retAdr + "') where id = ('" + chooseCustomer + "')";
SQLCon.Update(fullSentence);
break;
case 3:
Console.Write("Skriv din ændring: ");
int retAlder = Convert.ToInt32(ErrorHandling.IsNumberValid(Console.ReadLine()));
fullSentence = "update customers set alder = ('" + retAlder + "') where id = ('" + chooseCustomer + "')";
SQLCon.Update(fullSentence);
break;
}
}
public static void ChooseAllWatchLibrary()
{
Console.WriteLine("En liste over alle biler der har været på værksted");
SQLCon.SelectLibrary("select * from CarLibrary");
}
public static void ChooseAllWatchLog()
{
Console.WriteLine("Liste over alle biler på værkstedet");
Console.WriteLine();
SQLCon.SelectLog("Select * from CarLog");
}
public static void WatchTabel()
{
SQLCon.SelectCustomer("Select * from customers order by navn asc");
SQLCon.SelectCar("Select * from Car order by Brand, Model asc");
}
