Esempio n. 1
0
        public ActionResult Details(int id)
        {
            DataClasses1DataContext db = new DataClasses1DataContext();

            OrderAndServies         orderservies = new OrderAndServies();
            List <ListServiesModif> listServies  = new List <ListServiesModif>();


            /*
             * List<list_add_services> servies = new List<list_add_services>();
             *
             * //var order = db.Orders.Where(item => item.Id_order == id);
             * var order = db.ExecuteQuery<Order>(@"SELECT * FROM Orders WHERE Id_order = " + id + ";");
             * Order ddd = order.First();
             */

            var ttt = db.ExecuteQuery <OrderModific>(@"SELECT [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "'  AND Orders.id_client = Client.Id_client;").ToList <OrderModific>().First();

            //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)),	CAST([list_add_services].[id_order] AS NVARCHAR(100)),	CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY  CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();

            //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)),	CAST([list_add_services].[id_order] AS NVARCHAR(100)),	CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY  CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();

            //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT [list_add_services].[Id_list_add_services], [list_add_services].[id_order],	CAST([type_servies].[name] AS NVARCHAR(100)) AS 'name' FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "' GROUP BY [list_add_services].[Id_list_add_services],	[list_add_services].[Id_order],	CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();

            /*
             * orderservies.order = ttt;
             * orderservies.ListServirecs = listServies;
             */
            return(View(orderservies));
        }
        public ActionResult Details(int id)
        {
            /*
             * DataClasses1DataContext db = new DataClasses1DataContext();
             *
             * OrderAndServies orderservies = new OrderAndServies();
             * List<ListServiesModif> listServies = new List<ListServiesModif>();
             *
             * //var ttt = db.ExecuteQuery<OrderModific>(@"SELECT [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Orders].[payment], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "'  AND Orders.id_client = Client.Id_client;").ToList<OrderModific>().First();
             * var ttt = db.ExecuteQuery<OrderModific>(@"SELECT [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Orders].[payment], [Orders].[BigPrice], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "'  AND Orders.id_client = Client.Id_client").ToList<OrderModific>().First();
             *
             *
             * listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT [list_add_services].[Id_list_add_services], [list_add_services].[id_order], CAST([type_servies].[name] AS NVARCHAR(100)) AS 'name' FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "' GROUP BY [list_add_services].[Id_list_add_services],	[list_add_services].[Id_order],	CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();
             * //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT [list_add_services].[Id_list_add_services], [list_add_services].[id_order], CAST([type_servies].[name] AS NVARCHAR(100)) AS 'name' FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "' GROUP BY [list_add_services].[Id_list_add_services],	[list_add_services].[Id_order],	CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();
             *
             *
             * orderservies.order = ttt;
             * orderservies.list = listServies;
             *
             */

            DataClasses1DataContext db = new DataClasses1DataContext();

            OrderAndServies orderservies = new OrderAndServies();

            var order = db.ExecuteQuery <OrderModific>(@"SELECT [Orders].[id_client], [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Orders].[payment], [Orders].[BigPrice], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "'  AND Orders.id_client = Client.Id_client").ToList <OrderModific>().First();
            List <list_add_serviecsModific> listServies = FromDB <list_add_serviecsModific>(@"SELECT [list_add_services].*, [type_servies].[name] AS name_servies FROM [list_add_services], [type_servies] WHERE [list_add_services].[id_order] = " + id + " AND [list_add_services].id_servies = [type_servies].[Id_servies] ");
            //List<list_number> listNumber = FromDB<list_number>(@"SELECT * FROM [list_number] WHERE [list_number].[id_order] = " + id);

            //List<list_numberModifc> listNumber = FromDB<list_numberModifc>(@"SELECT [type_number].[name] AS 'number_room', [list_number].[settlement_date], [list_number].[eviction_date], [type_pool].[type] AS 'type_room', [list_number].[price] FROM [list_number], [type_pool], [type_number] WHERE [list_number].[id_order] = " + id + " AND [list_number].[id_number_room] = [type_number].[id_number] AND [list_number].[id_type_room] = [type_pool].Id_pool GROUP BY [type_number].[name], [list_number].[settlement_date], [list_number].[eviction_date], [type_pool].[type], [list_number].[price]");
            List <list_numberModifc> listNumber = FromDB <list_numberModifc>(@"SELECT CAST([type_number].[name] AS NVARCHAR(MAX)) AS 'number_room', [list_number].[settlement_date], [list_number].[eviction_date], CAST([type_pool].[type] AS NVARCHAR(MAX)) AS 'type_room', CAST([nametyperoom].[name] AS NVARCHAR(MAX)) AS 'col_in_room', CAST([list_number].[price] AS NVARCHAR(MAX)) AS 'price' FROM [list_number], [type_pool], [type_number], [nametyperoom] WHERE [list_number].[id_order] =  " + id + "  AND [list_number].[id_number_room] = [type_number].[id_number] AND [list_number].[id_type_room] = [type_pool].Id_pool AND [list_number].[id_col_in_room] = [nametyperoom].[Id] GROUP BY CAST([type_number].[name] AS NVARCHAR(MAX)), [list_number].[settlement_date], [list_number].[eviction_date], CAST([type_pool].[type] AS NVARCHAR(MAX)), CAST([nametyperoom].[name] AS NVARCHAR(MAX)), CAST([list_number].[price] AS NVARCHAR(MAX))");

            orderservies.order         = order;
            orderservies.ListServirecs = listServies;
            orderservies.ListNumber    = listNumber;

            return(View(orderservies));
        }