internal bool shtoFurnizim(Furnizimi f)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"INSERT INTO [dbo].[furnizimi]
(
[Id_Artikull],
[Sasia],
[Cmimi_blerjes],
[Id_koke_furnizimi]
VALUES
(
@Id_artikull,
@Sasia,
@Cmimi,
@Id_koke_furnizimi
)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Id_artikull", f.a.id);
cmd.Parameters.AddWithValue("@Sasia", f.sasiBlerje);
cmd.Parameters.AddWithValue("@Cmimi", f.cmimiBlerje);
cmd.Parameters.AddWithValue("@Id_koke_fature", f.kokeFurnizimi.id);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
}
return(isSuccess);
}
internal bool ndryshoFurnizim(Furnizimi f)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"UPDATE [dbo].[furnizimi]
SET [Id_koke_fature] = @Id_koke_fature,
[Id_Artikull] = @Id_artikull,
[Sasia] = @Sasia,
[Cmimi_blerjes] = @Cmimi
WHERE Id = @Id";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Id_koke_fature", f.kokeFurnizimi.id);
cmd.Parameters.AddWithValue("@Id_artikull", f.a.id);
cmd.Parameters.AddWithValue("@Sasia", f.sasiBlerje);
cmd.Parameters.AddWithValue("@Cmimi", f.cmimiBlerje);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
return(isSuccess);
}
}
internal bool fshiFurnizim(Furnizimi furnizimi)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string q = @"DELETE FROM [dbo].[furnizimi] WHERE [Id] = @ID ";
using (SqlCommand cmd = new SqlCommand(q, conn))
{
cmd.Parameters.AddWithValue("@ID", furnizimi.id);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
}
return(isSuccess);
}