/// <summary> /// Add a PackageProductSupplier to the DB /// </summary> /// <param name="packageId"></param> /// <param name="productSupplierId"></param> /// <returns></returns> public static bool Add(PackageProductSupplier packageProductSupplier) { if (Object.Equals(packageProductSupplier, null)) { return(false); } string query = "INSERT INTO Packages_Products_Suppliers(PackageId, ProductSupplierId) " + "Values(@PackageId,@ProductSupplierId)"; int rowsUpdated; SqlConnection connect = TravelExpertsConnection.GetConnection(); using (SqlCommand cmd = new SqlCommand(query, connect)) { cmd.Parameters.AddWithValue("@PackageId", packageProductSupplier.PackageId); cmd.Parameters.AddWithValue("@ProductSupplierId", packageProductSupplier.ProductSupplierId); connect.Open(); rowsUpdated = cmd.ExecuteNonQuery(); connect.Close(); } //no rows updated. if (rowsUpdated == 0) { return(false); } else { return(true); } }
public static PackageProductSupplier Get(PackageProductSupplier packageProductSupplier) { if (Object.Equals(packageProductSupplier, null)) { return(null); } PackageProductSupplier package = null; SqlConnection con = TravelExpertsConnection.GetConnection(); string command = "SELECT PackageId, ProductSupplierId " + "FROM Packages_Products_Suppliers " + "WHERE PackageId = @PackageId " + "AND ProductSupplierId = @ProductSupplierId"; using (SqlCommand cmd = new SqlCommand(command, con)) { con.Open(); cmd.Parameters.AddWithValue("@PackageId", packageProductSupplier.PackageId); cmd.Parameters.AddWithValue("@ProductSupplierId", packageProductSupplier.ProductSupplierId); SqlDataReader read = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (read.Read()) { package = new PackageProductSupplier() { PackageId = (int)read["PackageId"], ProductSupplierId = (int)read["ProductSupplierId"] }; } } // close command return(package); }