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); } }