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