private void button1_Click(object sender, EventArgs e) { try { SOCIETE SOCIETE = entity.SOCIETE.FirstOrDefault(societe => societe.CODE_S == fillaleID); SOCIETE.NOM_S = tb2.Text; SOCIETE.ADR_S = tb3.Text; SOCIETE.VILLE = tb4.Text; SOCIETE.CODE_POSTAL = Convert.ToDecimal(tb5.Text); SOCIETE.TEL_S = tb6.Text; SOCIETE.PAY = tb7.Text; entity.SaveChanges(); MessageFormtOK MessageFormtOK = new MessageFormtOK("Modification avec success..."); var result = MessageFormtOK.ShowDialog(); Close(); } catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { try { SOCIETE societe = entity.SOCIETE.FirstOrDefault(S => S.CODE_S.Equals((decimal)comboboxSociete.SelectedValue)); MACHINE Machine = entity.MACHINE.FirstOrDefault(machine => machine.ID_M == machineID); Machine.TYPE_M = cb2.Text; Machine.CODE_S = societe.CODE_S; Machine.LIB = tb1.Text; Machine.IP = tb2.Text; Machine.PORT = Convert.ToDecimal(tb3.Text); Machine.PWD = tb4.Text; Machine.ID_LECTEUR = 1; // Machine.SOCIETE = societe; entity.SaveChanges(); MessageFormtOK MessageFormtOK = new MessageFormtOK("Modification avec success..."); var result = MessageFormtOK.ShowDialog(); Close(); } catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { try { SOCIETE societe = entity.SOCIETE.FirstOrDefault(S => S.CODE_S.Equals((decimal)comboboxSociete.SelectedValue)); MACHINE machine = new MACHINE { // ID_M = Convert.ToDecimal(cb1.Text), TYPE_M = cb2.Text, CODE_S = societe.CODE_S, LIB = tb1.Text, IP = tb2.Text, PORT = Convert.ToDecimal(tb3.Text), PWD = tb4.Text, ID_LECTEUR = 1, SOCIETE = societe }; entity.MACHINE.Add(machine); entity.SaveChanges(); MessageBox.Show("ajout avec success..."); MessageFormtOK MessageFormtOK = new MessageFormtOK("ajout avec success..."); var result = MessageFormtOK.ShowDialog(); Close(); } catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { SOCIETE societe = entity.SOCIETE.FirstOrDefault(S => S.CODE_S.Equals((decimal)comboBox1.SelectedValue)); // var ID = entity.SHIFT.First().CODE; SHIFT Shift = entity.SHIFT.FirstOrDefault(shift => shift.CODE == shiftID); // CODE = ID + 1, // CODE = 5, Shift.LIBELLE = TextboxLibelle.Text; Shift.DATEDDEBUT = dateTimePicker1.Value; Shift.DATEDFIN = dateTimePicker2.Value; Shift.HEUREDEBUT = dateTimePicker3.Value; Shift.HEUREFIN = dateTimePicker4.Value; Shift.HEUREDEBUTPAUSE = dateTimePicker5.Value; Shift.HEUREFINPAUSE = dateTimePicker6.Value; Shift.WEEKEND = checkBoxWeekend.Checked ? 1 : 0; Shift.VACANCE = checkBoxVacances.Checked?1:0; Shift.JOURSFERIES = checkBoxJoursferies.Checked ? 1 : 0; Shift.CODE_S = societe.CODE_S; Shift.SOCIETE = societe; entity.SaveChanges(); this.Close(); MessageFormtOK MessageFormtOK = new MessageFormtOK("modification avec success..."); var result = MessageFormtOK.ShowDialog(); }
private void button1_Click(object sender, EventArgs e) { try { SOCIETE SOCIETE = new SOCIETE { NOM_S = tb2.Text, ADR_S = tb3.Text, VILLE = tb4.Text, CODE_POSTAL = Convert.ToDecimal(tb5.Text), TEL_S = tb6.Text, PAY = tb7.Text, }; entity.SOCIETE.Add(SOCIETE); entity.SaveChanges(); MessageFormtOK MessageFormtOK = new MessageFormtOK("ajout avec success..."); var result = MessageFormtOK.ShowDialog(); Close(); } catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }
private void button2_Click(object sender, EventArgs e) { try { string imgpath = img.ImageLocation; FileStream fs = new FileStream((string)imgpath, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); FileInfo fi = new FileInfo((string)imgpath); byte[] imgdata = br.ReadBytes((int)fi.Length); fs.Close(); br.Close(); SOCIETE societe = entity.SOCIETE.FirstOrDefault(S => S.CODE_S.Equals((decimal)comboBox1.SelectedValue)); SHIFT shift = entity.SHIFT.FirstOrDefault(S => S.CODE == (decimal)comboBox2.SelectedValue); PERSONNEL p = new PERSONNEL { MAT = tb1.Text, NOM = tb2.Text, PRENOM = tb3.Text, TEL = tb4.Text, ADR_P = tb5.Text, VILLE_P = tb6.Text, POSTE = tb7.Text, DATE_EMB = dt.Value, SALAIRE = Convert.ToDecimal(tb8.Text), PHOTO = imgdata, CODE_S = societe.CODE_S, SHIFT = shift, SOCIETE = societe, IDEMPRIENT = emprientID }; entity.PERSONNEL.Add(p); entity.SaveChanges(); ajout.ForeColor = Color.Green; MessageFormtOK MessageFormtOK = new MessageFormtOK("ajout avec success"); var result = MessageFormtOK.ShowDialog(); this.Close(); }//Try end catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { try { SOCIETE societe = entity.SOCIETE.FirstOrDefault(S => S.CODE_S.Equals((decimal)comboBox1.SelectedValue)); // var ID = entity.SHIFT.First().CODE; SHIFT shift = new SHIFT { // CODE = ID + 1, // CODE = 5, LIBELLE = TextboxLibelle.Text, DATEDDEBUT = dateTimePicker1.Value, DATEDFIN = dateTimePicker2.Value, HEUREDEBUT = dateTimePicker3.Value, HEUREFIN = dateTimePicker4.Value, HEUREDEBUTPAUSE = dateTimePicker5.Value, HEUREFINPAUSE = dateTimePicker6.Value, WEEKEND = checkBoxWeekend.Checked ? 1 : 0, VACANCE = checkBoxVacances.Checked ? 1 : 0, JOURSFERIES = checkBoxJoursferies.Checked ? 1 : 0, CODE_S = societe.CODE_S, SOCIETE = societe }; entity.SHIFT.Add(shift); entity.SaveChanges(); MessageFormtOK MessageFormtOK = new MessageFormtOK("ajout avec success"); var result = MessageFormtOK.ShowDialog(); this.Close(); } catch (Exception ex) { MessageFormError MessageForm = new MessageFormError(ex.Message.ToString()); var result = MessageForm.ShowDialog(); } }