public List<SMSAccount> GetAllAccounts()
        {
            List<SMSAccount> acc = new List<SMSAccount>();
            using (AssociateConnDataContext asscon = new AssociateConnDataContext())
            {
                var associate = (from a in asscon.sp_SMSAccounts("SELECT",null,null,null,null,null)

                                 select new SMSAccount()
                                 {
                                     id=a.Id,
                                     password=a.Password,
                                     phoneNumber=a.Phone,
                                     sentSMS=a.SentSMS,
                                     email=a.Email
                                 }).ToList<SMSAccount>();
                acc = associate;
                return acc;
            }
        }
 public void UpdateSMSNumber(int id)
 {
     List<SMSAccount> acc = new List<SMSAccount>();
     using (AssociateConnDataContext asscon = new AssociateConnDataContext())
     {
         var val = asscon.sp_SMSAccounts("UPDATE", id, null, null, null, null);
     }
 }