public BindingList <AddressModel> SearchContacts(string name, string postalCode, string contactType, string city)
{
BindingList <AddressModel> returnList;
using (var dataContext = new AdressbookDataContext())
{
var address = from contact in dataContext.AddressContactLink
join link in dataContext.ContactType on contact.ContactId equals link.ContactId
where contact.Contact.Name.Contains(name) &
contact.Address.PostalCode.Contains(postalCode) &
link.ContactType1.Contains(contactType) &
contact.Address.City.Contains(city)
select new AddressModel()
{
Id = contact.Address.Id,
StreetAddress = contact.Address.StreetAddress,
PostalCode = contact.Address.PostalCode,
City = contact.Address.City
};
List <AddressModel> addressList = address.ToList();
returnList = new BindingList <AddressModel>(addressList);
}
return(returnList);
}
public void DeleteContact(int addressId)
{
using (var dataContext = new AdressbookDataContext())
{
var deleteAddress = dataContext.Address.SingleOrDefault(x => x.Id == addressId);
if (deleteAddress != null)
{
dataContext.Address.Remove(deleteAddress);
}
dataContext.SaveChanges();
}
}
public BindingList <View_Models.AddressContactLinkModel> GetAddressContactLinkModels()
{
BindingList <AddressContactLinkModel> links;
using (var dataContext = new AdressbookDataContext())
{
var linkQuery = from AClink in dataContext.AddressContactLink
select new AddressContactLinkModel()
{
AddressId = AClink.AddressId,
ContactId = AClink.ContactId
};
links = new BindingList <AddressContactLinkModel>(linkQuery.ToList());
}
return(links);
}
public void UpdateAddress(int addressId, string updateValue, string columnName)
{
using (var dataContext = new AdressbookDataContext())
{
var result = dataContext.Address.SingleOrDefault(x => x.Id == addressId);
if (result != null)
{
if (columnName == "StreetAddress")
{
result.StreetAddress = updateValue;
}
if (columnName == "PostalCode")
{
result.PostalCode = updateValue;
}
if (columnName == "City")
{
result.City = updateValue;
}
}
dataContext.SaveChanges();
}
}
