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