private void btn_ftr_dzn_Click(object sender, EventArgs e) { if (txt_ftr_tutar.Text.Contains('.') & txt_ftr_tutar.Text.Contains(',')) { DialogResult uyarı = new DialogResult(); uyarı = MessageBox.Show("Aynı anda hem virgül hem nokta giremezsiniz!", "FATURA SİLME", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); if (uyarı == DialogResult.OK) { } else { } } else { txt_ftr_tutar.Text = hf.Comma2Dot(txt_ftr_tutar.Text); txt_avans.Text = hf.Comma2Dot(txt_avans.Text); DateTime dt = Convert.ToDateTime(txt_ftr_tarih.Text); string dateToday = dt.ToString("d"); DayOfWeek day = Convert.ToDateTime(txt_ftr_tarih.Text).DayOfWeek; string dayToday = day.ToString(); if ((day == DayOfWeek.Saturday) || (day == DayOfWeek.Sunday)) { MessageBox.Show("Lütfen hafta içi olacak bir tarih giriniz! "); } else { fatura_euro = Convert.ToDecimal(hf.EuroCalculation(txt_ftr_tarih.Text, txt_ftr_tutar.Text, cmb_birim.Text, Convert.ToString(fatura_euro))); if (fatura_euro == Convert.ToDecimal(0000)) { MessageBox.Show("Lütfen İnternete Bağlanınız"); } else { vade = Convert.ToString(txt_ftr_vade.Text); baslangic = Convert.ToDateTime(txt_ftr_tarih.Text); bitis = baslangic.AddDays(int.Parse(vade)); if (cb_durum.Checked) { db = new DBConnect(); db.UpdateFaturalar(Convert.ToInt32(lbl_id.Text), Convert.ToString(txt_fatura_no.Text), Convert.ToString(cmb_projeNo.Text), Convert.ToString(cmb_firma.Text), Convert.ToInt32(txt_ftr_vade.Text), bitis, Convert.ToString(rcb_acıklama.Text), Convert.ToDateTime(txt_ftr_tarih.Text), ck_alarm.Checked, Convert.ToDecimal(txt_ftr_tutar.Text), Convert.ToString(cmb_birim.Text), Convert.ToInt32(txt_avans.Text), fatura_euro, Convert.ToString(lbl_tip.Text), Convert.ToString(cmb_ftr_tip.Text), Convert.ToString("ÖDENDİ")); this.Close(); } else { db = new DBConnect(); db.UpdateFaturalar(Convert.ToInt32(lbl_id.Text), Convert.ToString(txt_fatura_no.Text), Convert.ToString(cmb_projeNo.Text), Convert.ToString(cmb_firma.Text), Convert.ToInt32(txt_ftr_vade.Text), bitis, Convert.ToString(rcb_acıklama.Text), Convert.ToDateTime(txt_ftr_tarih.Text), ck_alarm.Checked, Convert.ToDecimal(txt_ftr_tutar.Text), Convert.ToString(cmb_birim.Text), Convert.ToInt32(txt_avans.Text), fatura_euro, Convert.ToString(lbl_tip.Text), Convert.ToString(cmb_ftr_tip.Text), Convert.ToString("ÖDENMEDİ")); this.Close(); } } } } }
private void btn_stf_kayit_Click(object sender, EventArgs e) { if (txt_mlz_brmFiyat.Text.Contains('.') & txt_mlz_brmFiyat.Text.Contains(',')) { DialogResult uyarı = new DialogResult(); uyarı = MessageBox.Show("Aynı anda hem virgül hem nokta giremezsiniz!", "FATURA SİLME", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); if (uyarı == DialogResult.OK) { } else { } } else { txt_mlz_brmFiyat.Text = hf.Comma2Dot(txt_mlz_brmFiyat.Text); DateTime dt = Convert.ToDateTime(date_teslim.Text); string dateToday = dt.ToString("d"); DayOfWeek day = Convert.ToDateTime(date_teslim.Text).DayOfWeek; if ((day == DayOfWeek.Saturday) || (day == DayOfWeek.Sunday)) { MessageBox.Show("Lütfen hafta içi olacak bir tarih giriniz! "); } else { siparis_euro = hf.EuroCalculation(date_teslim.Text, txt_mlz_brmFiyat.Text, cmb_paraBirimi.Text, siparis_euro); db = new DBConnect(); db.InsertSE(Convert.ToString(cmb_prjno.Text), Convert.ToString(txt_siparisNo.Text), Convert.ToString(txt_tedarikci.Text), Convert.ToString(txt_talepKisi.Text), Convert.ToDateTime(date_teslim.Text), Convert.ToInt32(txt_vade.Text), Convert.ToDateTime(date_temin.Text), Convert.ToDecimal(txt_mlz_brmFiyat.Text), Convert.ToString(cmb_paraBirimi.Text), Convert.ToDecimal(siparis_euro), Convert.ToString(rcb_aciklama.Text)); this.Close(); } } }
private void cmb_projeler_SelectedIndexChanged(object sender, EventArgs e) { index = 0; Array.Clear(monthG, 0, 12); Array.Clear(month_sumG, 0, 12); Array.Clear(monthK, 0, 12); Array.Clear(month_sumK, 0, 12); myConnection.Open(); try { komut = "SELECT sum(fatura_euro) FROM db_faturalar WHERE fatura_proje_no ='" + cmb_projeler.Text + "' AND fatura_tipi='G'"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { TOPLAM = Convert.ToDecimal(myReader.GetString(0)); lbl_top_maliyet.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } myReader.Close(); } catch { lbl_top_maliyet.Text = "0"; myReader.Close(); } try { komut = "SELECT sum(fatura_euro) FROM db_faturalar WHERE fatura_durum='ÖDENDİ' AND fatura_proje_no ='" + cmb_projeler.Text + "' AND fatura_tipi='G'"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { TOPLAM = Convert.ToDecimal(myReader.GetString(0)); lbl_odenmisG.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } myReader.Close(); } catch { lbl_odenmisG.Text = "0"; myReader.Close(); } try { komut = "SELECT proje_butce,proje_birim,proje_baslangic FROM db_projeler WHERE proje_no='" + cmb_projeler.Text + "'"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { lbl_prjEuro.Text = hf.EuroCalculation(Convert.ToString(myReader.GetString(2)), Convert.ToString(myReader.GetString(0)), Convert.ToString(myReader.GetString(1)), lbl_prjEuro.Text); lbl_prjEuro.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(lbl_prjEuro.Text)); } myReader.Close(); } catch { lbl_prjEuro.Text = "0"; myReader.Close(); } try { komut = "SELECT sum(fatura_euro) FROM db_faturalar WHERE fatura_durum='ÖDENDİ' AND fatura_proje_no ='" + cmb_projeler.Text + "' AND fatura_tipi='K'"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { TOPLAM = Convert.ToDecimal(myReader.GetString(0)); lbl_odenmisK.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } myReader.Close(); } catch { lbl_odenmisK.Text = "0"; myReader.Close(); } try { komut = "SELECT proje_butce,proje_birim FROM db_projeler WHERE proje_no='" + cmb_projeler.Text + "'"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { TOPLAM = Convert.ToDecimal(myReader.GetString(0)); BIRIM = Convert.ToString(myReader.GetString(1)); if (BIRIM == "USD") { lbl_prj_butce.Text = string.Format(new CultureInfo("en-SG"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } else if (BIRIM == "EUR") { lbl_prj_butce.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } else if (BIRIM == "TRY") { lbl_prj_butce.Text = string.Format("{0:C2}", Convert.ToDecimal(TOPLAM)); } else if (BIRIM == "GBP") { lbl_prj_butce.Text = string.Format(new CultureInfo("en-GB"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } else { lbl_prj_butce.Text = string.Format(new CultureInfo("en-CH"), "{0:C2}", Convert.ToDecimal(TOPLAM)); } } //lbl_prjEuro.Text = hf.EuroDonusum(BIRIM, Convert.ToString(TOPLAM)); //lbl_prjEuro.Text = string.Format(new CultureInfo("de-DE"), "{0:C2}", Convert.ToDecimal(lbl_prjEuro.Text)); myReader.Close(); } catch { lbl_prj_butce.Text = "0"; //lbl_prjEuro.Text = "0"; myReader.Close(); } try { komut = "SELECT DATE_FORMAT(fatura_vade_tarih,'%m-%Y') AS Month, SUM(fatura_euro) FROM db_faturalar WHERE fatura_durum='ÖDENMEDİ' and fatura_tipi='G' and fatura_proje_no ='" + cmb_projeler.Text + "' GROUP BY DATE_FORMAT(fatura_vade_tarih, '%m-%Y')"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if (Convert.ToDateTime(myReader.GetString(0)).Year == DateTime.Now.Year) { monthG[index] = Convert.ToDateTime(myReader.GetString(0)); month_sumG[index] = (float)Convert.ToDouble(myReader.GetString(1)); index++; } } myReader.Close(); } catch { //MessageBox.Show(Convert.ToString(DateTime.Now.AddMonths(1))); myReader.Close(); } try { index = 0; komut = "SELECT DATE_FORMAT(fatura_vade_tarih,'%m-%Y') AS Month, SUM(fatura_euro) FROM db_faturalar WHERE fatura_durum='ÖDENMEDİ' and fatura_tipi='K' and fatura_proje_no ='" + cmb_projeler.Text + "' GROUP BY DATE_FORMAT(fatura_vade_tarih, '%m-%Y')"; da = new MySqlDataAdapter(komut, connection); myCommand = new MySqlCommand(komut, myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if (Convert.ToDateTime(myReader.GetString(0)).Year == DateTime.Now.Year) { monthK[index] = Convert.ToDateTime(myReader.GetString(0)); month_sumK[index] = (float)Convert.ToDouble(myReader.GetString(1)); index++; } } myReader.Close(); } catch { //MessageBox.Show(Convert.ToString(DateTime.Now.AddMonths(1))); myReader.Close(); } myConnection.Close(); FillDGW(); DGWToplam(); DrawChart1(); DrawChart2(); DrawChart3(); DrawChart4(); }