public void SavePersonalDetails(SavePersonalDetails request)
{
Domain.StaffMember staffMember = new Domain.StaffMember()
{
ContactNo = request.ContactNo,
Department = request.Department,
EmpNo = request.EmpNo,
ExtNo = request.ExtNo,
FirstName = request.FirstName,
LastName = request.LastName,
UserName = request.UserName
};
_staffOrderRepo.SavePersonalDetails(staffMember);
}
public StaffMember GetStaffMemberEmpNo(string empNo)
{
IDbConnection conn = _connectionFactory.GetNewSqlConnectionWithLoginDetails(new SqlConnection(connection), String.Empty, String.Empty);
var sqlStr = "select FirstName, " +
"LastName, " +
"EmpNo, " +
"Dept," +
"ContactNo, " +
"ExtNo " +
" from stoStaff " +
"where EmpNo = @EmpNo ";
DynamicParameters param = new DynamicParameters();
param.Add("@EmpNo", empNo, dbType: DbType.String, direction: ParameterDirection.Input);
Domain.StaffMember staffMember = conn.Query <Domain.StaffMember>(sqlStr, param, commandType: CommandType.Text).SingleOrDefault();
return(staffMember);
}
