public List<BusinessLogic.Associate.Associate> GetAssociatesPerGroup(int groupid)
        {
            try
            {

                using (AssociateConnDataContext asso = new AssociateConnDataContext())
                {
                    var assoList = (from d in asso.Get_AssoListPerGroup(groupid)
                                    select new Associate.Associate
                                    {
                                        AssociateID = d.AssociateID,
                                        FirstName = d.FirstName,
                                        LastName = d.LastName,
                                        email = d.email,
                                        Mobile = d.Mobile
                                    }).ToList<Associate.Associate>();

                    return assoList;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }