/// <summary>
/// Inserts the serviceprovider email.
/// </summary>
/// <param name="serviceprovider">The serviceprovider.</param>
/// <param name="email">The email.</param>
/// <returns></returns>
public Email InsertServiceproviderEmail(ServiceProvider serviceprovider, String email)
{
try
{
if (email != null && email != "")
{
var AccountEmailDb = new AccountEmailsDb
{
Email = email,
AccountID = serviceprovider.AccountId,
ServiceProviderID = serviceprovider.Id,
};
var db = ObjectContextFactory.Create();
db.AccountEmails.Add(AccountEmailDb);
db.SaveChanges();
return(Mapper.Map <AccountEmailsDb, Email>(AccountEmailDb));
}
else
{
return(null);
}
}
catch (Exception ex)
{
Logger.Current.Error("Exception occurred while Inserting the ServiceProvider Email details", ex);
return(null);
}
}
/// <summary>
/// Updates the serviceprovider email.
/// </summary>
/// <param name="serviceprovider">The serviceprovider.</param>
/// <param name="email">The email.</param>
/// <returns></returns>
public Email UpdateServiceproviderEmail(ServiceProvider serviceprovider, String email)
{
try
{
var db = ObjectContextFactory.Create();
AccountEmailsDb accountEmailsDb = db.AccountEmails.Where(ae => ae.ServiceProviderID == serviceprovider.Id).FirstOrDefault();
if (accountEmailsDb == null)
{
return(InsertServiceproviderEmail(serviceprovider, email));
}
if (accountEmailsDb != null && email != null)
{
accountEmailsDb.Email = email;
accountEmailsDb.UserID = null;
db.SaveChanges();
return(Mapper.Map <AccountEmailsDb, Email>(accountEmailsDb));
}
else
{
return(null);
}
}
catch (Exception ex)
{
Logger.Current.Error("Exception occurred while Inserting the ServiceProvider Email details", ex);
return(null);
}
}
/// <summary>
/// Gets the service provider email.
/// </summary>
/// <param name="serviceProviderId">The service provider identifier.</param>
/// <returns></returns>
public Email GetServiceProviderEmail(int serviceProviderId)
{
try
{
if (serviceProviderId > 0)
{
var db = ObjectContextFactory.Create();
AccountEmailsDb accountEmailsDb = db.AccountEmails.Where(ae => ae.ServiceProviderID == serviceProviderId).FirstOrDefault();
if (accountEmailsDb != null)
{
return(Mapper.Map <AccountEmailsDb, Email>(accountEmailsDb));
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
Logger.Current.Error("Exception occurred while fetching the ServiceProvider Email details", ex);
return(null);
}
}
/// <summary>
/// Persists the emails.
/// </summary>
/// <param name="userSettings">The user settings.</param>
/// <param name="userSettingsDb">The user settings database.</param>
/// <param name="db">The database.</param>
private void persistEmails(UserSettings userSettings, UserSettingsDb userSettingsDb, CRMDb db)
{
if (userSettings.UserID > 0 && userSettings.Emails != null)
{
Email email = userSettings.Emails.Where(a => a.IsUpdated == true).SingleOrDefault();
AccountEmailsDb accountEmails = Mapper.Map <Email, AccountEmailsDb>(email);
if (accountEmails != null)
{
//if (accountEmails.IsPrimary == true)
//{
// UsersDb usersdb = db.Users.Where(u => (u.PrimaryEmail == accountEmails.Email) && (u.AccountID == accountEmails.AccountID) && (u.UserID == accountEmails.UserID)).SingleOrDefault();
// usersdb.EmailSignature = accountEmails.EmailSignature;
// db.SaveChanges();
//}
AccountEmailsDb accountEmailsdb = db.AccountEmails.Where(ae => ae.EmailID == accountEmails.EmailID).SingleOrDefault();
accountEmailsdb.EmailSignature = accountEmails.EmailSignature;
db.SaveChanges();
}
}
}
