private List <Species> GetSpecies(SQLQueryResult sQLQueryResult) { List <Species> species = new List <Species>(); { for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++) { int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["SpeciesID"]; string speciesName = (String)sQLQueryResult.dataTable.Rows[i]["SpeciesName"]; species.Add(SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName)); } return(species); } }
private List <Cage> GetCageList(SQLQueryResult sQLQueryResult) { List <Cage> cages = new List <Cage>(); for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++) { int cageID = (int)sQLQueryResult.dataTable.Rows[i]["CageID"]; int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["SpeciesID"]; string speciesName = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"]; Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName); cages.Add(CageFactory.Instance().CreateCage(cageID, species)); } return(cages); }
private List <Animal> GetAnimalList(SQLQueryResult sQLQueryResult) { List <Animal> animals = new List <Animal>(); for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++) { Employee employee = null; if (sQLQueryResult.dataTable.Rows[i].IsNull("EmployeeID")) { } else { string titleName = (string)sQLQueryResult.dataTable.Rows[i]["TitleName"]; int titleID = (int)sQLQueryResult.dataTable.Rows[i]["TitleID"]; Title title = TitleFactory.Instance().CreateTitle(titleName, titleID); string employeeName = (string)sQLQueryResult.dataTable.Rows[i]["EmployeeName"]; int employeeID = (int)sQLQueryResult.dataTable.Rows[i]["EmployeeID"]; bool employeeActive = (bool)sQLQueryResult.dataTable.Rows[i]["EmployeeActive"]; employee = EmployeeFactory.Instance().CreateEmployee(employeeID, employeeName, employeeActive, title); } int CustomerID = (int)sQLQueryResult.dataTable.Rows[i]["CustomerID"]; string customerName = (string)sQLQueryResult.dataTable.Rows[i]["customername"]; string customeradress = (string)sQLQueryResult.dataTable.Rows[i]["Adress"]; string customerphone = (string)sQLQueryResult.dataTable.Rows[i]["Phone"]; string customeremail = (string)sQLQueryResult.dataTable.Rows[i]["Email"]; bool customeractive = (bool)sQLQueryResult.dataTable.Rows[i]["Active"]; Customer customer = CustomerFactory.Instance().CreateCustomer(CustomerID, customerName, customeradress, customerphone, customeremail, customeractive, 0); int animalID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalID"]; string name = (string)sQLQueryResult.dataTable.Rows[i]["Name"]; DateTime birthday = (DateTime)sQLQueryResult.dataTable.Rows[i]["BirthYear"]; int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["Speciesid"]; string speciesName = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"]; Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName); double weight = Convert.ToDouble((decimal)sQLQueryResult.dataTable.Rows[i]["Weight"]); bool gender = (bool)sQLQueryResult.dataTable.Rows[i]["Gender"]; bool active = (bool)sQLQueryResult.dataTable.Rows[i]["Active"]; animals.Add(AnimalFactory.Instance().CreateAnimal(customer, animalID, name, birthday, species, weight, gender, employee, true)); } return(animals); }
public Animal GetAnimal(int animalID) { string query = Utility.ReadSQLQueryFromFile("GetAnimal.txt"); SQLQuery sQLQuery = new SQLQuery(query); sQLQuery.AddParameter("@animalid", animalID.ToString(), SqlDbType.Int); SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery); DataRow dataRow = sQLQueryResult.dataTable.Rows[0]; int CustomerID = (int)sQLQueryResult.dataTable.Rows[0]["CustomerID"]; string customerName = (string)sQLQueryResult.dataTable.Rows[0]["customername"]; string customeradress = (string)sQLQueryResult.dataTable.Rows[0]["Adress"]; string customerphone = (string)sQLQueryResult.dataTable.Rows[0]["Phone"]; string customeremail = (string)sQLQueryResult.dataTable.Rows[0]["Email"]; bool customeractive = (bool)sQLQueryResult.dataTable.Rows[0]["Active"]; Customer customer = CustomerFactory.Instance().CreateCustomer(CustomerID, customerName, customeradress, customerphone, customeremail, customeractive, 0); string speciesName = sQLQueryResult.dataTable.Rows[0]["SpeciesName"].ToString(); int speciesID = (int)sQLQueryResult.dataTable.Rows[0]["SpeciesID"]; Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName); string name = sQLQueryResult.dataTable.Rows[0]["SpeciesName"].ToString(); int employeeID = (int)sQLQueryResult.dataTable.Rows[0]["EmployeeID"]; Employee employee = EmployeeFactory.Instance().GetEmployee(employeeID, name); Animal animal = new Animal(customer, (int)dataRow["AnimalID"], (string)dataRow["Name"], (DateTime)dataRow["BirthYear"], species, (double)dataRow["Weight"], (bool)dataRow["Gender"], employee, (bool)dataRow["Active"]); return(animal); }
private List <Prescription> GetAllPrescriptionList(SQLQueryResult sQLQueryResult) { List <Prescription> prescriptions = new List <Prescription>(); for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++) { int prescriptionID; Employee employee; Animal animal; Item item; Title title; if (sQLQueryResult.dataTable.Rows[i].IsNull("EmployeeID")) { employee = null; } else { int employeeID = (int)sQLQueryResult.dataTable.Rows[i]["EmployeeID"]; string name = (string)sQLQueryResult.dataTable.Rows[i]["Employeename"]; int titleID = (int)sQLQueryResult.dataTable.Rows[i]["TitleID"]; string titleName = (string)sQLQueryResult.dataTable.Rows[i]["TitleName"]; title = TitleFactory.Instance().CreateTitle(titleName, titleID); employee = EmployeeFactory.Instance().CreateEmployee(employeeID, name, true, title); } if (sQLQueryResult.dataTable.Rows[i].IsNull("AnimalID")) { animal = null; } else { int customerID = (int)sQLQueryResult.dataTable.Rows[i]["CustomerID"]; string nameCustomer = (string)sQLQueryResult.dataTable.Rows[i]["CustomerName"]; string address = (string)sQLQueryResult.dataTable.Rows[i]["Adress"]; string phone = (string)sQLQueryResult.dataTable.Rows[i]["Phone"]; string email = (string)sQLQueryResult.dataTable.Rows[i]["Email"]; bool activeCustomer = (bool)sQLQueryResult.dataTable.Rows[i]["CustomerActive"]; int cvr = 0; string name = (string)sQLQueryResult.dataTable.Rows[i]["AnimalName"]; DateTime birthYear = (DateTime)sQLQueryResult.dataTable.Rows[i]["BirthYear"]; int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["SpeciesID"]; string nameSpecies = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"]; double weight = Convert.ToDouble((decimal)sQLQueryResult.dataTable.Rows[i]["Weight"]); bool gender = (bool)sQLQueryResult.dataTable.Rows[i]["Gender"]; bool activeAnimal = (bool)sQLQueryResult.dataTable.Rows[i]["AnimalActive"]; Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, nameSpecies); Customer customer = CustomerFactory.Instance().CreateCustomer(customerID, nameCustomer, address, phone, email, activeCustomer, cvr); animal = AnimalFactory.Instance().CreateAnimal(customer, name, birthYear, species, weight, gender, employee, activeAnimal); } if (sQLQueryResult.dataTable.Rows[i].IsNull("ItemID")) { item = null; } else { int itemID = (int)sQLQueryResult.dataTable.Rows[i]["ItemID"]; string name = (string)sQLQueryResult.dataTable.Rows[i]["ItemName"]; decimal price = (decimal)sQLQueryResult.dataTable.Rows[i]["ItemPrice"]; decimal costPrice = (decimal)sQLQueryResult.dataTable.Rows[i]["CostPrice"]; int amountItem = (int)sQLQueryResult.dataTable.Rows[i]["ItemAmount"]; bool prescription = (bool)sQLQueryResult.dataTable.Rows[i]["Prescription"]; bool treatment = (bool)sQLQueryResult.dataTable.Rows[i]["ItemTreatment"]; bool itemActive = (bool)sQLQueryResult.dataTable.Rows[i]["ItemActive"]; item = ItemFactory.Instance().CreateItem(itemID, name, amountItem, price, costPrice, prescription, treatment, itemActive); } int amount = (int)sQLQueryResult.dataTable.Rows[i]["Amount"]; DateTime prescriptionDay = (DateTime)sQLQueryResult.dataTable.Rows[i]["PrescriptionDay"]; bool payed = (bool)sQLQueryResult.dataTable.Rows[i]["Payed"]; prescriptionID = (int)sQLQueryResult.dataTable.Rows[i]["PrescriptionID"]; prescriptions.Add(PrescriptionFactory.Instance().CreatePrescription(prescriptionID, amount, prescriptionDay, payed, employee, animal, item)); } return(prescriptions); }
private List <Treatment> GetTreatmentList(SQLQueryResult sQLQueryResult) { List <Treatment> treatments = new List <Treatment>(); for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++) { int treatmentID; TreatmentType treatmentType; Employee employee; Employee animalEmployee = null; OperationRoom operationRoom; Cage cage; Item item; int animalID; Title title; if (sQLQueryResult.dataTable.Rows[i].IsNull("TreatmentID")) { treatmentID = -1; } else { treatmentID = (int)sQLQueryResult.dataTable.Rows[i]["TreatmentID"]; } if (sQLQueryResult.dataTable.Rows[i].IsNull("TreatmentTypeID")) { treatmentType = null; } else { int treatmentTypeID = (int)sQLQueryResult.dataTable.Rows[i]["TreatmentTypeID"]; string treatmentTypeName = (string)sQLQueryResult.dataTable.Rows[i]["Name"]; TreatmentType newTreatmentType = TreatmentTypeFactory.Instance().CreateTreatmentType(treatmentTypeID, treatmentTypeName); treatmentType = newTreatmentType; } if (sQLQueryResult.dataTable.Rows[i].IsNull("OperationRoomID")) { operationRoom = null; } else { int operationRoomID = (int)sQLQueryResult.dataTable.Rows[i]["OperationRoomID"]; operationRoom = OperationRoomFactory.Instance().CreateOperationRoom(operationRoomID); } if (sQLQueryResult.dataTable.Rows[i].IsNull("CageID")) { cage = null; } else { int cageID = (int)sQLQueryResult.dataTable.Rows[i]["CageID"]; int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["SpeciesID"]; string speciesName = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"]; Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName); cage = CageFactory.Instance().CreateCage(cageID, species); } if (sQLQueryResult.dataTable.Rows[i].IsNull("ItemID")) { item = null; } else { int itemID = (int)sQLQueryResult.dataTable.Rows[i]["ItemID"]; string name = (string)sQLQueryResult.dataTable.Rows[i]["ItemName"]; decimal price = (decimal)sQLQueryResult.dataTable.Rows[i]["Price"]; decimal costPrice = (decimal)sQLQueryResult.dataTable.Rows[i]["CostPrice"]; int amount = (int)sQLQueryResult.dataTable.Rows[i]["Amount"]; bool prescription = (bool)sQLQueryResult.dataTable.Rows[i]["Prescription"]; bool treatment = (bool)sQLQueryResult.dataTable.Rows[i]["ItemTreatment"]; bool itemActive = (bool)sQLQueryResult.dataTable.Rows[i]["ItemActive"]; item = ItemFactory.Instance().CreateItem(itemID, name, amount, price, costPrice, prescription, treatment, itemActive); } if (sQLQueryResult.dataTable.Rows[i].IsNull("EmployeeID")) { employee = null; } else { int employeeID = (int)sQLQueryResult.dataTable.Rows[i]["EmployeeID"]; string name = (string)sQLQueryResult.dataTable.Rows[i]["Employeename"]; int titleID = (int)sQLQueryResult.dataTable.Rows[i]["TitleID"]; string titleName = (string)sQLQueryResult.dataTable.Rows[i]["TitleName"]; title = TitleFactory.Instance().CreateTitle(titleName, titleID); employee = EmployeeFactory.Instance().CreateEmployee(employeeID, name, true, title); } animalID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalID"]; if (!sQLQueryResult.dataTable.Rows[i].IsNull("AnimalEmployeeID")) { int animalTitleID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalEmployeeTitleID"]; string animalTitleName = (string)sQLQueryResult.dataTable.Rows[i]["AnimalEmployeeTitle"]; Title animalEmployeeTitle = TitleFactory.Instance().CreateTitle(animalTitleName, animalTitleID); int animalEmployeeID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalEmployeeID"]; string animalEmployeeName = (string)sQLQueryResult.dataTable.Rows[i]["AnimalEmployeeName"]; bool animalEmployeeActive = (bool)sQLQueryResult.dataTable.Rows[i]["AnimalEmployeeActive"]; animalEmployee = EmployeeFactory.Instance().CreateEmployee(animalEmployeeID, animalEmployeeName, animalEmployeeActive, animalEmployeeTitle); } int animalSpeciesID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalSpeciesID"]; string animalSpeciesName = (string)sQLQueryResult.dataTable.Rows[i]["AnimalSpeciesName"]; Species animalSpecies = SpeciesFactory.Instance().CreateSpecies(animalSpeciesID, animalSpeciesName); int customerID = (int)sQLQueryResult.dataTable.Rows[i]["CustomerID"]; string customerName = (string)sQLQueryResult.dataTable.Rows[i]["CustomerName"]; string customerAddress = (string)sQLQueryResult.dataTable.Rows[i]["Adress"]; string customerPhone = (string)sQLQueryResult.dataTable.Rows[i]["Phone"]; string customerEmail = (string)sQLQueryResult.dataTable.Rows[i]["Email"]; bool customerActive = (bool)sQLQueryResult.dataTable.Rows[i]["CustomerActive"]; Customer customer = CustomerFactory.Instance().CreateCustomer(customerID, customerName, customerAddress, customerPhone, customerEmail, customerActive, 0); string animalName = (string)sQLQueryResult.dataTable.Rows[i]["AnimalName"]; DateTime animalBirthday = (DateTime)sQLQueryResult.dataTable.Rows[i]["BirthYear"]; bool animalGender = (bool)sQLQueryResult.dataTable.Rows[i]["Gender"]; double animalWeight = Convert.ToDouble((decimal)sQLQueryResult.dataTable.Rows[i]["Weight"]); bool animalActive = (bool)sQLQueryResult.dataTable.Rows[i]["AnimalActive"]; Animal animal = AnimalFactory.Instance().CreateAnimal(customer, animalID, animalName, animalBirthday, animalSpecies, animalWeight, animalGender, animalEmployee, animalActive); if (sQLQueryResult.dataTable.Rows[i].IsNull("AnimalID")) { animalID = -1; } else { animalID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalID"]; } DateTime startTime = (DateTime)sQLQueryResult.dataTable.Rows[i]["StartTime"]; DateTime endTime = (DateTime)sQLQueryResult.dataTable.Rows[i]["EndTime"]; bool payed = (bool)sQLQueryResult.dataTable.Rows[i]["Payed"]; string headline = (string)sQLQueryResult.dataTable.Rows[i]["Headline"]; bool active = (bool)sQLQueryResult.dataTable.Rows[i]["Active"]; int status = (int)sQLQueryResult.dataTable.Rows[i]["Status"]; treatments.Add(TreatmentFactory.Instance().CreateTreatment(treatmentID, treatmentType, operationRoom, cage, item, startTime, endTime, payed, headline, active, animal, employee, status)); } return(treatments); }