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