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