public async Task <List <LabOrderListViewModel> > GetLabOrderList()
{
var result = new List <LabOrderListViewModel>();
//Load List from Context
string con = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
string queryString = "SELECT LO.Id, LO.OrderDate, LO.AmountBilled, LO.AmountCollected, LT.LabTestName FROM LabOrder as LO " +
"LEFT JOIN LabTest as LT ON LO.LabTestId = LT.Id";
DataSet data;
using (SqlConnection connection = new SqlConnection(con))
{
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(queryString, connection);
var rows = await command.ExecuteNonQueryAsync();
data = new DataSet();
adapter.SelectCommand = command;
adapter.Fill(data);
connection.Close();
}
foreach (DataRow row in data.Tables[0].Rows)
{
LabOrderListViewModel laborder = getLabOrderFromDataRow(row);
result.Add(laborder);
}
return(result);
}
private static LabOrderListViewModel getLabOrderFromDataRow(DataRow row)
{
LabOrderListViewModel laborder = new LabOrderListViewModel
{
Id = row.Field <int>("Id"),
OrderDate = row.Field <DateTime>("OrderDate"),
OrderDateDisplay = row.Field <DateTime>("OrderDate").ToShortDateString(),
LabTestName = row.Field <string>("LabTestName"),
AmountBilled = row.Field <decimal>("AmountBilled"),
AmountCollected = row.Field <decimal>("AmountCollected")
};
return(laborder);
}
public async Task <List <LabOrderListViewModel> > GetLabOrderList()
{
var result = new List <LabOrderListViewModel>();
//Load List from Context
var labOrders = db.LabOrders.OrderByDescending(l => l.OrderDate).ToList();
foreach (var labOrder in labOrders)
{
var lo = new LabOrderListViewModel();
lo.Id = labOrder.Id;
lo.OrderDate = labOrder.OrderDate;
lo.OrderDateDisplay = labOrder.OrderDate.ToString("M/d/yy");
lo.LabTestName = labOrder.LabTest.LabTestName;
lo.AmountBilled = labOrder.AmountBilled;
lo.AmountCollected = labOrder.AmountCollected;
result.Add(lo);
}
return(await Task.FromResult(result));
}
