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));
}
