public static List <Card> LoadCardByUserId(string userId) { List <Card> cards = new List <Card>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.CardDetailQuery("Q", userId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["cardId"].ToString(); string CardNo = dr["cardNo"].ToString(); Card card = new Card(Id, CardNo); cards.Add(card); } return(cards); } catch (Exception ex) { return(null); } }
public List <AccessLevel> GetAccessLevels() { List <AccessLevel> accessLevels = new List <AccessLevel>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelQry("Q", id, name); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string id = dr["accessLevelID"].ToString(); string name = dr["accessLevelName"].ToString(); List <Door> doors = Door.GetDoorsByACSLevel(id); List <Schedule> schedules = Schedule.GetSchedulesByACSLevel(id); AccessLevel accessLevel = new AccessLevel(id, name, doors, schedules); accessLevels.Add(accessLevel); } return(accessLevels); } catch (Exception ex) { return(accessLevels); } }
public static List <Door> GetDoorsByACSLevel(string accessLevelId) { List <Door> doors = new List <Door>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelDQry("D", accessLevelId); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["doorId"].ToString(); string Name = dr["doorName"].ToString(); string deviceId = dr["deviceId"].ToString(); int readerNo = Convert.ToInt32(dr["readerNumber"]); int inputNo = Convert.ToInt32(dr["inputNumber"]); int outputNo = Convert.ToInt32(dr["outputNumber"]); int relayNo = Convert.ToInt32(dr["relayNumber"]); Device device = Device.GetDeviceByDoorId(Id); Door door = new Door(Id, Name, readerNo, inputNo, outputNo, readerNo, device); doors.Add(door); } return(doors); } catch (Exception ex) { return(doors); } }
public static List <User> GetUsersByGroup(string groupId) { List <User> users = new List <User>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupUserDetailQuery("Q", groupId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["userId"].ToString(); string Name = dr["personName"].ToString(); List <Card> cards = Card.LoadCardByUserId(Id); User user = new User(Id, Name, cards); users.Add(user); } return(users); } catch (Exception ex) { return(users); } }
public static Device GetDeviceByDoorId(string doorId) { Device device = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DoorQuery("D", doorId, "", ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string id = dr["deviceId"].ToString(); string name = dr["deviceName"].ToString(); string ip = dr["deviceIP"].ToString(); device = new Device(id, name, ip); } return(device); } catch (Exception ex) { return(device); } }
public List <Device> GetDevices() { List <Device> devices = new List <Device>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DeviceQuery("Q", id, name, ip); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string id = dr["deviceId"].ToString(); string name = dr["deviceName"].ToString(); string ip = dr["deviceIP"].ToString(); Device device = new Device(id, name, ip); devices.Add(device); } return(devices); } catch (Exception ex) { return(devices); } }
public List <GroupUser> GetUserGroup() { List <GroupUser> groupUsers = new List <GroupUser>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupUserQuery("Q", Id, name); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string groupId = dr["groupId"].ToString(); string groupName = dr["groupName"].ToString(); users = User.GetUsersByGroup(groupId); GroupUser groupUser = new GroupUser(groupId, groupName, users); groupUsers.Add(groupUser); } return(groupUsers); } catch (Exception ex) { return(groupUsers); } }
public static List <Period> GetPeriodsBySchedule(string ScheduleId) { List <Period> periods = new List <Period>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.PeriodQuery("Q", ScheduleId); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["DayInWeek"].ToString(); DateTime startTime = Convert.ToDateTime(dr["StartTime"].ToString()); DateTime endTime = Convert.ToDateTime(dr["EndTime"].ToString()); Period period = new Period(Id, startTime, endTime); periods.Add(period); } return(periods); } catch (Exception ex) { return(periods); } }
public List <Schedule> GetSchedule() { List <Schedule> schedules = new List <Schedule>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.ScheduleQry("Q", scheduleId, scheduleName); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["scheduleId"].ToString(); string Name = dr["scheduleName"].ToString(); string description = dr["description"].ToString(); List <Period> periods = Period.GetPeriodsBySchedule(Id); Schedule schedule = new Schedule(Id, Name, description, periods); schedules.Add(schedule); } return(schedules); } catch (Exception ex) { return(schedules); } }
public string AddEvent() { string result = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.EventSave("A", eventId, eventDate, device, functionCode, cardNo, doorId, status); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(result); } }