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