/// <summary>
/// inserts a payraise for eith an employee by id or for all employees and departments
/// </summary>
/// <param name="pay"></param>
/// <param name="all"></param>
/// <returns></returns>
public static IPayRaise CommitRaise(IPayRaise pay, bool all)
{
List <parmStructure> lstParms = new List <parmStructure>();
lstParms.Add(new parmStructure("@payIn", pay.payIn, ParameterDirection.Input, SqlDbType.Decimal));
lstParms.Add(new parmStructure("@affDate", pay.newAffDate, ParameterDirection.Input, SqlDbType.Date));
if (all)
{
DataAccess.SendData("[PayraiseLiving]", lstParms);
}
else
{
lstParms.Add(new parmStructure("@empId", pay.empId, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@payrate", pay.newPay, ParameterDirection.Output, SqlDbType.Money));
lstParms.Add(new parmStructure("@oldRate", pay.oldPay, ParameterDirection.Output, SqlDbType.Money));
lstParms.Add(new parmStructure("@oldAffDate", pay.oldAffDate, ParameterDirection.Output, SqlDbType.Date));
DataAccess.SendData("[PayraisePersonal]", lstParms);
pay.newPay = Convert.ToDouble(lstParms[3].parmValue);
pay.oldPay = Convert.ToDouble(lstParms[4].parmValue);
pay.oldAffDate = Convert.ToDateTime(lstParms[5].parmValue);
}
return(pay);
}
/// <summary>
/// Gives an employee a raise
/// </summary>
/// <param name="raise">All info needed for a raise</param>
/// <returns>Updated raise info</returns>
public static PayRaise UpdateRaise(IPayRaise raise)
{
raise = HRSQL.CommitRaise(raise, false);
PayRaise objRaise = PayFactory.Create();
objRaise.empId = raise.empId;
objRaise.payIn = raise.payIn;
objRaise.oldPay = raise.oldPay;
objRaise.oldAffDate = raise.oldAffDate;
objRaise.newPay = raise.newPay;
objRaise.newAffDate = raise.newAffDate;
return(objRaise);
}
/// <summary>
/// Gives all employees and departments a living cost raise
/// </summary>
/// <param name="raise">All info for a raise</param>
public static void UpdateAllRaises(IPayRaise raise)
{
raise = HRSQL.CommitRaise(raise, true);
}
