public void SendIt()
{
if (((Form1)Application.OpenForms["Form1"]).IsSendingProcessBusy == false)
{
((Form1)Application.OpenForms["Form1"]).IsSendingProcessBusy = true;
string updatesql="";
//MainDataModuleTableAdapters.tbl_sms_sendTableAdapter unsendsmstbl = new tbl_sms_sendTableAdapter();
try
{
DataTable dt = new tbl_sms_sendTableAdapter().GetDataByPosition(0);
updatesql = "";
string res = "";
//NiazPardaz.SendSoap ss = new NiazPardaz.SendSoap();
niazpardaz.Send ss = new GhasedakWinService.niazpardaz.Send();
foreach (DataRow dr in dt.Rows)
{
ss.SendSimpleSMS2(
dr["s_username"].ToString(),
dr["s_password"].ToString(),
dr["s_cell_no"].ToString(),
dr["s_smsCenterNo"].ToString(),
dr["s_body"].ToString(),
true);
/*
res = ss.doSendSMS(
dr["s_username"].ToString(),
dr["s_password"].ToString(),
dr["s_smsCenterNo"].ToString(),
dr["s_cell_no"].ToString(),
dr["s_body"].ToString(),
true);*/
Int64 _res = 0;
try
{
_res = Convert.ToInt64(res);
}
catch
{
_res = -1;
}
//if (_res != -1)
{
Int64 gid = -1;
try
{
if (dr["s_group_link"] != null) { gid = Convert.ToInt64(dr["s_group_link"].ToString()); }
}
catch
{
gid = -1;
}
updatesql = updatesql + " update tbl_sms_send set s_position=1,s_send_id=" + _res + " where s_id=" + dr["s_id"].ToString() + "; update tbl_sms_send_groups set sg_position=1 where sg_id=" + gid.ToString();
}
}
}
catch (Exception __e)
{
((Form1)Application.OpenForms["Form1"]).NewLog = "Error in creating SoapClient " + __e.Message;
}
if (updatesql != "")
{
System.Data.SqlClient.SqlConnection sqlc = new System.Data.SqlClient.SqlConnection(((Form1)Application.OpenForms["Form1"]).strConnectionString);
sqlc.Open();
System.Data.SqlClient.SqlCommand sqlcm = new System.Data.SqlClient.SqlCommand(updatesql, sqlc);
sqlcm.ExecuteNonQuery();
sqlc.Close();
}
((Form1)Application.OpenForms["Form1"]).IsSendingProcessBusy = false;
}
}
