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; }