public static List <Cattle> GetUserAnimals(int UId, int AnimalID) { ac.OpenConnection(); List <Cattle> cattle = new List <Cattle>(); //parameter and variable of this Procedure string[] variables = new string[] { "@UID", "@AnimalID" }; string[] values = new string[] { "" + UId, "" + AnimalID }; //get data from database DataTable data = ac.ExecuteDataTableProcedure("GetOneAnimal", variables, values, ac); if (data.Rows.Count != 0) { foreach (DataRow row in data.Rows) { //offspring List <Cattle> offSpring = new List <Cattle>(); //frame size FrameSize frmeSize = (FrameSize)Enum.Parse(typeof(FrameSize), row["CattleFrameSize"].ToString()); //Breeding status BreedingStatus bStatus = (BreedingStatus)Enum.Parse(typeof(BreedingStatus), row["CattleBreedingStatus"].ToString()); //Status Enum StatusEnum sStatus = (StatusEnum)Enum.Parse(typeof(StatusEnum), row["AnimalStatus"].ToString()); //Gender Enum GenderEnum gEnum = (GenderEnum)Enum.Parse(typeof(GenderEnum), row["AnimalGender"].ToString()); //animal type AnimalTypeEnum animalType = (AnimalTypeEnum)Enum.Parse(typeof(AnimalTypeEnum), row["AnimalType"].ToString()); cattle.Add ( new Cattle ( int.Parse(row["AnimalTid"].ToString()), row["AnimalBreed"].ToString(), gEnum, double.Parse(row["AnimalAge"].ToString()), int.Parse(row["AnimalYear"].ToString()), int.Parse(row["AnimalMonth"].ToString()), int.Parse(row["AnimalDay"].ToString()), animalType, row[4].ToString(), row[5].ToString(), (int)(Math.Round(double.Parse(row["AnimalAge"].ToString()) / 24)), int.Parse(row["personid"].ToString()), row["personname"].ToString(), row["personSurname"].ToString(), DateTime.Parse(row["personDOB"].ToString()), int.Parse(row["CattleID"].ToString()), int.Parse(row["CattleParentFatherID"].ToString()), int.Parse(row["CattleParentMotherID"].ToString()), (row["CattleImage"].ToString()) , offSpring, sStatus, double.Parse(row["CattleScotralSize"].ToString()), row["CattleColor"].ToString(), bStatus, frmeSize, double.Parse(row["CattleBirthWeight"].ToString()), double.Parse(row["CattleWeaningWeight"].ToString()), double.Parse(row["CattlePostWeaningWeight"].ToString()), double.Parse(row["CattleAdultSxWeight"].ToString()), double.Parse(row["CattleCurrentAdultWeight"].ToString()), DateTime.Parse(row["CattleCurrentWeightDateTaken"].ToString()), null, null, null )); } } return(cattle); }
public Cattle ( int aId, string aBreed, GenderEnum aGender, double aAge, int aYear, int aMonth, int aDay, AnimalTypeEnum aType, string aIdentifactionChar, string aCustomeIdentifaction, int oId, int pId, string pName, string pSurname, DateTime dob, int cId, int cParentFId, int cParentMId, string cImagePath, List <Cattle> cOffSpring, StatusEnum status, double cScotralSize, string cColor, BreedingStatus cBreedingStatus, FrameSize cFrameSize, double cBirthWeight, double cWeaningWeight, double cPostWeaningWeight, double cAdultSxWeight, double cCurrentAdultWeight, DateTime cCurrentWeightDateTaken, List <string> cDiagnoses, List <double> cAdultWeightHistory, List <DateTime> cAdultWeightDateHistory, DateTime aDOB ) : base(aId, aBreed, aGender, aAge, aYear, aMonth, aDay, aType, oId, pId, pName, pSurname, dob, status, aIdentifactionChar, aCustomeIdentifaction) { this.cId = cId; this.cParentFId = cParentFId; this.cParentMId = cParentMId; this.cImagePath = cImagePath; this.cOffSpring = cOffSpring; this.cScotralSize = cScotralSize; this.cColor = cColor; this.cBreedingStatus = cBreedingStatus; this.cFrameSize = cFrameSize; this.cBirthWeight = cBirthWeight; this.cWeaningWeight = cWeaningWeight; this.cPostWeaningWeight = cPostWeaningWeight; this.cAdultSxWeight = cAdultSxWeight; this.cCurrentAdultWeight = cCurrentAdultWeight; this.cCurrentWeightDateTaken = cCurrentWeightDateTaken; //------ this.cDiagnoses = cDiagnoses; this.cAdultWeightDateHistory = cAdultWeightDateHistory; this.cAdultWeightHistory = cAdultWeightHistory; //------ this.aDOB = aDOB; }
//get Offspring public static List <Cattle> GetAnimalsOffSpring(int UId, int AnimalID, string gender, Person person) { ac.OpenConnection(); // create procedure GetAnimalOffspring //@UID Bigint, //@AID Bigint, //@ParentGender varchar(100) List <Cattle> cattle = new List <Cattle>(); //parameter and variable of this Procedure string[] variables = new string[] { "@UID", "@AID", "@ParentGender" }; string[] values = new string[] { "" + UId, AnimalID.ToString(), gender }; //get data from database DataTable data = ac.ExecuteDataTableProcedure("GetAnimalOffspring", variables, values, ac); if (data.Rows.Count != 0) { foreach (DataRow row in data.Rows) { //A.PERSONID, //A.AnimalTid 0, A.AnimalType 1, A.AnimalBreed 2, A.AnimalCustomID 3, A.AnimalCurOwnerSignature 4, A.AnimalGender 5, //A.AnimalAge 6, A.AnimalYear 7, A.AnimalMonth 8, A.AnimalDay 9, A.AnimalStatus 10, A.IdentificationChar 11, //C.CattleParentFatherID 12, C.CattleParentMotherID 13,C.CattleImage 14,C.CattleScotralSize 15,C.CattleColor 16,C.CattleBreedingStatus 17, //C.CattleFrameSize 18,C.CattleBirthWeight 19,C.CattleWeaningWeight 20,C.CattlePostWeaningWeight 21,C.CattleAdultSxWeight 22, //C.CattleCurrentAdultWeight 23, C.CattleCurrentWeightDateTaken 24 //offspring List <Cattle> offSpring = new List <Cattle>(); #region Enums //frame size FrameSize frmeSize = (FrameSize)Enum.Parse(typeof(FrameSize), row[19].ToString()); //Breeding status BreedingStatus bStatus = (BreedingStatus)Enum.Parse(typeof(BreedingStatus), row[18].ToString()); //Status Enum StatusEnum sStatus = (StatusEnum)Enum.Parse(typeof(StatusEnum), row[11].ToString()); //Gender Enum GenderEnum gEnum = (GenderEnum)Enum.Parse(typeof(GenderEnum), row[6].ToString()); //animal type AnimalTypeEnum animalType = (AnimalTypeEnum)Enum.Parse(typeof(AnimalTypeEnum), row[2].ToString()); #endregion //weights List <double> weights = DataAccessData.AnimalWeightHistory(person.PId, int.Parse(row[1].ToString())).Values.ToList(); List <DateTime> weightDate = DataAccessData.AnimalWeightHistory(person.PId, int.Parse(row[1].ToString())).Keys.ToList(); cattle.Add ( new Cattle ( int.Parse(row[1].ToString()), row[3].ToString(), gEnum, double.Parse(row[7].ToString()), int.Parse(row[8].ToString()), int.Parse(row[9].ToString()), int.Parse(row[10].ToString()), animalType, row[4].ToString(), row[5].ToString(), person.PId, person.PId, person.PName, person.PSurname, person.Dob, 14478899, int.Parse(row[13].ToString()), int.Parse(row[14].ToString()), row[15].ToString() , null, sStatus, double.Parse(row[16].ToString()), row[17].ToString(), bStatus, frmeSize, double.Parse(row[20].ToString()), double.Parse(row[21].ToString()), double.Parse(row[22].ToString()), double.Parse(row[23].ToString()), double.Parse(row[24].ToString()), DateTime.Parse(row[25].ToString()), null, weights, weightDate )); } } return(cattle); }