public void CreateBalanceToAwardToAllEligibleUsers(long balance, DateTime effectiveDate, long cycleId) { try { using (var context = new GritCoinEntities()) { List <EmployeeModel> users = new EmployeeService().RetrieveEmployeeList().Where(Emp => Emp.IsEligible).ToList(); foreach (EmployeeModel user in users) { var BALANCE_TO_AWARD = new BALANCE_TO_AWARD { BALANCE_TO_AWARD_ID = GetSequenceNextValue(context, "GRITCOIN.BALANCE_TO_AWARD_SEQ"), COUNT = balance, EFFECTIVE_DATE = effectiveDate, CYCLE_ID = cycleId, EMPLOYEE_ID = user.EmployeeId }; context.AddToBALANCE_TO_AWARD(BALANCE_TO_AWARD); } context.SaveChanges(); } } catch { throw; } }
public long CreateEmployee(string userName, string displayName, bool isAdmin, bool isEligible, int balance, long cycleId, DateTime balanceEffectiveDate) { try { using (var context = new GritCoinEntities()) { var EMPLOYEE = new EMPLOYEE { EMPLOYEE_ID = GetSequenceNextValue(context, "GRITCOIN.EMPLOYEE_SEQ"), USERNAME = userName.ToLower(), DISPLAY_NAME = displayName, ADMIN_FLAG = isAdmin ? "Y" : "N", ELIGIBLE_FLAG = isEligible ? "Y" : "N" }; context.AddToEMPLOYEE(EMPLOYEE); context.SaveChanges(); var BALANCE_TO_AWARD = new BALANCE_TO_AWARD { BALANCE_TO_AWARD_ID = GetSequenceNextValue(context, "GRITCOIN.BALANCE_TO_AWARD_SEQ"), CYCLES = context.CYCLES.FirstOrDefault(cyc => cyc.CYCLE_ID == cycleId), COUNT = balance, EFFECTIVE_DATE = balanceEffectiveDate, EMPLOYEE = EMPLOYEE }; context.AddToBALANCE_TO_AWARD(BALANCE_TO_AWARD); context.SaveChanges(); return(EMPLOYEE.EMPLOYEE_ID); } } catch { throw; } }
public long CreateBalanceToAward(long balance, DateTime effectiveDate, long cycleId, long userId) { try { using (var context = new GritCoinEntities()) { var BALANCE_TO_AWARD = new BALANCE_TO_AWARD { BALANCE_TO_AWARD_ID = GetSequenceNextValue(context, "GRITCOIN.BALANCE_TO_AWARD_SEQ"), COUNT = balance, EFFECTIVE_DATE = effectiveDate, CYCLE_ID = cycleId, EMPLOYEE_ID = userId }; context.AddToBALANCE_TO_AWARD(BALANCE_TO_AWARD); context.SaveChanges(); return(BALANCE_TO_AWARD.BALANCE_TO_AWARD_ID); } } catch { throw; } }