public void Update(SMSBAL obj)
{
try
{
//Local
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_Update";
cmd.Parameters.Clear();
cmd.Parameters.Add("@sms_id", SqlDbType.Int).Value = obj.sms_id;
cmd.Parameters.Add("@phoneNo", SqlDbType.VarChar).Value = obj.phoneNo;
cmd.Parameters.Add("@Message", SqlDbType.VarChar).Value = obj.Message;
cmd.Parameters.Add("@IsDelieverd", SqlDbType.Bit).Value = obj.IsDelieverd;
cmd.Parameters.Add("@IsSeen", SqlDbType.Bit).Value = obj.IsSeen;
cmd.Parameters.Add("@TimeStamp", SqlDbType.DateTime).Value = obj.TimeStamp;
cmd.Parameters.Add("@status", SqlDbType.Bit).Value = obj.status;
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException e1)
{
MessageBox.Show(e1.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void RemoveAllfromTrash()
{
for (int i = 0; i < gridTrash.RowCount; i++)
{
SMSBAL sms = sms_db.LoadAll().Where(m => m.sms_id == Convert.ToInt32(gridTrash.Rows[i].Cells["sms_id"].Value)).SingleOrDefault();
sms_db.Delete(sms);
}
LoadSendItems();
}
public void MoveAllTrash()
{
for (int i = 0; i < gridSentItems.RowCount; i++)
{
SMSBAL sms = sms_db.LoadAll().Where(m => m.sms_id == Convert.ToInt32(gridSentItems.Rows[i].Cells["sms_id"].Value)).SingleOrDefault();
sms.status = false;
sms.phoneNo = gridSentItems.Rows[i].Cells["phoneNo"].Value.ToString();
sms.Message = gridSentItems.Rows[i].Cells["Message"].Value.ToString();
sms_db.Update(sms);
}
LoadSendItems();
}
public List <SMSBAL> LoadAll()
{
List <SMSBAL> listt = new List <SMSBAL>();
try
{
//Local
con.Close();
SqlDataReader dr;
try
{
con.Open();
}
catch (Exception)
{
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_LOADALL";
cmd.Parameters.Clear();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
SMSBAL obj1 = new SMSBAL();
float x = 0; obj1.sms_id = Convert.ToInt32(dr["sms_id"].ToString());
obj1.phoneNo = dr["phoneNo"].ToString();
obj1.Message = dr["Message"].ToString();
obj1.IsDelieverd = (bool)dr["IsDelieverd"];
obj1.IsSeen = (bool)dr["IsSeen"];
obj1.TimeStamp = Convert.ToDateTime(dr["TimeStamp"].ToString());
obj1.status = (bool)dr["status"];
listt.Add(obj1);
}
}
dr.Close();
con.Close();
}
catch (Exception)
{
con = new SQLCon().getCon();
}
return(listt);
}
public List <SMSBAL> Search(SMSBAL obj)
{
try
{
//Local
SqlDataReader dr;
List <SMSBAL> listt = new List <SMSBAL>();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_Search";
cmd.Parameters.Clear();
cmd.Parameters.Add("@sms_id", SqlDbType.Int).Value = obj.sms_id;
cmd.Parameters.Add("@phoneNo", SqlDbType.VarChar).Value = obj.phoneNo;
cmd.Parameters.Add("@Message", SqlDbType.VarChar).Value = obj.Message;
cmd.Parameters.Add("@TimeStamp", SqlDbType.DateTime).Value = obj.TimeStamp;
cmd.Parameters.Add("@status", SqlDbType.Bit).Value = obj.status;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
SMSBAL obj1 = new SMSBAL();
float x = 0; obj1.sms_id = Convert.ToInt32(dr["sms_id"].ToString());
obj1.phoneNo = dr["phoneNo"].ToString();
obj1.Message = dr["Message"].ToString();
obj1.IsDelieverd = (bool)dr["IsDelieverd"];
obj1.IsSeen = (bool)dr["IsSeen"];
obj1.TimeStamp = Convert.ToDateTime(dr["TimeStamp"].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);
}
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
{
foreach (var item in temp_db.LoadAll())
{
int hourcount = sms_db.LoadAll().Where(m => m.TimeStamp.Hour == DateTime.Now.Hour && m.TimeStamp.Date == DateTime.Now.Date && m.IsDelieverd).Count();
int daycount = sms_db.LoadAll().Where(m => m.TimeStamp.Date == DateTime.Now.Date && m.IsDelieverd).Count();
if (daycount <= 3600 && hourcount <= 150)
{
SMSBAL smsObj = new SMSBAL();
smsObj.phoneNo = item.phoneNo;
smsObj.Message = item.message;
smsObj.TimeStamp = item.TimeStamp;
smsObj.status = true;
bool IsSend = false;
SMS sms = new SMS();
foreach (var port in sms.GetConnectedPort())
{
if (sms.SendSMS(port, smsObj.Message, smsObj.phoneNo))
{
//message send
//MessageBox.Show("Message Sended");
smsObj.IsSeen = true;
smsObj.IsDelieverd = true;
IsSend = true;
break;
}
}
if (!IsSend)
{
smsObj.IsSeen = false;
smsObj.IsDelieverd = false;
//Message not Send
// MessageBox.Show("Message not Sended");
}
sms_db.Add(smsObj);
temp_db.Delete(item);
}
}
}
public void Delete(SMSBAL obj)
{
try
{
//Local
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_Delete";
cmd.Parameters.Clear();
cmd.Parameters.Add("@sms_id", SqlDbType.Int).Value = obj.sms_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 void ResendAll()
{
List <SMSBAL> sms_list = new List <SMSBAL>();
for (int i = 0; i < gridOutbox.RowCount; i++)
{
if (3 > Convert.ToInt32(gridOutbox.Rows[i].Cells["Resend Times"].Value))
{
SMSBAL sms = new SMSBAL();
sms.Message = gridOutbox.Rows[i].Cells["Message"].Value.ToString();
sms.phoneNo = gridOutbox.Rows[i].Cells["phoneNo"].Value.ToString();
sms.sms_id = Convert.ToInt32(gridOutbox.Rows[i].Cells["sms_id"].Value);
sms_list.Add(sms);
}
}
if (!backgroundWorker2.IsBusy)
{
timer1.Start();
Cursor.Current = Cursors.WaitCursor;
backgroundWorker2.RunWorkerAsync(sms_list);
}
}
