private void buttonValider_Click(object sender, EventArgs e)
{
int idPrevision = 0;
if (!buttonValiderModifClick && comboBoxQualification.SelectedItem != null && numericUpDownNbJours.Value > 0)
{
Prevision Prev = new Prevision(((ProjetForfait)comboBoxProjet.SelectedItem).CodeProjet, ((Qualification)comboBoxQualification.SelectedItem), (short)numericUpDownNbJours.Value, idPrevision);
if (DaoProjet.AddPrevision(Prev, out idPrevision) == true)
{
Prev.CodePrevision = idPrevision;
previsionBindingSource.Add(Prev);
}
else
{
MessageBox.Show("La prévision n'a pas été ajouté");
}
previsionBindingSource.ResumeBinding();
}
else if (buttonValiderModifClick)
{
((Prevision)laQualifDataGridViewTextBoxColumn.DataGridView.CurrentRow.DataBoundItem).LaQualif = (Qualification)comboBoxQualification.SelectedItem;
Prevision p = (Prevision)dataGridViewPrevisions.CurrentRow.DataBoundItem;
p.NbJours = Convert.ToInt16(numericUpDownNbJours.Value);
previsionBindingSource.ResetBindings(true);
}
groupBoxPrevision.Visible = false;
}
private void HamburgerMenuControl_OnItemClick(object sender, ItemClickEventArgs e)
{
HamburgerMenuIconItem ItemCliced = (HamburgerMenuIconItem)e.ClickedItem;
if (ItemCliced.Label == "Prévision")
{
Prevision LaPageDePrévision = (Prevision)ItemCliced.Tag;
if (((favoris)Favo.Tag).UserData.IsEmpty())
{
MessageBox.Show("La liste des favoris est Vide");
}
else
{
Tuple <int, int> LaWilayaEtLaDuree = ((favoris)Favo.Tag).UserData.getFirstElement();
if (LaPageDePrévision.NumWilaya != LaWilayaEtLaDuree.Item1)
{
DayData daymlm = IOData.LireDonnesJour("../../DonnesDunJour", LaWilayaEtLaDuree.Item1);
DateTime today = DateTime.Now.Add(IOData.LireDate());
LaPageDePrévision.NumWilaya = LaWilayaEtLaDuree.Item1;
LaPageDePrévision.Duree = LaWilayaEtLaDuree.Item2;
if (daymlm != null && !daymlm.Vide() && (daymlm.DateDuJour.Date == today.Date))
{
LaPageDePrévision.GridRec.Visibility = Visibility.Hidden;
LaPageDePrévision.flipView1.Visibility = Visibility.Visible;
LaPageDePrévision.BtmModifier.Visibility = Visibility.Visible;
LaPageDePrévision.Sauv.Visibility = Visibility.Visible;
LaPageDePrévision.Appliquer.Visibility = Visibility.Visible;
LaPageDePrévision.BtnAnnuler.Visibility = Visibility.Visible;
LaPageDePrévision.DounneesToday = daymlm;
LaPageDePrévision.ConstruireLesPagesDePreduction();
}
else
{
LaPageDePrévision.GridRec.Visibility = Visibility.Visible;
LaPageDePrévision.flipView1.Visibility = Visibility.Hidden;
LaPageDePrévision.BtnAnnuler.Visibility = Visibility.Hidden;
LaPageDePrévision.Sauv.Visibility = Visibility.Hidden;
LaPageDePrévision.Appliquer.Visibility = Visibility.Hidden;
LaPageDePrévision.BtmModifier.Visibility = Visibility.Hidden;
}
}
else if (LaPageDePrévision.Duree != LaWilayaEtLaDuree.Item2 && LaPageDePrévision.DounneesToday != null && !LaPageDePrévision.DounneesToday.Vide())
{
LaPageDePrévision.Duree = LaWilayaEtLaDuree.Item2;
LaPageDePrévision.ConstruireLesPagesDePreduction();
LaPageDePrévision.Sauv.Visibility = Visibility.Visible;
}
}
}
HamburgerMenuControl.Content = e.ClickedItem;
}
public static List <Prevision> GetPrevisionByProjet(int idProjet)
{
using (SqlConnection sqlConnect = GetConnection())
{
using (SqlCommand sqlCde = new SqlCommand())
{
sqlCde.Connection = sqlConnect;
string strsql = "GetAllPrevisions";
try
{
sqlCde.CommandType = CommandType.StoredProcedure;
sqlCde.CommandText = strsql;
//Definition du parametre
SqlParameter p1 = new SqlParameter("@vidprojet", SqlDbType.Int);
p1.Direction = ParameterDirection.Input;
p1.Value = idProjet;
sqlCde.Parameters.Add(p1);
SqlDataReader sqlRdr = sqlCde.ExecuteReader();
previsions = new List <Prevision>();
while (sqlRdr.Read())
{
Prevision previs = new Prevision()
{
CodePrevision = sqlRdr.GetInt32(0),
CodeProjet = sqlRdr.GetInt32(1),
NbJours = sqlRdr.GetInt16(3),
LaQualif = new Qualification()
{
CodeQualif = (sbyte)sqlRdr.GetByte(2)
},
};
previsions.Add(previs);
}
sqlRdr.Close();
return(previsions);
}
catch (Exception ex)
{
throw new DAOException(ex.Message);
}
}
}
}
private void dataGridViewPrevisions_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridViewPrevisions.Columns["Modifier"].Index && e.RowIndex >= 0)
{
Prevision p = (Prevision)dataGridViewPrevisions.CurrentRow.DataBoundItem;
groupBoxPrevision.Visible = true;
comboBoxQualification.SelectedItem = p.LaQualif;
numericUpDownNbJours.Value = p.NbJours;
buttonValiderModifClick = true;
}
else if (e.ColumnIndex == dataGridViewPrevisions.Columns["Supprimer"].Index && e.RowIndex >= 0)
{
string message = "Etes-vous sûr de vouloir supprimer";
string caption = "Suppression d'une prévision";
var result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
previsionBindingSource.RemoveAt(dataGridViewPrevisions.CurrentRow.Index);
previsionBindingSource.ResetBindings(true);
}
}
}
public static bool AddPrevision(Prevision prev, out int idPrev)
{
using (SqlConnection sqlConnect = GetConnection())
{
using (SqlCommand sqlCde = new SqlCommand())
{
sqlCde.Connection = sqlConnect;
string strsql = "AddPrevision";
try
{
sqlCde.CommandType = CommandType.StoredProcedure;
sqlCde.CommandText = strsql;
//Ajout des paramètres
sqlCde.Parameters.Add(new SqlParameter("@idprojet", SqlDbType.Int)).Value = prev.CodeProjet;
sqlCde.Parameters.Add(new SqlParameter("@idqualif", SqlDbType.TinyInt)).Value = Convert.ToInt32(prev.LaQualif.CodeQualif);
sqlCde.Parameters.Add(new SqlParameter("@nbJours", SqlDbType.SmallInt)).Value = prev.NbJours;
sqlCde.Parameters.Add(new SqlParameter("@idPrevision", SqlDbType.Int)).Direction = ParameterDirection.Output;
int n = sqlCde.ExecuteNonQuery();
if (n == 1)
{
MessageBox.Show("Mise a jour éffectuée");
}
idPrev = (int)sqlCde.Parameters["@idPrevision"].Value;
return(true);
}
catch (Exception ex)
{
throw new DAOException(ex.Message);
}
}
}
}
private void btnValider_Click(object sender, EventArgs e)
{
Qualification qualif;
if (butModifierClick)
{
if (!projSelect.prevision.Exists(x => x.LaQualif.CodeQualif == ((Qualification)comboBoxQualification.SelectedItem).CodeQualif)
||((Qualification)comboBoxQualification.SelectedItem).CodeQualif== ((Prevision)laQualifDataGridViewTextBoxColumn.DataGridView.CurrentRow.DataBoundItem).LaQualif.CodeQualif)
{
qualif = (Qualification)comboBoxQualification.SelectedItem;
nbJours.Value = numericUpDownNbJours.Value;
Prevision pr = new Prevision((int)codePrev.Value,projSelect.CodeProjet, qualif, (short)numericUpDownNbJours.Value);
if (DaoProjet.UpgPrevision(pr))
{
projSelect.UpgPrevision(pr);
}
butModifierClick = false;
grpboxPrevision.Visible = false;
comboBoxProjets.Enabled = true;
btnCreer.Enabled = true;
//Mets a jours les données du databinding prevision.
previsionBindingSource.ResetBindings(true);
//previsionBindingSource.DataSource = projSelect.prevision;
}
else
{
MessageBox.Show("Qualification déjà présente");
}
}
else if (butCreerClick)
{
if (!projSelect.prevision.Exists(x=>x.LaQualif.CodeQualif==((Qualification)comboBoxQualification.SelectedItem).CodeQualif))
{
Prevision prev = new Prevision(projSelect.CodeProjet,(Qualification)comboBoxQualification.SelectedItem, (short)numericUpDownNbJours.Value);
if (DaoProjet.AddPrevision(prev))
{
projSelect.AddPrevision(prev);
}
butCreerClick = false;
grpboxPrevision.Visible = false;
comboBoxProjets.Enabled = true;
btnCreer.Enabled = true;
//Mets a jours les données du databinding prevision.
previsionBindingSource.DataSource = projSelect.prevision;
previsionBindingSource.ResetBindings(true);
}
else
{
MessageBox.Show("Qualification déjà présente");
}
}
}
