private void btnSave_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
try
{
Validate();
tBLOZELGUNTableAdapter.Update(iaseDataSetOzelGun.TBLOZELGUN);
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
conn.Open();
var cmdUpd = new OleDbCommand();
cmdUpd.Connection = conn;
cmdUpd.CommandText = "UPDATE TBLOZELGUN SET EK_FLOAT1 = 1 WHERE OGUN = 'Sabah'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLOZELGUN SET EK_FLOAT1 = 2 WHERE OGUN = 'Öğle'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLOZELGUN SET EK_FLOAT1 = 3 WHERE OGUN = 'Akşam'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLOZELGUN SET EK_FLOAT1 = 4 WHERE OGUN = 'Ara Öğün'";
cmdUpd.ExecuteNonQuery();
XtraMessageBox.Show(u, "Kayıt Başarılı!!", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Hata!");
}
}
private void tileNavPane1_TileClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (e.Element.Tag != null)
{
if (e.Element.Tag.ToString() == "data-product")
{
AddPanel(Screen.Product);
}
else if (e.Element.Tag.ToString() == "data-member")
{
AddPanel(Screen.Member);
}
else if (e.Element.Tag.ToString() == "system-claim")
{
AddPanel(Screen.Claim);
}
else if (e.Element.Tag.ToString() == "system-stock-monitor")
{
AddPanel(Screen.StockMonitor);
}
else if (e.Element.Tag.ToString() == "item-report")
{
AddPanel(Screen.Report);
}
}
}
private void itmEinde_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (MessageBox.Show("Weet u zeker dat u alle programma's wilt afsluiten?", "Programma afsluiten", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
Application.Exit();
}
}
private void navEdit_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
frmAfdekmateriaal f = new frmAfdekmateriaal(int.Parse(gcCP.GetFocusedRowCellValue("AfdekID").ToString()));
f.ShowDialog();
gcSuppliers.DataSource = cls.GetAllAfdekmateriaal();
}
private void navButton6_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
this.Close();
Login a = new Login();
a.ShowDialog();
}
private void navAdd_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
frmAfdekmateriaal f = new frmAfdekmateriaal(0);
f.ShowDialog();
gcSuppliers.DataSource = cls.GetAllAfdekmateriaal();
}
private void btnSave_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
try
{
Validate();
tBLKISIBILDIRIMITableAdapter.Update(iaseDataSetKisiBildirimi.TBLKISIBILDIRIMI);
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
conn.Open();
var cmdUpd = new OleDbCommand();
cmdUpd.Connection = conn;
cmdUpd.CommandText = "UPDATE TBLKISIBILDIRIMI SET EK_FLOAT1 = 1 WHERE OGUN = 'Sabah' AND Format(TARIH, 'Short Date') = '" + dnTarih.DateTime.ToString("dd.MM.yyyy") + "'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLKISIBILDIRIMI SET EK_FLOAT1 = 2 WHERE OGUN = 'Öğle' AND Format(TARIH, 'Short Date') = '" + dnTarih.DateTime.ToString("dd.MM.yyyy") + "'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLKISIBILDIRIMI SET EK_FLOAT1 = 3 WHERE OGUN = 'Akşam' AND Format(TARIH, 'Short Date') = '" + dnTarih.DateTime.ToString("dd.MM.yyyy") + "'";
cmdUpd.ExecuteNonQuery();
cmdUpd.CommandText = "UPDATE TBLKISIBILDIRIMI SET EK_FLOAT1 = 4 WHERE OGUN = 'Ara Öğün' AND Format(TARIH, 'Short Date') = '" + dnTarih.DateTime.ToString("dd.MM.yyyy") + "'";
cmdUpd.ExecuteNonQuery();
XtraMessageBox.Show(u, "Kayıt Başarılı!!", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Hata!");
}
}
private void navButton2_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
Form_KisiListe kisi = new Form_KisiListe();
kisi.MdiParent = this;
kisi.Show();
}
private void navDelete_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (MessageBox.Show(DelMessage, DelCap, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
cls.DeleteAfdekmateriaal(int.Parse(gcCP.GetFocusedRowCellValue("AfdekID").ToString()));
gcSuppliers.DataSource = cls.GetAllAfdekmateriaal();
}
}
private void tileNavPane1_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (e.Element.Name == "btn_procesarpresupuesto")
{
Frm_Etapas objEtapas = new Frm_Etapas();
}
;
}
private void btnNewSB_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
gvOzelGunSB.AddNewRow();
gvOzelGunSB.SetFocusedRowCellValue("CREATE_DATE", DateTime.Now);
gvOzelGunSB.SetFocusedRowCellValue("CREATE_USERNO", IaseLib.userNo);
gvOzelGunSB.SetFocusedRowCellValue("LAST_UPDATE", DateTime.Now);
gvOzelGunSB.SetFocusedRowCellValue("LAST_UPUSERNO", IaseLib.userNo);
}
private void btnOzelGunMenusu_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
OzelGunMenusuSecim ozelGunMenusuSecim = new OzelGunMenusuSecim();
ozelGunMenusuSecim.gunlukYiyeceklerForm = this;
ozelGunMenusuSecim.tarih = dnTarih.DateTime.ToString("dd.MM.yyyy");
ozelGunMenusuSecim.ShowDialog();
}
private void navbtnAdmin_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
FormAdmin f = new FormAdmin(account.Id);
this.Hide();
f.ShowDialog();
reStart();
this.Show();
}
private void btnNewStok_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
gvYemekStok.AddNewRow();
gvYemekStok.SetFocusedRowCellValue("YEMEK_KODU", gvYemekler.GetFocusedRowCellValue("YEMEK_KODU"));
gvYemekStok.SetFocusedRowCellValue("CREATE_DATE", DateTime.Now);
gvYemekStok.SetFocusedRowCellValue("CREATE_USERNO", IaseLib.userNo);
gvYemekStok.SetFocusedRowCellValue("LAST_UPDATE", DateTime.Now);
gvYemekStok.SetFocusedRowCellValue("LAST_UPUSERNO", IaseLib.userNo);
}
private void btnNew_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
gvYemekListesi.AddNewRow();
gvYemekListesi.SetFocusedRowCellValue("CREATE_DATE", DateTime.Now);
gvYemekListesi.SetFocusedRowCellValue("CREATE_USERNO", IaseLib.userNo);
gvYemekListesi.SetFocusedRowCellValue("LAST_UPDATE", DateTime.Now);
gvYemekListesi.SetFocusedRowCellValue("LAST_UPUSERNO", IaseLib.userNo);
gvYemekListesi.SetFocusedRowCellValue("EK_STR1", gvOzelGunSB.GetFocusedRowCellValue("MENU_KODU"));
}
private void btnPDF_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
SaveFileDialog save = new SaveFileDialog();
if (save.ShowDialog() == DialogResult.OK)
{
gvStoklar.ExportToPdf(save.FileName + ".pdf");
}
}
private void btnNew_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
gvYemekListesi.AddNewRow();
gvYemekListesi.SetFocusedRowCellValue("CREATE_DATE", DateTime.Now);
gvYemekListesi.SetFocusedRowCellValue("CREATE_USERNO", IaseLib.userNo);
gvYemekListesi.SetFocusedRowCellValue("LAST_UPDATE", DateTime.Now);
gvYemekListesi.SetFocusedRowCellValue("LAST_UPUSERNO", IaseLib.userNo);
gvYemekListesi.SetFocusedRowCellValue("TARIH", dnTarih.DateTime);
}
private void btnPrint_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
link.Component = gcStoklar;
link.PrintingSystem.Document.AutoFitToPagesWidth = 1;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.PrintDlg();
}
private void navButton4_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (MessageBox.Show("真的要退出程序吗？", "退出程序", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Application.Exit();
}
else
{
}
}
private void tileNavPane1_TileClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (e.Element.Name == "navSale")
{
AddPanel(Screen.Sale);
}
else if (e.Element.Name == "navProduct")
{
AddPanel(Screen.Stock);
}
}
private void navDelete_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (XtraMessageBox.Show(this, "Weet u het zeker dat u deze gebruiker wilt verwijderen?", "Verwijder gebruiker", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int id = Convert.ToInt32(gcGebruiker.GetRowCellValue(gcGebruiker.FocusedRowHandle, "ID"));
if (id > 0)
{
MessageBox.Show("Weet u het zekere dat u deze gebruiker wilt verwijderen?", "Gebruiker verwijderen", MessageBoxButtons.OK, MessageBoxIcon.Warning);
herladen();
}
}
}
private void navOK_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (!kontrole())
{
return;
}
if (!haalData())
{
return;
}
this.DialogResult = DialogResult.OK;
}
private void navOK_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
if (AfID != 0)
{
cls.DeleteAfdekmateriaal(AfID);
}
else
{
AfID = cls.getmax() + 1;
}
cls.InsertAfdekmateriaal(AfID, txtNaam.Text, txtOmschrijving.Text, txtLocatie.Text, txtInfo.Text, cmbLev.SelectedValue.ToString(), decimal.Parse(txtPrijs.Text), ofd.FileName, txtMag.Text);
this.Close();
}
private void btnDel_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
if (XtraMessageBox.Show(u, "#" + gvYemekListesi.GetFocusedRowCellValue("YEMEK") + "# Silinecek.\nEmin Misiniz?", "Onay", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
gvYemekListesi.DeleteRow(gvYemekListesi.FocusedRowHandle);
}
}
private void btnDel_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
if (gvKullanicilar.GetFocusedRowCellValue("KULLANICI_ADI").ToString() == "ADMIN")
{
XtraMessageBox.Show(u, "ADMIN Kullanıcısı Silinemez!!!", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (XtraMessageBox.Show(u, "#" + gvKullanicilar.GetFocusedRowCellValue("KULLANICI_ADI") + "# Kullanıcı Tanımı Silinecek.\nEmin Misiniz?", "Onay", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
gvKullanicilar.DeleteRow(gvKullanicilar.FocusedRowHandle);
}
}
private void btnSaveSB_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
try
{
Validate();
tBLOZELGUNSBTableAdapter.Update(iaseDataSetOzelGunSB.TBLOZELGUNSB);
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
XtraMessageBox.Show(u, "Kayıt Başarılı!!", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Hata!");
}
}
private void ActionMenuItem(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
switch (e.Element.Tag as string)
{
case "대여 현황":
chartControl.BackColor = Color.Aquamarine;
gridControl.ForeColor = Color.DeepPink;
break;
case "매출 현황":
chartControl.BackColor = Color.Blue;
gridControl.ForeColor = Color.Brown;
break;
case "주차별 현황":
break;
case "전체 현황":
break;
}
}
private void tileNavPane1_ElementClick_1(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
Console.WriteLine(e.Element.Name);
switch (e.Element.Name)
{
case "D":
label1.Text = "A";
CargarFormulario(new POS_VENTAS());
break;
case "E":
label1.Text = "B";
break;
default:
Console.WriteLine("Default case");
break;
}
}
private void btnAktar_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
var u = new UserLookAndFeel(this);
u.UseDefaultLookAndFeel = false;
u.UseWindowsXPTheme = false;
u.Style = LookAndFeelStyle.Skin;
u.SkinName = IaseLib.skinName;
if (XtraMessageBox.Show(u, "Sözleşme Öğünleri Aktarılacak.\nEmin Misiniz?", "Onay", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
conn.Open();
var cmdIns = new OleDbCommand();
cmdIns.Connection = conn;
string recStr = "";
for (int i = 0; i < gvSozlesme.RowCount; i++)
{
if (i == 0)
{
recStr = Convert.ToInt32(gvSozlesme.GetRowCellValue(i, "REC_ID")).ToString();
}
else
{
recStr += "," + Convert.ToInt32(gvSozlesme.GetRowCellValue(i, "REC_ID")).ToString();
}
}
cmdIns.CommandText = "INSERT INTO TBLYEMEKLISTESIONAYLI SELECT * FROM TBLYEMEKLISTESI WHERE REC_ID IN(" + recStr + ")";
cmdIns.ExecuteNonQuery();
conn.Close();
XtraMessageBox.Show(u, "Kayıtlar Aktarıldı.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrids();
}
}
private void itmEinde_ElementClick(object sender, DevExpress.XtraBars.Navigation.NavElementEventArgs e)
{
ParentForm.Close();
}
