public Associate.Associate GetAssociateByID(string AssociateID)
 {
     int id = (AssociateID == string.Empty) ? 0 : Convert.ToInt32(AssociateID);
     using (AssociateConnDataContext asscon = new AssociateConnDataContext())
     {
         var associates = (from a in asscon.Get_AssociateByID(id)
                           select new Associate.Associate()
                           {
                               AssociateID = a.AssociateID,
                               FirstName = a.FirstName,
                               LastName = a.LastName,
                               Designation = a.Designation,
                               Practice = a.PracticeName,
                               Account = a.AccountName,
                               Location = a.Location,
                               email = a.email,
                               Mobile = a.Mobile,
                               DOJ = a.DOJ,
                               ProjectName = a.ProjectName,
                               Gender = a.Gender
                           }).SingleOrDefault<Associate.Associate>();
         return associates;
     }
 }