public void SaveNewAddress()
{
//Arrange
var db = new DBIntegrationEntities();
var myDateTime = new DateTime();
var sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd HH:mm:ss");
var newAdd = new Address();
newAdd.SiteId = 101;
newAdd.AddressTypeId = 5;
newAdd.AddressLine1 = "RealWorld Food";
newAdd.AddressLine2 = "101 Maple Str";
newAdd.AddressLine3 = "Suite 150";
newAdd.City = "Meridian";
newAdd.StateProvinceRegionId = 43;
newAdd.PostalCode = "83646";
newAdd.CountryRegionId = 01;
newAdd.CreatedDateTime = myDateTime;
newAdd.CreatedBy = "Administrator";
newAdd.ModifiedDateTime = myDateTime;
newAdd.ModifiedBy = "Administrator";
db.Addresses.Add(newAdd);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
Address savedAdd = (from d in db.Addresses where d.AddressId == newAdd.AddressId select d).Single();
Assert.AreEqual(savedAdd.SiteId , newAdd.SiteId);
Assert.AreEqual(savedAdd.AddressTypeId, newAdd.AddressTypeId);
Assert.AreEqual(savedAdd.AddressLine1, newAdd.AddressLine1);
Assert.AreEqual(savedAdd.AddressLine2, newAdd.AddressLine2);
Assert.AreEqual(savedAdd.AddressLine3, newAdd.AddressLine3);
Assert.AreEqual(savedAdd.City, newAdd.City);
Assert.AreEqual(savedAdd.StateProvinceRegionId, newAdd.StateProvinceRegionId);
Assert.AreEqual(savedAdd.PostalCode, newAdd.PostalCode);
Assert.AreEqual(savedAdd.CountryRegionId, newAdd.CountryRegionId);
Assert.AreEqual(savedAdd.CreatedDateTime, newAdd.CreatedDateTime);
Assert.AreEqual(savedAdd.CreatedBy, newAdd.CreatedBy);
Assert.AreEqual(savedAdd.ModifiedDateTime, newAdd.ModifiedDateTime);
Assert.AreEqual(savedAdd.ModifiedBy, newAdd.ModifiedBy);
//cleanup
db.Addresses.Remove(newAdd);
db.SaveChanges();
}
public void SaveNewAddress()
{
//Arrange
var db = new DBIntegrationEntities();
var myDateTime = new DateTime();
var sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd HH:mm:ss");
var newAdd = new Address();
newAdd.SiteId = 101;
newAdd.AddressTypeId = 5;
newAdd.AddressLine1 = "RealWorld Food";
newAdd.AddressLine2 = "101 Maple Str";
newAdd.AddressLine3 = "Suite 150";
newAdd.City = "Meridian";
newAdd.StateProvinceRegionId = 43;
newAdd.PostalCode = "83646";
newAdd.CountryRegionId = 01;
newAdd.CreatedDateTime = myDateTime;
newAdd.CreatedBy = "Administrator";
newAdd.ModifiedDateTime = myDateTime;
newAdd.ModifiedBy = "Administrator";
db.Addresses.Add(newAdd);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
Address savedAdd = (from d in db.Addresses where d.AddressId == newAdd.AddressId select d).Single();
Assert.AreEqual(savedAdd.SiteId, newAdd.SiteId);
Assert.AreEqual(savedAdd.AddressTypeId, newAdd.AddressTypeId);
Assert.AreEqual(savedAdd.AddressLine1, newAdd.AddressLine1);
Assert.AreEqual(savedAdd.AddressLine2, newAdd.AddressLine2);
Assert.AreEqual(savedAdd.AddressLine3, newAdd.AddressLine3);
Assert.AreEqual(savedAdd.City, newAdd.City);
Assert.AreEqual(savedAdd.StateProvinceRegionId, newAdd.StateProvinceRegionId);
Assert.AreEqual(savedAdd.PostalCode, newAdd.PostalCode);
Assert.AreEqual(savedAdd.CountryRegionId, newAdd.CountryRegionId);
Assert.AreEqual(savedAdd.CreatedDateTime, newAdd.CreatedDateTime);
Assert.AreEqual(savedAdd.CreatedBy, newAdd.CreatedBy);
Assert.AreEqual(savedAdd.ModifiedDateTime, newAdd.ModifiedDateTime);
Assert.AreEqual(savedAdd.ModifiedBy, newAdd.ModifiedBy);
//cleanup
db.Addresses.Remove(newAdd);
db.SaveChanges();
}
public void SaveNewPerson()
{
//Arrange
var db = new DBIntegrationEntities();
Person newUser = new Person();
newUser.OrganizationId = 1234;
newUser.UserTypeId = 12;
newUser.FirstName = "Fred";
newUser.LastName = "Jones";
newUser.PhoneNumber = "208-555=-234";
newUser.EmailAddress = "*****@*****.**";
newUser.UnitName = "RealIdaho";
newUser.UnitNumber = "4301";
newUser.Department = "Fast Food";
newUser.CreatedDateTime = new DateTime();
newUser.CreatedBy = "Administrator";
newUser.ModifiedDateTime = new DateTime();
newUser.ModifiedBy = "Administrator";
db.People.Add(newUser);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
var saveUser = (from d in db.People where d.UserId == newUser.UserId select d).Single();
Assert.AreEqual(saveUser.OrganizationId, newUser.OrganizationId);
Assert.AreEqual(saveUser.UserTypeId, newUser.UserTypeId);
Assert.AreEqual(saveUser.FirstName, newUser.FirstName);
Assert.AreEqual(saveUser.LastName, newUser.LastName);
Assert.AreEqual(saveUser.PhoneNumber, newUser.PhoneNumber);
Assert.AreEqual(saveUser.EmailAddress, newUser.EmailAddress);
Assert.AreEqual(saveUser.UnitName, newUser.UnitName);
Assert.AreEqual(saveUser.UnitNumber, newUser.UnitNumber);
Assert.AreEqual(saveUser.Department, newUser.Department);
Assert.AreEqual(saveUser.CreatedDateTime, newUser.CreatedDateTime);
Assert.AreEqual(saveUser.ModifiedDateTime, newUser.ModifiedDateTime);
Assert.AreEqual(saveUser.ModifiedBy, newUser.ModifiedBy);
//cleanup
db.People.Remove(newUser);
db.SaveChanges();
}
public void SaveNewSiteInfo()
{
//Arrange
var db = new DBIntegrationEntities();
Site newSite = new Site();
newSite.OrganizationId = 1234;
newSite.SiteTypeId = 7;
newSite.SiteName = "Little Island";
newSite.SiteCode = "RWF001";
newSite.TimeZoneId = 8;
newSite.CreatedDateTime = new DateTime();
newSite.CreatedBy = "Adminstrator";
newSite.ModifiedDateTime = new DateTime();
newSite.ModifiedBy = "Administrator";
db.Sites.Add(newSite);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
Site saveSite = (from d in db.Sites where d.SiteId == newSite.SiteId select d).Single();
Assert.AreEqual(saveSite.OrganizationId, newSite.OrganizationId);
Assert.AreEqual(saveSite.SiteTypeId, newSite.SiteTypeId);
Assert.AreEqual(saveSite.SiteName, newSite.SiteName);
Assert.AreEqual(saveSite.SiteCode, newSite.SiteCode);
Assert.AreEqual(saveSite.TimeZoneId, newSite.TimeZoneId);
Assert.AreEqual(saveSite.CreatedDateTime, newSite.CreatedDateTime);
Assert.AreEqual(saveSite.CreatedBy, newSite.CreatedBy);
Assert.AreEqual(saveSite.ModifiedDateTime, newSite.ModifiedDateTime);
Assert.AreEqual(saveSite.ModifiedBy, newSite.ModifiedBy);
//cleanup
db.Sites.Remove(newSite);
db.SaveChanges();
}
public void SaveNewPerson()
{
//Arrange
var db = new DBIntegrationEntities();
Person newUser = new Person();
newUser.OrganizationId = 1234;
newUser.UserTypeId = 12;
newUser.FirstName = "Fred";
newUser.LastName = "Jones";
newUser.PhoneNumber = "208-555=-234";
newUser.EmailAddress = "*****@*****.**";
newUser.UnitName = "RealIdaho";
newUser.UnitNumber = "4301";
newUser.Department = "Fast Food";
newUser.CreatedDateTime = new DateTime();
newUser.CreatedBy = "Administrator";
newUser.ModifiedDateTime = new DateTime();
newUser.ModifiedBy = "Administrator";
db.People.Add(newUser);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
var saveUser = (from d in db.People where d.UserId == newUser.UserId select d).Single();
Assert.AreEqual(saveUser.OrganizationId, newUser.OrganizationId);
Assert.AreEqual(saveUser.UserTypeId, newUser.UserTypeId);
Assert.AreEqual(saveUser.FirstName, newUser.FirstName);
Assert.AreEqual(saveUser.LastName, newUser.LastName);
Assert.AreEqual(saveUser.PhoneNumber, newUser.PhoneNumber);
Assert.AreEqual(saveUser.EmailAddress, newUser.EmailAddress);
Assert.AreEqual(saveUser.UnitName, newUser.UnitName);
Assert.AreEqual(saveUser.UnitNumber, newUser.UnitNumber);
Assert.AreEqual(saveUser.Department, newUser.Department);
Assert.AreEqual(saveUser.CreatedDateTime, newUser.CreatedDateTime);
Assert.AreEqual(saveUser.ModifiedDateTime, newUser.ModifiedDateTime);
Assert.AreEqual(saveUser.ModifiedBy, newUser.ModifiedBy);
//cleanup
db.People.Remove(newUser);
db.SaveChanges();
}
public void SaveNewSiteInfo()
{
//Arrange
var db = new DBIntegrationEntities();
Site newSite = new Site();
newSite.OrganizationId = 1234;
newSite.SiteTypeId = 7;
newSite.SiteName = "Little Island";
newSite.SiteCode = "RWF001";
newSite.TimeZoneId = 8;
newSite.CreatedDateTime = new DateTime();
newSite.CreatedBy = "Adminstrator";
newSite.ModifiedDateTime = new DateTime();
newSite.ModifiedBy = "Administrator";
db.Sites.Add(newSite);
//Act
db.SaveChanges();
//Assert -- See if the record retrieved matches the one just entered
Site saveSite = (from d in db.Sites where d.SiteId == newSite.SiteId select d).Single();
Assert.AreEqual(saveSite.OrganizationId, newSite.OrganizationId);
Assert.AreEqual(saveSite.SiteTypeId, newSite.SiteTypeId);
Assert.AreEqual(saveSite.SiteName, newSite.SiteName);
Assert.AreEqual(saveSite.SiteCode, newSite.SiteCode);
Assert.AreEqual(saveSite.TimeZoneId, newSite.TimeZoneId);
Assert.AreEqual(saveSite.CreatedDateTime, newSite.CreatedDateTime);
Assert.AreEqual(saveSite.CreatedBy, newSite.CreatedBy);
Assert.AreEqual(saveSite.ModifiedDateTime, newSite.ModifiedDateTime);
Assert.AreEqual(saveSite.ModifiedBy, newSite.ModifiedBy);
//cleanup
db.Sites.Remove(newSite);
db.SaveChanges();
}
