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