public void SearchASpecificAnimal() { Console.WriteLine("Enter the animal name of the animal you are looking for"); animalName = Console.ReadLine(); HsdbLinqToSqlDataContext dbAnimSearch = new HsdbLinqToSqlDataContext(); var animalResult = dbAnimSearch.Animals.Where(n => n.Name == animalName).Select(s => s).ToList(); if (animalResult != null) { Console.WriteLine("\nSEARCH RESULTS: \n"); foreach (var match in animalResult) { Console.WriteLine(" Room: " + match.Room); Console.WriteLine(" Name: " + match.Name); Console.WriteLine(" Animal Type: " + match.AnimalType); Console.WriteLine(" Gender: " + match.Gender); Console.WriteLine(" Food: " + match.Food); Console.WriteLine(" Shots: " + match.Shot); Console.WriteLine(" Price: " + match.Price); } } else { Console.WriteLine("! No Matches Found. !\n\n"); } GetOptionToEdit(); }
public void SearchByBoth() { HsdbLinqToSqlDataContext dbAnimSearch = new HsdbLinqToSqlDataContext(); var animalResult = dbAnimSearch.Animals.Where(t => t.AnimalType == typeChoice).Where(g => g.Gender == genderChoice).Select(anim => anim).ToList(); if (animalResult != null) { Console.WriteLine("\nSEARCH RESULTS: \n"); foreach (var match in animalResult) { Console.WriteLine(" Room: " + match.Room); Console.WriteLine(" Name: " + match.Name); Console.WriteLine(" Animal Type: " + match.AnimalType); Console.WriteLine(" Gender: " + match.Gender); Console.WriteLine(" Food: " + match.Food); Console.WriteLine(" Shots: " + match.Shot); Console.WriteLine(" Price: " + match.Price); } } else { Console.WriteLine("! No Matches Found. !\n\n"); } Console.WriteLine("Press any key to continue...."); Console.ReadKey(); }
public Register() { HsdbLinqToSqlDataContext dbAdopterObj = new HsdbLinqToSqlDataContext(); Adopter adopter = new Adopter(); Console.WriteLine("\nFill out user registration information below .."); Console.WriteLine("Enter First Name:"); adopter.P_FirstName = Console.ReadLine(); Console.WriteLine("Enter Last Name:"); adopter.P_LastName = Console.ReadLine(); Console.WriteLine("Enter Address:"); adopter.P_Address = Console.ReadLine(); Console.WriteLine("Enter City:"); adopter.P_City = Console.ReadLine(); Console.WriteLine("Enter State:"); adopter.P_State = Console.ReadLine(); Console.WriteLine("Enter Zip:"); adopter.P_Zip = Console.ReadLine(); Console.WriteLine("Phone:"); adopter.P_Phone = Console.ReadLine(); dbAdopterObj.Adopters.InsertOnSubmit(adopter); try { dbAdopterObj.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); Console.WriteLine("An error occurred, sorry for the inconvenience"); dbAdopterObj.SubmitChanges(); } }
private void DeleteAnimalFromTable(string animToEdit) { HsdbLinqToSqlDataContext removeAnimObj = new HsdbLinqToSqlDataContext(); List <Animal> removeFromGroup = (from animal in removeAnimObj.Animals where (animal.Room == animToEdit) select animal).ToList(); removeAnimObj.Animals.DeleteAllOnSubmit(removeFromGroup); removeAnimObj.SubmitChanges(); Console.WriteLine("This record has been deleted, Press any key to return to the Main Menu"); Console.ReadKey(); MainMenu mainMenu = new MainMenu(); }
public void EditShot(string animToEdit) { using (HsdbLinqToSqlDataContext editShotObj = new HsdbLinqToSqlDataContext()) { Animal animal = new Animal(); if (animal.Shot == animToEdit) { Console.WriteLine("Please enter Animal Type Value to be updated."); animal.Shot = Console.ReadLine(); } editShotObj.SubmitChanges(); } }
private void CollectPayment(string animToEdit) { HsdbLinqToSqlDataContext payAnimBalance = new HsdbLinqToSqlDataContext(); var animalPrice = payAnimBalance.Animals.Where(r => r.Room == animToEdit).Select(p => p).ToList(); if (animalPrice != null) { Console.WriteLine("\nSEARCH RESULTS: \n"); foreach (var adoptee in animalPrice) { Console.WriteLine(" Price: " + adoptee.Price); CollectMoney(); } } else { Console.WriteLine("! No Matches Found. !\n"); } }
public AddAnimalData() { HsdbLinqToSqlDataContext dbAnimObject = new HsdbLinqToSqlDataContext(); Animal animal = new Animal(); Console.WriteLine("\nEnter New animal info according to options."); Console.WriteLine("1. Room Placement: "); animal.Room = Console.ReadLine().ToLower(); Console.WriteLine("2. Animal's Name: "); animal.Name = Console.ReadLine().ToLower(); Console.WriteLine("3. Animal Type: "); animal.AnimalType = Console.ReadLine().ToLower(); Console.WriteLine("4. Gender: "); animal.Gender = Console.ReadLine().ToLower(); Console.WriteLine("5. Food: "); animal.Food = Console.ReadLine().ToLower(); Console.WriteLine("6. Shots: "); animal.Shot = Console.ReadLine().ToLower(); Console.WriteLine("7. Price: "); priceInput = Console.ReadLine(); if (Decimal.TryParse(priceInput, out setPrice)) { animal.Price = setPrice; } else { Console.WriteLine("Unable to parse '{0}'.", priceInput); } dbAnimObject.Animals.InsertOnSubmit(animal); try { dbAnimObject.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); Console.WriteLine("An error occurred, sorry for the inconvenience"); dbAnimObject.SubmitChanges(); } }
public static void ImportData(string file) { try { HsdbLinqToSqlDataContext dbImportObj = new HsdbLinqToSqlDataContext(); var importFile = GetFromCSV(file); foreach (var row in importFile) { AddAnimalData animImport = new AddAnimalData(); } Console.WriteLine("File successfully added.\n\n"); Console.WriteLine("Press [ENTER] to continue...."); Console.ReadKey(); } catch (Exception) { Console.WriteLine("An import error occurred, you must manually enter animals at this time"); Console.ReadKey(); } }
public void SearchAdoperByName() { DbConnect db = new DbConnect(); Adopter adopter = new Adopter(); Console.WriteLine("Enter Adopter's First Name"); adpFName = Console.ReadLine(); Console.WriteLine("Enter Adopter's Last Name"); adpLName = Console.ReadLine(); HsdbLinqToSqlDataContext dbAdopter = new HsdbLinqToSqlDataContext(); var adopterResult = dbAdopter.Adopters.Where(f => f.P_FirstName == adpFName).Where(l => l.P_LastName == adpLName).Select(a => a).ToList(); if (adopterResult != null) { Console.WriteLine("\nSEARCH RESULTS: \n"); foreach (var person in adopterResult) { Console.WriteLine(" ID: " + person.PersonID); Console.WriteLine(" First Name: " + person.P_FirstName); Console.WriteLine(" Last Name: " + person.P_LastName); Console.WriteLine(" Address: " + person.P_Address); Console.WriteLine(" City: " + person.P_City); Console.WriteLine(" State: " + person.P_State); Console.WriteLine(" Zip: " + person.P_Zip); Console.WriteLine(" Phone: " + person.P_Phone); } } else { Console.WriteLine("! No Matches Found. !\n\n"); } Console.WriteLine("Press any key to continue...."); Console.ReadKey(); }