public LocationVO(LocationDO location)
{
XPosition = location.LocationX;
YPosition = location.LocationY;
Name = location.Title;
ID = location.ID;
}
public static ILocationInfoDO MapPOtoDO(LocationPO iFrom)
{
ILocationInfoDO newlocation = new LocationDO();
newlocation.LocationID = iFrom.LocationID;
newlocation.LocationName = iFrom.LocationName;
newlocation.Address = iFrom.Address;
newlocation.Phone = iFrom.Phone;
newlocation.MaxCapacity = iFrom.MaxCapacity;
return(newlocation);
}
public List <ILocationInfoDO> ViewAllLocations()
{
List <ILocationInfoDO> viewList = new List <ILocationInfoDO>();
try
{
//create connection
using (SqlConnection connectionToSQL = new SqlConnection(connectionString))
//create a command
using (SqlCommand command = new SqlCommand("VIEW_ALL_LOCATIONS", connectionToSQL))
{
try
{
connectionToSQL.Open();
//use reader
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ILocationInfoDO location = new LocationDO();
location.LocationID = reader.GetInt64(0);
location.LocationName = reader.GetString(1);
location.Address = reader.GetString(2);
location.Phone = reader.GetString(3);
location.MaxCapacity = reader.GetInt64(4);
viewList.Add(location);
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
throw e;
}
finally
{
connectionToSQL.Close();
connectionToSQL.Dispose();
}
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
throw e;
}
finally
{
}
return(viewList);
}
public ILocationInfoDO ViewLocationByID(long LocationID)
{
ILocationInfoDO viewlocation = new LocationDO();
try
{
using (SqlConnection connectionToSQL = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand("VIEW_LOCATION_BY_ID", connectionToSQL))
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 35;
command.Parameters.AddWithValue("@LocationID", LocationID);
connectionToSQL.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
viewlocation.LocationID = reader.GetInt64(0);
viewlocation.LocationName = reader.GetString(1);
viewlocation.Address = reader.GetString(2);
viewlocation.Phone = reader.GetString(3);
viewlocation.MaxCapacity = reader.GetInt64(4);
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
throw e;
}
finally
{
}
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
throw e;
}
finally
{
//nothing
}
return(viewlocation);
}
public void MapDOtoPO()
{
//arange
ILocationInfoDO mock = new LocationDO();
mock.LocationID = 99;
mock.LocationName = "Home";
mock.Address = "123 Main";
mock.Phone = "999-999-9999";
mock.MaxCapacity = 50000;
//act
var result = LocationMap.MapDOtoPO(mock);
//assert
Assert.AreEqual(99, result.LocationID);
Assert.AreEqual("Home", result.LocationName);
Assert.AreEqual("123 Main", result.Address);
Assert.AreEqual("999-999-9999", result.Phone);
Assert.AreEqual(50000, result.MaxCapacity);
//assert for full method
// Assert.AreEqual(result, mock);
}
