public void SendSMSDettes()
{
bool envoie = true;
string numero = "";
string message = "";
string codeMs = "";
string utilisateur = "";
string dateEnvoie = "";
string Etat = "";
int count = 0;
try
{
innitialiseConnect();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
cmd = new SqlCommand("SELECT_SMS_DETTE", (SqlConnection)ImplementeConnexion.Instance.Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 30, DbType.String, InstantRound.GetInstance().Id));
dr = cmd.ExecuteReader();
while (dr.Read())
{
numero = dr["Numero"].ToString();
message = dr["Message"].ToString();
if (numero != "" && message != "" && count != 1)
{
ClsMessages ms = new ClsMessages();
if (message.Length <= 140)
{
//update_Valmsg(codeMs);
if (ms.sendshortMsg(numero, message) == false)
{
if (ms.sendlongMsg(numero, message + " ") == false)
{
envoie = false;
//ClsSMS msInsert = new ClsSMS();
//msInsert.NumeroTutaire1 = numero;
//msInsert.CorpsMessage1 = message;
//msInsert.DateEnvoie1 = dateEnvoie;
//msInsert.EtatSms1 = 0;
//msInsert.Utilisateur1 = utilisateur;
//insert_Messagerie(msInsert);
numero = "";
message = "";
codeMs = "";
dateEnvoie = "";
utilisateur = "";
Etat = "";
}
}
else
{
envoie = true;
numero = "";
message = "";
codeMs = "";
dateEnvoie = "";
utilisateur = "";
Etat = "";
}
}
else
{
//update_Valmsg(codeMs);
if (ms.sendlongMsg(numero, message) == true)
{
numero = "";
message = "";
envoie = true;
}
else
{
envoie = false;
//ClsSMS msInsert = new ClsSMS();
//msInsert.CorpsMessage1 = message;
//msInsert.DateEnvoie1 = dateEnvoie;
//msInsert.EtatSms1 = 0;
//msInsert.Utilisateur1 = utilisateur;
//insert_Messagerie(msInsert);
}
}
//update set statutMessage='non'
}
}
//dr.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
envoie = false;
//ClsSMS msInsert = new ClsSMS();
//msInsert.CorpsMessage1 = message;
//msInsert.DateEvoie1 = DateTime.Parse(dateEnvoie);
//msInsert.EtatSms1 = 0;
//msInsert.Utilisateur1 = utilisateur;
//insert_Messagerie(msInsert);
}
finally
{
con.Close();
}
//return envoie;
}
public void SendMessages()
{
bool envoie = true;
string numero = "";
string message = "";
string codeMs = "";
string utilisateur = "";
string dateEnvoie = "";
string Etat = "";
int count = 0;
//try
//{
innitialiseConnect();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
cmd = new SqlCommand("SELECT * FROM Messagerie WHERE EtatSms = 0 AND UserSession=@UserSession", (SqlConnection)ImplementeConnexion.Instance.Conn);
//sql.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserSession", UserSession.GetInstance().UserName);
dr = cmd.ExecuteReader();
while (dr.Read())
{
numero = dr["NumeroTutaire"].ToString();
message = dr["CorpsMessage"].ToString();
codeMs = dr["id"].ToString();
dateEnvoie = dr["DateEnvoie"].ToString();
utilisateur = dr["UserSession"].ToString();
Etat = dr["EtatSms"].ToString();
if (numero != "" && message != "" && count != 1)
{
ClsMessages ms = new ClsMessages();
if (message.Length <= 140)
{
update_Valmsg(codeMs);
if (ms.sendshortMsg(numero, message) == false)
{
if (ms.sendlongMsg(numero, message + " ") == false)
{
envoie = false;
ClsSMS msInsert = new ClsSMS();
msInsert.NumeroTutaire1 = numero;
msInsert.CorpsMessage1 = message;
msInsert.DateEnvoie1 = dateEnvoie;
msInsert.EtatSms1 = 0;
msInsert.Utilisateur1 = utilisateur;
insert_Messagerie(msInsert);
numero = "";
message = "";
codeMs = "";
dateEnvoie = "";
utilisateur = "";
Etat = "";
}
}
else
{
envoie = true;
numero = "";
message = "";
codeMs = "";
dateEnvoie = "";
utilisateur = "";
Etat = "";
}
}
else
{
update_Valmsg(codeMs);
if (ms.sendlongMsg(numero, message) == true)
{
numero = "";
message = "";
envoie = true;
}
else
{
envoie = false;
ClsSMS msInsert = new ClsSMS();
msInsert.CorpsMessage1 = message;
msInsert.DateEnvoie1 = dateEnvoie;
msInsert.EtatSms1 = 0;
msInsert.Utilisateur1 = utilisateur;
insert_Messagerie(msInsert);
}
}
//update set statutMessage='non'
}
}
//dr.Dispose();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
// envoie = false;
// ClsSMS msInsert = new ClsSMS();
// msInsert.CorpsMessage1 = message;
// //msInsert.DateEvoie1 = DateTime.Parse(dateEnvoie);
// msInsert.EtatSms1 = 0;
// msInsert.Utilisateur1 = utilisateur;
// insert_Messagerie(msInsert);
//}
//finally
//{
// con.Close();
//}
//return envoie;
}
