public void AddAnimalToDatabase()
{
Animal animal = new HumaneSociety.Animal();
animal.animalID = System.Guid.NewGuid();
animal.name = animalInputs[0];
animal.species = animalInputs[1];
animal.breed = animalInputs[2];
animal.roomNumber = Convert.ToInt32(animalInputs[3]);
bool b;
if (animalInputs[4] == "y")
{
b = true;
}
else if (animalInputs[4] == "n")
{
b = false;
}
else
{
b = true;
}
animal.adoptionAvailability = b;
animal.foodType = animalInputs[5];
animal.foodAmount = animalInputs[6];
animal.personalityType = animalInputs[7];
animal.price = Convert.ToDecimal(animalInputs[8]);
bool s;
if (animalInputs[9] == "y")
{
s = true;
}
else if (animalInputs[9] == "n")
{
s = false;
}
else
{
s = true;
}
animal.Shots = s;
humaneSocietyDataBase.Animals.InsertOnSubmit(animal);
humaneSocietyDataBase.SubmitChanges();
}
public void ImportCSVFile(string filePath)
{
try
{
IEnumerable <string> csvLines;
csvLines = File.ReadAllLines(filePath);
var query = from csvline in csvLines
let data = csvline.Split(',')
select new
{
name = data[0],
species = data[1],
breed = data[2],
roomNumber = data[3],
adoptionAvailability = data[4],
foodType = data[5],
foodAmount = data[6],
personalityType = data[7],
price = data[8],
Shots = data[9]
};
foreach (var data in query)
{
Animal animal = new HumaneSociety.Animal();
animal.animalID = System.Guid.NewGuid();
animal.name = data.name;
animal.species = data.species;
animal.breed = data.breed;
animal.roomNumber = Convert.ToInt32(data.roomNumber);
bool b;
if (data.adoptionAvailability == "true")
{
b = true;
}
else if (data.adoptionAvailability == "false")
{
b = false;
}
else
{
b = true;
}
animal.adoptionAvailability = b;
animal.foodType = data.foodType;
animal.foodAmount = data.foodAmount;
animal.personalityType = data.personalityType;
animal.price = Convert.ToDecimal(data.price);
bool s;
if (data.Shots == "y")
{
s = true;
}
else if (data.Shots == "n")
{
s = false;
}
else
{
s = true;
}
animal.Shots = s;
humaneSocietyDataBase.Animals.InsertOnSubmit(animal);
humaneSocietyDataBase.SubmitChanges();
}
}
catch
{
UserUI.DisplayMessage("Opps! That's not a correct file path! Try again.");
Run();
}
}
