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); }