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