public List<ReportPayment> GetReportPayments()
        {
          
            using (OMPContext entities = new OMPContext())
            {

             

               
                var query = from p in entities.Payments
                                            join a in entities.Abonents
                                            on p.INN equals a.INN


                            select new
                            {
                                Server = a.Server,
                                RegCardN = a.RegCardN,
                                INN = p.INN,
                                SName = a.SName,
                                TPlan = p.TPlan,
                                Ballance = p.Ballance,
                                APCurrent = p.APCurrent,
                                APNext = p.APNext,
                                TPlanCategory = p.TPlanCategory,
                                         TPlanPeriod=p.TPlanPeriod,
                                TZone=p.TZone
                                         
                                         
                            };

                List<ReportPayment> results = query.ToList();

                // Return the results in a List
                return results;

            }