public static void SendSMS(int fdpId, string text) { CTSContext db = new CTSContext(); var contacts = (from contact in db.Contacts where contact.FDPID == fdpId select contact).ToList(); foreach (Contact contact in contacts) { // INSERT SMS (InOutInd, MobileNumber, Text, RequestDate, SendAfterDate, Status, StatusDate, Attempts, EventTag) //VALUES ('O', @MobileNumber, @SMSMessage, @Today, @SendAfterDate, 'pending', @Today, 0, 'SEND_SMS') SMS sms = new DRMFSS.BLL.SMS(); sms.Attempts = 0; sms.EventTag = "SEND_SMS"; sms.InOutInd = "O"; sms.LastAttemptDate = null; sms.MobileNumber = contact.PhoneNo; sms.Text = text; sms.RequestDate = DateTime.Today; sms.SendAfterDate = DateTime.Today; sms.Status = "pending"; sms.StatusDate = DateTime.Today; db.SMS.Add(sms); //try //{ //} //catch (Exception e) //{ //} } db.SaveChanges(); }