static void Main(string[] args) { try { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand(@"Data Source=.\sqlexpress;Initial Catalog=CustomerOrderViewer;Integrated Security=True"); IList <CustomerOrderDetailModel> customerOrderDetailModels = customerOrderDetailCommand.GetList(); if (customerOrderDetailModels.Any()) { foreach (CustomerOrderDetailModel customerOrderDetailModel in customerOrderDetailModels) { Console.WriteLine($"{customerOrderDetailModel.CustomerOrderId}:" + $" Fullname: {customerOrderDetailModel.FirstName} {customerOrderDetailModel.LastName }" + $" (Id: {customerOrderDetailModel.CustomerId})" + $"- purchased {customerOrderDetailModel.Description}" + $" for {customerOrderDetailModel.Price}" + $" (Id: {customerOrderDetailModel.ItemId})"); } } } catch (Exception ex) { Console.WriteLine($"Something went wrong: {ex.Message}"); } }
static void Main(string[] args) { try { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand(@"Data Source=laptop-u0351eco\karimsql;Initial Catalog=CustumerOrderViewer;Integrated Security=True"); IList <CustomerOrderDetailModel> customerOrderDetailModels = customerOrderDetailCommand.GetList(); if (customerOrderDetailModels.Any()) { foreach (CustomerOrderDetailModel customerOrderDetailModel in customerOrderDetailModels) { Console.WriteLine("{0}: Fullname: {1} {2} (Id: {3}) - purchased {4} for {5} (Id: {6})", customerOrderDetailModel.CustomerOrderId, customerOrderDetailModel.FirstName, customerOrderDetailModel.LastName, customerOrderDetailModel.CustomerId, customerOrderDetailModel.Description, customerOrderDetailModel.Price, customerOrderDetailModel.ItemId ); } } } catch (Exception ex) { Console.WriteLine("Something went wrong {0}", ex.Message); } }
private static void DisplayCustomerOrders() { IList <CustomerOrderDetailModel> customerOrderDetails = _customerOrderCommand.GetList(); if (customerOrderDetails.Any()) { foreach (CustomerOrderDetailModel c in customerOrderDetails) { Console.WriteLine("{0}: Full Name: {1} {2} (Id: {3}) - purchased {4} for {5} (Id: {6}", c.CustomerOrderId, c.FirstName, c.LastName, c.CustomerId, c.Description, c.Price, c.ItemId); } } }
static void Main(string[] args) { try { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand("Data Source=localhost;Initial Catalog=CustomerOrderViewer;Integrated Security=True"); IList <CustomerOrderDetailModel> customerOrders = customerOrderDetailCommand.GetList(); if (customerOrders.Any()) { foreach (var customerOrder in customerOrders) { Console.WriteLine($"{customerOrder.CustomerOrderId}: FullName: {customerOrder.FirstName} {customerOrder.LastName} (CustomerId: {customerOrder.CustomerId}) - purchased {customerOrder.Description} for {customerOrder.Price} (ItemId: {customerOrder.ItemId})"); } } } catch (Exception ex) { Console.WriteLine($"Something went wrong: {ex.Message}"); } }
static void Main(string[] args) { try { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=CustomerOrderViewer;Integrated Security=True"); IList <CustomerOrderDetailModel> customerOrderDetailModels = customerOrderDetailCommand.GetList(); if (customerOrderDetailModels.Any()) { foreach (var item in customerOrderDetailModels) { Console.WriteLine($"{item.CustomerOrderId}: Fullname: {item.FirstName} {item.LastName} (Id: {item.CustomerId}) - purchased {item.Description} for {item.Price} (Id: {item.ItemId})"); } } } catch (Exception ex) { Console.WriteLine("Something went wrong {0}", ex.Message); } Console.ReadLine(); }
static void Main(string[] args) { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand(); List <CustomerOrderDetailModel> customerOrderDetailModels = new List <CustomerOrderDetailModel>(); try { customerOrderDetailModels = customerOrderDetailCommand.GetList(); if (customerOrderDetailModels.Any()) { foreach (CustomerOrderDetailModel eachRow in customerOrderDetailModels) { Console.WriteLine($" OrderId : {eachRow.OrderId} -- CustomerId: {eachRow.CustomerId} ,Customer : {eachRow.FirstName} {eachRow.LastName}," + $"Product: {eachRow.ProductName}, Price: {eachRow.ListPrice}"); } } } catch (Exception exception) { Console.WriteLine($"Faild : {exception.Message}"); } }
static void Main(string[] args) { CustomerOrderDetailCommand customerOrderDetailCommand = new CustomerOrderDetailCommand(@"Data Source=localhost;Initial Catalog=CustomerOrderViewer;Integrated Security=True"); IList <CustomerOrderDetailModerl> customerOrderDetailModels = customerOrderDetailCommand.GetList(); }