public static AccountDTO Get(string email, string password, MataDBEntities db)
{
var account = db.Account.Single(q => q.Email == email && q.Password == password);
var mapper = new AccountMapper();
return(mapper.MapToDTO(account));
}
internal static int Get(string tokenString, MataDBEntities db)
{
var guid = Guid.Parse(tokenString);
var token = db.Token.Single(q => q.TokenString == guid && q.StartTime <= DateTime.UtcNow && q.EndTime >= DateTime.UtcNow);
return(token.AccountID);
}
public static AccountDTO Get(int id, MataDBEntities db)
{
var account = db.Account.Single(q => q.ID == id);
var mapper = new AccountMapper();
return(mapper.MapToDTO(account));
}
public static string TryGet(int accountID, MataDBEntities db)
{
var token = db.Token.SingleOrDefault(q => q.AccountID == accountID && q.StartTime <= DateTime.UtcNow && q.EndTime >= DateTime.UtcNow);
if (token != null)
{
return(token.TokenString.ToString());
}
return(null);
}
public static void Update(int id, AccountDTO accountDTO, MataDBEntities db)
{
var account = db.Account.Single(q => q.ID == id);
account.FullName = accountDTO.FullName;
account.Email = accountDTO.Email;
account.Password = accountDTO.Password;
account.RoleName = accountDTO.RoleName;
db.SaveChanges();
}
public static int Create(AccountDTO accountDTO, MataDBEntities db)
{
var mapper = new AccountMapper();
var account = mapper.MapToEntity(accountDTO);
db.Account.Add(account);
db.SaveChanges();
return(account.ID);
}
public static int Create(BackLogDTO backLogDTO, MataDBEntities db)
{
var mapper = new BackLogMapper();
var backLog = mapper.MapToEntity(backLogDTO);
db.BackLog.Add(backLog);
db.SaveChanges();
return(backLog.ID);
}
public static string Create(int accountID, MataDBEntities db)
{
var token = new Token()
{
AccountID = accountID,
StartTime = DateTime.UtcNow,
EndTime = DateTime.UtcNow.AddDays(1),
TokenString = Guid.NewGuid()
};
db.Token.Add(token);
db.SaveChanges();
return(token.TokenString.ToString());
}
public static void Delete(int id, MataDBEntities db)
{
using (var ts = db.Database.BeginTransaction())
{
try
{
var account = db.Account.Single(q => q.ID == id);
TokenBL.Delete(account.ID, db);
db.Account.Remove(account);
db.SaveChanges();
ts.Commit();
}
catch (Exception)
{
ts.Rollback();
throw;
}
}
}
public static void Delete(int id, MataDBEntities db)
{
throw new NotImplementedException();
}
public static void Update(int id, BackLogDTO backLogDTO, MataDBEntities db)
{
throw new NotImplementedException();
}
internal static void Delete(int accountID, MataDBEntities db)
{
db.Token.RemoveRange(db.Token.Where(q => q.AccountID == accountID));
db.SaveChanges();
}
public static IEnumerable <AccountDTO> GetList(MataDBEntities db)
{
var mapper = new AccountMapper();
return(db.Account.ToList().Select(q => mapper.MapToDTO(q)));
}
public static AccountDTO Get(string tokenString, MataDBEntities db)
{
var accountID = TokenBL.Get(tokenString, db);
return(Get(accountID, db));
}
public static bool IsAccountExists(AccountDTO adminAccount, MataDBEntities db)
{
return(db.Account.Any(q => q.Email == adminAccount.Email && q.Password == adminAccount.Password));
}
