/// <summary> /// Creator: Awaab Elamin /// Created: 2020/04/15 /// Approver: Mohamed Elamin /// /// Get all Animals /// <remarks> /// Updater: /// Updated: /// Update: /// </remarks> /// <return>Animals Medicals Records</return> public List <AnimalMedical> getAllAnimals() { List <AnimalMedical> animals = new List <AnimalMedical>(); var conn = DBConnection.GetConnection(); string cmdText = @"sp_get__all_animals_medical_Record"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { AnimalMedical animal = new AnimalMedical(); animal.AnimalMedicalInfoID = reader.GetInt32(0); animal.AnimalName = reader.GetString(1); animal.SpayedNeutered = reader.GetBoolean(2); animal.Vaccinations = reader.GetString(3); animal.MostRecentVaccinationDate = reader.GetDateTime(4); animal.AdditionalNotes = reader.GetString(5); animal.UserFirstName = reader.GetString(6); animal.UseLastrName = reader.GetString(7); animals.Add(animal); } } reader.Close(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(animals); }
/// <summary> /// Creator: Awaab Elamin /// Created: 2020/2/5 /// Approver: Mohamed Elamin /// default constructor intialays the private lists to work as fake data base /// </summary> /// <remarks> /// Updater Awaab Elamin /// Updated: 2020/02/15 /// Update: (Add General questions list values) /// </remarks> /// /// <remarks> /// Updater Awaab Elamin /// Updated: 2020/04/15 /// Update: (Add Animal Medicals list values) /// </remarks> public FakeReviewerAccessor() { adoptionApplications = new List <AdoptionApplication>() { new AdoptionApplication() { AdoptionApplicationID = 10000, CustomerEmail = "*****@*****.**", AnimalName = "Bebe", Status = "Reviewer", RecievedDate = DateTime.Now.Date }, new AdoptionApplication() { AdoptionApplicationID = 10001, CustomerEmail = "*****@*****.**", AnimalName = "Bebe", Status = "Reviewer", RecievedDate = DateTime.Now.Date }, new AdoptionApplication() { AdoptionApplicationID = 10002, CustomerEmail = "*****@*****.**", AnimalName = "Bebe", Status = "Reviewer", RecievedDate = DateTime.Now.Date }, new AdoptionApplication() { AdoptionApplicationID = 10003, CustomerEmail = "*****@*****.**", AnimalName = "Bebe", Status = "Reviewer", RecievedDate = DateTime.Now.Date } }; customers = new List <AdoptionCustomer>() { new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Awaab", LastName = "Elamin", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Addallah", LastName = "Ali", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "AbelSamee", LastName = "Tomsah", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Adam", LastName = "Saleem", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Steph", LastName = "Wiliam", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Kamal", LastName = "AlAraby", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true }, new AdoptionCustomer() { CustomerEmail = "*****@*****.**", FirstName = "Ali", LastName = "Taha", PhoneNumber = "3192104964", AddressLineOne = "3000 J St SW", AddressLineTwo = "Apt 105", City = "Cedar Rapids", State = "IA", Zipcode = "52404", Active = true } }; customerQuestionnars = new List <CustomerQuestionnar>() { new CustomerQuestionnar() { QuestionDescription = "Q1", Answer = "Answer1" }, new CustomerQuestionnar() { QuestionDescription = "Q2", Answer = "Answer2" }, new CustomerQuestionnar() { QuestionDescription = "Q3", Answer = "Answer3" }, new CustomerQuestionnar() { QuestionDescription = "Q4", Answer = "Answer4" }, new CustomerQuestionnar() { QuestionDescription = "Q5", Answer = "Answer5" }, new CustomerQuestionnar() { QuestionDescription = "Q6", Answer = "Answer6" }, new CustomerQuestionnar() { QuestionDescription = "Q7", Answer = "Answer7" }, new CustomerQuestionnar() { QuestionDescription = "Q8", Answer = "Answer8" }, new CustomerQuestionnar() { QuestionDescription = "Q9", Answer = "Answer9" }, new CustomerQuestionnar() { QuestionDescription = "Q10", Answer = "Answer10" } }; generalQuestions = new List <GeneralQuestion>() { new GeneralQuestion() { QuestionID = 10000, Description = "Question1" }, new GeneralQuestion() { QuestionID = 10001, Description = "Question2" }, new GeneralQuestion() { QuestionID = 10002, Description = "Question3" }, new GeneralQuestion() { QuestionID = 10003, Description = "Question4" }, new GeneralQuestion() { QuestionID = 10004, Description = "Question5" }, new GeneralQuestion() { QuestionID = 10005, Description = "Question6" }, new GeneralQuestion() { QuestionID = 10006, Description = "Question7" }, new GeneralQuestion() { QuestionID = 10007, Description = "Question8" }, new GeneralQuestion() { QuestionID = 10008, Description = "Question9" }, new GeneralQuestion() { QuestionID = 10009, Description = "Question10" } }; animals = new List <AnimalMedical>(); animal = new AnimalMedical(); animal.AnimalName = "Animal"; animal.UserFirstName = "UserFirstName"; animal.UseLastrName = "UserLastName"; animal.SpayedNeutered = true; animal.Vaccinations = "V1"; animal.MostRecentVaccinationDate = DateTime.Now; animal.AdditionalNotes = "Note1"; animals.Add(animal); animal = new AnimalMedical(); animal.AnimalName = "Animal"; animal.UserFirstName = "UserFirstName"; animal.UseLastrName = "UserLastName"; animal.SpayedNeutered = true; animal.Vaccinations = "V2"; animal.MostRecentVaccinationDate = DateTime.Now; animal.AdditionalNotes = "Note2"; animals.Add(animal); animal = new AnimalMedical(); animal.AnimalName = "Animal"; animal.UserFirstName = "UserFirstName"; animal.UseLastrName = "UserLastName"; animal.SpayedNeutered = true; animal.Vaccinations = "V3"; animal.MostRecentVaccinationDate = DateTime.Now; animal.AdditionalNotes = "Note3"; animals.Add(animal); animal = new AnimalMedical(); animal.AnimalName = "Animal"; animal.UserFirstName = "UserFirstName"; animal.UseLastrName = "UserLastName"; animal.SpayedNeutered = true; animal.Vaccinations = "V4"; animal.MostRecentVaccinationDate = DateTime.Now; animal.AdditionalNotes = "Note4"; animals.Add(animal); animal = new AnimalMedical(); animal.AnimalName = "Animal"; animal.UserFirstName = "UserFirstName"; animal.UseLastrName = "UserLastName"; animal.SpayedNeutered = true; animal.Vaccinations = "V5"; animal.MostRecentVaccinationDate = DateTime.Now; animal.AdditionalNotes = "Note5"; animals.Add(animal); }