public RetailersInfo[] GetRetailersInfo() { try { using (var bmEntity = new RetailerMotivationProgramEntities()) { var retailersList = bmEntity.Retailers.Where(a => a.IsActive == true).ToList(); var list = new List <RetailersInfo>(); foreach (var items in retailersList) { var br = new RetailersInfo(); br.distributorcode = items.DistributorCode; br.distributorname = items.DistributorName; br.retailername = items.RetailerName; br.retaileraddress = items.RetailerAddress; br.retailerphone = items.PhoneNumber; br.retailerdetail = items.RetailerName + "-" + items.PhoneNumber; list.Add(br); } return(list.ToArray()); } } catch (Exception ex) { throw new CultureNotFoundException("Error Occured While Getting Information"); } }
public List <Retailer> GetRetailers(string term) { List <Retailer> retailers; using (var entity = new RetailerMotivationProgramEntities()) { retailers = entity.Retailers.Where(a => a.RetailerName.ToLower().Contains(term.ToLower()) && a.IsActive == true) .ToList(); } return(retailers); }