public class CustomerController : ApiController
    {
        List<CustomerModel> customers = new List<CustomerModel>();
        private CustomerController()
        {

            var _data = ViewCustomer();
            if (_data.Rows.Count > 0)
            {
                customers = (from DataRow _dr in _data.Rows
                             select new CustomerModel()
                             {
                                 custId = Convert.ToInt32(_dr["custId"]),
                                 custName = Convert.ToString(_dr["custName"]),
                                 custAddress = Convert.ToString(_dr["custAddress"]),
                                 custContact = Convert.ToString(_dr["custContact"]),
                                 custStatus = Convert.ToString(_dr["custStatus"]),
                                 agentId = Convert.ToInt32(_dr["agentId"]),
                                 agentContact = Convert.ToString(_dr["agentContact"])
                             }).ToList();
            }
        }

        // GET: api/Customer
        public List<CustomerModel> Get()
        {
            return customers;
        }

        // GET: api/Customer/5
        public CustomerModel Get(string num)
        {
            return customers.Where(x => x.agentContact.Equals(num)).FirstOrDefault();
        }

namespace DataLibrary.Repository
{
    public class DataRepository
    {

        public static DataTable ViewCustomer()
        {
            try
            {
                DataLayers CustData = new DataLayers();
                CustData.cmdType = CommandType.StoredProcedure;
                CustData.SQL = "CustomerStoredProcedure";
                CustData.paramVal = new string[,]
                {
                    { "@custId", ""},
                    { "@custName", ""},
                    { "@custAddress", ""},
                    { "@custContact", ""},
                    { "@custStatus", ""},
                    { "@agentId", ""},
                    { "@statement", "Select"}
                };
                return CustData.GetData();
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}