public IEnumerable<Contact> ReadAllContacts(int? categoryId = default(int?))
{
string query = "SELECT c.Id, Name, AddressId, a.StreetAndNumber, a.ZipCode, a.City, Gender, Blocked, BirthDay, Phone, Mobile FROM Contacts c INNER JOIN Addresses a ON a.Id = AddressId";
List<Contact> contactsTemp = new List<Contact>();
using (SqlConnection conn = GetConnection())
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Contact loadingContact = new Contact();
loadingContact.ContactId = reader.GetInt32(0);
loadingContact.Name = reader.GetString(1);
Address adres = new Address();
adres.AddressId = reader.GetInt32(2);
adres.StreetAndNumber = reader.GetString(3);
adres.Zipcode = (short)reader.GetInt16(4); //kan fout geven
adres.City = reader.GetString(5);
loadingContact.Adress = adres;
byte genderInt = reader.GetByte(6);// blijkbaar met eem byte
if (genderInt == 1)
loadingContact.Gender = Gender.Male;
else
loadingContact.Gender = Gender.Female;
loadingContact.Blocked = reader.GetBoolean(7);
loadingContact.Birthday = reader.GetDateTime(8);
loadingContact.Phone = reader.IsDBNull(9) ? null : reader.GetString(9);
loadingContact.Mobile = reader.IsDBNull(10) ? null : reader.GetString(10);
contactsTemp.Add(loadingContact);
}
}
return contactsTemp;
}
public void EditContact(Domain.Contact contact)
{
if (_db.Contact.Find(contact.Id) != null)
{
_db.Contact.Update(Mapper.Map(contact));
}
}
public void CreateContact(Contact contactToInsert)
{
// stap 1: de querry implementeren.
string adresQuery = "INSERT INTO Addresses (StreetAndNumber, ZipCode, City) VALUES (@streetAndNumber, @zipCode, @city);";
string contacQuerry = "INSERT INTO Contacts (Name, AddressId, Gender, Blocked, BirthDay, Phone, Mobile) VALUES (@name, @addressId, @gender, @blocked, @birthDay, @phone, @mobile)";
string indentityQuery = "SELECT SCOPE_IDENTITY()";
// een connectie starten
using (SqlConnection connectie = GetConnection())
{
connectie.Open();
//sql command definieren
//SqlCommand commando = new SqlCommand(contacQuerry, connectie);
//paramenters aanpassen
SqlCommand commando = new SqlCommand(adresQuery+indentityQuery, connectie);
commando.Parameters.AddWithValue("@streetAndNumber", contactToInsert.Adress.StreetAndNumber);
commando.Parameters.AddWithValue("@zipCode", contactToInsert.Adress.Zipcode);
commando.Parameters.AddWithValue("@city", contactToInsert.Adress.City);
//commando.ExecuteNonQuery();
int id = Convert.ToInt32(commando.ExecuteScalar());
commando = new SqlCommand(contacQuerry, connectie);
commando.Parameters.AddWithValue("@name", contactToInsert.Name);
commando.Parameters.AddWithValue("@addressId", id);//dummy waarde
commando.Parameters.AddWithValue("@gender", contactToInsert.Gender);
commando.Parameters.AddWithValue("@blocked", contactToInsert.Blocked);
commando.Parameters.AddWithValue("@birthDay", contactToInsert.Birthday);
commando.Parameters.AddWithValue("@phone", contactToInsert.Phone);
commando.Parameters.AddWithValue("@mobile", contactToInsert.Mobile);
commando.ExecuteNonQuery();
connectie.Close();
}
}
public async Task CreateCustomerFile_WithFileID_CreatesFileWithCorrectFileID()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Address address = new Address(
"1 High Street",
null,
"Some town",
"Some county",
"Post code",
new Country(Guid.NewGuid(), "UK - England"),
"01234 567890",
"*****@*****.**");
Contact contact = new Contact("John", "Smith", "Manager");
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
organisation.AddOrUpdateAddress(AddressType.OrganisationAddress, address);
organisation.AddOrUpdateMainContactPerson(contact);
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
BySchemeCustomerFileGenerator generator = new BySchemeCustomerFileGenerator();
ulong id = 12345;
// Act
var result = await generator.CreateAsync(id, invoiceRun);
CustomerFile customerFile = result.IbisFile;
// Assert
Assert.Equal((ulong)12345, customerFile.FileID);
}
/// <summary>
/// Triggers this instance.
/// </summary>
protected override void Trigger(Contact contact)
{
var chance = Random.Next(0, 70);
if (chance == 1)
{
contact.TagLine = _quotes.SelectRandom();
}
else if (chance == 2)
{
contact.TagLine = "";
}
}
public static externalDTO.Contact MapFromDomain(internalDTO.Contact contact)
{
var res = contact == null ? null : new externalDTO.Contact
{
Id = contact.Id,
PersonId = contact.PersonId,
Person = PersonMapper.MapFromDomain(contact.Person),
ContactTypeId = contact.ContactTypeId,
ContactType = ContactTypeMapper.MapFromDomain(contact.ContactType),
ContactValue = contact.ContactValue
};
return(res);
}
public static Data.Entities.Contact Map(Domain.Contact dmContact)
{
Data.Entities.Contact deContact = new Entities.Contact();
deContact.Id = dmContact.Id;
deContact.FirstName = dmContact.FirstName;
deContact.MiddleName = dmContact.MiddleName;
deContact.LastName = dmContact.LastName;
deContact.Mobile = dmContact.Mobile;
deContact.WorkPhone = dmContact.WorkPhone;
deContact.HomePhone = dmContact.HomePhone;
deContact.Email = dmContact.Email;
deContact.Created = dmContact.Created;
deContact.Modified = dmContact.Modified;
return(deContact);
}
/// <summary>
/// Creates a new contact.
/// </summary>
public Contact CreateContact()
{
var result = new Contact();
if (_random.Next(2) == 0)
{
result.Name = _maleFirstNames.SelectRandom() + " " + _lastNames.SelectRandom();
result.Photo = ExtractPhoto(false);
}
else
{
result.Name = _femaleFirstNames.SelectRandom() + " " + _lastNames.SelectRandom();
result.Photo = ExtractPhoto(true);
}
result.EmailAddress = result.Name.ToLowerInvariant().Replace(" ", ".") + "@hotmail.com";
_behaviors.SelectRandom().ApplyTo(result);
return result;
}
public async Task CanModifyProducer()
{
var notification = NotificationApplicationFactory.Create(Guid.NewGuid(), NotificationType.Recovery,
UKCompetentAuthority.England, 0);
var address = new Address("address1", string.Empty, "town", string.Empty, string.Empty, "country");
var business = ObjectFactory.CreateEmptyProducerBusiness();
var contact = new Contact(string.Empty, String.Empty, String.Empty, String.Empty);
context.NotificationApplications.Add(notification);
await context.SaveChangesAsync();
var producerCollection = new ProducerCollection(notification.Id);
var producer = producerCollection.AddProducer(business, address, contact);
context.Producers.Add(producerCollection);
await context.SaveChangesAsync();
var updateProducer = producerCollection.GetProducer(producer.Id);
var newAddress = new Address("address1", string.Empty, "town", string.Empty, string.Empty, "country");
updateProducer.Address = newAddress;
await context.SaveChangesAsync();
var newAddress1 =
await context.Database.SqlQuery<string>("SELECT [Address1] FROM [Notification].[Producer] WHERE Id = @id",
new SqlParameter("id", producer.Id)).SingleAsync();
Assert.Equal("address1", newAddress1);
context.DeleteOnCommit(producer);
context.DeleteOnCommit(producerCollection);
context.DeleteOnCommit(notification);
await context.SaveChangesAsync();
}
protected abstract void Trigger(Contact contact);
public void UpdateContact(Contact contactToUpdate)
{
string query = "UPDATE Contacts SET Name = @name, Gender = @gender, Blocked = @blocked, BirthDay = @birthDay, Phone = @phone, Mobile = @mobile WHERE Id = @contactId";
using(SqlConnection conn = GetConnection())
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@name", contactToUpdate.Name);
if(contactToUpdate.Gender == Gender.Male)
{
cmd.Parameters.AddWithValue("@gender", 1);
}
else
{
cmd.Parameters.AddWithValue("@gender", 2);
}
cmd.Parameters.AddWithValue("@blocked", contactToUpdate.Blocked);
cmd.Parameters.AddWithValue("@birthDay", contactToUpdate.Birthday);
cmd.Parameters.AddWithValue("@phone", contactToUpdate.Phone);
cmd.Parameters.AddWithValue("@mobile", contactToUpdate.Mobile);
cmd.Parameters.AddWithValue("@contactId", contactToUpdate.ContactId);
cmd.ExecuteNonQuery();
conn.Close();
}
}
public void Add(Domain.Contact contact)
{
_db.Contact.Add(Mapper.Map(contact));
}
public async Task CreateCustomerFile_WithExceptionThrown_ReturnsError_AndNoCustomerFile()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Address address = new Address(
"1 High Street",
null,
"Some town",
"Some county",
null, // A null value will cause the Ibis class to throw an exception.
new Country(Guid.NewGuid(), "UK - England"),
"01234 567890",
"*****@*****.**");
Contact contact = new Contact("John", "Smith", "Manager");
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
organisation.AddOrUpdateAddress(AddressType.OrganisationAddress, address);
organisation.AddOrUpdateMainContactPerson(contact);
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
BySchemeCustomerFileGenerator generator = new BySchemeCustomerFileGenerator();
// Act
var result = await generator.CreateAsync(0, invoiceRun);
// Assert
Assert.Null(result.IbisFile);
Assert.NotEmpty(result.Errors);
}
public async Task CreateCustomerFile_WithNonUkAddress_ConcatenatesPostCodeAndCountry()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Address address = new Address(
"1 High Street",
null,
"Some town",
"Some county",
"AABB",
new Country(Guid.NewGuid(), "Netherlands"),
"01234 567890",
"*****@*****.**");
Contact contact = new Contact("John", "Smith", "Manager");
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
organisation.AddOrUpdateAddress(AddressType.OrganisationAddress, address);
organisation.AddOrUpdateMainContactPerson(contact);
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
BySchemeCustomerFileGenerator generator = new BySchemeCustomerFileGenerator();
// Act
var result = await generator.CreateAsync(0, invoiceRun);
CustomerFile customerFile = result.IbisFile;
// Assert
Assert.NotNull(customerFile);
Assert.Equal(1, customerFile.Customers.Count);
Customer customer = customerFile.Customers[0];
Assert.Equal("AABB Netherlands", customer.Address.PostCode);
}
public void CreateContact(Contact contactToInsert)
{
throw new NotImplementedException();
}
public Contact ReadContact(int id)
{
string query = "SELECT c.Id, Name, AddressId, a.StreetAndNumber, a.ZipCode, a.City, Gender, Blocked, BirthDay, Phone, Mobile FROM Contacts c INNER JOIN Addresses a ON a.Id = AddressId WHERE c.Id = @contactId";
Contact loadingContact = new Contact();
using (SqlConnection conn = GetConnection())
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@contactId", id);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
loadingContact.ContactId = reader.GetInt32(0);
loadingContact.Name = reader.GetString(1);
Address adres = new Address();
adres.AddressId = reader.GetInt32(2);
adres.StreetAndNumber = reader.GetString(3);
adres.Zipcode = (short)reader.GetInt16(4); //kan fout geven
adres.City = reader.GetString(5);
loadingContact.Adress = adres;
byte genderInt = reader.GetByte(6);// blijkbaar met eem byte
if (genderInt == 1)
loadingContact.Gender = Gender.Male;
else
loadingContact.Gender = Gender.Female;
loadingContact.Blocked = reader.GetBoolean(7);
loadingContact.Birthday = reader.GetDateTime(8);
loadingContact.Phone = reader.IsDBNull(9) ? null : reader.GetString(9);
loadingContact.Mobile = reader.IsDBNull(10) ? null : reader.GetString(10);
}
return loadingContact;
}
/// <summary>
/// Applies the behavior to a contact.
/// </summary>
/// <param name="contact">The contact.</param>
public void ApplyTo(Contact contact)
{
_contactsToVisit.Add(contact);
Trigger(contact);
}
/// <summary>
/// Initializes a new instance of the <see cref="ContactEventArgs"/> class.
/// </summary>
/// <param name="contact">The contact.</param>
public AddContactEventArgs(Contact contact)
{
_contact = contact;
}
public void UpdateContact(Contact contactToUpdate)
{
throw new NotImplementedException();
}