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);
}
