public void SeenOutbox() { foreach (var item in sms_db.LoadAll().Where(m => !m.IsDelieverd && !m.IsSeen)) { item.IsSeen = true; sms_db.Update(item); } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { List <string> arg = e.Argument as List <string>;//0 message, 1 phoneNo, 2 sms_id,3 status bool IsSend = false; SMS sms = new SMS(); foreach (var port in sms.GetConnectedPort()) { if (sms.SendSMS(port, arg[0], arg[1])) { //message send //MessageBox.Show("Message Sended"); var resend_list = resend_db.LoadAll().Where(m => m.sms_id == Convert.ToInt32(arg[2])).ToList(); foreach (var item in resend_list) { resend_db.Delete(item); } SMSBAL sms_single = sms_db.LoadAll().Where(m => m.sms_id == Convert.ToInt32(arg[2])).SingleOrDefault(); sms_single.Message = arg[0]; sms_single.phoneNo = arg[1]; sms_single.IsDelieverd = true; sms_single.IsSeen = true; sms_db.Update(sms_single); IsSend = true; break; } } if (!IsSend) { ResendBAL resend = new ResendBAL(); resend.sms_id = Convert.ToInt32(arg[2]); resend_db.Add(resend); //Message not Send // MessageBox.Show("Message not Sended"); } }