public ActionResult Create(ViewModelRoom Model) { try { ViewBag.RoomtypeListVB = dc.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.FloorListVB = dc.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList(); ModelState.Clear(); return(View(Model)); } catch (Exception ex) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); } }
public ViewModelRoom GetRoomDetailsById(Guid Id) { ViewModelRoom model = new ViewModelRoom(); RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); List <ViewModelRoomPictureMapping> ListPicture = new List <ViewModelRoomPictureMapping>(); var picturedata = _db.RoomPictureMappings.Where(x => x.RoomId == Id).ToList(); var data = _db.Rooms.Where(x => x.RoomId == Id && x.IsActive == true).FirstOrDefault(); if (data != null) { model.DId = data.DId; model.RoomId = data.RoomId; model.FloorId = data.FloorId; model.RoomTypeId = data.RoomTypeId; model.RoomName = data.RoomName; model.RoomNumber = (int)data.RoomNumber; model.Description = data.Description; model.Capacity = data.Capacity; if (data.MinCapacity != null) { model.MinCapacity = (int)data.MinCapacity; } if (data.MaxCapacity != null) { model.MaxCapacity = (int)data.MaxCapacity; } model.Status = (int)data.Status; if (picturedata.Count > 0) { var comCount = 0; foreach (var item in picturedata) { ViewModelRoomPictureMapping cm = new ViewModelRoomPictureMapping(); comCount++; cm.RoomPictureMappingId = item.RoomPictureMappingId; cm.ActualFileName = item.ActualFileName; cm.DId = item.DId; cm.count = comCount; cm.RoomId = item.RoomId; cm.FileName = item.FileName; cm.Extension = item.Extension; ListPicture.Add(cm); } } model.RoomPictureMappingsList = ListPicture; } return(model); }
public List <ViewModelRoom> GetAllRoomList() { List <ViewModelRoom> Model = new List <ViewModelRoom>(); RoomMeetingManagementDbEntities dc = new RoomMeetingManagementDbEntities(); var data = dc.Rooms.Where(x => x.IsActive == true).OrderByDescending(x => x.DId).ToList(); if (data.Count > 0) { var count = 0; foreach (var item in data) { ViewModelRoom model = new ViewModelRoom(); count++; model.Count = count; model.DId = item.DId; model.RoomId = item.RoomId; model.FloorId = item.RoomId; model.RoomTypeId = item.RoomTypeId; model.RoomName = item.RoomName; model.Capacity = item.Capacity; var floordetails = getfloor_ListValueById((Guid)item.FloorId); var Roomtypedetails = getRoomtype_ListValueById((Guid)item.RoomTypeId); if (item.MinCapacity != null) { model.MinCapacity = (int)item.MinCapacity; } if (item.MaxCapacity != null) { model.MaxCapacity = (int)item.MaxCapacity; } if (floordetails != null) { model.Floor = floordetails.FloorName; } if (Roomtypedetails != null) { model.Roomtype = Roomtypedetails.RoomtypeName; } model.Status = (int)item.Status; model.Description = item.Description; model.CreatedBy = (int)item.CreatedBy; model.UpdatedBy = (int)item.UpdatedBy; model.CreatedDate = (DateTime)item.CreatedDate; model.UpdatedDate = (DateTime)item.UpdatedDate; Model.Add(model); } } return(Model); }
public ActionResult Edit(Guid id) { try { if (id == null) { return(null); } ViewModelRoom Room = _RoomMethods.GetRoomDetailsById(id); // ViewModelRoom Room = dc.Rooms.Include(s => s.RoomPictureMappings).SingleOrDefault(x => x.RoomId == id); ViewBag.RoomtypeListVB = dc.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.FloorListVB = dc.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList(); if (Room == null) { return(HttpNotFound()); } return(View("RoomForm", Room)); } catch { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); } }
public ActionResult Edit(ViewModelRoom Model) { try { if (Model.MinCapacity > Model.MaxCapacity) { ViewBag.RoomtypeListVB = dc.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.FloorListVB = dc.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.MinMax = "MinMax"; return(View("RoomForm", Model)); } var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); } var UserId = Convert.ToInt32(userDetail.user.id); if (ModelState.IsValid) { //New Files for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { RoomPictureMapping rpc = new RoomPictureMapping(); var ActualfileName = Path.GetFileName(file.FileName); var FileTime = DateTime.Now.ToFileTime(); string fileName = Path.GetFileNameWithoutExtension(file.FileName) + "_" + FileTime + Path.GetExtension(file.FileName); rpc.FileName = fileName; rpc.ActualFileName = ActualfileName; rpc.Extension = Path.GetExtension(fileName); rpc.RoomPictureMappingId = Guid.NewGuid(); rpc.RoomId = Model.RoomId; rpc.CreatedDate = DateTime.Now; rpc.UpdatedDate = DateTime.Now; rpc.CreatedBy = UserId; rpc.UpdatedBy = UserId; dc.RoomPictureMappings.Add(rpc); dc.SaveChanges(); var path = Path.Combine(Server.MapPath("~/Rotativa/RoomImage/"), Path.GetFileNameWithoutExtension(file.FileName) + "_" + FileTime + Path.GetExtension(file.FileName)); file.SaveAs(path); } } var data = dc.Rooms.Where(x => x.RoomId == Model.RoomId).FirstOrDefault(); if (data != null) { data.FloorId = Model.FloorId; data.RoomTypeId = Model.RoomTypeId; data.RoomName = Model.RoomName; data.RoomNumber = (int)Model.RoomNumber; data.Description = Model.Description; data.Capacity = Model.Capacity; data.MinCapacity = Model.MinCapacity; data.MaxCapacity = Model.MaxCapacity; data.UpdatedBy = UserId; data.UpdatedDate = DateTime.Now; Model.Status = 1; Model.IsActive = true; TempData["update"] = "doneupdate"; dc.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Update"; _MRMLog.Module = "Room Update Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Updated Room having id= " + Model.RoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; dc.MRMLogs.Add(_MRMLog); dc.SaveChanges(); } return(RedirectToAction("Index", "Rooms")); } return(View("Roomform", Model)); } catch (Exception ex) { string filePath = Server.MapPath("~/Rotativa/Bug/Error.txt"); using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); writer.WriteLine("InnerException : " + ex.InnerException); ex = ex.InnerException; } } return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); }; }
public ActionResult CreateRoom(ViewModelRoom Model) { try { if (Model.MinCapacity > Model.MaxCapacity) { ViewBag.RoomtypeListVB = dc.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.FloorListVB = dc.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.MinMax = "MinMax"; return(View("Create", Model)); } var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); } ObjectParameter returnId = new ObjectParameter("Exists", typeof(int)); var exist = dc.IsExistRooms(Model.RoomName, Model.RoomNumber, returnId).ToList(); int Roomexist = Convert.ToInt32(returnId.Value); if (Roomexist == 0) { var UserId = Convert.ToInt32(userDetail.user.id); Guid g = Guid.NewGuid(); if (ModelState.IsValid) { List <ViewModelRoomPictureMapping> fileDetails = new List <ViewModelRoomPictureMapping>(); for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { RoomPictureMapping rpc = new RoomPictureMapping(); var ActualfileName = Path.GetFileName(file.FileName); var FileTime = DateTime.Now.ToFileTime(); string fileName = Path.GetFileNameWithoutExtension(file.FileName) + "_" + FileTime + Path.GetExtension(file.FileName); rpc.FileName = fileName; rpc.ActualFileName = ActualfileName; rpc.Extension = Path.GetExtension(fileName); rpc.RoomPictureMappingId = Guid.NewGuid(); rpc.RoomId = g; rpc.CreatedDate = DateTime.Now; rpc.UpdatedDate = DateTime.Now; rpc.CreatedBy = UserId; rpc.UpdatedBy = UserId; dc.RoomPictureMappings.Add(rpc); dc.SaveChanges(); var path = Path.Combine(Server.MapPath("~/Rotativa/RoomImage/"), Path.GetFileNameWithoutExtension(file.FileName) + "_" + FileTime + Path.GetExtension(file.FileName)); file.SaveAs(path); } } Room rm = new Room(); rm.RoomId = g; rm.IsActive = true; rm.Status = 1; rm.CreatedDate = DateTime.Now; rm.UpdatedDate = DateTime.Now; rm.FloorId = Model.FloorId; rm.RoomTypeId = Model.RoomTypeId; rm.Capacity = Model.Capacity; rm.MinCapacity = Model.MinCapacity; rm.MaxCapacity = Model.MaxCapacity; rm.RoomNumber = Model.RoomNumber; rm.RoomName = Model.RoomName; rm.Description = Model.Description; rm.CreatedBy = UserId; rm.UpdatedBy = UserId; dc.Rooms.Add(rm); dc.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Create"; _MRMLog.Module = "Room Create Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Create Room having id= " + g; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; dc.MRMLogs.Add(_MRMLog); dc.SaveChanges(); TempData["create"] = "donecrate"; return(RedirectToAction("Index", "Rooms")); } return(View("Create", Model)); } else { ViewBag.RoomtypeListVB = dc.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList(); ViewBag.FloorListVB = dc.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList(); Model.IsExist = true; ViewBag.IsExistRoom = 1; return(View("Create", Model)); } } catch (Exception ex) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Rooms" })); } }
public int SaveRoomInfo(ViewModelRoom Model) { RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(3); } var UserId = Convert.ToInt32(userDetail.user.id); if (userDetail != null) { if (1 == 1) { var data = _db.Rooms.Where(x => x.RoomName == Model.RoomName || x.RoomId == Model.RoomId).FirstOrDefault(); if (data == null) { return(0); } else { var datas = _db.Rooms.Where(x => x.RoomId == Model.RoomId).FirstOrDefault(); if (datas != null) { datas.RoomName = Model.RoomName; datas.Description = Model.Description; datas.Status = Model.Status; datas.Capacity = Model.Capacity; datas.MinCapacity = (int)Model.MinCapacity; datas.MaxCapacity = (int)Model.MaxCapacity; datas.CreatedBy = Model.CreatedBy; datas.UpdatedBy = Convert.ToInt32(UserId); datas.UpdatedDate = DateTime.Now; _db.SaveChanges();//update MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Update"; _MRMLog.Module = "Room Update Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Updated Room having id= " + datas.RoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); } return(1); } } else { var data = _db.Rooms.Where(x => x.RoomName == Model.RoomName && x.IsActive == true).FirstOrDefault(); if (data != null) { return(0); } else { Room _Roomdata = new Room(); Guid g = Guid.NewGuid(); _Roomdata.RoomId = g; _Roomdata.RoomName = Model.RoomName; _Roomdata.Description = Model.Description; _Roomdata.Status = Model.Status; _Roomdata.IsActive = true; _Roomdata.Capacity = Model.Capacity; _Roomdata.MinCapacity = (int)Model.MinCapacity; _Roomdata.MaxCapacity = (int)Model.MaxCapacity; _Roomdata.CreatedBy = Convert.ToInt32(UserId); _Roomdata.UpdatedBy = Convert.ToInt32(UserId); _Roomdata.CreatedDate = DateTime.Now; _Roomdata.UpdatedDate = DateTime.Now; _db.Rooms.Add(_Roomdata); _db.SaveChanges(); return(1); } } } else { return(2); } }