public void LoadGridData()
{
//remplir data grid view : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
var req = (from cl in db.CLIENTs
select new
{
cl.NumeroSerie,
cl.NomAgenceOuClient,
cl.NumeroTelephoneClient,
cl.VILLE.LblVille
});
MyDataGrid.DataSource = req.ToList();
}
if (MyDataGrid.Columns.Count < 6)
{
MyDataGrid.Columns.Add(new DataGridViewButtonColumn
{
Name = "columnSupr",
UseColumnTextForButtonValue = true,
Text = "Supprimer !",
HeaderText = "",
SortMode = DataGridViewColumnSortMode.NotSortable,
Width = 488,
AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet,
MinimumWidth = 3
});
}
}
public void LoadGridData()
{
//remplir data grid view : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
var req = (from ing in db.INGENIEURs
select new
{
ing.IdIngenieur,
ing.noming,
ing.NumeroTelephoneIngenieur
});
MyDataGrid.DataSource = req.ToList();
}
if (MyDataGrid.Columns.Count < 3)
{
MyDataGrid.Columns.Add(new DataGridViewButtonColumn
{
Name = "columnSupr",
UseColumnTextForButtonValue = true,
Text = "Supprimer !",
HeaderText = "",
SortMode = DataGridViewColumnSortMode.NotSortable,
Width = 488,
AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet,
MinimumWidth = 3
});
}
}
public void LoadGridData()
{
//remplir data grid view : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
var req = (from s in db.SECRETAIREs
select new
{
s.id,
s.nom,
s.prenom,
s.email,
s.mdp
});
MyDataGrid.DataSource = req.ToList();
}
if (MyDataGrid.Columns.Count < 5)
{
MyDataGrid.Columns.Add(new DataGridViewButtonColumn
{
Name = "columnSupr",
UseColumnTextForButtonValue = true,
Text = "Supprimer !",
HeaderText = "",
SortMode = DataGridViewColumnSortMode.NotSortable,
Width = 488,
AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet,
MinimumWidth = 3
});
}
}
private void BtnSoumettre_Click(object sender, EventArgs e)
{
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
var admin = db.ADMINNs.Where(adminn => adminn.email.Equals(Email_Input.Text)).FirstOrDefault();
if (!(admin is null))
{
Validation(admin.nom + " " + admin.prenom, true);
EnvoyerEmail(admin.email, admin.mdp);
}
private void bunifuMaterialTextbox4_Leave(object sender, EventArgs e)
{
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
var secretaire = db.SECRETAIREs.Where(secretairee => secretairee.email.Equals(EmailInput.Text)).FirstOrDefault();
if (!(secretaire is null))
{
informationSplashScreen = $"secrétaire : {secretaire.nom} {secretaire.prenom} !";
pictureVerificationEmail.Image = Facturation.Properties.Resources.verified;
}
public void loaddata()
{
//remplissage comboBox data grid view : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
dropListVille.DisplayMember = "LblVille";
dropListVille.ValueMember = "IdVille";
dropListVille.DataSource = db.VILLEs.ToList();
}
LoadGridData();
}
public void Modifier_Click(object sender, EventArgs e)
{
//modifier : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
INGENIEUR ing = db.INGENIEURs.Find(InputCode.Text);
ing.noming = InputNom.Text;
ing.NumeroTelephoneIngenieur = InputTel.Text;
db.SaveChanges();
btnAnnuler_Click(sender, e);
}
AnimationFeedback("Modifié avec succées !", Properties.Resources.good);
}
private void MyDataGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
// testé et validé !
// intégre les donnée lli kaynine f la ligne dans les champs de l'interface d'ajout
if (e.ColumnIndex.Equals(0))
{
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
bunifuTransition1.HideSync(bunifuShadowPanel1, false, BunifuAnimatorNS.Animation.HorizSlide);
this.Ajouter.ButtonText = "Confirmer !";
this.Ajouter.Location = new System.Drawing.Point(423, 67);
this.Ajouter.Size = new System.Drawing.Size(92, 32);
if (this.InputCode.Enabled)
{
{
this.Ajouter.Click -= new EventHandler(Ajouter_Click);
this.Ajouter.Click += new EventHandler(Modifier_Click);
InputCode.Enabled = false;
}
var ing = db.INGENIEURs.Find(MyDataGrid.Rows[e.RowIndex].Cells["idIngenieur"].Value);
InputCode.Text = ing.IdIngenieur.ToString();
InputNom.Text = ing.noming;
InputTel.Text = ing.NumeroTelephoneIngenieur.ToString();
bunifuButton4.Visible = true;
bunifuTransition1.ShowSync(bunifuShadowPanel1, false, BunifuAnimatorNS.Animation.HorizSlide);
}
}
}
else if (e.ColumnIndex.Equals(5) || e.ColumnIndex.Equals(1))
{
if (
DialogResult.Yes ==
MessageBox.Show($"Etes vous sur de vouloir supprimer <{MyDataGrid.Rows[e.RowIndex].Cells["nom"].Value}> de la base de donnée ?? Cette action est irréversible !",
"Supression",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question)
)
{
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
db.CLIENTs.Remove(db.CLIENTs.Find(MyDataGrid.Rows[e.RowIndex].Cells["idIngenieur"].Value));
db.SaveChangesAsync();
AnimationFeedback("Suprimé avec succées !", Properties.Resources.good);
}
}
}
}
public void Modifier_Click(object sender, EventArgs e)
{
//modifier : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
CLIENT client = db.CLIENTs.Find(InputCode.Text);
client.NumeroTelephoneClient = InputTel.Text;
client.NomAgenceOuClient = InputNom.Text;
client.VILLE = db.VILLEs.Find(dropListVille.SelectedValue);
db.SaveChanges();
btnAnnuler_Click(sender, e);
}
AnimationFeedback("Modifié avec succées !", Properties.Resources.good);
}
private void IdentityVerification()
{
if (!Program.form.IsAdmin)
{
this.label10.Visible = this.label11.Visible = this.LB_NbrSecrtr.Visible = this.LB_NbrAdmin.Visible = false;
}
else
{
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
this.LB_NbrSecrtr.Text = db.SECRETAIREs.Count <SECRETAIRE>().ToString();
this.LB_NbrAdmin.Text = db.ADMINNs.Count <ADMINN>().ToString();
}
}
}
private void bunifuImageButton1_Click(object sender, EventArgs e)
{
//rechercher : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
MyDataGrid.DataSource = (from ing in db.INGENIEURs
select new
{
ing.IdIngenieur,
ing.noming,
ing.NumeroTelephoneIngenieur
}).Where(INGENIEUR => INGENIEUR.noming.Contains(bunifuMetroTextbox1.Text))
.ToList();
}
}
private void bunifuImageButton1_Click(object sender, EventArgs e)
{
//rechercher : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
MyDataGrid.DataSource = (from cl in db.CLIENTs
select new
{
cl.NumeroSerie,
cl.NomAgenceOuClient,
cl.NumeroTelephoneClient,
cl.VILLE.LblVille
}).Where(client => client.NomAgenceOuClient.Contains(bunifuMetroTextbox1.Text))
.ToList();
}
}
public void LoadData()
{
Canvas canvas;
DataPoint dataPoint = new DataPoint(BunifuDataViz._type.Bunifu_doughnut);
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
int pourcentageClientEntreprises = db.CLIENTs.Where(client => client.NumeroSerie.StartsWith("En")).Count();
dataPoint.addLabely("Entreprises", pourcentageClientEntreprises);
int pourcentageClientParticuler = db.CLIENTs.Where(client => client.NumeroSerie.StartsWith("Pa")).Count();
dataPoint.addLabely("Particuler", pourcentageClientParticuler);
canvas = new Canvas();
canvas.addData(dataPoint);
bunifuDataViz1.Render(canvas);
dataPoint.clear();
// ***Statistiques***
//manque remplissage de Dataviz 2 et 3
this.LB_NbrClient.Text = db.CLIENTs.Count <CLIENT>().ToString();
this.LB_NbrIngenieur.Text = db.INGENIEURs.Count <INGENIEUR>().ToString();
this.LB_FactureImp.Text = db.FACTURATIONs.Where(facture => facture.EstImprime == true).ToList().Count <FACTURATION>().ToString();
this.LB_FactureNoImp.Text = db.FACTURATIONs.Where(facture => facture.EstImprime == false).ToList().Count <FACTURATION>().ToString();
this.LB_NbrPieces.Text = db.PIECEs.Count <PIECE>().ToString();
IdentityVerification();
OutilConnect.Connect();
OutilConnect.sqlCommand = new System.Data.SqlClient.SqlCommand("select top 1 LblVille , count(*) as countt from client c inner join ville v on c.Id_Class# = v.IdVille group by LblVille order by countt desc", OutilConnect.sqlConnection);
OutilConnect.reader = OutilConnect.sqlCommand.ExecuteReader();
OutilConnect.table = new DataTable();
OutilConnect.table.Load(OutilConnect.reader);
this.LB_VilleMax.Text = OutilConnect.table.Rows[0]["LblVille"].ToString();
OutilConnect.reader.Close();
OutilConnect.sqlCommand = new System.Data.SqlClient.SqlCommand("select top 1 c.NomAgenceOuClient , count(*) as countt from Appel a inner join CLIENT c on c.NumeroSerie = a.IdClient# group by c.NomAgenceOuClient order by countt desc", OutilConnect.sqlConnection);
OutilConnect.reader = OutilConnect.sqlCommand.ExecuteReader();
OutilConnect.table.Load(OutilConnect.reader);
this.LB_ClientEx.Text = String.IsNullOrEmpty(OutilConnect.table.Rows[0]["NomAgenceOuClient"].ToString()) ?
"Digital Factory" : OutilConnect.table.Rows[0]["NomAgenceOuClient"].ToString();
OutilConnect.reader.Close();
OutilConnect.DeConnect();
}
}
private void Ajouter_Click(object sender, EventArgs e)
{
//ajouter : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
if (db.INGENIEURs.Find(InputCode.Text) is null)
{
db.INGENIEURs.Add(new INGENIEUR
{
IdIngenieur = Convert.ToInt32(InputCode.Text),
noming = InputNom.Text,
NumeroTelephoneIngenieur = InputTel.Text,
});
db.SaveChanges();
AnimationFeedback("Ajouté avec succées !", Properties.Resources.good);
}
else
{
AnimationFeedback("Client déja existant !", Properties.Resources.notValid);
}
}
}
public void Ajouter_Click(object sender, EventArgs e)
{
//ajouter : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
if (db.CLIENTs.Find(InputCode.Text) is null)
{
db.CLIENTs.Add(new CLIENT
{
NumeroSerie = InputCode.Text,
NumeroTelephoneClient = InputTel.Text,
NomAgenceOuClient = InputNom.Text,
VILLE = db.VILLEs.Find(dropListVille.SelectedValue)
});
db.SaveChanges();
AnimationFeedback("Ajouté avec succées !", Properties.Resources.good);
}
else
{
AnimationFeedback("Client déja existant !", Properties.Resources.notValid);
}
}
}
private void bunifuButton1_Click(object sender, EventArgs e)
{
//ajouter : testé et validé !
using (Facturation_DBEntities db = new Facturation_DBEntities())
{
if (db.SECRETAIREs.Find(InputCode.Text) is null)
{
db.SECRETAIREs.Add(new SECRETAIRE
{
id = int.Parse(InputCode.ToString()),
nom = bunifuMaterialTextbox1.Text,
prenom = bunifuMaterialTextbox2.Text,
email = bunifuMaterialTextbox3.Text,
mdp = bunifuMaterialTextbox4.Text
});
db.SaveChanges();
AnimationFeedback("Ajouté avec succées !", Properties.Resources.good);
}
else
{
AnimationFeedback("Client déja existant !", Properties.Resources.notValid);
}
}
}
