private void Connecter_Click(object sender, EventArgs e) { SqlDataReader sdr = DatabaseOperations.LoginIsCorrect(Tb_login.Text, Tb_mdp.Text); if (sdr.Read()) { if (sdr[0].ToString() == "admin") { string Nom = sdr[1].ToString(), Prenom = sdr[2].ToString(); sdr.Close(); MainAdmin mainAdmin = new MainAdmin(Nom, Prenom); mainAdmin.Show(); Hide(); } else { if (sdr[0].ToString() == "agent") { string Nom = sdr[1].ToString(), Prenom = sdr[2].ToString(); sdr.Close(); MainAgent mainAgent = new MainAgent(Nom, Prenom); mainAgent.Show(); Hide(); } else { if (sdr[0].ToString() == "caissier") { string Nom = sdr[1].ToString(), Prenom = sdr[2].ToString(); sdr.Close(); MainCaissier mainCaissier = new MainCaissier(Nom, Prenom); mainCaissier.Show(); Hide(); } else { MessageBox.Show("Votre Login est inccorect"); sdr.Close(); } } } } DatabaseOperations.closeCon(); }
internal void ajouterCommande_Load(object sender, EventArgs e) { if (!DesignMode) { TB_total.Enabled = false; TB_facture_N.Text = "F2019-" + DatabaseOperations.maxId(); display_data(); connection.Open(); SqlCommand cmd = connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select reference from produit"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { CB_reference.Items.Add(dr["reference"].ToString()); } connection.Close(); } }