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