internal bool shtoKokeFurnizimi(KokeFurnizimi kf) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"INSERT INTO [dbo].[koke_furnizimi] ( [Id], [Id_furnitori], [Data], [Nr_fature], VALUES ( @Id_furnitori, @Data, @Nr_fature )"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_furnitori", kf.f.id); cmd.Parameters.AddWithValue("@Data", kf.date); cmd.Parameters.AddWithValue("@Nr_fature", kf.nr_fature); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
internal bool ndryshoKokeFurnizimi(KokeFurnizimi kf) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"UPDATE [dbo].[koke_furnizimi] SET [Id_furnitori]=@Id_furnitori, [Data]=@Data, [Nr_fature]=@Nr_fature WHERE Id = @Id"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_furnitori", kf.f.id); cmd.Parameters.AddWithValue("@Data", kf.date); cmd.Parameters.AddWithValue("@Nr_fature", kf.nr_fature); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } return(isSuccess); } }
public Furnizimi() { kokeFurnizimi = new KokeFurnizimi(); a = new Artikull(); }