public byte[] GetRommList() { try { string strConnection = ConfigurationManager.ConnectionStrings["DigiLock"].ConnectionString; OleDbConnection objConnection = new OleDbConnection(strConnection); objConnection.Open();//打开连接 OleDbCommand odCommand = objConnection.CreateCommand(); odCommand.CommandText = "SELECT ROOMNO,STATE,CARDQTY FROM ROOMLIST"; OleDbDataReader reader = odCommand.ExecuteReader(); List <RoomListModel> Roomlistmodel = new List <RoomListModel>(); using (reader) { while (reader.Read()) { RoomListModel mRoom = new RoomListModel(); mRoom.State = dbh.ToString(reader["STATE"]); mRoom.RoomNo = reader["RoomNo"].ToString().Substring(1, 3); mRoom.CardQTY = dbh.ToInt32(reader["CARDQTY"]); Roomlistmodel.Add(mRoom); } reader.Close(); } objConnection.Close(); return(cmn.SerializeObject(Roomlistmodel)); } catch (Exception err) { throw err; } }
/// <summary> /// Get All Room /// </summary> /// <param name="roomList"></param> /// <returns></returns> public RoomListModel GetAllRooms(RoomListModel roomList) { RoomListModel roomListModel = new RoomListModel(); try { var room = this.context?.Rooms.Where(x => x.TenantId == roomList.TenantId && x.SchoolId == roomList.SchoolId && x.IsActive == true).OrderBy(x => x.SortOrder).ToList(); roomListModel.TableroomList = room; roomListModel._tenantName = roomList._tenantName; roomListModel._token = roomList._token; if (room.Count > 0) { roomListModel._failure = false; } else { roomListModel._failure = true; roomListModel._message = NORECORDFOUND; } } catch (Exception es) { roomListModel._message = es.Message; roomListModel._failure = true; roomListModel._tenantName = roomList._tenantName; roomListModel._token = roomList._token; } return(roomListModel); }
public ActionResult <RoomListModel> GetAllRoom(RoomListModel room) { RoomListModel roomList = new RoomListModel(); try { if (room.SchoolId > 0) { roomList = _roomRegisterService.GetAllRoom(room); } else { roomList._token = room._token; roomList._tenantName = room._tenantName; roomList._failure = true; roomList._message = "Please enter valid school id"; } } catch (Exception es) { roomList._message = es.Message; roomList._failure = true; } return(roomList); }
private RoomListModel PrepareCoolAppListModel(RoomListModel model, List <Room> rooms) { foreach (var c in rooms) { RoomModel ccm = new RoomModel(); ccm = PrepareRoomModel(ccm, c); model.Items.Add(ccm); } return(model); }
public ActionResult LoadTable() { var draw = Request.Form["draw"].FirstOrDefault(); var start = Convert.ToInt32(Request.Form["start"].FirstOrDefault()); var length = Convert.ToInt32(Request.Form["length"].FirstOrDefault()); string search = Request.Form["search[value]"][0]; //Get Sort columns value var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault(); var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault(); long totalRecords = 0; var coolApps = _roomService.SearchRoom(companyId, out totalRecords, start, length, search, sortColumn, sortColumnDir == "asc"); //GetUserAddresses(user.Id, out totalRecords, start, length, search, sortColumn, sortColumnDir == "asc"); RoomListModel model = new RoomListModel(); model = PrepareCoolAppListModel(model, coolApps); return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = model.Items })); }
/// <summary> /// Get All Room /// </summary> /// <param name="roomList"></param> /// <returns></returns> public RoomListModel GetAllRoom(RoomListModel roomList) { RoomListModel roomlListModel = new RoomListModel(); try { if (TokenManager.CheckToken(roomList._tenantName + roomList._userName, roomList._token)) { roomlListModel = this.roomRepository.GetAllRooms(roomList); } else { roomlListModel._failure = true; roomlListModel._message = TOKENINVALID; } } catch (Exception es) { roomlListModel._failure = true; roomlListModel._message = es.Message; } return(roomlListModel); }
public ActionResult Index() { RoomListModel model = new RoomListModel(); return(View(model)); }