public void UploadBalance(AccountBalance accountBalance)
{
using (var db = new AccountBalanceContext())
{
accountBalance.BalanceDate = DateTime.Now;
db.AccountBalance.Add(accountBalance);
db.SaveChanges();
}
}
public List <AccountBalance> GetBalancePeriodWise(DateTime startDate, DateTime endDate)
{
List <AccountBalance> accountBalance;
using (var db = new AccountBalanceContext())
{
accountBalance = db.AccountBalance.Where(a => a.BalanceDate >= startDate & a.BalanceDate <= endDate).ToList();
}
return(accountBalance);
}
public Users ValidateUser(Users user)
{
using (var db = new AccountBalanceContext())
{
Users user_actual = db.Users.FirstOrDefault(u => u.Username == user.Username & u.Password == user.Password);
if (user_actual != null)
{
user_actual.Password = string.Empty;
}
return(user_actual);
}
}
public AccountBalance GetCurrentBalance()
{
AccountBalance accountBalance = new AccountBalance();
using (var db = new AccountBalanceContext())
{
accountBalance.BalanceCanteen = db.AccountBalance.Sum(s => s.BalanceCanteen);
accountBalance.BalanceMarketing = db.AccountBalance.Sum(s => s.BalanceMarketing);
accountBalance.BalanceCEOCar = db.AccountBalance.Sum(s => s.BalanceCEOCar);
accountBalance.BalanceRAD = db.AccountBalance.Sum(s => s.BalanceRAD);
accountBalance.BalanceParkingFines = db.AccountBalance.Sum(s => s.BalanceParkingFines);
accountBalance.BalanceID = db.AccountBalance.Select(s => s.BalanceID).LastOrDefault();
accountBalance.BalanceDate = db.AccountBalance.Select(s => s.BalanceDate).LastOrDefault();
}
return(accountBalance);
}
public AccountsQueries(AccountBalanceContext mongoDB, IDTOMapper mapper)
{
this.mongoDB = mongoDB;
this.mapper = mapper;
}
public CustomerReadOnlyRepository(AccountBalanceContext mongoContext)
{
_mongoContext = mongoContext;
}
public CustomersQueries(AccountBalanceContext mongoDB, IResultConverter mapper)
{
this.mongoDB = mongoDB;
this.mapper = mapper;
}
public CustomerWriteOnlyRepository(AccountBalanceContext mongoContext)
{
this.mongoContext = mongoContext;
}
