public string AddAssociate(Cog.MLIAD.BusinessLogic.Associate.Associate associate)
        {
            using (AssociateConnDataContext asscon = new AssociateConnDataContext())
            {
                try
                {
                    int retasct = 0;
                    retasct = asscon.Add_Associate(associate.AssociateID, associate.FirstName, associate.LastName, associate.Mobile, associate.email, associate.DirectReportID, associate.IsApproved, associate.ProjectID, associate.LocationID, associate.DesignationID, associate.DOJ, associate.DOB, associate.IsActive, associate.UserID, associate.Password, associate.GroupID);
                    if (!(retasct == 0))
                    {
                        BusinessLogic.Associate.Associate approver = (from a in asscon.get_AdminByGroup(associate.GroupID)
                                                                      select new Cog.MLIAD.BusinessLogic.Associate.Associate()
                                                                      {
                                                                          AssociateID = a.AssociateID,
                                                                          FirstName = (a.FirstName == null) ? "" : a.FirstName,
                                                                          LastName = (a.LastName == null) ? "" : a.LastName,
                                                                          Mobile = (a.Mobile == null) ? "" : a.Mobile,
                                                                          email = (a.email == null) ? "" : a.email,
                                                                          UserID = (a.UserId == null) ? "" : a.UserId
                                                                      }).SingleOrDefault<Cog.MLIAD.BusinessLogic.Associate.Associate>();

                        string sendSubject = "Pending Request";
                        string mailbody = "<html><body>Dear " + approver.FirstName + ",<br /> You have pending request to approve for " + associate.FirstName + " " + associate.LastName + ".<br / >Please login to www.AssociateConnect.com to approve the request.<br / ><br />Regards,<br />AssociateConnect Admin Team<body><html>";
                        SendEmail(sendSubject, mailbody, associate.email, approver.email,true);
                        sendSubject = "Request Summited";
                        mailbody = "<html><body>Dear " + associate.FirstName + ",<br /> your request is successfully submitted to" + approver.FirstName + " " + approver.LastName + " for approval.<br / >You will get confirmation mail once your request gets appreved.<br / ><br />Regards,<br />AssociateConnect Admin Team<body><html>";
                        SendEmail(sendSubject, mailbody, approver.email, associate.email,true);

                        BusinessLogic.Associate.SMS sms = new SMS();
                        sms.smsBody = "You have pending request to approve for " + associate.FirstName + " " + associate.LastName + ".";
                        sms.toList = approver.Mobile;
                        SendSMS(sms);
                        sms.smsBody = "your request is successfully submitted to" + approver.FirstName + " " + approver.LastName + " for approval.";
                        sms.toList = associate.Mobile;
                        SendSMS(sms);

                        return "success";
                    }
                    else
                        return "failure";
                }
                catch (Exception ex)
                {
                    throw ex;
                }

            }
        }