public IActionResult Index(int id = 1)
{
ABCReportModel model = new ABCReportModel();
//string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=ABC;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
return(View(model));
}
public IActionResult Index(int id = 1)
{
_connection.Open();
ABCReportModel model = new ABCReportModel();
System.Data.SqlClient.SqlCommand command = _connection.CreateCommand();
command.CommandText = "SP_OrderReport";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@orderID", id);
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(command);
System.Data.DataSet dataSet = new System.Data.DataSet();
adapter.Fill(dataSet);
model.OrderID = (int)dataSet.Tables[0].Rows[0][0];
model.DateOrdered = (DateTime)dataSet.Tables[0].Rows[0][1];
model.PhoneNumbers = new string[dataSet.Tables[1].Rows.Count];
for (int i = 0; i < dataSet.Tables[1].Rows.Count; i++)
{
model.PhoneNumbers[i] = (string)dataSet.Tables[1].Rows[i][0];
}
model.LineItems = new ABCReportModelLineItem[dataSet.Tables[2].Rows.Count];
for (int i = 0; i < dataSet.Tables[2].Rows.Count; i++)
{
model.LineItems[i] = new ABCReportModelLineItem
{
ProductCode = (string)dataSet.Tables[2].Rows[i][0]
};
}
//Do your work
_connection.Close();
return(View(model));
}
