public SipAccount GetByUserName(string userName)
{
using (var db = GetDbContext())
{
SipAccountEntity user = db.SipAccounts.SingleOrDefault(u => u.UserName == userName);
return(MapToSipAccount(user));
}
}
public SipAccount GetById(Guid id)
{
using (var db = GetDbContext())
{
SipAccountEntity dbAccount = db.SipAccounts.SingleOrDefault(u => u.Id == id);
return(MapToSipAccount(dbAccount));
}
}
private SipAccount MapUser(SipAccountEntity dbAccount)
{
return(dbAccount == null ? null : new SipAccount()
{
Id = dbAccount.Id,
UserName = dbAccount.UserName,
DisplayName = dbAccount.DisplayName,
});
}
private SipAccount MapUser(SipAccountEntity dbUser)
{
return(new SipAccount
{
Id = dbUser.Id,
UserName = dbUser.UserName,
DisplayName = dbUser.DisplayName,
Comment = dbUser.Comment
});
}
public void Update(SipAccount ccmUser)
{
using (var db = GetDbContext())
{
SipAccountEntity dbUser = db.SipAccounts.SingleOrDefault(u => u.Id == ccmUser.Id);
if (dbUser != null)
{
SetEntityFromSipAccount(db, ccmUser, dbUser);
db.SaveChanges();
}
}
}
public void UpdatePassword(Guid id, string password)
{
using (var db = GetDbContext())
{
SipAccountEntity dbUser = db.SipAccounts.SingleOrDefault(u => u.Id == id);
if (dbUser != null)
{
dbUser.Password = password;
db.SaveChanges();
}
}
}
public void UpdateComment(Guid id, string comment)
{
using (var db = GetDbContext())
{
SipAccountEntity dbUser = db.SipAccounts.SingleOrDefault(u => u.Id == id);
if (dbUser != null)
{
dbUser.Comment = comment;
db.SaveChanges();
}
}
}
public void Create(SipAccount account)
{
if (account == null)
{
throw new ArgumentNullException(nameof(account));
}
using (var db = GetDbContext())
{
var dbAccount = new SipAccountEntity();
SetEntityFromSipAccount(db, account, dbAccount);
db.SipAccounts.Add(dbAccount);
db.SaveChanges();
}
}
private SipAccount MapToSipAccount(SipAccountEntity dbAccount)
{
return(dbAccount == null ? null : new SipAccount
{
Id = dbAccount.Id,
UserName = dbAccount.UserName,
DisplayName = dbAccount.DisplayName,
Comment = dbAccount.Comment,
ExtensionNumber = dbAccount.ExtensionNumber,
AccountLocked = dbAccount.AccountLocked,
AccountType = dbAccount.AccountType,
Owner = MapToOwner(dbAccount.Owner),
CodecType = MaptoCodecType(dbAccount.CodecType)
});
}
private SipAccount MapEntityToSipAccont(CodecType codecType, SipAccountEntity user)
{
return(new SipAccount
{
Id = user.Id,
UserName = user.UserName,
CodecType = codecType,
Comment = user.Comment,
DisplayName = user.DisplayName,
Owner = user.Owner != null ? new Owner {
Id = user.Owner.Id, Name = user.Owner.Name
} : null,
AccountLocked = user.AccountLocked,
});
}
private void SetEntityFromSipAccount(CcmDbContext cxt, SipAccount account, SipAccountEntity dbAccount)
{
dbAccount.Id = account.Id;
dbAccount.UserName = account.UserName;
dbAccount.Comment = account.Comment;
dbAccount.ExtensionNumber = account.ExtensionNumber;
dbAccount.DisplayName = account.DisplayName;
dbAccount.Owner = account.Owner != null?cxt.Owners.SingleOrDefault(o => o.Id == account.Owner.Id) : null;
dbAccount.CodecType = account.CodecType != null?cxt.CodecTypes.SingleOrDefault(c => c.Id == account.CodecType.Id) : null;
dbAccount.AccountLocked = account.AccountLocked;
dbAccount.AccountType = account.AccountType;
if (!string.IsNullOrEmpty(account.Password))
{
dbAccount.Password = account.Password;
}
}
public void Delete(Guid id)
{
if (id == null)
{
throw new ArgumentNullException(nameof(id));
}
using (var db = GetDbContext())
{
SipAccountEntity account = db.SipAccounts.SingleOrDefault(u => u.Id == id);
if (account != null)
{
account.RegisteredSips?.Clear();
db.SipAccounts.Remove(account);
db.SaveChanges();
}
else
{
log.Info("Could not find user {0}", id);
}
}
}
