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