public void WorkPhoneTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
string expected = string.Empty; // TODO: Initialize to an appropriate value
string actual;
target.WorkPhone = expected;
actual = target.WorkPhone;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void TimezoneOffsetTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
Nullable<double> expected = new Nullable<double>(); // TODO: Initialize to an appropriate value
Nullable<double> actual;
target.TimezoneOffset = expected;
actual = target.TimezoneOffset;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void CustomerConstructorTest()
{
Customer target = new Customer();
Assert.Inconclusive("TODO: Implement code to verify target");
}
public void BillingAddressTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
AddressInfo expected = null; // TODO: Initialize to an appropriate value
AddressInfo actual;
target.BillingAddress = expected;
actual = target.BillingAddress;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void SaveTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
target.Save();
Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
public void CustomerNameTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
string actual;
actual = target.CustomerName;
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void CreatedOnTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
DateTime expected = new DateTime(); // TODO: Initialize to an appropriate value
DateTime actual;
target.CreatedOn = expected;
actual = target.CreatedOn;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void IDTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
Guid expected = new Guid(); // TODO: Initialize to an appropriate value
Guid actual;
target.ID = expected;
actual = target.ID;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public void SexTest()
{
Customer target = new Customer(); // TODO: Initialize to an appropriate value
bool expected = false; // TODO: Initialize to an appropriate value
bool actual;
target.Sex = expected;
actual = target.Sex;
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public static Customer ToCustomer(this DataRow row)
{
// todo: finish implementing rest of properties
Customer c = new Customer
{
ID = row.GetGuid("UserID"),
InitialOfferID = row.GetGuid("InitialOfferID"),
FirstName = row.GetString("FirstName"),
LastName = row.GetString("LastName"),
HomePhone = row.GetString("HomePhone"),
WorkPhone = row.GetString("WorkPhone"),
CellPhone = row.GetString("CellPhone"),
DOB = row.GetDate("DateOfBirth")
};
c.ShippingAddress.AddressLine1 = row.GetString("ShippingAddress1");
c.ShippingAddress.AddressLine2 = row.GetString("ShippingAddress2");
c.ShippingAddress.City = row.GetString("ShippingCity");
c.ShippingAddress.State = row.GetString("ShippingState");
c.ShippingAddress.Country = row.GetString("Country");
c.ShippingAddress.ZipCode = row.GetString("ShippingZipCode");
c.BillingAddress.AddressLine1 = row.GetString("BillingAddress1");
c.BillingAddress.AddressLine2 = row.GetString("BillingAddress2");
c.BillingAddress.City = row.GetString("BillingCity");
c.BillingAddress.State = row.GetString("BillingState");
c.BillingAddress.Country = row.GetString("BillingCountry");
c.BillingAddress.ZipCode = row.GetString("BillingZipCode");
return c;
//Customer entity = null;
//if (row["Id"] != System.DBNull.Value)
// entity.ID = (Guid)row["UserID"];
//if (row["InitialOfferID"] != System.DBNull.Value)
// entity.InitialOfferID = (Guid)row["InitialOfferID"];
//if (row["FirstName"] != System.DBNull.Value)
// entity.FirstName = (string)row["FirstName"];
//if (row["LastName"] != System.DBNull.Value)
// entity.LastName = (string)row["LastName"];
//if (row["HomePhone"] != System.DBNull.Value)
// entity.HomePhone = (string)row["HomePhone"];
//if (row["WorkPhone"] != System.DBNull.Value)
// entity.WorkPhone = (string)row["WorkPhone"];
//if (row["CellPhone"] != System.DBNull.Value)
// entity.CellPhone = (string)row["CellPhone"];
//if (row["DateOfBirth"] != System.DBNull.Value)
// entity.DOB = (DateTime)row["DateOfBirth"];
//if (row["Suffix"] != System.DBNull.Value)
// entity.Suffix = (string)row["Suffix"];
//if (row["Prefix"] != System.DBNull.Value)
// entity.Prefix = (string)row["Prefix"];
//if (row["Browser"] != System.DBNull.Value)
// entity.Browser = (string)row["Browser"];
//if (row["TimezoneOffset"] != System.DBNull.Value)
// entity.TimezoneOffset = (double)row["TimezoneOffset"];
//if (row["Timezone"] != System.DBNull.Value)
// entity.Timezone = (string)row["Timezone"];
//if (row["LanguageCode"] != System.DBNull.Value)
// entity.LanguageCode = (string)row["LanguageCode"];
//if (row["CreatedOn"] != System.DBNull.Value)
// entity.CreatedOn = (DateTime)row["CreatedOn"];
//if (row["LastUpdatedDate"] != System.DBNull.Value)
// entity.LastUpdatedOn = (DateTime)row["LastUpdatedDate"];
//if (row["ShippingAddress1"] != System.DBNull.Value)
// entity.ShippingAddress.AddressLine1= (string)row["ShippingAddress1"];
//if (row["ShippingAddress2"] != System.DBNull.Value)
// entity.ShippingAddress.AddressLine2= (string)row["ShippingAddress2"];
//if (row["ShippingCity"] != System.DBNull.Value)
// entity.ShippingAddress.City = (string)row["ShippingCity"];
//if (row["ShippingState"] != System.DBNull.Value)
// entity.ShippingAddress.State = (string)row["ShippingState"];
//if (row["ShippingCountry"] != System.DBNull.Value)
// entity.ShippingAddress.Country = (string)row["ShippingCountry"];
//if (row["ShippingZipCode"] != System.DBNull.Value)
// entity.ShippingAddress.ZipCode = (string)row["ShippingZipCode"];
//if (row["BillingAddress1"] != System.DBNull.Value)
// entity.BillingAddress.AddressLine1 = (string)row["BillingAddress1"];
//if (row["BillingAddress2"] != System.DBNull.Value)
// entity.BillingAddress.AddressLine2 = (string)row["BillingAddress2"];
//if (row["BillingCity"] != System.DBNull.Value)
// entity.BillingAddress.City = (string)row["BillingCity"];
//if (row["BillingState"] != System.DBNull.Value)
// entity.BillingAddress.State = (string)row["BillingState"];
//if (row["BillingCountry"] != System.DBNull.Value)
// entity.BillingAddress.Country = (string)row["BillingCountry"];
//if (row["BillingZipCode"] != System.DBNull.Value)
// entity.BillingAddress.ZipCode = (string)row["BillingZipCode"];
//return entity;
}
//public void CreateAudit(CustomerUserAudit audit)
//{
// CustomerUserAudit.CreateAudit(audit);
//}
#endregion
#region Static Methods
public static void Insert(Customer customer)
{
DbCommand cmd = SqlHelpers.CreateCommand(
BillingController.ConnectionString, "mon_bill_INSERT_CUSTOMER");
cmd.AddInputParam("pInitialOfferID", DbType.Guid, customer.InitialOfferID);
cmd.AddInputParam("pFirstName", DbType.String, customer.FirstName);
cmd.AddInputParam("pLastName", DbType.String, customer.LastName);
cmd.AddInputParam("pMiddleName", DbType.String, customer.MiddleName);
cmd.AddInputParam("pHomePhone", DbType.String, customer.HomePhone);
cmd.AddInputParam("pWorkPhone", DbType.String, customer.WorkPhone);
cmd.AddInputParam("pCellPhone", DbType.String, customer.CellPhone);
cmd.AddInputParam("pShippingAddress1", DbType.String, customer.ShippingAddress.AddressLine1);
cmd.AddInputParam("pShippingAddress2", DbType.String, customer.ShippingAddress.AddressLine2);
cmd.AddInputParam("pShippingCity", DbType.String, customer.ShippingAddress.City);
cmd.AddInputParam("pShippingState", DbType.String, customer.ShippingAddress.State);
cmd.AddInputParam("pShippingCountry", DbType.String, customer.ShippingAddress.Country);
cmd.AddInputParam("pShippingZipCode", DbType.String, customer.ShippingAddress.ZipCode);
cmd.AddInputParam("pBillingAddress1", DbType.String, customer.BillingAddress.AddressLine1);
cmd.AddInputParam("pBillingAddress2", DbType.String, customer.BillingAddress.AddressLine2);
cmd.AddInputParam("pBillingCity", DbType.String, customer.BillingAddress.City);
cmd.AddInputParam("pBillingState", DbType.String, customer.BillingAddress.State);
cmd.AddInputParam("pBillingCountry", DbType.String, customer.BillingAddress.Country);
cmd.AddInputParam("pBillingZipCode", DbType.String, customer.BillingAddress.ZipCode);
cmd.AddInputParam("pDateOfBirth", DbType.Date, customer.DOB);
cmd.AddInputParam("pSuffix", DbType.String, customer.Suffix);
cmd.AddInputParam("pPrefix", DbType.String, customer.Prefix);
cmd.AddInputParam("pBrowser", DbType.String, customer.Browser);
cmd.AddInputParam("pTimezone", DbType.String, customer.Timezone);
cmd.AddInputParam("pTimezoneOffset", DbType.Double, customer.TimezoneOffset);
cmd.AddInputParam("pLanguageCode", DbType.String, customer.LanguageCode);
cmd.AddInputParam("pSex", DbType.Boolean, customer.Sex);
cmd.AddOutputParam("oCustomerID", DbType.Guid);
SqlHelpers.ExecuteNonQuery(cmd);
customer.ID = cmd.ExtractGuid("oCustomerID");
}
public static void Update(Customer customer)
{
DbCommand cmd = SqlHelpers.CreateCommand(
BillingController.ConnectionString, "mon_bill_UPDATE_CUSTOMER");
}