public List <Company> GetAllCompany(CompanyAdvanceSearch companyAdvanceSearch) { List <Company> companyList = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[PSA].[GetAllCompany]"; cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = string.IsNullOrEmpty(companyAdvanceSearch.SearchTerm) ? "" : companyAdvanceSearch.SearchTerm; cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = companyAdvanceSearch.DataTablePaging.Start; if (companyAdvanceSearch.DataTablePaging.Length == -1) { cmd.Parameters.AddWithValue("@Length", DBNull.Value); } else { cmd.Parameters.Add("@Length", SqlDbType.Int).Value = companyAdvanceSearch.DataTablePaging.Length; } cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { companyList = new List <Company>(); while (sdr.Read()) { Company company = new Company(); { company.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : company.ID); company.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : company.Name); company.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : company.TotalCount); company.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : company.FilteredCount); } companyList.Add(company); } } } } } } catch (Exception ex) { throw ex; } return(companyList); }
public List <Company> GetAllCompany(CompanyAdvanceSearch companyAdvanceSearch) { return(_companyRepository.GetAllCompany(companyAdvanceSearch)); }