public void remplirLesChamps(string nuticket)
{
int intIwant = StringintoInt(nuticket);
if (intIwant == 0)
{
return;
}
DTtickets = BDD.SelectDT("SELECT * FROM tbl_suiviastea WHERE NTICKET ='" + nuticket + "';", "sogetrel");
// Erreur on avait pris selectedText au lieu de SelectedItem.
cbxAffaire.SelectedItem = DTtickets.Rows[0]["AFFAIRE"].ToString();
cbxCateg.SelectedItem = DTtickets.Rows[0]["CATEGORIE"].ToString();
cbxCloture.SelectedItem = DTtickets.Rows[0]["CLOTURE"].ToString();
cbxCriti.SelectedItem = DTtickets.Rows[0]["CRITICITE"].ToString();
cbxFormat.SelectedItem = DTtickets.Rows[0]["FORMATDEMANDE"].ToString();
cbxNiveauR.SelectedItem = DTtickets.Rows[0]["NIVEAUDERESOLUTION"].ToString();
cbxProfil.SelectedItem = DTtickets.Rows[0]["PROFIL"].ToString();
lblTicket.Text = nuticket;
txtDescription.Text = DTtickets.Rows[0]["DESCRIPTION"].ToString();
txtEmail.Text = DTtickets.Rows[0]["EMAIL"].ToString();
txtNom.Text = DTtickets.Rows[0]["NOM"].ToString();
txtRefClient.Text = DTtickets.Rows[0]["REFERENCECLIENT"].ToString();
txtTelephone.Text = DTtickets.Rows[0]["TELEPHONE"].ToString();
txtAction.Text = DTtickets.Rows[0]["ACTION"].ToString();
string dateetheurederesolution = DTtickets.Rows[0]["DATEDERESOLUTION"].ToString() + " " + DTtickets.Rows[0]["HEUREDERESOLUTION"].ToString();
if (dateetheurederesolution.Equals(" ") == false)
{
dtp1.Value = DateTime.ParseExact(dateetheurederesolution, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);
lblDate.Visible = true;
dtp1.Visible = true;
}
}
public void InsertintoSQL()
{
string numeroticket = NumeroProchainTicket();
int week = ((DateTime.Now.DayOfYear / 7) + 1);
// Check if Resolu ou non.
string heureResolution;
string dateResolution;
string delaisResolution;
if (cbxCloture.Text.Contains("Oui"))
{
heureResolution = DateTime.Now.ToString("HH:mm");
dateResolution = DateTime.Now.ToString("dd/MM/yyyy");
delaisResolution = "00:10";
}
else
{
heureResolution = " ";
dateResolution = " ";
delaisResolution = " ";
}
string query = "INSERT INTO tbl_suiviastea (NTICKET,HOTLINER,DATECREATION,HEUREDECREATION,SEMAINE,MOIS,ANNEE,FORMATDEMANDE,NOM,TELEPHONE,EMAIL,REFERENCECLIENT,PROFIL,AFFAIRE,CATEGORIE,CRITICITE,DESCRIPTION,CLOTURE,NIVEAUDERESOLUTION,ACTION,DATEDERESOLUTION,HEUREDERESOLUTION,DELAISDERESOLUTION)";
query += " VALUES ('" + numeroticket + "','hotliner1', '" + DateTime.Now.ToString("dd/MM/yyyy") + "','" + DateTime.Now.AddMinutes(-10).ToString("HH:mm") + "','" + week.ToString() + "',";
query += "'" + DateTime.Now.Month.ToString() + "','" + DateTime.Now.Year.ToString() + "','" + cbxFormat.Text + "','" + txtNom.Text.Replace("'", "''") + "','" + txtTelephone.Text.Replace("'", "''") + "','" + txtEmail.Text.Replace("'", "''") + "','" + txtRefClient.Text.Replace("'", "''") + "','" + cbxProfil.Text + "','" + cbxAffaire.Text;
query += "','" + cbxCateg.Text + "','" + cbxCriti.Text + "','" + txtDescription.Text.Replace("'", "''") + "','" + cbxCloture.Text + "','" + cbxNiveauR.Text;
query += "','" + txtAction.Text.Replace("'", "''");
query += "','" + dtp1.Value.Date.ToString("dd/MM/yyyy");
query += "','" + dtp1.Value.ToString("HH:mm");
query += "','" + delaisResolution + "')";
BDD.InsertOrUpdate(query, "sogetrel");
monsuiviastea.ListViewRafraichir();
}
