private static Run convertToRun(DataRow row) { Run run = new HawkeyehvkBLL.Run(); run.runNumber = Convert.ToInt32(row[0]); if (((String)row[1]).ToUpper().Equals(("L"))) { run.size = 'L'; } else { run.size = 'R'; } return(run); }
public static List <Reservation> fillReservationModified(DataSet ds) {// this was modified to get pet info and run number Reservation res = new Reservation(); List <Reservation> resList = new List <Reservation>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { if (i != 0 && (Convert.ToInt32(ds.Tables[0].Rows[i]["RESERVATION_NUMBER"]) == Convert.ToInt32(ds.Tables[0].Rows[i - 1]["RESERVATION_NUMBER"]))) { res.petReservationList.Add(new PetReservation()); res.petReservationList[res.petReservationList.Count - 1].pet.petNumber = Convert.ToInt16(ds.Tables[0].Rows[i]["PET_NUMBER"].ToString()); try { Run run = new HawkeyehvkBLL.Run(); run.runNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["RUN_RUN_NUMBER"].ToString()); res.petReservationList[res.petReservationList.Count - 1].run = run; } catch { //run was null } Pet pet = new Pet(); pet.petNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["PET_NUMBER"].ToString()); pet.name = ds.Tables[0].Rows[i]["PET_NAME"].ToString(); pet.gender = ds.Tables[0].Rows[i]["PET_GENDER"].ToString().ToCharArray()[0]; pet.isFixed = ds.Tables[0].Rows[i]["PET_FIXED"].ToString().ToCharArray()[0]; pet.breed = ds.Tables[0].Rows[i]["PET_BREED"].ToString(); try { pet.birthday = DateTime.Parse(ds.Tables[0].Rows[i]["PET_BIRTHDATE"].ToString()); } catch { //birthday was null } pet.size = ds.Tables[0].Rows[i]["DOG_SIZE"].ToString().ToCharArray()[0]; pet.notes = ds.Tables[0].Rows[i]["SPECIAL_NOTES"].ToString(); res.petReservationList[res.petReservationList.Count - 1].pet = pet; res.petReservationList[res.petReservationList.Count - 1].petResNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["PET_RES_NUMBER"]); } else { res = new Reservation(); //Retrieve pet info , owner # , reservation detail res.reservationNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["RESERVATION_NUMBER"]); res.startDate = DateTime.Parse(ds.Tables[0].Rows[i]["RESERVATION_START_DATE"].ToString()); res.endDate = DateTime.Parse(ds.Tables[0].Rows[i]["RESERVATION_END_DATE"].ToString()); res.ownerNumber = Convert.ToInt16(ds.Tables[0].Rows[i]["OWNER_NUMBER"].ToString()); res.petReservationList.Add(new PetReservation()); // int petNum = Convert.ToInt16(ds.Tables[0].Rows[i]["PET_NUMBER"].ToString()); //res.petReservationList[res.petReservationList.Count - 1].pet.petNumber = Convert.ToInt16(ds.Tables[0].Rows[i]["PET_NUMBER"].ToString()); Run run = new HawkeyehvkBLL.Run(); try { run.runNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["RUN_RUN_NUMBER"].ToString()); res.petReservationList[res.petReservationList.Count - 1].run = run; } catch { //run was null } Pet pet = new Pet(); pet.petNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["PET_NUMBER"].ToString()); pet.name = ds.Tables[0].Rows[i]["PET_NAME"].ToString(); pet.gender = ds.Tables[0].Rows[i]["PET_GENDER"].ToString().ToCharArray()[0]; pet.isFixed = ds.Tables[0].Rows[i]["PET_FIXED"].ToString().ToCharArray()[0]; pet.breed = ds.Tables[0].Rows[i]["PET_BREED"].ToString(); try { pet.birthday = DateTime.Parse(ds.Tables[0].Rows[i]["PET_BIRTHDATE"].ToString()); } catch { //birthday was null } pet.size = ds.Tables[0].Rows[i]["DOG_SIZE"].ToString().ToCharArray()[0]; pet.notes = ds.Tables[0].Rows[i]["SPECIAL_NOTES"].ToString(); res.petReservationList[res.petReservationList.Count - 1].pet = pet; res.petReservationList[res.petReservationList.Count - 1].petResNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["PET_RES_NUMBER"]); resList.Add(res); } } catch (Exception e) { Console.WriteLine(e.ToString()); } } return(resList); }