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