/// <summary>
/// Count of the Addresses By City
/// </summary>
/// <param name="city"></param>
/// <returns></returns>
public int CountOfAddressesByCity(string city)
{
Log.DebugFormat("Received Request for CountOfAddressedByCity with city={0}", city);
int count = 0;
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
count = context.Addresses.Count(item => item.City.Equals(city,StringComparison.OrdinalIgnoreCase));
}
Log.DebugFormat("Processed Request and count is {0}", count);
return count;
}
/// <summary>
/// Returns all the distinct cites
/// </summary>
/// <returns></returns>
public string[] FindAllDistinctCities()
{
Log.Debug("Received Request for FindAllDistinctCities");
string[] cities = null;
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
cities=context.Addresses.Select(item => item.City).Distinct().ToArray();
}
if(cities!=null)
{
Log.DebugFormat("Processed Request & Sending the following response {0}",
string.Join(",", cities));
}
return cities;
}
/// <summary>
/// Add address
/// </summary>
/// <param name="address"></param>
public void AddAddress(Definitions.Address address)
{
Log.DebugFormat("Received Request for AddAddress with following values {0}", address);
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
context.Addresses.Add(new Address()
{
City = address.City,
Country = address.Country,
State = address.State,
StreetLine1 = address.StreetLine1,
StreetLine2 = address.StreetLine2
});
context.SaveChanges();
}
Log.Debug("Processed Request for Add Address");
}
/// <summary>
/// Deletes Contact By email id
/// </summary>
/// <param name="emailId"></param>
/// <returns>number of records deleted</returns>
public int DeleteContactsByEmailId(string emailId)
{
Log.DebugFormat(" Received Request to DeleteContactsByEmailId with emailid: {0}", emailId);
int count = 0;
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
var items = context.ContactInformations.Where(item => item.EmailId.Equals(emailId, StringComparison.OrdinalIgnoreCase));
Parallel.ForEach(items, item =>
{
Log.DebugFormat("Removing record with contactInformation {0}", item);
});
count = items.Count();
context.ContactInformations.RemoveRange(items);
context.SaveChanges();
}
Log.Debug("Processed Request DeleteContactsByEmailId");
return count;
}
/// <summary>
/// This method returns all the contact information
/// </summary>
/// <returns></returns>
public SoapServiceLibrary.Definitions.ContactInformation[] GetAllContactInformations()
{
Log.Debug("Received Request for the GetAllContactInformations");
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
SoapServiceLibrary.Definitions.ContactInformation[] contacts = context.ContactInformations.Select(item => new SoapServiceLibrary.Definitions.ContactInformation
{
EmailId = item.EmailId,
FacebookId = item.FacebookId,
LinkedInId = item.LinkedInId,
PrimaryContactNumber = item.FacebookId,
SecondaryContactNumber = item.SecondaryContactNumber,
SkypeId = item.SkypeId
}).ToArray();
//Logging the contacts
Parallel.ForEach(contacts, item => { Log.Debug(item); });
Log.Debug("Processed Request for the GetAllContactInformations");
return contacts;
}
}
/// <summary>
/// This method will be used to add the contact information
/// </summary>
/// <param name="contactInformation"></param>
/// <returns></returns>
public bool AddContactInfo(SoapServiceLibrary.Definitions.ContactInformation contactInformation)
{
Log.DebugFormat("Recived Request to AddContactInfo with ContactInformation:{0}", contactInformation);
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
context.ContactInformations.Add(new SoapServices.DAL.EducationalInstitution.ContactInformation
{
EmailId = contactInformation.EmailId,
FacebookId = contactInformation.FacebookId,
LinkedInId = contactInformation.LinkedInId,
PrimaryContactNumber = contactInformation.PrimaryContactNumber,
SecondaryContactNumber = contactInformation.SecondaryContactNumber,
SkypeId = contactInformation.SkypeId
});
context.SaveChanges();
}
Log.Debug("Addition Succesful & sending response as true");
return true;
}
/// <summary>
/// Gets the Contact Information By Mail
/// </summary>
/// <param name="emailId"></param>
/// <returns></returns>
public SoapServiceLibrary.Definitions.ContactInformation[] GetContactInformationByMail(string emailId)
{
Log.DebugFormat("Received Request for GetContactInformationByMail with email id {0}", emailId);
SoapServiceLibrary.Definitions.ContactInformation[] contactInformations;
using (EducationalInstitutionDbContext context = new EducationalInstitutionDbContext())
{
contactInformations = context.ContactInformations.Where(
item => item.EmailId.Equals(emailId, StringComparison.OrdinalIgnoreCase)).Select(item => new SoapServiceLibrary.Definitions.ContactInformation
{
EmailId = item.EmailId,
FacebookId = item.FacebookId,
LinkedInId = item.LinkedInId,
PrimaryContactNumber = item.PrimaryContactNumber,
SecondaryContactNumber = item.SecondaryContactNumber,
SkypeId = item.SkypeId
}).ToArray();
Parallel.ForEach(contactInformations, item => { Log.Debug(item); });
Log.DebugFormat("Processed Request for GetContactInformationByMail with email id {0}", emailId);
return contactInformations;
}
}
