private static void Add(Synergy_User user, string username)
{
using (var _context = new SynergyDbContext())
{
_context.Synergy_Users.Add(user);
_context.SaveChanges();
Synergy_Account account = new Synergy_Account()
{
IsActive = true,
Password = PasswordEncription.CreateSHAHash("Pa$$word"),
UserName = username,
UserId = user.UserId
};
_context.Synergy_Accounts.Add(account);
_context.SaveChanges();
}
}
private static void DeleteUser(int id)
{
using (var _context = new SynergyDbContext())
{
var user = _context.Synergy_Users.Where(x => x.UserId == id && x.IsActive).FirstOrDefault();
user.IsActive = false;
var account = _context.Synergy_Accounts.Where(x => x.UserId == id && x.IsActive).FirstOrDefault();
account.IsActive = false;
_context.SaveChanges();
}
}
private static void UpdateUser(int id, int?age, string email, string firstname, string lastname)
{
using (var _context = new SynergyDbContext())
{
var user = _context.Synergy_Users.Where(x => x.UserId == id && x.IsActive).FirstOrDefault();
user.Age = age;
user.Email = email;
user.FirstName = firstname;
user.LastName = lastname;
_context.SaveChanges();
}
}
private static void UpdateHistory(int historyId, SynergyResponse response)
{
using (var context = new SynergyDbContext())
{
var history = context.Synergy_ApiHistory.Where(x => x.Id == historyId && x.IsActive).FirstOrDefault();
if (history != null)
{
history.Message = string.IsNullOrEmpty(response.Message) ? "Processed successfully." : response.Message;
history.Status = response.Status.ToString();
context.SaveChanges();
}
}
}
private static int RequestHistory(SynergyDbContext context, int logId, SynergyRequest request)
{
Synergy_ApiHistory history = new Synergy_ApiHistory()
{
IsActive = true,
LogId = logId,
Request = request.Request,
RequestDateTime = DateTime.UtcNow
};
context.Synergy_ApiHistory.Add(history);
context.SaveChanges();
return(history.Id);
}
private static int RequestLog(SynergyDbContext context, int apiId, SynergyRequest request)
{
var logDetail = context.Synergy_ApiRequestLogs.Where(x => x.UserId == request.UserId && x.ApiId == apiId && x.IsActive).FirstOrDefault();
if (logDetail != null)
{
logDetail.Requests = logDetail.Requests + 1;
context.SaveChanges();
return(logDetail.Id);
}
else
{
Synergy_ApiRequestLog log = new Synergy_ApiRequestLog()
{
ApiId = apiId,
IsActive = true,
Requests = 1,
UserId = request.UserId
};
context.Synergy_ApiRequestLogs.Add(log);
context.SaveChanges();
return(log.Id);
}
}
