public void Delete(ResendBAL obj) { try { //Local con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Resend_Delete"; cmd.Parameters.Clear(); cmd.Parameters.Add("@resend_id", SqlDbType.Int).Value = obj.resend_id; cmd.ExecuteNonQuery(); con.Close(); } catch (SqlException e1) { MessageBox.Show(e1.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { List <SMSBAL> sms_list = e.Argument as List <SMSBAL>;//0 message, 1 phoneNo, 2 sms_id,3 status foreach (var item in sms_list) { bool IsSend = false; SMS sms = new SMS(); foreach (var port in sms.GetConnectedPort()) { if (sms.SendSMS(port, item.Message, item.phoneNo)) { //message send //MessageBox.Show("Message Sended"); var resend_list = resend_db.LoadAll().Where(m => m.sms_id == item.sms_id).ToList(); foreach (var item1 in resend_list) { resend_db.Delete(item1); } SMSBAL sms_single = sms_db.LoadAll().Where(m => m.sms_id == item.sms_id).SingleOrDefault(); sms_single.Message = item.Message; sms_single.phoneNo = item.phoneNo; 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(item.sms_id); resend_db.Add(resend); //Message not Send // MessageBox.Show("Message not Sended"); } } }
public List <ResendBAL> Search(ResendBAL obj) { try { //Local SqlDataReader dr; List <ResendBAL> listt = new List <ResendBAL>(); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Resend_Search"; cmd.Parameters.Clear(); cmd.Parameters.Add("@resend_id", SqlDbType.Int).Value = obj.resend_id; cmd.Parameters.Add("@sms_id", SqlDbType.Int).Value = obj.sms_id; cmd.Parameters.Add("@status", SqlDbType.Bit).Value = obj.status; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ResendBAL obj1 = new ResendBAL(); float x = 0; obj1.resend_id = Convert.ToInt32(dr["resend_id"].ToString()); obj1.sms_id = Convert.ToInt32(dr["sms_id"].ToString()); obj1.status = (bool)dr["status"]; listt.Add(obj1); } } dr.Close(); con.Close(); return(listt); } catch (SqlException e) { MessageBox.Show(e.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } return(null); }