public bool UpdateStatusAndAddClockOut(Employee_DAL emp) { bool updated; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@pin", emp.PIN), new SqlParameter("@date", DateTime.Now) }; updated = SqlDBHelper.ExecuteNonQuery("usp_UpdateStatusAndClockOut", CommandType.StoredProcedure, pars); return(updated); }
public bool AddNewEmployee(Employee_DAL emp) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@pin", emp.PIN), new SqlParameter("@lastName", emp.LastName), new SqlParameter("@firstName", emp.FirstName), new SqlParameter("@email", emp.EMailAddress), new SqlParameter("@region", emp.Region), new SqlParameter("@employeeIdType", emp.EmployeeTypeID), }; return(SqlDBHelper.ExecuteNonQuery("usp_AddEmployee", CommandType.StoredProcedure, parameters)); }