public List<Associate.Designation> GetDesignation()
 {
     using (AssociateConnDataContext asscon = new AssociateConnDataContext())
     {
         var designations = (from a in asscon.Get_Designation()
                             select new Associate.Designation()
                             {
                                 DesignationID = a.DesignationID,
                                 DesignationName = a.Designation
                             }).ToList<Associate.Designation>();
         return designations;
     }
 }