void SetKasaGenelGider() { try { _selectedKasaKodu = cmboxKasalar.Text; if (!string.IsNullOrEmpty(_selectedKasaKodu)) { double gelir = mngKasaHar.GetKasaGelirGiderBySubeKoduAndKasaKodu(UserInfo.Sube.Id, _selectedKasaKodu, KasaGelirGider.Gelir); double gider = mngKasaHar.GetKasaGelirGiderBySubeKoduAndKasaKodu(UserInfo.Sube.Id, _selectedKasaKodu, KasaGelirGider.Gider); Kasa kasa = mngKasa.GetById(_selectedKasaKodu, false); double devir = kasa.SonDevirTutar.GetValueOrDefault(0); double bakiye = (gelir + devir) - gider; txtDevir.Text = devir.ToString("F2"); txtToplamGelir.Text = gelir.ToString("F2"); txtToplamGider.Text = gider.ToString("F2"); txtDevreden.Text = bakiye.ToString("F2"); tslabTopGelir.Text = gelir.ToString("F2"); tslabTopGider.Text = gider.ToString("F2"); tsLabBakiye.Text = bakiye.ToString("F2"); this.Text = string.Format("KasaKodu:{0};Tarih:{1}", cmboxKasalar.Text, dateIslemTarih.Value.ToString("d")); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
private void btn_KasaEkle_Click(object sender, EventArgs e) { Kasa kasaEntity = new Kasa(); if (!string.IsNullOrEmpty(txt_KasaAdi.Text)) { kasaEntity.Adi = txt_KasaAdi.Text; } if (!string.IsNullOrEmpty(txt_Aciklama.Text)) { kasaEntity.Aciklama = txt_Aciklama.Text; } bool sonuc = kOrm.Insert(kasaEntity); if (sonuc) { MessageBox.Show("Kasa Ekleme başarılı"); dataGridView1.DataSource = kOrm.Select(); } else { MessageBox.Show("Ekleme işlemi başarısız"); } }
private void btnEkle_Click(object sender, EventArgs e) { Kasa k = new Kasa(); if (txtAdi.Text == null || txtAdi.Text == "") { MessageBox.Show("Kasa adını giriniz", "Kasa Adı", MessageBoxButtons.OK, MessageBoxIcon.Information); txtAdi.Focus(); return; } k.Adi = Tools.ToTitleCase(txtAdi.Text); k.Aciklama = Tools.ToTitleCase(txtAciklama.Text); bool sonuc = kOrm.Insert(k); if (sonuc) { MessageBox.Show("Kasa Eklendi", "Kasa Ekleme", MessageBoxButtons.OK, MessageBoxIcon.Information); dataGridView1.DataSource = kOrm.Select(); Tools.Temizle(this); txtAdi.Focus(); } else { MessageBox.Show("Kasa eklenmedi\n -Benzer iki kasa eklenemez", "Kasa Ekleme", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void silToolStripMenuItem_Click_1(object sender, EventArgs e) { int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Id"].Value); if (id <= 0) { MessageBox.Show("Silinecek eleman yoktur"); } else { Kasa k = new Kasa(); k.Id = id; bool sonuc = kOrm.Delete(k); if (sonuc) { MessageBox.Show("Kasa Silindi", "Kasa Silme", MessageBoxButtons.OK, MessageBoxIcon.Information); dataGridView1.DataSource = kOrm.Select(); dataGridView1.Focus(); } else { MessageBox.Show("Kasa Silinmedi\n", "Kasa Silme", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
void KayitSil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { Kasa kasa = mngKasa.GetById(txtKasaKodu.Text, true); mngKasa.BeginTransaction(); mngKasa.Delete(kasa); LoadGrid(); YeniKayit(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } finally { try { mngKasa.CommitTransaction(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } } }
void Kaydet() { try { Kasa kasa = mngKasa.GetById(txtKasaKodu.Text, false); if (kasa == null) { kasa = new Kasa(); } kasa.Id = txtKasaKodu.Text; kasa.KasaIsmi = txtKasaIsmi.Text; kasa.SonDevirTarih = dateTimePicker1.Value.JustDate(); kasa.SonDevirTutar = txtSonDevirTutar.Text.ParseNullable <double>(x => double.Parse(x)); kasa.KayitTarih = DateTime.Now; kasa.Sube = UserInfo.Sube; mngKasa.BeginTransaction(); mngKasa.SaveOrUpdate(kasa); YeniKayit(); LoadGrid(); } catch (Exception) { } finally { try { mngKasa.CommitTransaction(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } }
public async Task <IActionResult> PutKasa(int id, Kasa kasa) { if (id != kasa.Kasaid) { return(BadRequest()); } _context.Entry(kasa).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!KasaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Kasa> > PostKasa(Kasa kasa) { _context.Kasa.Add(kasa); await _context.SaveChangesAsync(); return(CreatedAtAction("GetKasa", new { id = kasa.Kasaid }, kasa)); }
public ActionResult DeleteKasa(int id) { if (Session["Grubu"].ToString() == "Teknik Servis Kullanıcısı") { return(Json(new { success = false, message = "Yetkiniz Yoktur." }, JsonRequestBehavior.AllowGet)); } else { using (sayazilimEntities db = new sayazilimEntities()) { Kasa emp = db.Kasa.Where(x => x.ID == id).FirstOrDefault <Kasa>(); if (emp.Merkez == true) { return(Json(new { success = false, message = "Merkez Kasa Silinemez" }, JsonRequestBehavior.AllowGet)); } else { using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand cmd = new SqlCommand("IslemKontrolKasa", conp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@KasaID", emp.ID); // input parameter // output parameter SqlParameter average = new SqlParameter("@deger", SqlDbType.NVarChar, 50); average.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(average); // return value SqlParameter count = cmd.CreateParameter(); count.Direction = System.Data.ParameterDirection.ReturnValue; cmd.Parameters.Add(count); cmd.ExecuteNonQuery(); if (Convert.ToInt32(count.Value) != 0) { if (average.Value.ToString() == "İşlem") { return(Json(new { success = false, message = "Bu kasaya ait " + average.Value.ToString() + " işlem bulunmaktadır.Silinemez" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Seçili Kasa Bakiyesi 0'dan Büyüktür.İşlemlerinizi Kontrol Ediniz" }, JsonRequestBehavior.AllowGet)); } } else { db.Kasa.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } } } } }
public BlackOrderMage() : base(AIType.AI_Mage, FightMode.Closest, 10, 1, 0.2, 0.4) { Name = "Black Order Mage"; Title = "of the Dragons's Flame Sect"; Race = Utility.RandomBool() ? Race.Human : Race.Elf; Body = Race == Race.Elf ? 605 : 400; Hue = Utility.RandomSkinHue(); Utility.AssignRandomHair(this); if (Utility.RandomBool()) { Utility.AssignRandomFacialHair(this, HairHue); } SetStr(125, 175); SetDex(90, 110); SetInt(285, 305); SetHits(900, 1100); SetDamage(12, 26); SetDamageType(ResistanceType.Physical, 100); SetResistance(ResistanceType.Physical, 40, 65); SetResistance(ResistanceType.Fire, 50, 70); SetResistance(ResistanceType.Cold, 30, 50); SetResistance(ResistanceType.Poison, 45, 65); SetResistance(ResistanceType.Energy, 45, 65); Fame = 10000; Karma = -10000; SetSkill(SkillName.MagicResist, 80.0, 100.0); SetSkill(SkillName.Tactics, 115.0, 130.0); SetSkill(SkillName.Wrestling, 95.0, 120.0); SetSkill(SkillName.Anatomy, 105.0, 120.0); SetSkill(SkillName.Magery, 100.0, 110.0); SetSkill(SkillName.EvalInt, 100.0, 110.0); /* Equip */ Item item = null; AddItem(new Waraji()); item = new FancyShirt(); item.Hue = 1309; AddItem(item); item = new Kasa(); item.Hue = 1309; AddItem(item); item = new Hakama(); item.Hue = 1309; AddItem(item); }
public frmKasaIslem(Kasa entity) { InitializeComponent(); _entity = entity; txtKasaKodu.DataBindings.Add("text", _entity, "KasaKodu"); txtKasaAdi.DataBindings.Add("text", _entity, "KasaAdi"); txtYetkiliKodu.DataBindings.Add("text", _entity, "YetkiliKodu"); txtYetkiliAdi.DataBindings.Add("text", _entity, "YetkiliAdi"); txtAciklama.DataBindings.Add("text", _entity, "Aciklama"); }
private void btnStokSec_Click(object sender, EventArgs e) { if (gridView1.GetSelectedRows().Length != 0) { string kasakodu = gridView1.GetFocusedRowCellValue(colKasaKodu).ToString(); entity = context.Kasalar.SingleOrDefault(c => c.KasaKodu == kasakodu); secildi = true; this.Close(); } }
private void btnCariSec_Click(object sender, EventArgs e) { if (gridView1KasaSecim.GetSelectedRows().Length != 0) // gridview boş değil ise bu işlemi yap { string kasakodu = gridView1KasaSecim.GetFocusedRowCellValue(colKasaKodu).ToString(); entity = context.Kasalar.SingleOrDefault(c => c.KasaKodu == kasakodu); secildi = true; this.Close(); } }
private void simpleButton1_Click(object sender, EventArgs e) { frmKasaSec kasaSec = new frmKasaSec(); kasaSec.ShowDialog(); if (kasaSec.secildi) { _kasaBilgi = context.Kasalar.SingleOrDefault(c => c.Id == kasaSec.entity.Id); txtKasaKodu.Text = kasaSec.entity.KasaKodu; txtKasaAdi.Text = kasaSec.entity.KasaAdi; } }
public IHttpActionResult Post([FromBody] Kasa kasa) { try { db.Kasa.Add(kasa); db.SaveChanges(); return(Ok(kasa)); } catch (Exception error) { return(InternalServerError(error)); } }
public IHttpActionResult Patch([FromBody] Kasa kasa) { try { db.Entry(kasa).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Ok(kasa)); } catch (Exception error) { return(InternalServerError(error)); } }
protected override void GuncelNesneOlustur() { currentEntity = new Kasa { Id = id, Kod = txtKod.Text, KasaAdi = txtKasaAdi.Text, OzelKod1Id = txtOzelKod1.Id, OzelKod2Id = txtOzelKod2.Id, SubeId = AnaForm.SubeId, DonemId = AnaForm.DonemId, Aciklama = txtAciklama.Text, Durum = tglDurum.IsOn }; ButonEnabledDurumu(); }
protected override void GuncelNesneOlustur() { CurrentEntity = new Kasa { Id = Id, Kod = txtKod.Text, KasaAdi = txtKasaAdi.Text, OzelKod1Id = txtOzelKod1.Id,//nullable veri kabul ettiği için convert gerek yok OzelKod2Id = txtOzelKod2.Id, SubeId = AnaForm.SubeId, DonemId = AnaForm.DonemId, Aciklama = txtAciklama.Text, Durum = tglDurum.IsOn }; ButonEnabledDurumu(); }
private void btnEkle_Click(object sender, EventArgs e) { Kasa k = new Kasa(); k.Adi = txtKasaAdi.Text; k.Aciklama = txtAciklama.Text; bool sonuc = kOrm.Insert(k); if (sonuc) { MessageBox.Show("Kasa Eklendi"); dataGridView1.DataSource = kOrm.Select(); } else { MessageBox.Show("Kasa Eklenirken Hata Oluştu"); } }
private void btnEkle_Click(object sender, EventArgs e) { Kasa k = new Kasa(); k.Adi = txtAdi.Text; k.Aciklama = txtAciklama.Text; bool sonuc = kOrm.Insert(k); if (sonuc) { MessageBox.Show("Kasa Ekleme Başarılı"); dataGridView1.DataSource = kOrm.Select(); } else { MessageBox.Show("Kayıt Ekleme Başarısız"); } }
private void btnEkle_Click(object sender, EventArgs e) { Kasa ksa = new Kasa(); ksa.Adi = txtKasaAdi.Text; ksa.Aciklama = txtAciklama.Text; bool sonuc = kasaOrm.Insert(ksa); if (sonuc) { MessageBox.Show("Kasa ekleme başarılı"); dtgrKasa.DataSource = kasaOrm.Select(); } else { MessageBox.Show("Kasa ekleme başarısiz"); } }
public static List <Kasa> GetListKasa() { object tLockObj = new object(); OleDbCommand command = new OleDbCommand(); OleDbDataReader reader; List <Kasa> KasaList = new List <Kasa>(); string queryString = ""; lock (tLockObj) { using (var connection = new OleDbConnection(connectionAdress)) { try { connection.Open(); queryString = "SELECT * FROM Kasa"; command.CommandText = queryString; command.Connection = connection; reader = command.ExecuteReader(); while (reader.Read()) { var kasa = new Kasa { ID = reader["ID"] as int? ?? default(int), KasaMiktari = reader["KasaMiktari"] as int? ?? default(int), KontorBirimFiyati = reader["KontorBirimFiyati"] as int? ?? default(int), Tarih = reader["Tarih"] as DateTime? ?? default(DateTime) }; KasaList.Add(kasa); } } catch (Exception) { return(new List <Kasa>()); } finally { connection.Close(); connection.Dispose(); } return(KasaList); } } }
public static bool AddKasa(Kasa kasa) { object tLockObj = new object(); OleDbCommand command = new OleDbCommand(); string queryString = ""; int rowsCount = 0; lock (tLockObj) { using (var conncection = new OleDbConnection(connectionAdress)) { try { conncection.Open(); queryString = "INSERT INTO Kasa(KasaMiktari,KontorBirimFiyati,Tarih) VALUES(" + kasa.KasaMiktari + "," + kasa.KontorBirimFiyati + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')"; command.CommandText = queryString; command.Connection = conncection; //command.Parameters.AddWithValue("@kasaMiktari", kasa.KasaMiktari); //command.Parameters.AddWithValue("@kontorBirimFiyati", kasa.KontorBirimFiyati); //command.Parameters.AddWithValue("@Tarih", kasa.Tarih); rowsCount = command.ExecuteNonQuery(); } catch (Exception ex) { string result = ex.Message; rowsCount = 0; } finally { conncection.Close(); conncection.Dispose(); } if (rowsCount > 0) { return(true); } else { return(false); } } } }
public IHttpActionResult Get(int Id) { try { Kasa result = db.Kasa.Find(Id); if (result == null) { return(NotFound()); } else { return(Ok(result)); } } catch (Exception error) { return(InternalServerError(error)); } }
private void btnUpdate_Click(object sender, EventArgs e) { Kasa kasaEntity = new Kasa(); kasaEntity.Adi = txt_KasaAdi.Text; kasaEntity.Aciklama = txt_Aciklama.Text; kasaEntity.Id = int.Parse(dataGridView1.CurrentRow.Cells["Id"].Value.ToString()); bool sonuc = kOrm.Update(kasaEntity); if (sonuc) { MessageBox.Show("Kasa Guncelleme başarılı"); dataGridView1.DataSource = kOrm.Select(); } else { MessageBox.Show("Guncelleme işlemi başarısız"); } }
private void txtKasaKodu_KeyUp(object sender, KeyEventArgs e) { try { if (!string.IsNullOrEmpty(txtKasaKodu.Text) && e.KeyCode == Keys.Tab) { Kasa kasa = mngKasa.GetById(txtKasaKodu.Text, false); if (kasa != null) { txtKasaIsmi.Text = kasa.KasaIsmi; txtSonDevirTutar.Text = kasa.SonDevirTutar.FromNullableToString(); dateTimePicker1.Text = kasa.SonDevirTarih.FromNullableToString(); } txtKasaIsmi.Focus(); } } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
public static bool UpdateKasa(Kasa kasa) { object tLockObj = new object(); OleDbCommand command = new OleDbCommand(); string queryString = ""; int rowsCount = 0; lock (tLockObj) { using (var connection = new OleDbConnection(connectionAdress)) { try { connection.Open(); queryString = "UPDATE Kasa SET(KasaMiktari=@kasaMiktari,KontorBirimFiyati=@kontorBirimFiyati,Tarih=@tarih) WHERE ID=@id"; command.Connection = connection; command.CommandText = queryString; command.Parameters.AddWithValue("@kasaMiktari", kasa.KasaMiktari); command.Parameters.AddWithValue("@KontorBirimFiyati", kasa.KontorBirimFiyati); command.Parameters.AddWithValue("@tarih", kasa.Tarih); command.Parameters.AddWithValue("@id", kasa.ID); rowsCount = command.ExecuteNonQuery(); } catch (Exception) { rowsCount = 0; } finally { connection.Close(); connection.Dispose(); } if (rowsCount > 0) { return(true); } else { return(false); } } } }
public frmOdemeEkrani(int odemeTuruId, Nullable <decimal> odenmesiGereken = null) { InitializeComponent(); int kasaId = Convert.ToInt32(SettingsTool.AyarOku(SettingsTool.Ayarlar.SatisAyarlari_VarsayilanKasa)); _kasaBilgi = context.Kasalar.SingleOrDefault(c => c.Id == kasaId); _odemeTuruBilgi = context.OdemeTurleri.SingleOrDefault(c => c.Id == odemeTuruId); txtOdemeTuru.Text = _odemeTuruBilgi.OdemeTuruAdi; txtKasaKodu.Text = _kasaBilgi.KasaKodu; txtKasaAdi.Text = _kasaBilgi.KasaAdi; if (odenmesiGereken != null) { gelenTutar = odenmesiGereken.Value; } else { txtTutar.Properties.Buttons[1].Visible = false; } }
public IHttpActionResult Delete(int Id) { try { Kasa result = db.Kasa.Find(Id); if (result == null) { return(NotFound()); } else { db.Kasa.Remove(result); db.SaveChanges(); return(Ok()); } } catch (Exception error) { return(InternalServerError(error)); } }
public ActionResult KasaBilgi(int id) { ViewBag.KasaIslemID = 0; using (sayazilimEntities db = new sayazilimEntities()) { Kasa emp = db.Kasa.Where(x => x.ID == id).FirstOrDefault <Kasa>(); if (emp != null) { ViewBag.KasaTutar = emp.Bakiye.ToString(); ViewBag.KasaID = id; } //if (emp.ParaBirimi == "TL") //{ // emp.Bakiye = emp. //} return(Json(new { success = true, data = emp }, JsonRequestBehavior.AllowGet)); } }