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();
}
}
