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 OrderLineModel LoadOneOrderLine(int id)
{
//create SQL Query
string sql = @"SELECT *
FROM dbo.[OrderLine]
WHERE OrderLineId = @id;";
return SqlDataAccess.LoadOne<OrderLineModel>(sql, id);
}
public static StoreModel LoadOneStore(int id)
{
// Create SQL Query
string sql = @"SELECT *
FROM dbo.[Store]
WHERE StoreId = @id;";
return(SqlDataAccess.LoadOne <StoreModel>(sql, id));
}
public static PartModel LoadOnePart(int id)
{
//create SQL Query
string sql = @"SELECT *
FROM dbo.[Part]
WHERE PartId = @id;";
return(SqlDataAccess.LoadOne <PartModel>(sql, id));
}
public static EmployeeModel LoadOneEmployee(int id)
{
//create SQL Query
string sql = @"SELECT *
FROM dbo.[Employee]
WHERE EmployeeId = @id;";
return(SqlDataAccess.LoadOne <EmployeeModel>(sql, id));
}
public static ClientModel LoadOneClient(int id)
{
//Create SQL Query
string sql = @"SELECT *
FROM dbo.[Client]
WHERE ClientId = @id;";
//load the data access to call the client data
return(SqlDataAccess.LoadOne <ClientModel>(sql, id));
}
//Methodto load data
public static BugModel LoadOneBug(int id)
{
//create the sql command
string sql = @"SELECT Id, Description, Status, Details, PriorityLevel, BugProjectId
FROM dbo.Bug
WHERE Id = @id";
//call the sql data access to load the project data
return(SqlDataAccess.LoadOne <BugModel>(sql, id)); // the <ProjectModel> is used to specify the type
}
//Methodto load data
public static TagsModel LoadOneTag(int id)
{
//create the sql command
string sql = @"SELECT Id, TagDescription, TagType
FROM dbo.Tags
WHERE Id = @id";
//call the sql data access to load the Tags data
return(SqlDataAccess.LoadOne <TagsModel>(sql, id)); // the <TagsModel> is used to specify the type
}
//Methodto load data
public static ProjectModel LoadOneProject(int id)
{
//create the sql command
string sql = @"SELECT Id, Name, Description, DeadLine
FROM dbo.Project
WHERE Id = @id";
//call the sql data access to load the project data
return(SqlDataAccess.LoadOne <ProjectModel>(sql, id)); // the <ProjectModel> is used to specify the type
}
//Methodto load data
public static UserModel LoadOneUser(int id)
{
//create the sql command
string sql = @"SELECT Id, UserName, FirstName, LastName
FROM dbo.[User]
WHERE Id = @id";
//call the sql data access to load the User data
return(SqlDataAccess.LoadOne <UserModel>(sql, id)); // the <UserModel> is used to specify the type
}
public static OrderModel LoadOneOrder(int id)
{
//create SQL Query
string sqlHeader = @"SELECT *
FROM dbo.[Order]
WHERE OrderId = @id;";
var orderHeader = SqlDataAccess.LoadOne <OrderModel>(sqlHeader, id);
return(orderHeader);
}
public static OrderLineModel LoadOneLine(int id)
{
string sqlBody = @"
SELECT dbo.[OrderLine].*, dbo.[Part].PartName, dbo.[Service].ServiceName
FROM ((dbo.[OrderLine]
LEFT OUTER JOIN dbo.[Part] ON dbo.[OrderLine].PartId = dbo.[Part].PartId)
LEFT OUTER JOIN dbo.[Service] ON dbo.[OrderLine].ServiceId = dbo.[Service].ServiceId)
WHERE dbo.[OrderLine].OrderLineId = @id;";
var orderBody = SqlDataAccess.LoadOne <OrderLineModel>(sqlBody, id);
return(orderBody);
}
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);
}
public static Order2Model LoadOneOrder2(int id)
{
//create SQL Query
string sqlHeader = @"
SELECT dbo.[Order].OrderId, dbo.[Client].UserName AS ClientName,
dbo.[Store].StoreName,
dbo.[Employee].UserName AS EmployeeName,
dbo.[Order].OrderTime, dbo.[Order].OrderType,
dbo.[Order].Specifications, dbo.[Order].[Description],
dbo.[Order].[Location], dbo.[Order].[Status],
dbo.[OrderLine].OrderLineId,
dbo.[OrderLine].PartId, dbo.[OrderLine].ServiceId,
dbo.[OrderLine].[LineNo], dbo.[OrderLine].LineDescription,
dbo.[OrderLine].ServiceQty, dbo.[OrderLine].PartQty,
dbo.[OrderLine].[Status], dbo.[OrderLine].OrderNotes
FROM ((((dbo.[ORDER] LEFT OUTER dbo.[ORDERLINE] ON dbo.[ORDER].OrderId = dbo.[ORDERLINE].Order) LEFT OUTER dbo.[Client] ON dbo.[Order].ClientId = dbo.[Client].ClientId) LEFT OUTER dbo.[Store] ON dbo.[ORDER].StoreId = dbo.[Store].StoreId) LEFT OUTER dbo.[Employee] ON dbo.[ORDER].EmployeeId = dbo.[Employee].EmployeeId)
WHERE dbo.[ORDER].OrderId = @id ";
var orderHeader = SqlDataAccess.LoadOne <Order2Model>(sqlHeader, id);
return(orderHeader);
}
