public void Add(Entities.Models.MOLD mold) { using (AlfaPlastikContext context = new AlfaPlastikContext()) { var sonuc = context.MOLDs.Any(x => x.MOLD_NAME == mold.MOLD_NAME); var sonuc2 = context.MOLDs.Any(x => x.MOLD_NO == mold.MOLD_NO); if (sonuc == true) { MessageBox.Show("aynı isim giremez"); } else { if (sonuc2 == true) { MessageBox.Show("aynı NO giremez"); } else { var entity = context.Entry(mold); entity.State = System.Data.Entity.EntityState.Added; context.SaveChanges(); MessageBox.Show("Kayıt Eklendi"); } } } }
public void checkkontrol() { if (checkBox1.Checked == true) { if (IsEmriEkle.id != null) { WRKORD w = managerWRKORD.Find(x => x.WRKORD_ID == IsEmriEkle.id); Entities.Models.MOLD wrh = managerMOLD.Find(z => z.MOLD_ID == (int)IsEmriEkle.Instance.comboBox_Kn.SelectedValue); w.STATUS_ = "DEVAM EDİYOR"; IsEmriEkle.Instance.comboBox5.Text = "DEVAM EDİYOR"; IsEmriEkle.Instance.comboBox_Ambar.Text = "KALIPHANE"; wrh.Warehouse_ID = Convert.ToInt32(IsEmriEkle.Instance.comboBox_Ambar.SelectedValue); managerMOLD.Update(wrh); managerWRKORD.Update(w); } } else { if (IsEmriEkle.id != null) { WRKORD w = managerWRKORD.Find(x => x.WRKORD_ID == IsEmriEkle.id); w.STATUS_ = "BAŞLAMADI"; IsEmriEkle.Instance.comboBox5.Text = "BAŞLAMADI"; managerWRKORD.Update(w); } } }
public void IsEmri() { if (!string.IsNullOrEmpty(comboBox_BakimTipi.Text) && !string.IsNullOrEmpty(comboBox_Ka.Text) && !string.IsNullOrEmpty(comboBox_Kn.Text) && !string.IsNullOrEmpty(TBX_İsEmriNo.Text) && !string.IsNullOrEmpty(ucIsEmir1.comboBox1.Text) && !string.IsNullOrEmpty(ucIsEmir1.comboBox_Öncelik.Text) && !string.IsNullOrEmpty(ucIsEmir1.dateTimePicker3.Text) && !string.IsNullOrEmpty(ucIsEmir1.dateTimePicker2.Text) && !string.IsNullOrEmpty(ucIsEmir1.richTextBox_not.Text)) { Entities.Models.MOLD m = managerMOLD.Find(a => a.MOLD_ID == (int)comboBox_Kn.SelectedValue); w.WRKORD_INSERTDATE = DateTime.Now; w.CREATER_ID = GirisSayfasi.aktif.USERS_ID; w.Mold_ID = (int)comboBox_Ka.SelectedValue; w.Mold_ID = (int)comboBox_Kn.SelectedValue; m.Warehouse_ID = (int)comboBox_Ambar.SelectedValue; w.Maintaintype_ID = (int)comboBox_BakimTipi.SelectedValue; w.STATUS_ = comboBox5.Text; w.WRKORD_NO = Convert.ToInt32(TBX_İsEmriNo.Text); managerMOLD.Update(m); dal.Add(w); if (w.WRKORD_ID == 0) { MessageBox.Show("Hatalı Kayıt"); } else { IdAta(); DefaultAta(); dal1.Add(wL1); dal2.Add(wL2); dal3.Add(wL3); dal4.Add(wL4); TalepEkle(); dal1.Update(wL1); emirGor.Listele(); button9.Visible = false; ucIsEmir1.label7.Text = w.WRKORD_INSERTDATE.ToString();//kayıt işlemi gerçekleştiğinde talep kısmının altında labelin içinde kayıt tarihi gelir. ucIsEmir1.label7.Visible = true; button_PLANLAMA.BackColor = Color.Gold; button_PLANLAMA.Enabled = true; ucIsEmir21.richTextBox_TalepNot.Text = ucIsEmir1.richTextBox_not.Text; ucIsEmir21.textBox_tarih.Text = ucIsEmir1.dateTimePicker2.Text; ucIsEmir31.richTextBox_isemir.Text = ucIsEmir1.richTextBox_not.Text; } } else { MessageBox.Show("Lütfen Tüm Alanları Doldurunuz"); } }
public void Update(Entities.Models.MOLD mold) { using (AlfaPlastikContext context = new AlfaPlastikContext()) { try { var entity = context.Entry(mold); entity.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } catch (Exception) { MessageBox.Show("Aynı değer girilemez"); } } }
public void Delete(Entities.Models.MOLD mold) { using (AlfaPlastikContext context = new AlfaPlastikContext()) { var hata = context.WRKORDs.Any(x => x.Mold_ID == mold.MOLD_ID); if (hata == true) { MessageBox.Show("Silinemez Kayıt,Hareket Görmüştür!"); } else { var entity = context.Entry(mold); 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."); } }