private void btnSiparisKoduOlustur_Click(object sender, EventArgs e)
{
try
{
sqlCmd = new SqlCommand("SELECT TOP 1 SIPARIS_INCKEY FROM SIPARIS ORDER BY SIPARIS_INCKEY DESC", Program.connection);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.HasRows)
{
ActionControl.ActionAllControls(this, "clear");
siparisListesiGridView.Rows.Clear();
siparisListesiGridView.Refresh();
txtSiparisTarih.Text = DateTime.Now.ToString("dd.MM.yyyy");
txtSiparisTeslimTarih.Text = DateTime.Now.ToString("dd.MM.yyyy");
sqlReader.Read();
txtSiparisKodu.Text = "SP" + (int.Parse(sqlReader["SIPARIS_INCKEY"].ToString()) + 1).ToString("D10");
siparisKod = txtSiparisKodu.Text;
sqlReader.Close();
}
else
{
txtSiparisKodu.Text = "SP0000000001";
}
}
catch (Exception ex)
{
Notification.messageBoxError(ex.Message);
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
ActionControl.ActionAllControls(groupBox1, "clear");
ActionControl.ActionAllControls(groupBox2, "clear");
ActionControl.ActionAllControls(groupBox3, "clear");
ActionControl.ActionAllControls(groupBox4, "clear");
cbStokDepo.Items.Clear();
siparisListesiGridView.Rows.Clear();
siparisStokList.Clear();
siparisTipi.SelectedIndex = 0;
txtSiparisTarih.Text = DateTime.Now.ToString("dd.MM.yyyy");
txtSiparisTeslimTarih.Text = DateTime.Now.ToString("dd.MM.yyyy");
}
private void silBttn_Click(object sender, EventArgs e)
{
if (kullaniciListesiGridView.SelectedRows.Count == 1)
{
try
{
DialogResult dialogResult = MessageBox.Show("SİLMEK İSTEDİĞİNİZDEN EMİN MİSİNİZ ?", "UYARI", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int kullaniciId = Int32.Parse(kullaniciListesiGridView.SelectedRows[0].Cells[0].Value.ToString());
SqlCommand command = new SqlCommand("DELETE FROM KULLANICI WHERE KUL_INCKEY = @kul_inckey", Program.connection);
command.Parameters.Add("@kul_inckey", SqlDbType.Int).Value = kullaniciId;
int affectedRows = command.ExecuteNonQuery();
if (affectedRows > 0)
{
kullaniciListesiGridView.Rows.RemoveAt(selectedItem.Item1);
ActionControl.ActionAllControls(this, "clear");
textTemizle();
Notification.messageBox("Kullanıcı Başarıyla Silindi");
}
else
{
Notification.messageBoxError("Bir sorun oluştu, kullanıcı silinemedi !");
}
}
}
catch (Exception ex)
{
Notification.messageBoxError(ex.Source);
}
}
else
{
Notification.messageBoxError("Seçili bir kayıt bulunamadı !");
}
}
private void CariListeleDuzenle_Load(object sender, EventArgs e)
{
ActionControl.ActionAllControls(groupBox1, "disable");
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
ActionControl.ActionAllControls(this, "clear");
}
private void txtCariKod_TextChanged(object sender, EventArgs e)
{
ActionControl.ActionAllControls(groupBox1, "enable");
try
{
sqlCmd = new SqlCommand("SELECT * FROM CARI WHERE CARI_INCKEY=@cari_inckey", Program.connection);
sqlCmd.Parameters.AddWithValue("@cari_inckey", secilenCari.Item1);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
sqlReader.Read();
if (!String.IsNullOrEmpty(sqlReader["TC_NO"].ToString().Trim()))
{
gercekKisiRadio.Checked = true;
tuzelKisiRadio.Checked = false;
txtVergiDaire.Enabled = false;
txtVergiDaire.ReadOnly = true;
txtVergiNo.Enabled = false;
txtVergiNo.ReadOnly = true;
txtTcKimlik.Enabled = true;
txtTcKimlik.ReadOnly = false;
}
else
{
tuzelKisiRadio.Checked = true;
gercekKisiRadio.Checked = false;
txtTcKimlik.Enabled = false;
txtTcKimlik.ReadOnly = true;
txtVergiDaire.Enabled = true;
txtVergiDaire.ReadOnly = false;
txtVergiNo.Enabled = true;
txtVergiNo.ReadOnly = false;
}
txtTicariUnvan.Text = sqlReader["TICARI_UNVAN"].ToString();
txtAdSoyad.Text = sqlReader["ADSOYAD"].ToString();
txtTcKimlik.Text = sqlReader["TC_NO"].ToString();
txtIl.Text = sqlReader["IL"].ToString();
txtIlce.Text = sqlReader["ILCE"].ToString();
txtVergiDaire.Text = sqlReader["VERGI_DAIRE"].ToString();
txtVergiNo.Text = sqlReader["VERGI_NO"].ToString();
txtEposta.Text = sqlReader["EPOSTA"].ToString();
txtTelefonNo.Text = sqlReader["TEL_NO"].ToString();
txtFaxNo.Text = sqlReader["FAX_NO"].ToString();
txtAdres.Text = sqlReader["ADRES"].ToString();
if (bool.Parse(sqlReader["CARI_DURUM"].ToString()))
{
hesapDurumuAktif.Checked = true;
hesapDurumuPasif.Checked = false;
}
else
{
hesapDurumuAktif.Checked = false;
hesapDurumuPasif.Checked = true;
}
}
catch (Exception ex)
{
Notification.messageBoxError(ex.Message);
}
}
private void temizleBttn_Click(object sender, EventArgs e)
{
ActionControl.ActionAllControls(this, "clear");
}
private void btnListeyeEkle_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtStokKodu.Text) || String.IsNullOrEmpty(txtBirimFiyat.Text))
{
Notification.messageBoxError("LÜTFEN STOK SEÇİNİZ");
}
else
{
if (decimal.Parse(txtToplamFiyat.Text) > 0)
{
string stokDepoInckey = "";
string stokInckey = "";
string stokKodu = "";
string stokAdi = "";
string stokMiktar = "";
string stokBirim = "";
string stokBirimFiyat = "";
string stokTutar = "";
string stokDepo = "";
if (stokGuncelle.Item1)
{
siparisListesiGridView.Rows.RemoveAt(stokGuncelle.Item2);
stokDepoInckey = selectedUpdateItem.Item1.ToString();
stokInckey = selectedUpdateItem.Item2.ToString();
stokKodu = txtStokKodu.Text.Trim();
stokAdi = txtStokAdi.Text.Trim();
stokDepo = cbStokDepo.SelectedItem.ToString().Split('-')[1].Trim();
stokMiktar = txtStokMiktar.Text.Trim();
stokBirim = txtStokBirim.Text.Trim();
stokBirimFiyat = txtBirimFiyat.Text.Trim();
stokTutar = txtToplamFiyat.Text.Trim();
siparisListesiGridView.Rows.Add(stokDepoInckey, stokInckey, stokKodu, stokAdi, stokDepo, stokMiktar, stokBirim, stokBirimFiyat, stokTutar);
siparisToplamTutar += decimal.Parse(stokTutar);
siparisStokList.Add(stokInckey);
btnListeyeEkle.Text = "LİSTEYE EKLE";
ActionControl.ActionAllControls(groupBox4, "clear");
cbStokDepo.Items.Clear();
}
else
{
if (!siparisStokList.Contains(selectedItem.Item2["STOK_INCKEY"].Value.ToString()))
{
stokDepoInckey = cbStokDepo.SelectedItem.ToString().Split('-')[0].Trim();
stokInckey = selectedItem.Item2["STOK_INCKEY"].Value.ToString();
stokKodu = txtStokKodu.Text.Trim();
stokAdi = selectedItem.Item2["STOK_ADI"].Value.ToString();
stokMiktar = txtStokMiktar.Text;
stokBirim = txtStokBirim.Text;
stokBirimFiyat = selectedItem.Item2["BIRIM_FIYAT"].Value.ToString();
stokTutar = txtToplamFiyat.Text;
stokDepo = cbStokDepo.SelectedItem.ToString().Split('-')[1].Trim();
siparisListesiGridView.Rows.Add(stokDepoInckey, stokInckey, stokKodu, stokAdi, stokDepo, stokMiktar, stokBirim, stokBirimFiyat, stokTutar);
siparisStokList.Add(selectedItem.Item2["STOK_INCKEY"].Value.ToString());
siparisToplamTutar += decimal.Parse(stokTutar);
kaydetBttn.Enabled = true;
ActionControl.ActionAllControls(groupBox4, "clear");
cbStokDepo.Items.Clear();
}
}
siparisListesiGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
}