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.");
}
}
