public void Update(SMS_tempBAL obj)
{
try
{
//Local
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_temp_Update";
cmd.Parameters.Clear();
cmd.Parameters.Add("@smstemp_id", SqlDbType.Int).Value = obj.smstemp_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;
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException e1)
{
MessageBox.Show(e1.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void On_OK()
{
if (Validategrid() && Validate_richTxt_message())
{
MessageBox.Show("Sending " + (gridExcelloadedFile.Rows.Count) + " Messages Please Wait....");
int phoneNoIndex = GetPhonenoIndex();
for (int i = 0; i < gridExcelloadedFile.Rows.Count; i++)
{
SMS_tempBAL sMS_Temp = new SMS_tempBAL();
sMS_Temp.phoneNo = gridExcelloadedFile.Rows[i].Cells[phoneNoIndex].Value.ToString();
sMS_Temp.message = GetMessage(i);
sMS_Temp.TimeStamp = DateTime.Now;
temp_db.Add(sMS_Temp);
}
this.Hide();
}
}
public void SendSMS()
{
if (ValidatephoneNo() && Validate_richTxt_message())
{
string[] str = txt_phone.Text.Split(',');
for (int i = 0; i < str.Length; i++)
{
SMS_tempBAL temp = new SMS_tempBAL();
temp.phoneNo = str[i];
temp.message = richTxt_message.Text;
temp.TimeStamp = DateTime.Now;
temp_db.Add(temp);
}
txt_phone.Text = "";
richTxt_message.Text = "";
PhoneBookLocalStorage.list.Clear();
}
}
public List <SMS_tempBAL> Search(SMS_tempBAL obj)
{
try
{
//Local
SqlDataReader dr;
List <SMS_tempBAL> listt = new List <SMS_tempBAL>();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_temp_Search";
cmd.Parameters.Clear();
cmd.Parameters.Add("@smstemp_id", SqlDbType.Int).Value = obj.smstemp_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())
{
SMS_tempBAL obj1 = new SMS_tempBAL();
float x = 0; obj1.smstemp_id = Convert.ToInt32(dr["smstemp_id"].ToString());
obj1.phoneNo = dr["phoneNo"].ToString();
obj1.message = dr["message"].ToString();
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);
}
public void Delete(SMS_tempBAL obj)
{
try
{
//Local
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SMS_temp_Delete";
cmd.Parameters.Clear();
cmd.Parameters.Add("@smstemp_id", SqlDbType.Int).Value = obj.smstemp_id;
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException e1)
{
MessageBox.Show(e1.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
