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