class ProductDB { // Get the connection string from an external file public stat

Question

class ProductDB
{

// Get the connection string from an external file
public static string ConnectionString()
{
return File.ReadAllText(@"....DBConnStr.txt", Encoding.UTF8);
}

// Get a connection to DB
public static OleDbConnection GetConnection()
{
// Declare a connection and initialze to null
OleDbConnection conn = null;

// Declare string and call method to get connection string from file
string connStr = File.ReadAllText(@"....DBConnStr.txt", Encoding.UTF8);
conn = new OleDbConnection(connStr);

// Show connection string in message box
// MessageBox.Show(connStr); // For debugging

// Instantiate connection

// Return connection
return conn;
}

// Get a list of all Products from DB
public static List<Product> GetProducts()
{
// Declare a List of Product and initialize to null pointer
List<Product> pl = null;
using (ProductsDB = new ProductDB())
{
List<Product> products = db.Products.where(x => x.ProductTypeID == ProductTypeId).toList()
return products;
}
// Declare and get connection

// Declare a string to contain the sql statement
string sqlStr = "";

// Show sql string in message box
MessageBox.Show(sqlStr); // For debugging

// Declare and instantiate a command
  

// Read all Products from DB in try-catch block
// Try
  
// Instantiate List of Product
  
// Open connection
  
// Execute the command reader
  
// Loop to get all records and copy to List of Product
  
// Instantiate Product with constructor, passing data from reader
  
// Add Product to List of Product
  
// Catch
  
// Catch exception
// MessageBox.Show("Exception: " + ex.ToString());
// Set List of Product to null pointer
  
// Finally
  
// If connection not null close it
  
// Return Products List
return pl;
}

The first task is to complete the Product hierarchy, which only has two simple classes. The Product class contains an int ID, ring Type, st Name and double Price. Write these as auto-implemented ring properties to decrease coding. Product has two constructors: one that accepts a fields (copies all fields from parameters to class fields) and another that accepts a Product (copies the data from the parameter Product to this Product). The Hoagie class inherits the Product class and has three Boolean fields to record lettuce, tomato or onion on a Hoagie Product. Again, write as auto-implemented properties There are also two constructors: one that accepts all Product and Hoagie fields (passes Product fields to Product and copies the Hoagie fields to this Hoagie) a another that accepts a Product and the Hoagie fields (The Product parameter is passed to the Product constructor that accepts a Product and copies the Hoagie fields to this Hoagie). The class diagrams are below properties ID Properties Name Price Lettuce Type Tomato Methods Methods Product (-1 overload Hoagie 1 overload) Task 1: Write Product hierarchy 1. Write Product class as described above a. Write the auto-implemented properties b. Write the constructors 2. Write Hoagie class as described above a. Write the auto-implemented properties b. Write the constructors 3. Declare Product List (name it pl) and Product (name it p) identifiers at top of frmMain 4. Check for and fix any errors indicated by .Net

Explanation / Answer

Task 1:

Question 1:

class Product
{
public int Id { get; set; }
public string Type { get; set; }
public string Name { get; set; }
public double Price { get; set; }

public void Product(int id, string Type, string Name, double price)
{
this.Id = id;
this.Type = Type;
this.Name = Name;
this.Price = price;
}

public void Product(Product p)
{   
this.Id = p.Id;
this.Type = p.Type;
this.Name = p.Name;
this.Price = p.Price;
}

}

Question 2:

class Hoagie : Product
{
public string lettuce { get; set; }
public string tomato { get; set; }
public string onion { get; set; }

public void Hoagie(int id, string Type, string Name, double price,string Lettuce,string Tomato,string Onion)
{
this.Id = id;
this.Type = Type;
this.Name = Name;
this.Price = price;
this.lettuce = Lettuce;
this.tomato = Tomato;
this.onion = Onion;
}

public void Hoagie(Product p, string Lettuce, string Tomato, string Onion)
{
this.Id = p.Id;
this.Type = p.Type;
this.Name = p.Name;
this.Price = p.Price;
this.lettuce = Lettuce;
this.tomato = Tomato;
this.onion = Onion;
}
}

Question 3:

// Declare these two below identifiers in main method

Product p = new Product();
List<Product> pl = new List<Product>();

Question 4: Sorry for this I need entire .cs code.

Note : I just created according your requirement. You need to integrate in your program carefully

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.