public void insert_Messagerie(ClsSMS cb)
{
try
{
innitialiseConnect();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
//cmd = new IDbCommand();
cmd = new SqlCommand("INSERT_MESSAGE", (SqlConnection)ImplementeConnexion.Instance.Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@num", 25, DbType.String, cb.NumeroTutaire1));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@corpsMessage", 255, DbType.String, cb.CorpsMessage1));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@etatSms", 30, DbType.String, cb.EtatSms1));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@userSession", 30, DbType.String, cb.Utilisateur1));
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cmd.Dispose();
}
}
void EnvoieMessage(string numero, string message)
{
ClsSMS sms = new ClsSMS();
sms.NumeroTutaire1 = numero;
sms.CorpsMessage1 = message;
sms.EtatSms1 = 0;
sms.Utilisateur1 = UserSession.GetInstance().UserName;
DynamicClasses.GetInstance().insert_Messagerie(sms);
}
void sendMessages(string num, string msgText)
{
ClsSMS sms = new ClsSMS();
sms.Numero = num;
sms.CorpsMsg = msgText;
sms.DateEnvoie = DateTime.Now;
sms.EtatSMS = 0;
sms.User = "******";
ClsGlossiaires.GetInstance().insert_SMS(sms);
}
public void insert_SMS(ClsSMS cb)
{
try
{
if (!con.State.ToString().ToLower().Equals("open"))
{
con.Open();
}
cmd = new SqlCommand("insert into tMessagerie(NumeroTutaire,CorpsMessage,DateEnvoie,EtatSms,Utilisateur) values (@NumeroTutaire,@CorpsMessage,@DateEnvoie,@EtatSms,@Utilisateur)", con);
cmd.Parameters.AddWithValue("@NumeroTutaire", cb.Numero);
cmd.Parameters.AddWithValue("@CorpsMessage", cb.CorpsMsg);
cmd.Parameters.AddWithValue("@DateEnvoie", cb.DateEnvoie);
cmd.Parameters.AddWithValue("@EtatSms", cb.EtatSMS);
cmd.Parameters.AddWithValue("@Utilisateur", cb.User);
cmd.ExecuteNonQuery();
//DialogResult res = MessageBox.Show("voulez vous vraiment enregistrer cette operation?", "Suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//if (res == DialogResult.Yes)
//{
//}
//else
//{
// MessageBox.Show("Opération Annulée!");
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cmd.Dispose();
con.Close();
}
}
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;
}
void RefreshData(ClsSMS sms)
{
dgSms.DataSource = sms.AllSms();
}
void Refresh(ClsSMS sms)
{
dgSms.DataSource = sms.AllNumDette();
}
