private void worker_DoWork(object sender, DoWorkEventArgs e) { var _EntitiesContext = new QVMobileApplicationEntities(); while (true) { var allNotSentMessages = _EntitiesContext.SMS_Message.Where(model => model.IsSent == false).ToList(); var SMSConfig = _EntitiesContext.SMS_Config.FirstOrDefault(s => s.IsDefault == true); var SMSParam = _EntitiesContext.SMS_ConfigParam.Where(p => p.SMSConfigId == SMSConfig.ID).ToList(); // Code to send SMS here foreach (var item in allNotSentMessages) { int smsResponseNumber; if (SendMessage(item, SMSConfig, SMSParam, out smsResponseNumber)) { item.IsSent = true; item.SendDate = DateTime.Now; } item.ResponseNumber = smsResponseNumber; // item.ResponseNumber = 500; _EntitiesContext.SaveChanges(); } //Thread.Sleep(20000); Thread.Sleep((int)SMSConfig.IntervalTimeToSend); } }
public DbContext GetContext() { var context = new QVMobileApplicationEntities(); // context.Configuration.ProxyCreationEnabled = false; return(context); }
public int InsertNewMessage(string PhoneNumber, string TxtMessage) { var _EntitiesContext = new QVMobileApplicationEntities(); SMS_Message MessageObj = new SMS_Message(); MessageObj.PhoneNumber = PhoneNumber; MessageObj.TextMessage = TxtMessage; MessageObj.IsSent = false; MessageObj.CreationDate = DateTime.Now; _EntitiesContext.SMS_Message.Add(MessageObj); var ret = _EntitiesContext.SaveChanges(); if (ret > 0) { return(MessageObj.ID); } else { return(0); } }
public ReportService() { _Entities = new QVMobileApplicationEntities(); }
public List <SMS_Message> GetSMSMessageList() { var _EntitiesContext = new QVMobileApplicationEntities(); return(_EntitiesContext.SMS_Message.ToList()); }