//I am still in the processing of finishing this method public static List<ReturnReceiptProductList> GetReceiptProductList(int rid) { List<ReturnReceiptProductList> productList = new List<ReturnReceiptProductList>(); ReturnReceiptProductList returnReceipt = new ReturnReceiptProductList(); using (SqlConnection connection = ConnectionString.GetSqlConnection()) { string sqlList = "SELECT * FROM OrdersList WHERE ReceiptId = @rid"; using (SqlCommand cmdList = new SqlCommand(sqlList, connection)) { cmdList.Parameters.AddWithValue("@rid", rid); connection.Open(); using (SqlDataReader reader = cmdList.ExecuteReader()) { if (reader != null) { while (reader.Read()) { Product product = new Product(); Receipt receipt = new Receipt(); receipt.ReceiptID = Convert.ToInt32(reader["ReceiptId"].ToString()); receipt.UserId = Convert.ToInt32(reader["UserId"].ToString()); product.ProductId = Convert.ToInt32(reader["ProductId"].ToString()); product.ProductName = reader["ProductName"].ToString(); product.ProductQuantity = Convert.ToInt32(reader["ProductQuantity"].ToString()); product.ProductPrice = Convert.ToDecimal(reader["ProductPrice"].ToString()); product.ProductTax = Convert.ToDecimal(reader["ProductTax"].ToString()); } } } } } } public class ReturnReceiptProductList { //Returning the values to link Product & Receipt. public Product Product { get; set; } public Receipt Receipt { get; set; } public ReturnReceiptProductList() { } public ReturnReceiptProductList(Product p, Receipt r) { Product = p; Receipt = r; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)