private void GetPassword()
{
UserInterface.DisplayUserOptions("Please enter your password: (CaSe SeNsItIvE)");
employee.Password = UserInterface.GetUserInput();
}
private void UpdateIncome()
{
UserInterface.DisplayUserOptions("What is your household income? (If you would like to omit it enter 0)");
client.Income = UserInterface.GetIntegerData();
Query.updateClient(client);
}
// TODO: Animal Multi-Trait Search
internal static IQueryable <Animal> SearchForAnimalsByMultipleTraits(Dictionary <int, string> updates) // parameter(s)?
{
bool searchForTrait = true;
var animals = db.Animals.ToList();
while (searchForTrait == true)
{
List <string> options = new List <string>()
{
"Select Update:", "1. Category", "2. Name", "3. Age", "4. Demeanor", "5. Kid friendly", "6. Pet friendly", "7. Weight", "8. Finished", "You will be prompted again for any additional updates."
};
UserInterface.DisplayUserOptions(options);
var userInput = UserInterface.GetIntegerData();
switch (userInput)
{
case 1:
UserInterface.DisplayUserOptions("Enter an animal category to search by:");
string searchCategory = UserInterface.GetUserInput();
animals = animals.Where(c => c.Category.Name == searchCategory).Select(c => c).ToList();
break;
case 2:
UserInterface.DisplayUserOptions("Enter an animal name to search by:");
string searchName = UserInterface.GetUserInput();
animals = animals.Where(n => n.Name == searchName).Select(n => n).ToList();
break;
case 3:
UserInterface.DisplayUserOptions("Enter an animal age to search by:");
int searchAge = UserInterface.GetIntegerData();
animals = animals.Where(a => a.Age == searchAge).Select(a => a).ToList();
break;
case 4:
UserInterface.DisplayUserOptions("Enter an animal demeanor to search by:");
string searchDemeanor = UserInterface.GetUserInput();
animals = animals.Where(d => d.Demeanor == searchDemeanor).Select(d => d).ToList();
break;
case 5:
bool?searchKidFriendly = UserInterface.GetBitData("Search if an animal is kid friendly:");
animals = animals.Where(k => k.KidFriendly == searchKidFriendly).Select(k => k).ToList();
break;
case 6:
bool?searchPetFriendly = UserInterface.GetBitData("Search if an animal is pet frirndly:");
animals = animals.Where(p => p.PetFriendly == searchPetFriendly).Select(p => p).ToList();
break;
case 7:
UserInterface.DisplayUserOptions("Enter an animal weight to search by:");
int searchWeight = UserInterface.GetIntegerData();
animals = animals.Where(w => w.Weight == searchWeight).Select(w => w).ToList();
break;
default:
Console.WriteLine("Please make a valid selection.");
break;
}
Console.WriteLine("Would you like to search again?");;
string input = UserInterface.GetUserInput();
if (input.ToLower() == "yes" || input.ToLower() == "y")
{
searchForTrait = true;
}
else if (input.ToLower() == "no" || input.ToLower() == "n")
{
searchForTrait = false;
}
else
{
UserInterface.DisplayUserOptions("Input not recognized please try again");
}
}
return(animals);
//throw new NotImplementedException();
}
public Client()
{
UI = new UserInterface();
management = new Management();
// will need to send in the new management class that is intatiated in the program
}
//// TODO Items: ////
// TODO: Allow any of the CRUD operations to occur here
internal static void RunEmployeeQueries(Employee employee, string crudOperation)
{
switch (crudOperation)
{
case "create":
var checkEmployeeNumber = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
if (checkEmployeeNumber == null)
{
var checkEmployeeEmail = db.Employees.Where(e => e.Email == employee.Email).FirstOrDefault();
if (checkEmployeeEmail == null)
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
else
{
UserInterface.DisplayUserOptions("Employee ID number already exists.");
}
}
else
{
UserInterface.DisplayUserOptions("Employee e-mail already exists.");
}
break;
case "delete":
employee = db.Employees.Where(e => e.UserName == employee.UserName && e.EmployeeId == employee.EmployeeId).SingleOrDefault();
db.Employees.DeleteOnSubmit(employee);
db.SubmitChanges();
break;
case "read":
employee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
List <string> employeeRead = new List <string>()
{
"Employee name: " + employee.FirstName + "" + employee.LastName,
"Employee username: "******"Employee number: " + employee.EmployeeNumber,
"Employee e-mail" + employee.Email,
};
UserInterface.DisplayUserOptions(employeeRead);
break;
case "update":
employee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
List <string> employeeUpdate = new List <string>()
{
"Employee name: " + employee.FirstName + "" + employee.LastName,
"Employee username: "******"Employee number: " + employee.EmployeeNumber,
"Employee e-mail" + employee.Email,
"Employee password: "******"first name", "the employee's");
employee.LastName = UserInterface.GetStringData("last name", "the employee's");
employee.EmployeeNumber = int.Parse(UserInterface.GetStringData("employee number", "the employee's"));
employee.Email = UserInterface.GetStringData("email", "the employee's");
break;
}
//throw new NotImplementedException();
}
internal static void UpdateAnimal(int animalId, Dictionary <int, string> updates)
{
try
{
if (db.Animals.FirstOrDefault(a => a.AnimalId == animalId) is null)
{
UserInterface.DisplayUserOptions("Animal does not exist in database, cannot update.");
return;
}
}
catch (Exception ex)
{
UserInterface.DisplayUserOptions(ex.Message);
}
foreach (var update in updates)
{
switch (update.Key)
{
case 1:
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().Category = db.Categories.Where(b => b.Name == update.Value).FirstOrDefault();
break;
case 2:
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().Name = update.Value;
break;
case 3:
int age;
if (Int32.TryParse(update.Value, out age))
{
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().Age = age;
}
;
break;
case 4:
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().Demeanor = update.Value;
break;
case 5:
try
{
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().KidFriendly =
Convert.ToBoolean(update.Value);
}
catch (Exception e) { UserInterface.DisplayUserOptions(e.Message); }
break;
case 6:
try
{
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().PetFriendly =
Convert.ToBoolean(update.Value);
}
catch (Exception e) { UserInterface.DisplayUserOptions(e.Message); }
break;
case 7:
int weight;
if (Int32.TryParse(update.Value, out weight))
{
db.Animals.Where(a => a.AnimalId == animalId).FirstOrDefault().Weight = weight;
}
break;
default:
break;
}
}
db.SubmitChanges();
}
private static void UpdateHomeSize(Client client)
{
Console.Clear();
UserInterface.DisplayUserOptions("What is your home size? (small, medium, large)");
}
private static void ReadEmployee(Employee employee)
{
Employee foundEmployee = db.Employees.FirstOrDefault(a => a.EmployeeNumber == employee.EmployeeNumber);
UserInterface.DisplayEmployeeInfo(foundEmployee);
}
public void AddCSVFile(string fileName)
{
try
{
using (TextFieldParser parser = new TextFieldParser(@fileName))
{
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
while (!parser.EndOfData)
{
string[] animalTrait = parser.ReadFields();
Animal animalToAdd = new Animal();
animalToAdd.Name = animalTrait[0].Trim('"');
int?intParseValue = UserInterface.GetCsvIntData(animalTrait[2]);
animalToAdd.Weight = intParseValue;
string testedInput = UserInterface.CsvNullChecker(animalTrait[1]);
while (testedInput == null)
{
UserInterface.DisplayUserOptions("Please enter the animal`s species: ");
string input = Console.ReadLine();
intParseValue = Query.GetCategoryId(input);
if (intParseValue != null)
{
testedInput = "Not null";
}
}
animalToAdd.CategoryId = intParseValue;
intParseValue = UserInterface.GetCsvIntData(animalTrait[3]);
animalToAdd.Age = intParseValue;
intParseValue = UserInterface.GetCsvIntData(animalTrait[4]);
animalToAdd.DietPlanId = intParseValue;
animalToAdd.Demeanor = animalTrait[5].Trim('"');
bool?newFriendlyStatus = UserInterface.GetCsvBoolData(animalTrait[6]);
animalToAdd.KidFriendly = newFriendlyStatus;
newFriendlyStatus = UserInterface.GetCsvBoolData(animalTrait[7]);
animalToAdd.PetFriendly = newFriendlyStatus;
animalToAdd.Gender = animalTrait[8];
animalToAdd.AdoptionStatus = animalTrait[9].Trim('"');
intParseValue = UserInterface.GetCsvIntData(animalTrait[10]);
animalToAdd.EmployeeId = intParseValue;
if (Query.CheckIfEmptyRoom())
{
Query.AddAnimal(animalToAdd);
Query.PlaceAnimalIntoRoom(animalToAdd.AnimalId);
}
else
{
UserInterface.DisplayUserOptions("There are no open rooms at this time. The animal has not been admitted. Press any key to continue.");
Console.ReadLine();
RunUserMenus();
}
}
RunUserMenus();
}
}
catch
{
UserInterface.DisplayUserOptions("There is something wrong with the file you are attempting to load or the file does not exist. Please check it and try again. Press any key to continue.");
Console.ReadLine();
RunUserMenus();
}
}