public IList <AllClientsPermanentNote> LoadCffPermanentNotes()
{
IList <AllClientsPermanentNote> notes = new List <AllClientsPermanentNote>();
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"NotesClientPerm_LoadAll"))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
string parsedNotes = CustomerNotesParser.Parse(cleverReader.ToString("notes"));
AllClientsPermanentNote note = new AllClientsPermanentNote(cleverReader.FromBigInteger("NotesID"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.ToString("ClientName"),
cleverReader.ToDate("Created"),
parsedNotes,
cleverReader.ToInteger("CreatedBy"),
cleverReader.ToString("EmployeeName"),
cleverReader.ToInteger("ModifiedBy"),
cleverReader.ToString(
"ModifiedByEmployeeName"),
cleverReader.ToDate("Modified"));
notes.Add(note);
}
}
}
return(notes);
}
public IList <AllClientsPermanentNote> LoadCffPermanentNotesOnRange(DateRange dateRange)
{
ArgumentChecker.ThrowIfNull(dateRange, "fromDate");
SqlParameter[] sqlParameters = new[]
{
CreateFromDateParameter(dateRange.StartDate),
CreateToDateParameters(dateRange.EndDate)
};
IList <AllClientsPermanentNote> notes = new List <AllClientsPermanentNote>();
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"NotesClientPerm_LoadAllOnRange", sqlParameters))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
string parsedNotes = CustomerNotesParser.Parse(cleverReader.ToString("notes"));
AllClientsPermanentNote note = new AllClientsPermanentNote(cleverReader.FromBigInteger("NotesID"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.ToString("ClientName"),
cleverReader.ToDate("Created"),
parsedNotes,
cleverReader.ToInteger("CreatedBy"),
cleverReader.ToString("EmployeeName"),
cleverReader.ToInteger("ModifiedBy"),
cleverReader.ToString(
"ModifiedByEmployeeName"),
cleverReader.ToDate("Modified"));
notes.Add(note);
}
}
}
return(notes);
}
