public DataSet OrderCustomerDetails(int customer_ID)
{
//CustomerssDataAccessDetails customerAccess = new CustomerssDataAccessDetails();
//var datatable = customerAccess.FindCustomerDetails(customer_ID);
InsertIntoCustomerAccess insertIntoCustomer = new InsertIntoCustomerAccess();
var datatable = insertIntoCustomer.InsertCustomers();
//UpdateCustomerAccess updateCustomer = new UpdateCustomerAccess();
//var datatable = updateCustomer.UpdateCustomer();
//OrdersOfCustomerDataAccessDetails orderAccess = new OrdersOfCustomerDataAccessDetails();
//var table = orderAccess.FindOrders(customer_ID);
InsertOrderAccess insertOrder = new InsertOrderAccess();
var table = insertOrder.InsertOrders();
//UpdateCustomerAccess updateCustomer = new UpdateCustomerAccess();
//var table = updateCustomer.UpdateCustomer();
DataSet dataSet = new DataSet();
dataSet.Tables.Add(datatable);
dataSet.Tables.Add(table);
return(dataSet);
}
static void Main(string[] args)
{
Console.WriteLine("Enter Customer_ID to see the details:");
var customer_ID = Convert.ToInt32(Console.ReadLine());
//CustomerssDataAccessDetails customerAccess = new CustomerssDataAccessDetails();
//var datatable = customerAccess.FindCustomerDetails(customer_ID);
InsertIntoCustomerAccess insertIntoCustomer = new InsertIntoCustomerAccess();
var datatable = insertIntoCustomer.InsertCustomers();
//UpdateCustomerAccess updateCustomer = new UpdateCustomerAccess();
//var datatable = updateCustomer.UpdateCustomer();
//OrdersOfCustomerDataAccessDetails orderAccess = new OrdersOfCustomerDataAccessDetails();
//var table = orderAccess.FindOrders(customer_ID);
InsertOrderAccess insertOrder = new InsertOrderAccess();
var table = insertOrder.InsertOrders();
//UpdateCustomerAccess updateCustomer = new UpdateCustomerAccess();
//var table = updateCustomer.UpdateCustomer();
DataSet dataSet = new DataSet();
dataSet.Tables.Add(datatable);
dataSet.Tables.Add(table);
//return dataSet;
//try
//{
// dataSet = new OrderOfCustomerAccessDetails().OrderCustomerDetails(customer_ID);
//}
//catch(Exception ex)
//{
// Console.WriteLine("Error occured."+ex.Message);
//}
//Console.WriteLine("Enter Customer Details:");
//foreach (DataRow dataRow in dataSet.Tables[0].Rows)
//{
// Console.WriteLine(dataRow["Customer_ID"]+"|"+dataRow["Customer_name"]+"|"+dataRow["City"]);
//}
//Console.WriteLine("Enter Order Details:");
//foreach (DataRow dataRow1 in dataSet.Tables[1].Rows)
//{
// Console.WriteLine(dataRow1["Order_No"]+"|"+dataRow1["Purchase_Amount"]+"|"+dataRow1["Customer_ID"]);
//}
}