using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        List<Complaint_Log> sample= new List<Complaint_Log>();

        //Make our dummy list here

        sample.Add(new Complaint_Log {

            CompanyName="Company A",

            ContactPerson="Bob Smith"

        });

        sample.Add(new Complaint_Log {

            CompanyName="Company B",

            ContactPerson="Fred Stevens"

        });

        sample.Add(new Complaint_Log {

            CompanyName="Company A",

            ContactPerson="Rick Moore"

        });

        sample.Add(new Complaint_Log {

            CompanyName="Company C",

            ContactPerson="Bob Smith"

        });

        //Now get the desired output

        var company = from c in sample

            group c by c.CompanyName into g

            orderby g.Key

            select new CompanyAlertModel()

        {

            Customer = g.Key,

            Occurrence = g.Count(),

        };

​

    // Get list of all the contact names with more than 1 occurrence

    var contact = from c in sample

                  group c by c.ContactPerson into g

                  orderby g.Key

                  select new ContactAlertModel()

                      {

                          Customer = g.Key,

                          Occurrence = g.Count(),

                      };

        var x= company.Where(x => x.Occurrence > 1).ToList();

        var y=contact.Where(x => x.Occurrence > 1).ToList();

        ShowDataViewModel sendToPartial=new ShowDataViewModel();

        sendToPartial.companyAlertModel=x;

        sendToPartial.contactAlertModel=y;

        //Send one model to the partial view

        //return PartialView(sendToPartial);

    }

}

​

public class ShowDataViewModel()

{

    public List<ContactAlertModel> contactAlertModel= new List<ContactAlertModel>();

    public List<CompanyAlertModel> companyAlertModel= new List<CompanyAlertModel>();

}

​

public class CompanyAlertModel

{

    public CompanyAlertModel() { }

​

    public string Customer { get; set; }

    public Nullable<int> Occurrence { get; set; }

    public Complaint_Log Complaints { get; set; }

}

​

public class ContactAlertModel

{

    public ContactAlertModel() { }

​

    public string Customer { get; set; }

    public Nullable<int> Occurrence { get; set; }

    public Complaint_Log Complaints { get; set; }

}

​

public class Complaint_Log

{

   public string CompanyName {get;set;}

   public string ContactPerson {get;set;}

}