public List <ViewModelFloor> GetAllFloorList()
{
List <ViewModelFloor> Model = new List <ViewModelFloor>();
RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities();
var data = _db.Floors.Where(x => x.IsActive == true).OrderByDescending(x => x.DId).ToList();
if (data.Count > 0)
{
var count = 0;
foreach (var item in data)
{
ViewModelFloor model = new ViewModelFloor();
count++;
model.Count = count;
model.DId = item.DId;
model.FloorId = item.FloorId;
model.FloorName = item.FloorName;
model.Description = item.Description;
model.Status = (int)item.Status;
model.CreatedBy = (int)item.CreatedBy;
model.UpdatedBy = (int)item.UpdatedBy;
model.CreatedDate = item.CreatedDate;
model.UpdatedDate = item.UpdatedDate;
Model.Add(model);
}
}
return(Model);
}
public ActionResult Index(ViewModelCalendarRoomDetail Model)
{
try
{
RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities();
ViewBag.RoomtypeListVB = _db.RoomTypes.Where(x => x.IsActive == true && x.Status == 1).ToList();
ViewBag.FloorListVB = _db.Floors.Where(x => x.IsActive == true && x.Status == 1).ToList();
ViewBag.StatusMsg = TempData["StatusMsg"];
return(View());
}
catch (Exception ex)
{
string filePath = Server.MapPath("~/Rotativa/Bug/Error.txt");// @"D:\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(View());
}
public JsonResult GetEvents()
{
ViewModelCalendar model = new ViewModelCalendar();
using (RoomMeetingManagementDbEntities dc = new RoomMeetingManagementDbEntities())
{
var caldetail = CM.calendardetailtomodel();
var rows2 = caldetail.ToList();
return(new JsonResult {
Data = rows2, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public bool checkRoomReferenceID(Guid Id)
{
RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities();
var data = _db.BookRooms.Where(x => x.RoomId == Id && x.IsActive == true).ToList();
if (data.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
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 ViewModelFloor GetFloorDetailsById(Guid Id)
{
ViewModelFloor model = new ViewModelFloor();
RoomMeetingManagementDbEntities _db = new RoomMeetingManagementDbEntities();
var data = _db.Floors.Where(x => x.FloorId == Id && x.IsActive == true).FirstOrDefault();
if (data != null)
{
// model.Count = 1;
model.DId = data.DId;
model.FloorId = data.FloorId;
model.FloorName = data.FloorName;
model.FloorNumber = data.FloorNumber;
model.Description = data.Description;
model.Status = (int)data.Status;
//model.IsEdit = 1;
}
return(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 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);
}
}
