public static historique getMaPartie(Guid resultat)
{
historique monHistorique = new historique();
monHistorique = historiqueDAL.getMonResultat(resultat);
return(monHistorique);
}
public static historique getMonResultat(Guid Resultat)
{
historique monH = new historique();
SqlConnection sqlConnection1 = new SqlConnection(getDbConnexion());
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "select * from [dbo].[sudoku_historique] where resultat ='" + Resultat + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
monH.Id = (Guid)reader[0];
monH.Numero = reader[1].ToString();
monH.Resultat = (Guid)reader[2];
monH.Difficulte = reader[3].ToString();
monH.NumeroIndice = reader[4].ToString();
}
// Data is accessible through the DataReader object here.
sqlConnection1.Close();
return(monH);
}
public static SDTO_Historique GetHistoriqueExploitation(string CodeExploitation, string Periode)
{
SDTO_Historique Result = null;
historique histo = null;
if (!string.IsNullOrEmpty(Periode) && !string.IsNullOrEmpty(CodeExploitation))
{
histo = new DAL <historique>().Find(p => p.codexp == CodeExploitation && p.perfact.Trim() == Periode.Trim()).FirstOrDefault();
}
if (histo != null)
{
Result = new SDTO_Historique()
{
codexp = histo.codexp,
codsite = histo.codsite,
datecpte = histo.datecpte,
datextract = histo.datextract,
datoper = histo.datoper,
datrecept = histo.datrecept,
modextract = histo.modextract,
modrecept = histo.modrecept,
nbrmvt = histo.nbrmvt,
numoperec = histo.numoperec,
numoperex = histo.numoperex,
perfact = histo.perfact,
};
}
return(Result);
}
public static bool MiseAJourHistorique(string CodeExploitation, string Periode, ref string errmess)
{
bool Result = false;
try
{
historique histo = null;
if (!string.IsNullOrEmpty(Periode) && !string.IsNullOrEmpty(CodeExploitation))
{
histo = new DAL <historique>().Find(p => p.codexp == CodeExploitation && p.perfact.Trim() == Periode.Trim()).FirstOrDefault();
}
if (histo != null)
{
histo.modextract = Convert.ToChar("1");
histo.datextract = DateTime.Now;
new DAL <historique>().UpdateRow(histo, p => p.codexp == histo.codexp.Trim() && p.perfact.Trim() == histo.perfact.Trim());
Result = true;
}
}
catch (Exception ex)
{
errmess = ex.Message;
Result = false;
}
return(Result);
}
public static void addHistorique(string numero, Guid resultat, string difficulte, string numeroindice)
{
historique maPartie = new historique();
maPartie.Id = new Guid();
maPartie.Id = Guid.NewGuid();
maPartie.Difficulte = difficulte;
maPartie.NumeroIndice = numeroindice;
maPartie.Resultat = resultat;
maPartie.Numero = numero;
historiqueDAL.addHistorique(maPartie);
}
public static void addHistorique(historique monH)
{
SqlConnection sqlConnection1 = new SqlConnection(getDbConnexion());
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "INSERT INTO [dbo].[sudoku_historique] VALUES ('" + monH.Id + "','" + monH.Numero + "','" + monH.Resultat + "','" + monH.Difficulte + "','" + monH.NumeroIndice + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.
sqlConnection1.Close();
}
private void cb_mesParties_SelectedIndexChanged_1(object sender, EventArgs e)
{
if (cb_mesParties.SelectedIndex != -1)
{
int x = 0;
string temp = "";
int y = 0;
char[,] grid = new char[9, 9];
historique monH = new historique();
Resultat monR = (Resultat)cb_mesParties.SelectedItem;
monH = historiqueService.getMaPartie(monR.Id);
lb_temps.Text = int.Parse(monR.Temps) / 60 + ":" + int.Parse(monR.Temps) % 60;
lb_difficulte.Text = monH.Difficulte;
for (int i = 0; i < monH.Numero.Length; i++)
{
grid[y, x] = monH.Numero[i];
DataGridView1.Rows[y].Cells[x].Value = monH.Numero[i];
if (monH.NumeroIndice[i] == '1')
{
DataGridView1.Rows[y].Cells[x].Style.ForeColor = Color.Black;
}
else
{
DataGridView1.Rows[y].Cells[x].Style.ForeColor = Color.Blue;
}
if (x == 8)
{
y++;
x = 0;
}
else
{
x++;
}
}
}
}
private void initChart(string difficulte)
{
chart_stat.Series["stat"].Points.Clear();
chart_stat.Titles.Clear();
int nbPartie;
historique unH = new historique();
List <Resultat> mesParties = new List <Resultat>();
mesParties = resultatService.getMesResultats(monUser.Id);
List <Resultat> mesPartiesAvecDifficulte = new List <Resultat>();
foreach (Resultat unR in mesParties)
{
unH = historiqueService.getMaPartie(unR.Id);
if (unH.Difficulte == difficulte)
{
mesPartiesAvecDifficulte.Add(unR);
}
}
nbPartie = mesPartiesAvecDifficulte.Count();
if (nbPartie != 0)
{
chart_stat.Titles.Add("Statistique de mes parties [" + nbPartie + " jouées]");
lb_nbPartie.Visible = false;
int nb1 = 0;
int nb2 = 0;
int nb3 = 0;
int nb4 = 0;
int nb5 = 0;
int nb6 = 0;
int monTemps = 0;
foreach (Resultat unR in mesPartiesAvecDifficulte)
{
monTemps = int.Parse(unR.Temps) / 60;
if (monTemps >= 0 && monTemps < 2)
{
nb1++;
}
if (monTemps >= 2 && monTemps < 4)
{
nb2++;
}
if (monTemps >= 4 && monTemps < 6)
{
nb3++;
}
if (monTemps >= 6 && monTemps < 8)
{
nb4++;
}
if (monTemps >= 8 && monTemps < 10)
{
nb5++;
}
if (monTemps >= 10)
{
nb6++;
}
}
if (nb1 > 0)
{
chart_stat.Series["stat"].Points.AddXY("0-2m[" + nb1 + "]", nb1);
}
if (nb2 > 0)
{
chart_stat.Series["stat"].Points.AddXY("2-4m[" + nb2 + "]", nb2);
}
if (nb3 > 0)
{
chart_stat.Series["stat"].Points.AddXY("4-6m[" + nb3 + "]", nb3);
}
if (nb4 > 0)
{
chart_stat.Series["stat"].Points.AddXY("6-8m[" + nb4 + "]", nb4);
}
if (nb5 > 0)
{
chart_stat.Series["stat"].Points.AddXY("8-10m[" + nb5 + "]", nb5);
}
if (nb6 > 0)
{
chart_stat.Series["stat"].Points.AddXY(">10m[" + nb6 + "]", nb6);
}
}
else
{
lb_nbPartie.Visible = true;
}
}
