public static User FromDbEntity(SqlEntity.User sqlUser)
{
if (sqlUser == null)
{
return(null);
}
var db = new ApplicationDomainContext();
var securityQuestion = SecurityQuestion.FromDbEntity(db.Select <SqlEntity.SecurityQuestion>()
.First(q => q.Id == sqlUser.SecurityQuestion));
//Do not fill the password
return(new User
{
Id = sqlUser.Id,
Username = sqlUser.Username,
Role = (UserRole)sqlUser.Role,
FullName = sqlUser.FullName,
IsActive = sqlUser.IsActive == 1,
IsDeleted = sqlUser.IsDeleted == 1,
SuspendFrom = sqlUser.SuspendFrom,
SuspendTo = sqlUser.SuspendTo,
Email = sqlUser.Email,
PasswordExpiration = sqlUser.PasswordExpiration,
SecurityQuestion = new SecurityQuestion
{
Id = securityQuestion.Id,
Question = securityQuestion.Question,
Answer = sqlUser.SecurityAnswer
},
Address = sqlUser.Address,
DateOfBirth = sqlUser.DateOfBirth
});
}
public static JournalTransaction FromDbEntity(SqlEntities.JournalTransaction sqlTransaction)
{
var db = new ApplicationDomainContext();
var users = db.Select <SqlEntities.User>().ToArray();
var attachments = db.Select <SqlEntities.Attachment>().Where(a => a.TransactionId == sqlTransaction.Id);
var journal =
Journal.FromDbEntity(db.Select <SqlEntities.Journal>().First(j => j.Id == sqlTransaction.JournalId));
var createdBy = User.FromDbEntity(users.First(u => u.Id == sqlTransaction.CreatedBy));
var resolvedBy = sqlTransaction.ResolvedBy.HasValue ?
User.FromDbEntity(users.FirstOrDefault(u => u.Id == sqlTransaction.ResolvedBy.Value)) : null;
var entries = db.Select <SqlEntities.JournalEntry>().Where(e => e.TransactionId == sqlTransaction.Id).Select(JournalEntry.FromDbEntity).ToList();
return(new JournalTransaction
{
Id = sqlTransaction.Id,
CreateDate = sqlTransaction.CreateDate,
Description = sqlTransaction.Description,
ResolveDate = sqlTransaction.ResolveDate,
Journal = journal,
Type = (TransactionType)sqlTransaction.Type,
ResolvedBy = resolvedBy,
CreatedBy = createdBy,
Entries = entries,
Status = (TransactionStatusType)sqlTransaction.Status,
Attachments = attachments.Select(Attachment.FromDbEntity).ToList()
});
}
public static Account FromDbEntity(SqlEntity.Account account)
{
var db = new ApplicationDomainContext();
var subcategory = db.Select <SqlEntity.Subcategory>().First(s => s.Id == account.SubcategoryId);
var category = db.Select <SqlEntity.Category>().First(c => c.Id == account.CategoryId);
return(FromDbEntity(account, category, subcategory));
}
public static JournalEntry FromDbEntity(SqlEntities.JournalEntry sqlEntry)
{
var db = new ApplicationDomainContext();
var account = Account.FromDbEntity(db.Select <SqlEntities.Account>().First(a => a.Id == sqlEntry.AccountId));
return(new JournalEntry
{
Id = sqlEntry.Id,
Amount = sqlEntry.Amount,
TransactionId = sqlEntry.TransactionId,
Side = (NormalSide)sqlEntry.Side,
Account = account
});
}
