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 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 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 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); }