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