public ActionResult Create()
{
ComplexModelClientAndServies list = new ComplexModelClientAndServies();
list.ListClient = FromDB <Client>(@"SELECT [Client].[id_client], [Client].[FIO] FROM [Client]");;
return(View(list));
}
//
// GET: /Room/
public ActionResult ListRoom()
{
ComplexModelClientAndServies list = new ComplexModelClientAndServies();
//List<TypeNumberModifString> roomFromDB = FromDB<TypeNumberModifString>(@"SELECT [type_number].[Id_number] AS nn, [type_number].[name], [type_number].[col], [type_pool].[type], [type_number].[Free] FROM [type_number], [type_pool] WHERE [type_number].[id_pool] = [type_pool].[Id_pool]");
List <TypeNumberModifString> roomFromDB = FromDB <TypeNumberModifString>(@"SELECT [type_number].[Id_number] AS nn, [type_number].[name], [type_number].[col], [type_pool].[type], [type_number].[Free] FROM [type_number], [type_pool] WHERE [type_number].[id_pool] = [type_pool].[Id_pool]");
return(View(roomFromDB));
}
private ComplexModelClientAndServies UpDateData()
{
ComplexModelClientAndServies BigList = new ComplexModelClientAndServies();
return(BigList);
}
//public ActionResult ProcessingOrder(OrderAcceptModif order, int? IdOrder111 )
public ActionResult ProcessingOrder(OrderServiesModific order, int?IdOrder111)
{
ViewBag.IdOrder = IdOrder111;
ComplexModelClientAndServies list = new ComplexModelClientAndServies();
/*
* List<Client> clientFromDB = FromDBClient(@"SELECT [Client].[id_client], [Client].[FIO] FROM [Client]");
* List<type_servies> TypeServiesFromDB = FromDBListTypeServiecs(@"SELECT * FROM [type_servies]");
*/
List <Client> clientFromDB = FromDB <Client>(@"SELECT [Client].[id_client], [Client].[FIO] FROM [Client]");
ViewBag.Name_client = (from p in clientFromDB where p.Id_client == order.Id_client select p.FIO).First();
List <type_servies> TypeServiesFromDB = FromDB <type_servies>(@"SELECT * FROM [type_servies]");
//1
List <type_pool> TypePoolFromDB = FromDB <type_pool>(@"SELECT * FROM [type_pool]");
//2
List <nametyperoom> NameTypeRoomFromDB = FromDB <nametyperoom>(@"SELECT * FROM [nametyperoom]");
ViewBag.IdOrder = IdOrder111;
//if(IdOrder111 == null) IdOrder111 = order.if
//Список подзаказов номеров
//List<list_number> listNumberOrder = FromDB<list_number>(@"SELECT * FROM [list_number] WHERE [list_number].[id_order] = " + IdOrder111);
//List<list_numberModifc> listNumberOrder = 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] = " + ViewBag.IdOrder + " 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> listNumberOrder = 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)), CAST([list_number].[price] AS NVARCHAR(MAX)) FROM [list_number], [type_pool], [type_number], [nametyperoom] WHERE [list_number].[id_order] = " + ViewBag.IdOrder + " 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))");
List <list_numberModifc> listNumberOrder = 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] = " + IdOrder111 + " 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))");
//Список услугов
//List<list_add_services> listAddServiesOrder = FromDB<list_add_services>(@"SELECT * FROM [list_add_services] WHERE [list_add_services].[id_order] = " + IdOrder111);
List <list_add_serviecsModific> listAddServiesOrder = 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] = " + IdOrder111 + " AND [list_add_services].id_servies = [type_servies].[Id_servies] ");
list.ListClient = clientFromDB;
list.ListTypePool = TypePoolFromDB;
list.ListNameTypeRoom = NameTypeRoomFromDB;
list.ListTypeServies = TypeServiesFromDB;
list.llll = listNumberOrder;
list.add_llll = listAddServiesOrder;
if (order.Id_client != null)
{
ViewBag.flagTypeRoom = true;
ViewBag.Id_client = order.Id_client;
ViewBag.Name_client = (from p in clientFromDB where p.Id_client == order.Id_client select p.FIO).First();
}
if (order.Id_pool != null)
{
ViewBag.flagColMest = true;
ViewBag.Id_pool = order.Id_pool;
}
if (order.Id != null)
{
ViewBag.flagNumber = true;
ViewBag.Id = order.Id;
//3
//List<type_number> NumberFromDB = FromDBNumber<type_number>(@"SELECT * FROM [type_number] WHERE [type_number].[id_pool] = " + Id);
//List<type_number> NumberFromDB = FromDB<type_number>(@"SELECT * FROM [type_number] WHERE [type_number].[id_pool] = " + order.Id_pool + " AND [type_number].[col]=" + order.Id);
List <type_number> NumberFromDB = FromDB <type_number>(@"SELECT * FROM [type_number] WHERE [type_number].[id_pool] = " + order.Id_pool + " AND [type_number].[col]=" + order.Id + " AND [type_number].[Free] = '1'");
list.ListNumber = NumberFromDB;
//return View("Create", list);
}
if (order.Id_number != null)
{
/*
* ViewBag.flagCol = true;
* ViewBag.Col = order.col;
*/
ViewBag.flagDateBegin = true;
ViewBag.Begin = order.begin_date;
}
/*
* if (order.col != null)
* {
* ViewBag.flagBegin = true;
* ViewBag.Begin = order.begin_date;
* }
*/
if (order.begin_date != null)
{
/*
* ViewBag.flagDateBegin = true;
* ViewBag.DateBegin = order.begin_date;
*/
ViewBag.flagTimeBegin = true;
ViewBag.TimeBegin = order.begin_date.Value.TimeOfDay;
}
if (order.begin_time != null)
{
ViewBag.flagDateEnd = true;
ViewBag.DateEnd = order.end_date;
order.begin_date = new DateTime(order.begin_date.Value.Year, order.begin_date.Value.Month, order.begin_date.Value.Day, order.begin_time.Value.Hour, order.begin_time.Value.Minute, order.begin_time.Value.Second);
}
if (order.end_date != null)
{
ViewBag.flagTimeEnd = true;
ViewBag.TimeEnd = order.end_time;
}
int price;
int tariff;
if (order.end_time != null)
{
order.end_date = new DateTime(order.end_date.Value.Year, order.end_date.Value.Month, order.end_date.Value.Day, order.end_time.Value.Hour, order.end_time.Value.Minute, order.end_time.Value.Second);
//Тип комнаты
var ddd333 = Type_Room.Where(el => el.Id_pool == order.Id_pool).FirstOrDefault();
tariff = Convert.ToInt32(ddd333.tariff);
var fff = Type_Room;
{ }
//Количество человека
//Дней
DateTime data1 = Convert.ToDateTime(order.begin_date);
DateTime data2 = Convert.ToDateTime(order.end_date);
if (data2 > data1)
{
order.begin_date = data2;
order.end_date = data1;
}
var date5 = data2 - data1;
int day = date5.Days;
if (day == 0)
{
day = 1;
}
// int day = order.end_date - order.begin_date;
ViewBag.flagPrice = true;
ViewBag.Price = tariff * day;
order.price = tariff * day;
ViewBag.flagSmallButton = true;
}
// приянть подзаказы
if (Request.Form["submitbutton21"] != null)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var item = new list_number()
{
id_order = Convert.ToInt32(IdOrder111),
id_type_room = Convert.ToInt32(order.Id_pool),
id_col_in_room = Convert.ToInt32(order.Id),
id_number_room = Convert.ToInt32(order.Id_number),
settlement_date = Convert.ToDateTime(order.begin_date),
eviction_date = Convert.ToDateTime(order.end_date),
price = Convert.ToInt32(order.price)
};
{ }
db.list_number.InsertOnSubmit(item);
db.SubmitChanges();
type_number item22 = db.type_number.Single(e => e.Id_number == order.Id_number);
//if (item22.Free) item22.Free = false;
var item2 = new type_number()
{
id_pool = order.Id_number,
Free = !item22.Free
};
//!!****!!!! db.SubmitChanges();
{ }
//ViewBag.flagTypeRoom = false;
ViewBag.flagColMest = false;
ViewBag.flagNumber = false;
ViewBag.flagCol = false;
ViewBag.flagDateBegin = false;
ViewBag.flagTimeBegin = false;
ViewBag.flagDateEnd = false;
ViewBag.flagTimeEnd = false;
ViewBag.flagPrice = false;
ViewBag.flagSmallButton = false;
//ViewBag.Id_client = null;
//ViewBag.Name_client = null;
ViewBag.Id_pool = null;
ViewBag.Id_number = null;
ViewBag.Col = null;
ViewBag.DateBegin = null;
ViewBag.TimeBegin = null;
ViewBag.DateEnd = null;
ViewBag.TimeEnd = null;
ViewBag.Price = null;
//listNumberOrder = 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] = " + IdOrder111 + " 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]");
//listNumberOrder = 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)), CAST([list_number].[price] AS NVARCHAR(MAX)) AS 'price' FROM [list_number], [type_pool], [type_number], [nametyperoom] WHERE [list_number].[id_order] = " + IdOrder111 + " 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))");
listNumberOrder = 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] = " + IdOrder111 + " 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))");
list.llll = listNumberOrder;
//Список услугов
//listAddServiesOrder = FromDB<list_add_services>(@"SELECT * FROM [list_add_services] WHERE [list_add_services].[id_order] = " + IdOrder111);
listAddServiesOrder = 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] = " + IdOrder111 + " AND [list_add_services].id_servies = [type_servies].[Id_servies] ");
list.add_llll = listAddServiesOrder;
//order = null;
order.Id_pool = null;
order.Id = null;
order.Id_number = null;
ViewBag.Titles = " --- Виберите --- ";
int priceAllOrder = FromDBOne(@"SELECT SUM([list_number].[price]) FROM [list_number] WHERE [list_number].[id_order] =" + IdOrder111);
int priceAllServiecs = FromDBOne(@"SELECT SUM([list_add_services].[price]) FROM [list_add_services] WHERE [list_add_services].[id_order] = " + IdOrder111);
list.BigPrice = priceAllOrder + priceAllServiecs;
ViewBag.BigPrice = priceAllOrder + priceAllServiecs;
return(View("Create", list));
}
//принять дпо. услуги
if (order.id_servies != null)
{
ViewBag.flagServiesDate = true;
ViewBag.IDServies = order.id_servies;
}
if (order.dateUse != null)
{
ViewBag.flagTimeUse = true;
ViewBag.dateUse = order.dateUse;
}
if (order.timeUse != null)
{
ViewBag.flagColUse = true;
ViewBag.timeUse = order.timeUse;
order.dateUse = new DateTime(order.dateUse.Value.Year, order.dateUse.Value.Month, order.dateUse.Value.Day, order.timeUse.Value.Hour, order.timeUse.Value.Minute, order.timeUse.Value.Second);
}
if (order.colServ != null)
{
ViewBag.flagPriceServies = true;
ViewBag.flagServiesButton = true;
ViewBag.ColUse = order.colServ;
var ttt = list.ListTypeServies;
// var ddd333 = Type_Room.Where(el => el.Id_pool == order.Id_pool).FirstOrDefault();
var temp = ttt.Where(el => el.Id_servies == order.id_servies).FirstOrDefault();
int tarrif = Convert.ToInt32(temp.tariff);
order.priceServies = order.colServ * tarrif;
ViewBag.PriceServies = order.priceServies;
}
// полній заказ с услугами
if (Request.Form["submitbuttonServies"] != null)
{
var fff = order;
DataClasses1DataContext db = new DataClasses1DataContext();
//DateTime dtm = new DateTime(order.dateUse.Value.Year, order.dateUse.Value.Month, order.dateUse.Value.Day, order.timeUse.Value.Hour, order.timeUse.Value.Minute, order.timeUse.Value.Second);
list_add_services item = new list_add_services()
{
id_order = Convert.ToInt32(IdOrder111),
id_servies = Convert.ToInt32(order.id_servies),
DateUse = Convert.ToDateTime(order.dateUse),
col = order.colServ,
price = order.priceServies
};
{ }
db.list_add_services.InsertOnSubmit(item);
db.SubmitChanges();
ViewBag.flagServiesDate = false;
ViewBag.flagTimeUse = false;
ViewBag.flagColUse = false;
ViewBag.flagPriceServies = false;
ViewBag.flagServiesButton = false;
ViewBag.IDServies = null;
ViewBag.ServiesDate = null;
ViewBag.TimeUse = null;
ViewBag.ColUse = null;
ViewBag.PriceServies = null;
list.add_llll = 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] = " + ViewBag.IdOrder + " AND [list_add_services].id_servies = [type_servies].[Id_servies] ");;
//return View("Index");
order.id_servies = null;
int priceAllOrder = FromDBOne(@"SELECT SUM([list_number].[price]) FROM [list_number] WHERE [list_number].[id_order] =" + IdOrder111);
int priceAllServiecs = FromDBOne(@"SELECT SUM([list_add_services].[price]) FROM [list_add_services] WHERE [list_add_services].[id_order] = " + IdOrder111);
list.BigPrice = priceAllOrder + priceAllServiecs;
ViewBag.BigPrice = priceAllOrder + priceAllServiecs;
}
{ }
if (Request.Form["submitbuttonBigOrder"] != null)
{
int BigPrice = list.BigPrice;
DataClasses1DataContext db = new DataClasses1DataContext();
List <DateTime> trempDateTime = new List <DateTime>();
if (list.llll.Count != 0)
{
foreach (var item in list.llll)
{
trempDateTime.Add(item.settlement_date);
trempDateTime.Add(item.eviction_date);
}
DateTime minDate = DateTime.MaxValue;
DateTime maxDate = DateTime.MinValue;
foreach (DateTime dateString in trempDateTime)
{
DateTime date = dateString;
if (date < minDate)
{
minDate = date;
}
if (date > maxDate)
{
maxDate = date;
}
}
int priceAllOrder = FromDBOne(@"SELECT SUM([list_number].[price]) FROM [list_number] WHERE [list_number].[id_order] =" + IdOrder111);
int priceAllServiecs = FromDBOne(@"SELECT SUM([list_add_services].[price]) FROM [list_add_services] WHERE [list_add_services].[id_order] = " + IdOrder111);
//list.BigPrice = priceAllOrder + priceAllServiecs;
int bigPriceeee = priceAllOrder + priceAllServiecs;
Orders item22 = db.Orders.Single(e => e.Id_order == IdOrder111);
item22.payment = order.payment;
item22.begin = minDate;
item22.end = maxDate;
item22.BigPrice = bigPriceeee;
}
else
{
Orders item22 = db.Orders.Single(e => e.Id_order == IdOrder111);
item22.begin = null;
item22.end = null;
}
db.SubmitChanges();
db = new DataClasses1DataContext();
List <Order> orders = new List <Order>();
List <list_add_services> servies = new List <list_add_services>();
orders = db.ExecuteQuery <Order>(@"SELECT * FROM Orders").ToList <Order>();
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_client = Client.Id_client;").ToList <OrderModific>();
//return View("ShowOrder", ttt);
return(Redirect("/Home/Index"));
}
return(View("Create", list));
}
public ActionResult ChoiceClient(int Id_client)
{
int Id_client111 = Id_client;
var date = DateTime.Now;
{ }
//Создание новый заказ
DataClasses1DataContext db = new DataClasses1DataContext();
Orders item = new Orders()
{
id_client = Convert.ToInt32(Id_client111),
date = DateTime.Now,
Done = false,
Hide = false
};
db.Orders.InsertOnSubmit(item);
db.SubmitChanges();
List <Orders> fff = FromDB <Orders>(@"SELECT [Orders].[Id_order] FROM [Orders]");
string fff222 = fff.Select(it => it.Id_order).Max().ToString();
ViewBag.IdOrder = fff222;
ViewBag.flagTypeRoom = true;
ViewBag.Id_client = Id_client111;
ComplexModelClientAndServies list = new ComplexModelClientAndServies();
/*
* List<Client> clientFromDB = FromDBClient(@"SELECT [Client].[id_client], [Client].[FIO] FROM [Client]");
* List<type_servies> TypeServiesFromDB = FromDBListTypeServiecs(@"SELECT * FROM [type_servies]");
*/
List <Client> clientFromDB = FromDB <Client>(@"SELECT [Client].[id_client], [Client].[FIO] FROM [Client]");
ViewBag.Name_client = (from p in clientFromDB where p.Id_client == Id_client111 select p.FIO).First();
List <type_servies> TypeServiesFromDB = FromDB <type_servies>(@"SELECT * FROM [type_servies]");
//1
List <type_pool> TypePoolFromDB = FromDB <type_pool>(@"SELECT * FROM [type_pool]");
;
//2
List <nametyperoom> NameTypeRoomFromDB = FromDB <nametyperoom>(@"SELECT * FROM [nametyperoom]");
//Список подзаказов номеров
//List<list_number> listNumberOrder = FromDB<list_number>(@"SELECT * FROM [list_number] WHERE [list_number].[id_order] = " + ViewBag.IdOrder);
//List<list_numberModifc> listNumberOrder = 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] = " + ViewBag.IdOrder + " 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> listNumberOrder = 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] = " + ViewBag.IdOrder + " 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))");
//Список услугов
//List<list_add_services> listAddServiesOrder = FromDB<list_add_services>(@"SELECT * FROM [list_add_services] WHERE [list_add_services].[id_order] = " + ViewBag.IdOrder);
List <list_add_serviecsModific> listAddServiesOrder = 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] = '" + ViewBag.IdOrder + "' AND [list_add_services].[id_servies] = [type_servies].[Id_servies] ");
list.ListClient = clientFromDB;
list.ListTypePool = TypePoolFromDB;
list.ListNameTypeRoom = NameTypeRoomFromDB;
list.ListTypeServies = TypeServiesFromDB;
list.llll = listNumberOrder;
list.add_llll = listAddServiesOrder;
return(View("Create", list));
}
