public int Add(Gider Entity)
{
/*
* INSERT INTO [Giderler]
* ([Id]
* ,[GiderAdi]
* ,[Miktar]
* ,[Tarih]
* ,[HesapId])
* ,[KategoriId]
* VALUES
* (<Id, bigint,>
* ,<GiderAdi, text,>
* ,<Miktar, real,>
* ,<Tarih, text,>
* ,<HesapId, bigint,>
* ,KategoriId);
*/
string query = "insert into Giderler (GiderAdi,Miktar,Tarih,HesapId,KategoriId) values (@gideradi,@miktar,@tarih,@hasapid,@KategoriId)";
command = new SQLiteCommand(query, connection);
command.Parameters.AddWithValue("@gideradi", Entity.GiderAdi);
command.Parameters.AddWithValue("@miktar", Entity.Miktar);
command.Parameters.AddWithValue("@hasapid", Entity.Hesap_Kart_Id);
command.Parameters.AddWithValue("@KategoriId", Entity.KategoriId);
command.Parameters.AddWithValue("@tarih", Entity.Tarih);
command.Prepare();
connection.Open();
ReturnValue = command.ExecuteNonQuery();
connection.Close();
if (ReturnValue == 1)
{
DalHesapKart dalHesapKart = new DalHesapKart();
dalHesapKart.BakiyeSubtraction(Entity.Miktar, Entity.Hesap_Kart_Id);
}
return(ReturnValue);
}
