public Publisher Update(Publisher publisher)
{
Publisher result = new Publisher();
using (MailPusherDBContext context = new MailPusherDBContext())
{
Publisher dbPublisher = context.Publishers.FirstOrDefault(x => x.ID == publisher.ID);
if (dbPublisher != null)
{
dbPublisher.Domain = publisher.Domain;
if (publisher.Status != dbPublisher.Status)
{
dbPublisher.StatusChanged = DateTime.UtcNow;
}
dbPublisher.Status = publisher.Status;
dbPublisher.Language = publisher.Language;
dbPublisher.NACEID = publisher.NACEID;
dbPublisher.Name = publisher.Name;
dbPublisher.Updater = publisher.Updater;
}
context.Entry(dbPublisher).State = EntityState.Modified;
context.SaveChanges();
result = context.Publishers.Include(x => x.NACE).FirstOrDefault(x => x.ID == publisher.ID);;
}
return(result);
}
public Publisher UpdateLastReceivedEmailDate(int publisherID)
{
Publisher result = new Publisher();
using (MailPusherDBContext context = new MailPusherDBContext())
{
result = context.Publishers.FirstOrDefault(x => x.ID == publisherID);
result.LastReceivedEmail = DateTime.UtcNow;
context.Entry(result).State = EntityState.Modified;
context.SaveChanges();
}
return(result);
}
public UserSettings Update(string userId, string language)
{
UserSettings result = new UserSettings();
using (var context = new MailPusherDBContext())
{
result = context.UserSettings.FirstOrDefault(x => x.UserId == userId);
if (result.Language != language)
{
result.Language = language;
context.Entry(result).State = EntityState.Modified;
context.SaveChanges();
}
}
return(result);
}
public bool ChangePublisherStatus(PublisherStatus status, int id, string userId)
{
using (MailPusherDBContext context = new MailPusherDBContext())
{
Publisher result = context.Publishers.FirstOrDefault(x => x.ID == id);
if (status != result.Status)
{
result.StatusChanged = DateTime.UtcNow;
}
result.Status = status;
result.UpdaterId = userId;
result.Updated = DateTime.UtcNow;
context.Entry(result).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}