public static int KasaBakiye(BankaSurragate bnk) { using (DB_OtoGaleriEntities DB = new DB_OtoGaleriEntities()) { var g = (from a in DB.TB_Banka orderby a.İslemID descending select a.KasadakiPara).FirstOrDefault(); return(g.Value); } }
public static int IslemEkleKasa(BankaSurragate bankaSur) { using (DB_OtoGaleriEntities DB = new DB_OtoGaleriEntities()) { TB_Banka bank = new TB_Banka(); bank.İslemCesidi = bankaSur.islemCesidi; bank.İslemAciklama = bankaSur.İslemAciklama; var g = (from a in DB.TB_Banka orderby a.İslemID descending select a.BankadakiPara).FirstOrDefault(); if (g == null) { bank.BankadakiPara = bankaSur.BankadakiPara + 0; } else { bank.BankadakiPara = g; } var k = (from a in DB.TB_Banka orderby a.İslemID descending select a.KasadakiPara).FirstOrDefault(); if (k == null) { bank.KasadakiPara = bankaSur.KasadakiPara + 0; } else { bank.KasadakiPara = bankaSur.KasadakiPara + k; } DB.TB_Banka.Add(bank); DB.SaveChanges(); return(bank.İslemID); } }