public void AddWalk(Walks walk)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "INSERT INTO Walks (Date) OUTPUT INSERTED.Id Values (@Date)";
cmd.Parameters.Add(new SqlParameter("@Date", walk.Date));
cmd.CommandText = "INSERT INTO Walks (Duration) OUTPUT INSERTED.Id Values (@Duration)";
cmd.Parameters.Add(new SqlParameter("@Duration", walk.Duration));
cmd.CommandText = "INSERT INTO Walks (WalkerId) OUTPUT INSERTED.Id Values (@WalkerId)";
cmd.Parameters.Add(new SqlParameter("@WalkerId", walk.WalkerId));
cmd.CommandText = "INSERT INTO Walks (DogId) OUTPUT INSERTED.Id Values (@DogId)";
cmd.Parameters.Add(new SqlParameter("@DogId", walk.DogId));
int id = (int)cmd.ExecuteScalar();
walk.Id = id;
}
}
}
public Walks GetWalkById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT Date, Duration, WalkerId, DogId FROM Walk WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
Walks walk = null;
if (reader.Read())
{
walk = new Walks
{
Id = id,
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId"))
};
}
reader.Close();
return(walk);
}
}
}
public Walks GetWalkById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT *
From Walks
WHERE Id = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkStatusId = reader.GetInt32(reader.GetOrdinal("WalkStatusId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId"))
};
reader.Close();
return(walk);
}
reader.Close();
return(null);
}
}
}
public int TotalWalkTime()
{
int totalTime = 0;
Walks.ForEach(w => totalTime += w.Duration);
return(totalTime / 60);
}
public void UpdateWalk(Walks walk)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
UPDATE Walks
SET
WalkStatusId = @statusId,
Duration = @duration,
WalkerId = @walker,
DogId = @dog
WHERE Id = @id
";
cmd.Parameters.AddWithValue("@statusId", walk.WalkStatusId);
cmd.Parameters.AddWithValue("@duration", walk.Duration);
cmd.Parameters.AddWithValue("@walker", walk.WalkerId);
cmd.Parameters.AddWithValue("@dog", walk.DogId);
cmd.Parameters.AddWithValue("@id", walk.Id);
cmd.ExecuteNonQuery();
}
}
}
public void AddWalk(Walks walk)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
INSERT INTO Walks (
Date,
Duration,
walkerId,
dogId)
OUTPUT INSERTED.ID
VALUES (@date, @duration, @walkerId, @dogId);
";
cmd.Parameters.AddWithValue("@date", walk.Date);
cmd.Parameters.AddWithValue("@duration", walk.Duration);
cmd.Parameters.AddWithValue("@walkerId", walk.WalkerId);
cmd.Parameters.AddWithValue("@dogId", walk.DogId);
int id = (int)cmd.ExecuteScalar();
walk.Id = id;
}
}
}
public void SaveWalk()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
db.DeferredLoadingEnabled = false;
Walks walk = new Walks
{
AnimalID = AnimalID,
Date = Date,
PersonID = PersonID,
Note = Note
};
db.Walks.InsertOnSubmit(walk);
db.SubmitChanges();
ID = walk.ID;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SetInformations(Walks walk)
{
Note = walk.Note;
AnimalID = walk.AnimalID;
Date = walk.Date;
PersonID = walk.PersonID;
}
public List <Walks> GetWalksByWalkerId(int walkerId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT * FROM Walks WHERE WalkerId=@id";
cmd.Parameters.AddWithValue("@id", walkerId);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId"))
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public void UpdateWalks(Walks walk)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
UPDATE Walks
SET Date = @date
Duration = @duration
walkerId = @walkerId
dogId = @dogId
OUTPUT INSERTED.ID
VALUES (@date, @duration, @walkerId, @dogId)";
cmd.Parameters.AddWithValue("@date", walk.Date);
cmd.Parameters.AddWithValue("@duration", walk.Duration);
cmd.Parameters.AddWithValue("@walkerId", walk.WalkerId);
cmd.Parameters.AddWithValue("@dogId", walk.DogId);
cmd.ExecuteNonQuery();
}
}
}
public List <Walks> GetAll()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT Id, Date, Duration, WalkerId, DogId FROM Walks";
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public ActionResult Create(Walks Walk)
{
try {
int counter = 0;
foreach (int dog in Walk.Dogs)
{
_walkRepo.AddWalks(Walk, counter);
counter++;
}
return(RedirectToAction("Index"));
}
catch
{
List <Dog> Dog = _dogRepo.GetAllDogs();
List <Walker> Walker = _walkerRepo.GetAllWalkers();
WalksViewModel vm = new WalksViewModel
{
Dog = Dog,
Walker = Walker,
Walk = new Walks()
};
return(View(vm));
}
}
private void LvAnimals_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Walks selectedAnimal = lvAnimals.SelectedItem as Walks;
if (selectedAnimal != null)
{
selectedAnimal.walk();
}
}
public string TotalWalkTime()
{
List <int> durationArray = Walks.Select(w => w.Duration).ToList();
int totalminutes = durationArray.Sum() / 60;
int hours = (totalminutes / 60);
int mins = totalminutes - (hours * 60);
return($"{hours} hours {mins} mins");
}
public Walks GetWalkByIdDetails(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id,
w.Date,
w.Duration,
w.dogId,
w.walkerId ,
d.Name as DogName,
ww.Name as WalkerName
FROM Walks w
JOIN Dog d ON w.dogId = d.Id
JOIN Walker ww on w.walkerId = ww.Id
WHERE w.Id = @id
";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
DogId = reader.GetInt32(reader.GetOrdinal("Id")),
WalkerId = reader.GetInt32(reader.GetOrdinal("walkerId")),
Dog = new Dog()
{
Name = reader.GetString(reader.GetOrdinal("DogName"))
},
Walker = new Walker()
{
Name = reader.GetString(reader.GetOrdinal("WalkerName"))
}
};
reader.Close();
return(walk);
}
else
{
reader.Close();
return(null);
}
}
}
}
public List <Walks> GetAllWalks()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id, w.[Date], w.Duration, w.WalkerId, w.DogId, d.Name as DogName, d.OwnerId, o.Name as OwnerName, wa.Name as WalkerName
FROM Walks w
JOIN Dog d ON w.DogId = d.Id
JOIN Owner o On o.Id = d.OwnerId
Join Walker wa ON w.WalkerId = wa.Id
Order By WalkerName
";
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
Walker = new Walker
{
Name = reader.GetString(reader.GetOrdinal("WalkerName")),
},
Dog = new Dog
{
Name = reader.GetString(reader.GetOrdinal("DogName")),
},
Owner = new Owner
{
Name = reader.GetString(reader.GetOrdinal("OwnerName")),
}
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public ActionResult Edit(int id, Walks walk)
{
try
{
_walksRepository.UpdateWalk(walk);
return(RedirectToAction("Details", "Walkers"));
}
catch
{
return(View());
}
}
public List <Walks> GetAllWalks()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id,
w.Date,
w.Duration,
w.dogId,
w.walkerId ,
d.Name as DogName,
ww.Name as WalkerName
FROM Walks w
JOIN Dog d ON w.dogId = d.Id
JOIN Walker ww on w.walkerId = ww.Id
";
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
DogId = reader.GetInt32(reader.GetOrdinal("Id")),
WalkerId = reader.GetInt32(reader.GetOrdinal("walkerId")),
Dog = new Dog()
{
Name = reader.GetString(reader.GetOrdinal("DogName"))
},
Walker = new Walker()
{
Name = reader.GetString(reader.GetOrdinal("WalkerName"))
}
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public ActionResult Edit(int id, Walks walk)
{
try
{
_walksRepo.UpdateWalks(walk);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View(walk));
}
}
public List <Walks> GetAllWalks()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT Id, Date, Duration, WalkerId, DogId FROM Walks";
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
int idColumnPosition = reader.GetOrdinal("Id");
int idValue = reader.GetInt32(idColumnPosition);
int walkDateColumnPosition = reader.GetOrdinal("Date");
DateTime walkDateValue = reader.GetDateTime(walkDateColumnPosition);
int walkDurationColumnPosition = reader.GetOrdinal("Duration");
int walkDurationValue = reader.GetInt32(walkDurationColumnPosition);
int walkWalkerIdColumnPosition = reader.GetOrdinal("WalkerId");
int walkWalkerIdValue = reader.GetInt32(walkWalkerIdColumnPosition);
int walkDogIdColumnPosition = reader.GetOrdinal("DogId");
int walkDogIdValue = reader.GetInt32(walkDogIdColumnPosition);
Walks walk = new Walks
{
Id = idValue,
Date = walkDateValue,
Duration = walkDurationValue,
WalkerId = walkWalkerIdValue,
DogId = walkDogIdValue
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public List <Walks> GetWalksById(int walkerId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id,
w.Date,
w.Duration,
w.dogId,
d.ownerId as ownerId,
o.Name as OwnerName
FROM Walks w
JOIN Dog d on w.dogId = d.Id
JOIN Owner o on d.ownerId = o.Id
WHERE w.WalkerId = @walkerId
Order By OwnerName
";
cmd.Parameters.AddWithValue("@walkerId", walkerId);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
DogId = reader.GetInt32(reader.GetOrdinal("dogId")),
Dog = new Dog()
{
Id = reader.GetInt32(reader.GetOrdinal("dogId")),
OwnerId = reader.GetInt32(reader.GetOrdinal("ownerId"))
},
Owner = new Owner()
{
Name = reader.GetString(reader.GetOrdinal("OwnerName"))
}
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public List <Walks> GetWalksByWalkerId(int walkerId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT ws.Id, Date, Duration,WalkerId,DogId, o.Id, o.Name
FROM Walks ws
JOIN Dog d On ws.DogId =d.Id
JOIN Owner o On d.OwnerId = o.Id
WHERE WalkerId = @id
ORDER BY Date DESC
";
cmd.Parameters.AddWithValue("@id", walkerId);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
Dog = new Dog()
{
Id = reader.GetInt32(reader.GetOrdinal("DogId")),
Owner = new Owner()
{
Name = reader.GetString(reader.GetOrdinal("Name"))
}
},
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public Walks GetWalkById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT ws.Id, Date, Duration,WalkerId,DogId, o.Id, o.Name
FROM Walks ws
JOIN Dog d On ws.DogId =d.Id
JOIN Owner o On d.OwnerId = o.Id
WHERE Id = @id
";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
Dog = new Dog()
{
Id = reader.GetInt32(reader.GetOrdinal("DogId")),
Owner = new Owner()
{
Name = reader.GetString(reader.GetOrdinal("Name"))
}
},
};
reader.Close();
return(walk);
}
else
{
reader.Close();
return(null);
}
}
}
}
public List <Walks> GetWalksByWalker(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT wks.Id AS WalkId, Date, Duration, WalkerId, DogId,
d.Id AS DogId, OwnerId,
o.Id AS OId, o.Name AS OName
FROM Walks wks
JOIN Dog d ON d.Id = wks.DogId
JOIN Owner o ON d.OwnerId = o.Id
WHERE wks.WalkerId = @id
";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("WalkId")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
Owner = new Owner()
{
Id = reader.GetInt32(reader.GetOrdinal("OId")),
Name = reader.GetString(reader.GetOrdinal("OName"))
}
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public async Task <IActionResult> Get()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id, w.Date, w.Duration, w.DogId, w.WalkerId, wa.Id, wa.Name as walkerName
FROM Walks w
LEFT JOIN Walker wa
ON w.WalkerId = w.Id";
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> allWalks = new List <Walks>();
while (reader.Read())
{
var Walks = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
walker = new Walker()
{
Id = reader.GetInt32(reader.GetOrdinal("WalkerId")),
Name = reader.GetString(reader.GetOrdinal("walkerName"))
}
};
allWalks.Add(Walks);
}
reader.Close();
return(Ok(allWalks));
}
}
}
public List <Walks> GetWalksByWalkerId(int walkerId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT w.Id, w.Date, w.Duration, w.WalkerId, w.DogId, o.[Name] AS OwnerName
FROM Walks w
JOIN Dog d ON d.Id = w.DogId
JOIN [Owner] o ON o.Id = d.OwnerId
WHERE WalkerId = @walkerId
";
cmd.Parameters.AddWithValue("@walkerId", walkerId);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")) / 60,
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
OwnerName = reader.GetString(reader.GetOrdinal("OwnerName"))
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
public ActionResult Create(Walks Walks)
{
try
{
_walksRepo.AddWalk(Walks);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
List <Walker> walkers = _walkerRepo.GetAllWalkers();
List <Dog> dogs = _dogRepo.GetAllDogs();
WalkFormModel vm = new WalkFormModel()
{
Walks = new Walks(),
Dogs = dogs,
Walkers = walkers
};
return(View(vm));
}
}
public void UpdateWalk()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
Walks walk = db.Walks.FirstOrDefault(i => i.ID == ID);
walk.AnimalID = AnimalID;
walk.PersonID = PersonID;
walk.Note = Note;
walk.Date = Date;
db.SubmitChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//GET LIST of Walks by Dog.Id
public List <Walks> GetWalksByDogId(int dogId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT Id, Date, Duration, WalkerId, DogId
FROM Walks
WHERE DogId = @dogId
";
//built in method to create reader that can interpret sql response
cmd.Parameters.AddWithValue("@dogId", dogId);
SqlDataReader reader = cmd.ExecuteReader();
//creates a new list of dogs to hold data read by the sqldatareader
List <Walks> walksTaken = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId"))
};
//add this dog to the list dogs
walksTaken.Add(walk);
}
//READERS MUST ALWAYS BE CLOSED
reader.Close();
//return the list as our List representing Walkers.GetAllWalkers()
return(walksTaken);
}
}
}
public List <Walks> GetWalksByWalker(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT Walks.Id, Date, Duration, WalkerId, DogId, Owner.Id as OwnerId, WalkStatusId
From Walks
LEFT JOIN Dog
ON Dog.Id = Walks.DogId
LEFT JOIN Owner
ON Owner.Id = Dog.OwnerId
WHERE WalkerId = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
List <Walks> walks = new List <Walks>();
while (reader.Read())
{
Walks walk = new Walks()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Date = reader.GetDateTime(reader.GetOrdinal("Date")),
Duration = reader.GetInt32(reader.GetOrdinal("Duration")),
WalkerId = reader.GetInt32(reader.GetOrdinal("WalkerId")),
DogId = reader.GetInt32(reader.GetOrdinal("DogId")),
WalkStatusId = reader.GetInt32(reader.GetOrdinal("WalkStatusId"))
};
walks.Add(walk);
}
reader.Close();
return(walks);
}
}
}
