public void GetAllBorrower()
        {
            // Arrange
            BorrowersModel model = new BorrowersModel();

            Common.SearchCriteria obj = new Common.SearchCriteria();
            obj.StartIndex = 0;
            obj.EndIndex   = 10;
            obj.Text       = string.Empty;
            Assert.IsNotNull(model.GetAllBorrowers(obj));
            Assert.AreEqual(10, model.GetAllBorrowers(obj).Count);
        }
 /// <summary>
 /// AutoComplete Borrowers Suggestions
 /// </summary>
 /// <param>term</param>
 ///   <returns>JsonResult</returns>
 public JsonResult AutoCompleteBorrowers(string term)
 {
     try
     {
         BorrowersModel obj   = new BorrowersModel();
         SearchCriteria sc    = new SearchCriteria();
         SearchCriteria Count = new SearchCriteria();
         Count.Text    = string.Empty;
         sc.Text       = term;
         sc.StartIndex = 0;
         sc.EndIndex   = obj.TotalBorrowers(Count);
         return(Json(obj.GetAllBorrowers(sc), JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         Logging.Error(ex.Message);
         return(null);
     }
 }
        /// <summary>
        /// Brings The DataBack to Borrowers Table Based on Filter
        /// </summary>
        /// <param> Table Parameters</param>
        ///   <param> Search Criteria</param>
        ///   <returns>JqDataTable</returns>
        private JqDataTable <object[]> SearchInBorrowers(jQueryDataTableParamModel param, string searchCriteria)
        {
            try
            {
                SearchCriteria criteria = ConvertFromJsonToObject <SearchCriteria>(searchCriteria);

                int startIndex = 0;
                if (param.iDisplayStart > 0)
                {
                    startIndex = param.iDisplayStart + 1;
                }
                else
                {
                    startIndex = param.iDisplayStart;
                }

                criteria.StartIndex = startIndex;
                criteria.EndIndex   = param.iDisplayStart + param.iDisplayLength;
                criteria.SortOrder  = param.sSortDir_0;
                criteria.SortingCol = param.iSortCol_0;

                if (String.IsNullOrWhiteSpace(criteria.Text))
                {
                    criteria.Text = String.Empty;
                }

                BorrowersModel obj   = new BorrowersModel();
                int            count = obj.TotalBorrowers(criteria);

                var data = new List <object[]>();

                IList <BorrowersModel> bModels = new List <BorrowersModel>();
                bModels = obj.GetAllBorrowers(criteria);


                foreach (BorrowersModel item in bModels)
                {
                    var array = new object[3];
                    array[0] = item.ID;
                    array[1] = item.FirstName;
                    array[2] = item.LastName;


                    data.Add(array);
                }

                return(new JqDataTable <object[]>
                {
                    sEcho = param.sEcho,
                    iTotalRecords = count,
                    iTotalDisplayRecords = count,
                    aaData = data
                });
            }

            catch (Exception ex)
            {
                Logging.Error(ex.Message);
                return(null);
            }
        }