public async Task <IActionResult> EditRoom(decimal id, [Bind("RoomId,RoomFloor,RoomStatus,CatId")] TRoom tRoom)
{
SetDashboard(3);
if (id != tRoom.RoomId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
tRoom.RoomStatus = Convert.ToInt16(tRoom.RoomStatus);
_context.Update(tRoom);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!_context.TRooms.Any(e => e.RoomId == id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(ViewRoom)));
}
ViewData["CatId"] = new SelectList(_context.TCategories, "CatId", "CatId", tRoom.CatId);
return(View(tRoom));
}
public IActionResult Index(string c, string n)
{
try
{
if (Request.Query.ContainsKey("c") && Request.Query.ContainsKey("n"))
{
//Console.WriteLine($"{Request.Query["corp"]} {Request.Query["number"]}");
string corp = c; //Request.Query["c"].ToString();
int my_number = int.Parse(n); //int.Parse(Request.Query["number"]);
var info_room = _db.TRoom.FromSqlInterpolated($"SELECT * FROM t_room WHERE pavilion = {corp} AND number_room = {my_number}").ToList(); //pavilion = {corp} AND
TRoom inf = new TRoom();
//inf = db.TRoom ;
inf.IdRoom = info_room[0].IdRoom;
inf.Pavilion = info_room[0].Pavilion;
inf.NumberRoom = info_room[0].NumberRoom;
inf.ShortDesc = info_room[0].ShortDesc;
inf.LongDesc = info_room[0].LongDesc;
inf.PhoneNumber = info_room[0].PhoneNumber;
inf.Email = info_room[0].Email;
return(View(inf));
}
else
{
return(StatusCode(404));
//Response.WriteAsync("Ресурс не найден");
}
}
catch
{
return(StatusCode(404));
}
}
public IActionResult WriteRoom(string Corp, string Number, string ShortDesc, string LongDesc, string Phone, string Email)
{
//var LongDesc = Request.Form["LongDesc"];
TRoom UserEnter = new TRoom();
UserEnter.Pavilion = Corp;
UserEnter.NumberRoom = int.Parse(Number);
UserEnter.ShortDesc = ShortDesc;
UserEnter.LongDesc = LongDesc;
UserEnter.PhoneNumber = Phone;
UserEnter.Email = Email;
int i = 0;
i = _db.Database.ExecuteSqlRaw($"UPDATE t_room SET short_desc = '{UserEnter.ShortDesc}', long_desc = '{UserEnter.LongDesc}', phone_number = '{UserEnter.PhoneNumber}', email = '{UserEnter.Email}' WHERE pavilion = '{UserEnter.Pavilion}' AND number_room = {UserEnter.NumberRoom}");
if (i == 0)
{
_db.Database.ExecuteSqlRaw($"INSERT INTO t_room (pavilion, number_room, short_desc, long_desc, phone_number, email) VALUES('{UserEnter.Pavilion}', {UserEnter.NumberRoom}, '{UserEnter.ShortDesc}', '{UserEnter.LongDesc}', '{UserEnter.PhoneNumber}', '{UserEnter.Email}')");
}
return(Redirect($"~/Home/Qrgen?Corp={Corp}&Number={Number}"));
// }
//catch
// {
// return Redirect($"~/Home/WriteRoom?corp={Corp}&n={Number}");
}
public async static Task <TRoom> Add()
{
var rpository = Game.Scene.GetComponent <RoomRpository>();
var room = new TRoom();
room.SetCreator("Admin");
room.SetUpdater("Admin");
await rpository.DBContext.InsertAsync(room);
return(room);
}
//Remove selected room
public IActionResult RemoveRoom(decimal id)
{
List <TRoom> roomList = JsonConvert.DeserializeObject <List <TRoom> >(HttpContext.Session.GetString("rooms"));
TRoom removeRoom = roomList.FirstOrDefault(x => x.RoomId == id);
if (removeRoom != null)
{
roomList.Remove(removeRoom);
}
HttpContext.Session.SetString("rooms", JsonConvert.SerializeObject(roomList));
return(RedirectToAction("Rooms", new { id = -1 }));
}
public async Task <IActionResult> CreateRoom([Bind("RoomId,RoomFloor,RoomStatus,CatId")] TRoom tRoom)
{
SetDashboard(3);
if (HttpContext.Session.GetString("UType") != "A")
{
TempData["Error"] = "Insufficient login permission";
return(RedirectToAction("Index", "Login"));
}
if (ModelState.IsValid)
{
_context.Add(tRoom);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(ViewRoom)));
}
ViewData["CatId"] = new SelectList(_context.TCategories, "CatId", "CatId", tRoom.CatId);
return(RedirectToAction(nameof(ViewRoom)));
}
//Change out of order to active
public async Task <IActionResult> ActiveRoom(decimal id)
{
SetDashboard(3);
if (HttpContext.Session.GetString("UType") != "A")
{
TempData["Error"] = "Insufficient login permission";
return(RedirectToAction("Index", "Login"));
}
var tRoom = new TRoom()
{
RoomId = id, RoomStatus = 1
};
_context.Entry(tRoom).Property("RoomStatus").IsModified = true;
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(ViewRoom)));
}
public IActionResult WriteRoom(string corp, string n) // изменение или добавление новой комнаты
{
if (corp == null || n == null)
{
TRoom inf0 = new TRoom();
return(View(inf0));
}
var info_room = _db.TRoom.FromSqlInterpolated($"SELECT * FROM t_room WHERE pavilion = {corp} AND number_room = {int.Parse(n)}").ToList(); //pavilion = {corp} AND
TRoom inf = new TRoom();
//inf = db.TRoom ;
inf.IdRoom = info_room[0].IdRoom;
inf.Pavilion = info_room[0].Pavilion;
inf.NumberRoom = info_room[0].NumberRoom;
inf.ShortDesc = info_room[0].ShortDesc;
inf.LongDesc = info_room[0].LongDesc;
inf.PhoneNumber = info_room[0].PhoneNumber;
inf.Email = info_room[0].Email;
return(View(inf));
}
public Passage(TRoom room1, TRoom room2)
{
Room1 = room1;
Room2 = room2;
}
public RoomConfiguration(TRoom room, Vector2Int position, PolygonGrid2D outline)
{
Room = room;
Position = position;
Outline = outline;
}
public IActionResult Table(string corp = "", string number = "") // отображение списка комната + человек (изм 11.02.2020)
{
// FromSqlInterpolated
//var info_room = _db.Database. ExecuteSqlCommand("select tr.pavilion, tr.number_room, tr.short_desc, tr.long_desc, tr.phone_number, tr.email, tp.surname, tp.name1, tp.name2 from t_room tr left join room_person rp on rp.id_room = tr.Id_room left join t_person tp on tp.id_person = rp.id_person").ToList();
var infoDB = from tr in _db.TRoom
join rp in _db.RoomPerson on tr.IdRoom equals rp.IdRoom into RP2
from rp2 in RP2.DefaultIfEmpty()
join tp in _db.TPerson on rp2.IdPerson equals tp.IdPerson into TP2
from tp2 in TP2.DefaultIfEmpty()
select new
{
Id = tr.IdRoom,
Pavilion = tr.Pavilion,
Number = tr.NumberRoom,
ShortDesc = tr.ShortDesc,
LongDesc = tr.LongDesc,
Phone = tr.PhoneNumber,
Email = tr.Email,
//tp2 != null ? tp2.Surname + " " + tp2.Name1 + " " + tp2.Name2 : ""
IdP = tp2.IdPerson,
Surname = tp2.Surname,
Name1 = tp2.Name1,
Name2 = tp2.Name2
};
List <RoomFull> info = new List <RoomFull>();
foreach (var a in infoDB)
{
TRoom r = new TRoom();
r.IdRoom = a.Id;
r.Pavilion = a.Pavilion;
r.NumberRoom = a.Number;
r.ShortDesc = a.ShortDesc; // != null ? {true} : {false}
r.LongDesc = a.LongDesc != null ? a.LongDesc : "";
r.LongDesc = r.LongDesc.Length < 65 ? r.LongDesc : r.LongDesc.Substring(0, 50) + "...";
r.PhoneNumber = a.Phone;
r.Email = a.Email;
string str = "";
if (a.Surname != null)
{
str = a.Surname;
if (a.Name1 != null)
{
str = str + " " + a.Name1.Substring(0, 1) + ".";
if (a.Name2 != null)
{
str = str + " " + a.Name2.Substring(0, 1) + ".";
}
}
}
if (corp != null && corp != "" && corp != r.Pavilion)
{
continue;
}
if (number != null && number != "" && int.Parse(number) != r.NumberRoom)
{
continue;
}
info.Add(new RoomFull()
{
IDPerson = a.IdP,
RoomInfo = r,
PersonInfo = str
});
}
return(View(info));
}
public static void AddActor(TRoom room)
{
Game.Scene.GetComponent <ActorComponentStorage>().AddActor <RoomComponent, TRoom>(room);
}
//View rooms of selected category
public IActionResult Rooms(decimal id = 0, IFormCollection collection = null)
{
DateTime dtFrom;
DateTime dtTo;
string catID;
List <TRoom> roomList = new List <TRoom>();
if (HttpContext.Session.GetInt32("pending") == 1)
{
roomList = JsonConvert.DeserializeObject <List <TRoom> >(HttpContext.Session.GetString("rooms"));
}
if (collection.Count > 0)
{
dtFrom = DateTime.Parse(collection["resFrom"]);
dtTo = DateTime.Parse(collection["resTo"]);
catID = collection["catID"];
HttpContext.Session.SetString("resFrom", dtFrom.ToShortDateString());
HttpContext.Session.SetString("resTo", dtTo.ToShortDateString());
HttpContext.Session.SetString("resCat", catID);
}
else
{
dtFrom = DateTime.Parse(HttpContext.Session.GetString("resFrom"));
dtTo = DateTime.Parse(HttpContext.Session.GetString("resTo"));
catID = HttpContext.Session.GetString("resCat");
var newRoom = new TRoom {
RoomId = id, CatId = catID
};
if (HttpContext.Session.GetInt32("pending") != 1)
{
roomList.Add(newRoom);
HttpContext.Session.SetString("rooms", JsonConvert.SerializeObject(roomList));
HttpContext.Session.SetInt32("pending", 1);
}
else
{
roomList = JsonConvert.DeserializeObject <List <TRoom> >(HttpContext.Session.GetString("rooms"));
if (id != -1)
{
roomList.Add(newRoom);
HttpContext.Session.SetString("rooms", JsonConvert.SerializeObject(roomList));
}
}
}
var tRoom = _context.TRooms
.Where(x => x.CatId == catID.ToString() &&
!_context.TReservationRooms
.Include(res => res.Res)
.Where(res => (res.Res.ResFrom >= dtFrom && res.Res.ResFrom <= dtTo) || (res.Res.ResFrom <= dtFrom && res.Res.ResTo >= dtTo))
.Select(res => res.RoomId)
.Contains(x.RoomId) &&
x.RoomStatus == 1)
.ToList();
foreach (var item in tRoom)
{
item.TRates = _context.TRates.Where(x => x.RoomId == item.RoomId).ToList();
foreach (var item2 in roomList)
{
if (item.RoomId == item2.RoomId)
{
item.RoomStatus = 0;
break;
}
}
}
return(View(tRoom));
}