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