public IUserIdentifier Read(Guid id, string value)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
return(db.UserIdentifiers.Where(i => i.Value == value && i.UserIdentifierTypeEntity.Id == id).FirstOrDefault());
}
}
public IUserIdentifier Read(string value)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
return(db.UserIdentifiers.Where(i => i.Value == value).FirstOrDefault());
}
}
public IEnumerable <IUserIdentifierType> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <UserIdentifierTypeEntity> listToGet = db.UserIdentifierTypes;
return(listToGet);
}
}
public ICronTask Read(Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
CronTaskEntity itemToRead = db.CronTasks.Where(i => i.Id == id).FirstOrDefault();
return(itemToRead);
}
}
public IEnumerable <ISegment> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <SegmentEntity> listToGet = db.Segments;
return(listToGet);
}
}
public IEnumerable <IUser> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <UserEntity> listToGet = db.Users;
return(listToGet);
}
}
public IEnumerable <ISource> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <SourceEntity> listToGet = db.Sources;
return(listToGet);
}
}
public IEmailSetting Read(Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
EmailSettingEntity itemToRead = db.EmailSettings.Where(i => i.Id == id).FirstOrDefault();
return(itemToRead);
}
}
public IEnumerable <ICronTask> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <CronTaskEntity> listToGet = db.CronTasks;
return(listToGet);
}
}
public IEnumerable <IEmailSetting> GetAll()
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
IEnumerable <EmailSettingEntity> listToGet = db.EmailSettings;
return(listToGet);
}
}
public ISource Read(Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
SourceEntity itemToRead = db.Sources.Where(i => i.Id == id).FirstOrDefault();
return(itemToRead);
}
}
public IUser Read(Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
UserEntity itemToRead = db.Users.Where(i => i.Id == id).FirstOrDefault();
return(itemToRead);
}
}
public void Update(IEmailSetting item, Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
EmailSettingEntity itemToUpdate = db.EmailSettings.Where(i => i.Id == id).FirstOrDefault();
itemToUpdate.Update(item);
db.SaveChanges();
}
}
public void Create(IEmailSetting item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
EmailSettingEntity itemToAdd = new EmailSettingEntity(item);
db.EmailSettings.Add(itemToAdd);
db.SaveChanges();
}
}
public void Create(ISource item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
SourceEntity itemToAdd = new SourceEntity(item);
db.Sources.Add(itemToAdd);
db.SaveChanges();
}
}
public void Delete(Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
UserEntity itemToDelete = db.Users.Where(i => i.Id == id).FirstOrDefault();
db.Remove(itemToDelete);
db.SaveChanges();
}
}
public void Create(ISegment item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
SegmentEntity itemToAdd = new SegmentEntity(item);
db.Segments.Add(itemToAdd);
db.SaveChanges();
}
}
public void Create(IUserType item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
UserTypeEntity itemToAdd = new UserTypeEntity(item);
db.UserTypes.Add(itemToAdd);
db.SaveChanges();
}
}
public void Update(IUser item, Guid id)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
UserEntity itemToUpdate = db.Users.Where(i => i.Id == id).FirstOrDefault();
itemToUpdate.Update(item);
db.SaveChanges();
}
}
public void Create(ICronTask item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
CronTaskEntity itemToAdd = new CronTaskEntity(item);
db.CronTasks.Add(itemToAdd);
db.SaveChanges();
}
}
public IUser ReadUser(string identifierValue, out Guid userId)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
userId = new Guid();
var user = db.Users.Where(u => u.UserIdentifierEntities.Where(i => i.Value == identifierValue).FirstOrDefault() != null).FirstOrDefault();
if (user != null)
{
userId = user.Id;
}
return(user);
}
}
public void Create(IUser item)
{
using (FilkioCrmContext db = new FilkioCrmContext())
{
UserEntity itemToAdd = new UserEntity(item);
db.Attach(itemToAdd.SourceEntity);
db.Attach(itemToAdd.UserTypeEntity);
itemToAdd.UserIdentifierEntities = itemToAdd.UserIdentifierEntities.DistinctBy(t => t.UserIdentifierTypeEntity.Id).ToList();
foreach (var i in itemToAdd.UserIdentifierEntities)
{
db.Attach(i.UserIdentifierTypeEntity);
}
db.Users.Add(itemToAdd);
db.SaveChanges();
}
}
