public static OrderStructureModel LoadOneOrderStructure2(int id) { //create SQL Query string sqlHeader = @" SELECT dbo.[Order].* , dbo.[Client].UserName AS ClientName, dbo.[Store].StoreName, dbo.[Employee].UserName AS EmployeeName FROM (((dbo.[Order] INNER JOIN dbo.[Client] ON dbo.[Order].ClientId = dbo.[Client].ClientId) INNER JOIN dbo.[Store] ON dbo.[Order].StoreId = dbo.[Store].StoreId) INNER JOIN dbo.[Employee] ON dbo.[Order].EmployeeId = dbo.[Employee].EmployeeId ) WHERE dbo.[Order].OrderId = @id ;"; string sqlBody = @" SELECT dbo.[OrderLine].*, dbo.[Part].PartName, dbo.[Service].ServiceName FROM ((dbo.[OrderLine] INNER JOIN dbo.[Part] ON dbo.[OrderLine].PartId = dbo.[Part].PartId) INNER JOIN dbo.[Service] ON dbo.[OrderLine].ServiceId = dbo.[Service].ServiceId) WHERE OrderId = @id;"; var orderHeader = SqlDataAccess.LoadOne <OrderModel>(sqlHeader, id); var orderBody = SqlDataAccess.LoadData <OrderLineModel>(sqlBody, id); var order = new OrderStructureModel { OrderHeading = orderHeader, OrderBody = orderBody }; return(order); }
public static OrderStructureModel LoadOneOrderStructure(int id) { //create SQL Query string sqlHeader = @"SELECT * FROM dbo.[Order] WHERE OrderId = @id;"; string sqlBody = @"SELECT * FROM dbo.[OrderLine] WHERE OrderId = @id;"; var orderHeader = SqlDataAccess.LoadOne <OrderModel>(sqlHeader, id); var orderBody = SqlDataAccess.LoadData <OrderLineModel>(sqlBody, id); var order = new OrderStructureModel { OrderHeading = orderHeader, OrderBody = orderBody }; return(order); }