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