public static List <RBDocument> GetDocuments(int startNumber, int numberDocs, string sortColumn, string sortOrder)
{
var con = ConfigurationManager.ConnectionStrings["RBDocMigration"].ToString();
List <RBDocument> documents = new List <RBDocument>();
using (SqlConnection myConnection = new SqlConnection(con))
{
string oString = "select * from Documents ORDER BY Reference OFFSET " + startNumber + " ROWS FETCH NEXT " + numberDocs + " ROWS ONLY";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
myConnection.Open();
try
{
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
RBDocument doc = new RBDocument();
doc.CreatedDate = DateTime.Parse(oReader["CreatedDate"].ToString());
doc.DocumentLabel = oReader["DocumentLabel"].ToString();
doc.DocumentLabelCode = oReader["DocumentLabelCode"].ToString();
doc.DocumentLabelGuid = oReader["DocumentLabelGuid"].ToString();
doc.FileLocation = oReader["FileLocation"].ToString();
doc.FileReference = oReader["FileReference"].ToString();
doc.Reference = oReader["Reference"].ToString();
documents.Add(doc);
}
myConnection.Close();
}
} catch (Exception ex) { }
}
return(documents);
}
private static IEnumerable <RBDocument> GetRecordsFromDatabaseWithFilter(string search, string sortColumn, string sortOrder, int displayLength, int displayStart)
{
// At this point you can call to your database to get the data
// but I will just populate a sample collection in code
var records = new List <RBDocument>();
if (search != null)
{
records = RBDocument.GetDocumentsWithFilter(displayStart, displayLength, search, sortColumn, sortOrder);
}
else
{
records = RBDocument.GetDocuments(displayStart, displayLength, sortColumn, sortOrder);
}
return(records);
}
private static int GetTotalRecordsWithFilter(string search)
{
return(RBDocument.CountDocumentsWithFilter(search));
}
private static int GetTotalRecords()
{
return(RBDocument.CountDocuments());
}
public static List<RBDocument> GetDocumentsWithFilter(int startNumber, int numberDocs, string reference, string sortColumn, string sortOrder)
{
var con = ConfigurationManager.ConnectionStrings["RBDocMigration"].ToString();
List<RBDocument> documents = new List<RBDocument>();
using (SqlConnection myConnection = new SqlConnection(con))
{
string oString = "select * from Documents where Reference = @reference ORDER BY " + sortColumn + " " + sortOrder + " OFFSET " + startNumber + " ROWS FETCH NEXT " + numberDocs + " ROWS ONLY";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@reference", reference);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
RBDocument doc = new RBDocument();
doc.CreatedDate = DateTime.Parse(oReader["CreatedDate"].ToString());
doc.DocumentLabel = oReader["DocumentLabel"].ToString();
doc.DocumentLabelCode = oReader["DocumentLabelCode"].ToString();
doc.DocumentLabelGuid = oReader["DocumentLabelGuid"].ToString();
doc.FileLocation = oReader["FileLocation"].ToString();
doc.FileReference = oReader["FileReference"].ToString();
doc.Reference = oReader["Reference"].ToString();
doc.FunctionalArea = oReader["FunctionalArea"].ToString();
documents.Add(doc);
}
myConnection.Close();
}
}
return documents;
}
