private void button_OK_Click(object sender, EventArgs e)
{
if (IsEmriEkle.id != null)
{
WL_COMPLETE wL4 = managerWL_COMPLETE.Find(x => x.WRKID == IsEmriEkle.id);
wL4.COMPLETION_DATE = dateTimePicker1.Value;
wL4.COMPLETION_TİME = TimeSpan.FromHours(dateTimePicker2.Value.Hour);
wL4.DELIVERY_TYPE = comboBox1.Text;
wL4.DELIVERY_NOTE = richTextBox_Teslim.Text;
int sonuc = managerWL_COMPLETE.Update(wL4);
if (sonuc > 0)
{
UcEmirGor uc = new UcEmirGor();
MessageBox.Show("Kayıt Eklendi");
if (IsEmriEkle.id != null)
{
WRKORD w = managerWRKORD.Find(x => x.WRKORD_ID == IsEmriEkle.id);
w.STATUS_ = "TAMAMLANDI";
IsEmriEkle.Instance.comboBox5.Text = "TAMAMLANDI";
uc.Listele();
managerWRKORD.Update(w);
}
}
else
{
MessageBox.Show("Hata Meydana Geldi");
}
}
else
{
MessageBox.Show("Lütfen Tüm Alanları Doldurunuz");
}
}
public void Update(WL_COMPLETE uc4)
{
using (AlfaPlastikContext context = new AlfaPlastikContext())
{
var entity = context.Entry(uc4);
entity.State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(WL_COMPLETE uc4)
{
using (AlfaPlastikContext context = new AlfaPlastikContext())
{
var entity = context.Entry(uc4);
entity.State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
MessageBox.Show("Kayıt Silindi");
}
}
private void BTN_G1_Click(object sender, EventArgs e)
{
WRKORD wrk = managerWRKORD.Find(x => x.WRKORD_ID == (int)TBX_İsEmriNo.Tag);
WL_REQUEST wl1 = managerWL_REQUEST.Find(y => y.WRKID == (int)ucIsEmirDuzen11.comboBox_Öncelik.Tag);
WL_PLAN wl2 = managerWL_PLAN.Find(w => w.WRKID == (int)ucIsEmirDuzen21.comboBox_BakımPersonel.Tag);
WL_PROCESS wl3 = managerWL_PROCESS.Find(z => z.WRKID == (int)ucIsEmirDuzen31.richTextBox_yapılan.Tag);
WL_COMPLETE wl4 = managerWL_COMPLETE.Find(q => q.WRKID == (int)ucIsEmirDuzen41.richTextBox_Teslim.Tag);
Entities.Models.MOLD m = managerMOLD.Find(a => a.MOLD_ID == (int)comboBox_Kn.SelectedValue);
if (!string.IsNullOrEmpty(TBX_İsEmriNo.Text))
{
if (comboBox_Ambar.SelectedValue != null)
{
m.Warehouse_ID = (int)(comboBox_Ambar.SelectedValue);
}
if (ucIsEmirDuzen11.comboBox1.SelectedValue != null)
{
wl1.REQUEST_BY = (int)(ucIsEmirDuzen11.comboBox1.SelectedValue);
}
if (comboBox_BakimTipi.SelectedValue != null)
{
wrk.Maintaintype_ID = (int)(comboBox_BakimTipi.SelectedValue);
}
if (comboBox_Ka.SelectedValue != null && comboBox_Kn.SelectedValue != null)
{
wrk.Mold_ID = (int)(comboBox_Ka.SelectedValue);
wrk.Mold_ID = (int)(comboBox_Kn.SelectedValue);
}
wrk.WRKORD_NO = Convert.ToInt32(TBX_İsEmriNo.Text);
wrk.WRKORD_INSERTDATE = dtp_Tarih.Value;
wrk.STATUS_ = cmb_statü.Text;
wrk.MODIFIER_ID = GirisSayfasi.aktif.USERS_ID;
wrk.MODIFYDATE = DateTime.Now;
wl1.PRIORITY = ucIsEmirDuzen11.comboBox_Öncelik.Text;
wl1.REQUEST_DATE = ucIsEmirDuzen11.dateTimePicker2.Value;
wl1.PLANNED_START_DATE = ucIsEmirDuzen11.dateTimePicker3.Value;
wl1.WRK_NOTE = ucIsEmirDuzen11.rTB.Text;
wl2.MAINTAIN_PERSON = Convert.ToInt32(ucIsEmirDuzen21.comboBox_BakımPersonel.Tag);
wl2.MAINTAIN_PERSON_NAME = ucIsEmirDuzen21.comboBox_BakımPersonel.Text;
wl2.ESTIMATED_START_DATE = ucIsEmirDuzen21.dateTimePicker1.Value;
wl2.PLANNED_TİME = Convert.ToInt32(ucIsEmirDuzen21.textBox_saat.Text);
wl2.TO_DO_NOTE = ucIsEmirDuzen21.richTextBoxYapılacaklarNot.Text;
wl3.PROCESS_NOTE = ucIsEmirDuzen31.richTextBox_yapılan.Text;
if (ucIsEmirDuzen21.checkBox2.Checked == true)
{
ucIsEmirDuzen31.textBox1.Visible = true;
ucIsEmirDuzen31.checkBox2.Visible = true;
wl3.OPE1_ID = (int)ucIsEmirDuzen21.comboBox1.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox3.Checked == true)
{
ucIsEmirDuzen31.checkBox3.Visible = true;
ucIsEmirDuzen31.textBox2.Visible = true;
wl3.OPE2_ID = (int)ucIsEmirDuzen21.comboBox2.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox4.Checked == true)
{
ucIsEmirDuzen31.checkBox4.Visible = true;
ucIsEmirDuzen31.textBox3.Visible = true;
wl3.OPE3_ID = (int)ucIsEmirDuzen21.comboBox3.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox5.Checked == true)
{
ucIsEmirDuzen31.checkBox5.Visible = true;
ucIsEmirDuzen31.textBox4.Visible = true;
wl3.OPE4_ID = (int)ucIsEmirDuzen21.comboBox4.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox6.Checked == true)
{
ucIsEmirDuzen31.checkBox6.Visible = true;
ucIsEmirDuzen31.textBox5.Visible = true;
wl3.OPE5_ID = (int)ucIsEmirDuzen21.comboBox5.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox7.Checked == true)
{
ucIsEmirDuzen31.checkBox7.Visible = true;
ucIsEmirDuzen31.textBox6.Visible = true;
wl3.OPE6_ID = (int)ucIsEmirDuzen21.comboBox6.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox8.Checked == true)
{
ucIsEmirDuzen31.checkBox8.Visible = true;
ucIsEmirDuzen31.textBox7.Visible = true;
wl3.OPE7_ID = (int)ucIsEmirDuzen21.comboBox7.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen21.checkBox9.Checked == true)
{
ucIsEmirDuzen31.checkBox9.Visible = true;
ucIsEmirDuzen31.textBox8.Visible = true;
wl3.OPE8_ID = (int)ucIsEmirDuzen21.comboBox8.SelectedValue;
managerWL_PROCESS.Update(wl3);
}
if (ucIsEmirDuzen31.checkBox2.Checked == true)
{
wl3.OPE1_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox3.Checked == true)
{
wl3.OPE2_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox4.Checked == true)
{
wl3.OPE3_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox5.Checked == true)
{
wl3.OPE4_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox6.Checked == true)
{
wl3.OPE5_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox7.Checked == true)
{
wl3.OPE6_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox8.Checked == true)
{
wl3.OPE7_DATE = DateTime.Now;
}
if (ucIsEmirDuzen31.checkBox9.Checked == true)
{
wl3.OPE8_DATE = DateTime.Now;
}
wl4.DELIVERY_TYPE = ucIsEmirDuzen41.comboBox1.Text;
wl4.DELIVERY_NOTE = ucIsEmirDuzen41.richTextBox_Teslim.Text;
wl4.COMPLETION_TİME = ucIsEmirDuzen41.dateTimePicker2.Value.TimeOfDay;
wl4.COMPLETION_DATE = ucIsEmirDuzen41.dateTimePicker1.Value;
managerMOLD.Update(m);
int sonuc = managerWRKORD.Update(wrk);
managerWL_REQUEST.Update(wl1);
managerWL_PLAN.Update(wl2);
managerWL_PROCESS.Update(wl3);
managerWL_COMPLETE.Update(wl4);
if (sonuc >= 0)
{
MessageBox.Show("Kayıt Güncellendi");
this.Close();
}
else
{
MessageBox.Show("Kayıt Güncellenemedi");
}
}
else
{
MessageBox.Show("Boş alanı doldurunuz.");
}
}
