internal User GetUser(string name)
{
using var db = new TimeBankContext();
try
{
return((from u in db.Users where u.Name == name select u).First());
}
catch
{
return(null);
}
}
internal User GetUser(long id)
{
using var db = new TimeBankContext();
try
{
return((from u in db.Users where u.UserId == id select u).First());
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(null);
}
}
internal async void InsertOrUpdate(Category cat)
{
await using var db = new TimeBankContext();
var query = (from c in db.Categories where c.ID == cat.ID select c).FirstOrDefault();
if (query == null)
{
db.Categories.Add(cat);
}
else
{
query.Name = cat.Name;
}
await db.SaveChangesAsync();
}
internal async void InsertOrUpdate(Token token)
{
await using var db = new TimeBankContext();
var query = (from t in db.Tokens where t.ID == token.ID select t).FirstOrDefault();
if (query == null)
{
db.Tokens.Add(token);
}
else
{
query.Name = token.Name;
query.Hours = token.Hours;
}
await db.SaveChangesAsync();
}
internal async void InsertOrUpdate(Payment payment)
{
await using var db = new TimeBankContext();
var query = (from p in db.Payments where p.ID == payment.ID select p).FirstOrDefault();
if (query == null)
{
db.Payments.Add(payment);
}
else
{
query.PaymentType = payment.PaymentType;
query.User = payment.User;
query.TBankUserID = payment.TBankUserID;
query.Validation = payment.Validation;
query.ValidationId = payment.ValidationId;
}
await db.SaveChangesAsync();
}
internal async void InsertOrUpdate(Incidence incidence)
{
await using var db = new TimeBankContext();
var query = (from i in db.Incidences where i.ID == incidence.ID select i).FirstOrDefault();
if (query == null)
{
db.Incidences.Add(incidence);
}
else
{
query.Service = incidence.Service;
query.ServiceID = incidence.ServiceID;
query.Solved = incidence.Solved;
query.Description = incidence.Description;
query.Comments = incidence.Comments ?? new List <Comment>();
}
await db.SaveChangesAsync();
}
internal async void InsertOrUpdate(Service service)
{
await using var db = new TimeBankContext();
var query = (from s in db.Services where s.ServiceID == service.ServiceID select s).FirstOrDefault();
if (query == null)
{
db.Services.Add(service);
}
else
{
query.Name = service.Name;
query.Price = service.Price;
query.Provider = service.Provider;
query.ProviderID = service.ProviderID;
query.ServiceID = service.ServiceID;
query.Validation = service.Validation;
}
await db.SaveChangesAsync();
}
internal async void InsertOrUpdate(User user)
{
await using (var db = new TimeBankContext())
{
var query = (from u in db.Users where u.UserId == user.UserId select u).FirstOrDefault();
if (query == null)
{
db.Users.Add(user);
}
else
{
query.Address = user.Address ?? new Address();
query.AddressId = user.AddressId;
query.Admin = user.Admin;
query.Comments = user.Comments ?? new List <Comment>();
query.InDate = user.InDate;
query.LastName = user.LastName;
query.Name = user.Name;
query.OutDate = user.OutDate;
query.Password = user.Password;
query.Payments = user.Payments ?? new List <Payment>();
query.ProvideServices = user.ProvideServices;
query.Rating = user.Rating;
query.UserId = user.UserId;
query.Validations = user.Validations ?? new List <Validation>();
query.Wallet = user.Wallet ?? new Wallet();
}
db.Database.OpenConnection();
try
{
db.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Users ON");
await db.SaveChangesAsync();
db.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Users OFF");
}
catch (Exception ex)
{
throw ex;
}
}
}
internal async void InsertOrUpdate(Validation val)
{
await using var db = new TimeBankContext();
var query = (from v in db.Validations where v.ID == val.ID select v).FirstOrDefault();
if (query == null)
{
db.Validations.Add(val);
}
else
{
query.Incidences = val.Incidences ?? new List <Incidence>();
query.Paid = val.Paid;
query.Service = val.Service;
query.ServiceID = val.ServiceID;
query.ServiceUsedOn = val.ServiceUsedOn;
query.TBankUserID = val.TBankUserID;
query.Validated = val.Validated;
query.ValidatedOn = val.ValidatedOn;
}
await db.SaveChangesAsync();
}
internal List <Category> GetCategories()
{
using var db = new TimeBankContext();
return(db.Categories.ToList());
}
internal Category GetCategory(string name)
{
using var db = new TimeBankContext();
return((from c in db.Categories where c.Name == name select c).FirstOrDefault());
}
internal Category GetCategory(int catId)
{
using var db = new TimeBankContext();
return((from c in db.Categories where c.ID == catId select c).FirstOrDefault());
}
internal Validation GetPendingValidations(long id)
{
using var db = new TimeBankContext();
return((from val in db.Validations where val.ID == id select val).FirstOrDefault());
}
internal Incidence GetIncidence(int id)
{
using var db = new TimeBankContext();
return(db.Incidences.FirstOrDefault(i => i.ID == id));
}
internal Service GetService(long serviceID)
{
using var db = new TimeBankContext();
return(db.Services.FirstOrDefault(p => p.ServiceID == serviceID));
}
internal Service GetService(string serviceName)
{
using var db = new TimeBankContext();
return(db.Services.FirstOrDefault(s => s.Name == serviceName));
}
internal async void RemoveUser(User user)
{
await using var db = new TimeBankContext();
db.Users.Remove(user);
db.SaveChanges();
}
internal List <User> GetUsers()
{
using var db = new TimeBankContext();
return((from u in db.Users select u).ToList());
}
internal async void RemoveCategory(Category cat)
{
using var db = new TimeBankContext();
db.Categories.Remove(cat);
await db.SaveChangesAsync();
}
internal Token GetTokenById(int tokenId)
{
using var db = new TimeBankContext();
return(db.Tokens.FirstOrDefault(t => t.ID == tokenId));
}
internal List <Service> GetAllServices(User user)
{
using var db = new TimeBankContext();
return((from ser in db.Services where ser.Provider == user select ser).ToList());
}
internal List <Token> GetTokensList()
{
using var db = new TimeBankContext();
return((from token in db.Tokens select token).OrderByDescending(x => x.Hours).ToList());
}
internal List <Service> GetAllServices()
{
using var db = new TimeBankContext();
return((from ser in db.Services select ser).ToList());
}
internal async void RemoveToken(Token token)
{
await using var db = new TimeBankContext();
db.Tokens.Remove(token);
await db.SaveChangesAsync();
}
internal async void RemoveService(Service service)
{
await using var db = new TimeBankContext();
db.Services.Remove(service);
}
internal List <Service> GetAllServices(Category cat)
{
using var db = new TimeBankContext();
return((from ser in db.Services where ser.Category == cat select ser).ToList());
}
internal List <Validation> GetPendingValidations(User user)
{
using var db = new TimeBankContext();
return((from val in db.Validations where val.User == user select val).ToList());
}
internal List <Validation> GetPendingValidations(Service service)
{
using var db = new TimeBankContext();
return((from val in db.Validations where val.Service == service select val).ToList());
}
