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