public ActionResult Edit(ViewModelFloor Model) { var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Floor" })); } var UserId = Convert.ToInt32(userDetail.user.id); if (ModelState.IsValid) { try { var data = dc.Floors.Where(x => x.FloorId == Model.FloorId && x.IsActive == true).FirstOrDefault(); if (data != null) { data.FloorName = Model.FloorName; data.FloorNumber = Model.FloorNumber; data.Description = Model.Description; data.CreatedBy = UserId; data.UpdatedBy = UserId; data.FloorId = Model.FloorId; data.CreatedDate = DateTime.Now; data.UpdatedDate = DateTime.Now; data.Status = 1; data.IsActive = true; dc.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Update"; _MRMLog.Module = "Floor Update Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Updated Floor having id= " + Model.FloorId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; dc.MRMLogs.Add(_MRMLog); dc.SaveChanges(); TempData["update"] = "doneupdate"; } return(RedirectToAction("Index", "Floor")); } catch { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Floor" })); } } return(View(Model)); }
public ActionResult CreateFloor(ViewModelFloor Model) { var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(RedirectToAction("Index", "Login", new { ReturnUrl = "/Floor" })); } var UserId = Convert.ToInt32(userDetail.user.id); Guid g = Guid.NewGuid(); if (ModelState.IsValid) { Floor fl = new Floor(); fl.FloorName = Model.FloorName; fl.FloorNumber = Model.FloorNumber; fl.Description = Model.Description; fl.CreatedBy = UserId; fl.UpdatedBy = UserId; fl.FloorId = g; fl.IsActive = true; fl.Status = 1; fl.CreatedDate = DateTime.Now; fl.UpdatedDate = DateTime.Now; dc.Floors.Add(fl); dc.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Create"; _MRMLog.Module = "Floor Create Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Create Floor having id= " + g; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; dc.MRMLogs.Add(_MRMLog); dc.SaveChanges(); TempData["create"] = "donecrate"; return(RedirectToAction("Index", "Floor")); } return(View("FloorForm", Model)); }
public bool ActivateFloorReferenceID(Guid Id) { var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(false); } else { var UserId = Convert.ToInt32(userDetail.user.id); RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); // var Roomdata = _db.Rooms.Where(x => x.RoomId == Id && x.IsActive == true && x.Status == 0).ToList(); // var BookRoomdata = _db.BookRooms.Where(x => x.RoomId == Id && x.IsActive == true).ToList(); var floordata = _db.Floors.Where(x => x.FloorId == Id && x.IsActive == true && x.Status == 0).FirstOrDefault(); if (floordata != null) { floordata.Status = 1; floordata.UpdatedBy = UserId; floordata.UpdatedDate = DateTime.Now; _db.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Active"; _MRMLog.Module = "Floor Active Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Active Floor having id= " + floordata.FloorId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); return(true); } else { return(false); } } }
public bool DeleteRoomInfo(Guid Id) { RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); var data = _db.Rooms.Where(x => x.RoomId == Id).FirstOrDefault(); if (data != null) { data.IsActive = false; data.UpdatedDate = DateTime.Now; _db.SaveChanges(); var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(false); } else { var UserId = Convert.ToInt32(userDetail.user.id); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Delete"; _MRMLog.Module = "Floor Delete Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has deleted Room having id= " + data.RoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); return(true); } } else { return(false); } }
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); } }
public bool DeActivateRoomReferenceID(Guid Id) { var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail == null) { return(false); } else { var UserId = Convert.ToInt32(userDetail.user.id); RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); var Roomdata = _db.Rooms.Where(x => x.RoomId == Id && x.IsActive == true).ToList(); var BookRoomdata = _db.BookRooms.Where(x => x.RoomId == Id && x.IsActive == true).ToList(); if (Roomdata != null) { foreach (var item in Roomdata) { if (item.Status == 1) { item.Status = 0; item.UpdatedBy = UserId; item.UpdatedDate = DateTime.Now; _db.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "DeActive"; _MRMLog.Module = "Room DeActive Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has DeActive Room having id= " + item.RoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); } else { item.Status = 1; item.UpdatedBy = UserId; item.UpdatedDate = DateTime.Now; _db.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "Active"; _MRMLog.Module = "Room Active Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Active Room having id= " + item.RoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); } //item.UpdatedBy = UserId; //item.UpdatedDate = DateTime.Now; //_db.SaveChanges(); } } if (BookRoomdata != null) { foreach (var item in BookRoomdata) { item.IsActive = false; item.UpdatedBy = UserId; item.UpdatedDate = DateTime.Now; _db.SaveChanges(); MRMLog _MRMLog = new MRMLog(); _MRMLog.UserId = Convert.ToInt32(UserId); _MRMLog.Action = "DeActive"; _MRMLog.Module = "Room DeActive Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has DeActive BookRoom having id= " + item.BookRoomId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); } return(true); } else { return(false); } } }
public int SaveFloorInfo(ViewModelFloor Model) { RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities(); var userDetail = SessionHelper.GetUserDetailFromSession(); if (userDetail != null) { var UserId = Convert.ToInt32(userDetail.user.id); if (1 == 1) { var data = _db.Floors.Where(x => x.FloorName == Model.FloorName || x.FloorId == Model.FloorId).FirstOrDefault(); if (data == null) { return(0); } else { var datas = _db.Floors.Where(x => x.FloorId == Model.FloorId).FirstOrDefault(); if (datas != null) { datas.FloorName = Model.FloorName; datas.FloorNumber = Model.FloorNumber; datas.Description = Model.Description; datas.Status = Model.Status; 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 = "Floor Update Operation"; _MRMLog.Description = userDetail.user.first_name + "_" + userDetail.user.last_name + " has Updated Floor having id= " + datas.FloorId; _MRMLog.CreatedBy = Convert.ToInt32(UserId); _MRMLog.CraetedDate = DateTime.Now; _db.MRMLogs.Add(_MRMLog); _db.SaveChanges(); } return(1); } } else { var data = _db.Floors.Where(x => x.FloorName == Model.FloorName && x.IsActive == true).FirstOrDefault(); if (data != null) { return(0); } else { Floor _floordata = new Floor(); Guid g = Guid.NewGuid(); _floordata.FloorId = g; _floordata.FloorName = Model.FloorName; _floordata.FloorNumber = Model.FloorNumber; _floordata.Description = Model.Description; _floordata.Status = Model.Status; _floordata.IsActive = true; _floordata.CreatedBy = Convert.ToInt32(UserId); _floordata.UpdatedBy = Convert.ToInt32(UserId); _floordata.CreatedDate = DateTime.Now; _floordata.UpdatedDate = DateTime.Now; _db.Floors.Add(_floordata); _db.SaveChanges(); return(1); } } } else { return(2); } }