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