/// <summary> /// Get access level by Id /// </summary> /// <param name="accessLvId">ID of access level need get</param> /// <returns>one access level object</returns> public static AccessLevel LoadAccessLevelById(string accessLvId) { AccessLevel accessLevel = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelQry("Q", accessLvId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["accessLevelID"].ToString(); string Name = dr["accessLevelName"].ToString(); List <Door> doors = GetDoors(Id); List <Schedule> schedules = GetSchedules(Id); accessLevel = new AccessLevel(Id, Name, doors, schedules); } return(accessLevel); } catch { return(null); } }
public static List <OperatorLevel> GetAllOptLevel() { List <OperatorLevel> operatorLevels = new List <OperatorLevel>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.OperatorQuery("Q", "", "", ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["optLevelid"].ToString(); string Name = dr["optLevelName"].ToString(); OperatorLevel operatorLevel = new OperatorLevel(Id, Name); operatorLevels.Add(operatorLevel); } return(operatorLevels); } catch (Exception ex) { return(operatorLevels); } }
/// <summary> /// Get user group from DB /// </summary> /// <param name="groupId">ID of user group need get</param> /// <returns>One group user object</returns> public static GroupUser LoadGroupUserById(string groupId) { DataTable dt = null; GroupUser groupUser = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupUserQuery("Q", groupId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["groupId"].ToString(); string groupName = dr["groupName"].ToString(); List <Users> listUsers = Users.LoadUsersByGroup(groupId); groupUser = new GroupUser(groupId, groupName, listUsers); } return(groupUser); } catch (Exception ex) { return(null); } }
/// <summary> /// Get all schedules in DB /// </summary> /// <returns>List of scheduls in DB</returns> public static List <Schedule> LoadAllSchedule() { List <Schedule> schedules = new List <Schedule>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.ScheduleQry("Q", "", ""); 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(); Schedule schedule = new Schedule(Id, Name, description); schedules.Add(schedule); } return(schedules); } catch (Exception ex) { return(schedules); } }
/// <summary> /// Get door by Id /// </summary> /// <param name="doorId">ID of door need get</param> /// <returns>one door object</returns> public static Door LoadDoorById(string doorId) { Door door = new Door(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DoorQuery("Q", doorId, "", ""); 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(); Device device = Device.LoadDeviceById(deviceId); string rNumber = dr["readerNumber"].ToString(); string iNumber = dr["inputNumber"].ToString(); string oNumber = dr["outputNumber"].ToString(); string reNumber = dr["relayNumber"].ToString(); door = new Door(Id, Name, device, rNumber, iNumber, oNumber, reNumber); } return(door); } catch (Exception ex) { return(null); } }
public static List <Card> LoadAllCard() { List <Card> cards = new List <Card>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.CardDetailQuery("Q", "", ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string cardNo = dr["cardNo"].ToString(); string cardId = dr["cardId"].ToString(); Card c = new Card(cardId, cardNo); cards.Add(c); } return(cards); } catch (Exception ex) { return(cards); } return(cards); }
/// <summary> /// Add access level /// </summary> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string Add(string creator) { string result = "OK"; DataTable dt = null; try { //Add aclv master ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelSave("A", groupId, GroupName, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); //Add schedule of aclv foreach (Schedule s in listSchedule) { result = AddSchedule(groupId, s.ScheduleId, creator); } //Add door of aclv foreach (Door d in listDoor) { result = AddSchedule(groupId, d.DoorId, creator); } return(result); } catch (Exception ex) { return(string.Format("Access level class - Add: {0}", ex.ToString())); } }
/// <summary> /// Get access group base on group id from DB /// </summary> /// <returns>one group access object</returns> public static GroupAccess GetAccessGroupById(string groupId) { GroupAccess groupAccesses = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessQuery("Q", groupId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["groupId"].ToString(); string Name = dr["groupName"].ToString(); string description = dr["groupDescription"].ToString(); //Get user in group List <Users> users = Users.LoadUsersByACGroup(Id); //Get Guser in group List <GroupUser> groupUsers = GroupUser.LoadUserGroupByACGroup(Id); //Get Access Lv in group List <AccessLevel> accessLevels = AccessLevel.LoadAccessLevelByACGroup(Id); groupAccesses = new GroupAccess(Id, Name, description, accessLevels, users, groupUsers); } return(groupAccesses); } catch (Exception ex) { return(null); } }
/// <summary> /// Get attendance of each person by date /// </summary> /// <param name="attendanceDate">date need to get attendance data</param> /// <returns>List of event</returns> public static List <Event> LoadAttendance(DateTime attendanceDate) { List <Event> events = new List <Event>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AttendanceQuery("A", attendanceDate); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { DateTime eDate = Convert.ToDateTime(dr["eventDate"].ToString()); string dName = dr["deviceName"].ToString(); string dIP = dr["device"].ToString(); string ePerson = dr["personName"].ToString(); string eCardNo = dr["cardNo"].ToString(); string eDoorName = dr["doorName"].ToString(); string eStatus = dr["status"].ToString(); string eGroup = dr["company"].ToString(); Event e = new Event(eDate, dName, dIP, ePerson, eCardNo, eDoorName, eStatus, eGroup); events.Add(e); } return(events); } catch (Exception ex) { return(events); } }
/// <summary> /// Get event with conditions /// </summary> /// <param name="SDate">start time</param> /// <param name="EDate">end time</param> /// <param name="CardNo">card no</param> /// <returns>List of events</returns> public static List <Event> LoadEventFilter(string SDate, string EDate, string CardNo) { List <Event> events = new List <Event>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.EventQry("Q", "", CardNo, SDate, EDate); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { DateTime eDate = Convert.ToDateTime(dr["eventDate"].ToString()); string dName = dr["deviceName"].ToString(); string dIP = dr["device"].ToString(); string ePerson = dr["personName"].ToString(); string eCardNo = dr["cardNo"].ToString(); string eDoorName = dr["doorName"].ToString(); string eStatus = dr["status"].ToString(); Event e = new Event(eDate, dName, dIP, ePerson, eCardNo, eDoorName, eStatus); events.Add(e); } return(events); } catch (Exception ex) { return(null); } }
/// <summary> /// Get device by device id from DB /// </summary> /// <param name="deviceId">Id of device need get</param> /// <returns>One device object</returns> public static Device LoadDeviceById(string deviceId) { Device device = new Device(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DeviceQuery("Q", deviceId, "", ""); 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(null); } }
/// <summary> /// Get all device info from DB /// </summary> /// <returns>List of device</returns> public static List <Device> LoadAllDevices() { List <Device> devices = new List <Device>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DeviceQuery("Q", "", "", ""); 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(null); } }
/// <summary> /// Update user info in DB /// </summary> /// <param name="groupUser">group user id include user</param> /// <param name="groupAccess">group access id include user</param> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string Update(string groupUser, string groupAccess, string creator) { string result = "OK"; DataTable dt = null; try { //Update user master ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.UserSave("U", id, optLevel, userName, passWord, name, avatar, email, phoneNo, status, startDate, experiedDate, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); if (result == "OK") { //Delete user in old group user GroupUser group = new GroupUser("", ""); result = group.DeleteUser(id, creator); if (result == "OK") { //Add user to user group GroupUser group1 = new GroupUser(groupUser, ""); result = group1.AddUser(id, creator); if (result == "OK") { //Delete user in old access group GroupAccess accessGroup = new GroupAccess("", ""); result = accessGroup.DeleteUser(id, creator); if (result == "OK") { //Add user to access group GroupAccess accessGroup1 = new GroupAccess(groupAccess, ""); result = accessGroup1.AddUser(id, creator); if (result == "OK") { //Add card foreach (Card c in listCard) { result = c.Add(creator); result = c.AddUser(id, creator); } } } } } } return(result); } catch (Exception ex) { return(string.Format("User class - Update: {0}", ex.ToString())); } }
/// <summary> /// Get user from DB by user id /// </summary> /// <param name="id">ID of user need get</param> /// <returns>one user object</returns> public static Users LoadUsersById(string id) { Users users = null; DataTable dt = null; byte[] avatar = null; DateTime start = DateTime.Today; DateTime end = DateTime.Today; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.UserQuery("Q", id, "", ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["userId"].ToString(); string Name = dr["personName"].ToString(); string userName = dr["userName"].ToString(); string passWord = dr["password"].ToString(); string email = dr["email"].ToString(); string phoneNo = dr["phoneNo"].ToString(); bool status = Convert.ToBoolean(dr["status"]); string optLevel = dr["optLevel"].ToString(); string s = dr["avatar"].ToString(); if (s != "") { avatar = (byte[])dr["avatar"]; } string sStart = dr["startDate"].ToString(); if (sStart != "") { start = Convert.ToDateTime(sStart); } string sEnd = dr["experiedDate"].ToString(); if (sEnd != "") { end = Convert.ToDateTime(sEnd); } List <Card> cards = Card.LoadCardByUserId(Id); users = new Users(Id, Name, userName, passWord, email, phoneNo, status, optLevel, cards, avatar, start, end); } return(users); } catch (Exception ex) { return(null); } }
/// <summary> /// Get login history /// </summary> /// <param name="sDate">start time</param> /// <param name="eDate">end time</param> /// <returns></returns> public static DataTable LoadLogin(DateTime sDate, DateTime eDate) { DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.LoginQuery("Q", sDate, eDate); dt = ds.Tables[0]; return(dt); } catch (Exception ex) { return(dt); } }
/// <summary> /// statistic event from first of month to end of month /// </summary> /// <param name="SDate">start time</param> /// <param name="EDate">end time</param> /// <returns>Data set have 3 table :DENY, GRANTED, NOT_DEFINED</returns> public static DataSet LoadEventByMonth(string SDate, string EDate) { List <Event> events = new List <Event>(); DataSet ds = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); ds = client.EventQry("M", "", "", SDate, EDate); return(ds); } catch (Exception ex) { return(null); } }
/// <summary> /// Get schdule by schedule ID /// </summary> /// <param name="scheduleId">ID of schedule need get</param> /// <returns>One schedule object</returns> public static Schedule LoadScheduleById(string scheduleId) { Schedule schedule = new Schedule(); List <Period> periods = new List <Period>(); DataTable dt = null; DataTable dt1 = NewMethod(); try { //Get schedule master ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.ScheduleQry("Q", scheduleId, ""); 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(); schedule = new Schedule(Id, Name, description); } //Get periods in schedule ServiceReference1.WSACUSoapClient client1 = new ServiceReference1.WSACUSoapClient(); DataSet ds1 = client1.PeriodQuery("Q", scheduleId); dt1 = ds1.Tables[0]; foreach (DataRow dr in dt1.Rows) { string dayInWeek = dr["DayInWeek"].ToString(); DateTime startTime = DateTime.ParseExact(dr["StartTime"].ToString(), "HH:mm:ss", CultureInfo.InvariantCulture); DateTime endTime = DateTime.ParseExact(dr["EndTime"].ToString(), "HH:mm:ss", CultureInfo.InvariantCulture); Period period = new Period(dayInWeek, startTime, endTime); periods.Add(period); } schedule.ListPeriod = periods; return(schedule); } catch (Exception ex) { return(null); } }
/// <summary> /// Delete user into group /// </summary> /// <param name="userId">ID of user need delete</param> /// <param name="creator">user id login</param> /// <returns>OK or error from DB</returns> public string DeleteUser(string userId, string creator) { string result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupUserDetailSave("D", "", userId, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("Group user class - Delete user: {0}", ex.ToString())); } }
/// <summary> /// update group user /// </summary> /// <param name="creator">user id login</param> /// <returns>OK or error from DB</returns> public string Update(string creator) { string result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupUserSave("U", groupId, groupName, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("Group user class - Update: {0}", ex.ToString())); } }
/// <summary> /// Auto generate access level id base on max id on DB /// </summary> /// <returns>ID: ACSxxxxxxx </returns> public static string GenId() { string id = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelQry("S", "", ""); dt = ds.Tables[0]; id = dt.Rows[0][0].ToString(); return(id); } catch (Exception ex) { return(null); } }
/// <summary> /// Add user into access group /// </summary> /// <param name="userId">Id of user need add</param> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string AddUser(string userId, string creator) { string Result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessUSave("A", groupId, userId, creator, DateTime.Today); dt = ds.Tables[0]; Result = dt.Rows[0][0].ToString(); return(Result); } catch (Exception ex) { return(string.Format("Access group class - Add user: {0}", ex.ToString())); } }
/// <summary> /// Delete all user group in access group /// </summary> /// <param name="groupid">Id of access group need delete</param> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public static string DeleteAllUserGroup(string groupid, string creator) { string Result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessUGSave("D", groupid, "", creator, DateTime.Today); dt = ds.Tables[0]; Result = dt.Rows[0][0].ToString(); return(Result); } catch (Exception ex) { return(string.Format("Access group class - Delete all user group: {0}", ex.ToString())); } }
/// <summary> /// Delete access group /// </summary> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string Delete(string creator) { string Result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessSave("D", groupId, groupName, groupDescription, creator, DateTime.Today); dt = ds.Tables[0]; Result = dt.Rows[0][0].ToString(); return(Result); } catch (Exception ex) { return(string.Format("Access group class - Delete: {0}", ex.ToString())); } }
/// <summary> /// Uddate schedule info /// </summary> /// <param name="creator">User login id</param> /// <returns>Result of command: OK or get error from DB</returns> public string Update(string creator) { string result = "OK"; DataTable dt = null; DataTable dt1 = null; try { //Update schedule master ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.ScheduleSave("U", scheduleId, scheduleName, description, creator, DateTime.Now); dt = ds.Tables[0]; //Delete old period result = DeleteAllPeriod(scheduleId, creator); if (dt.Rows[0][0].ToString() == "OK") { //Add new period foreach (Period p in listPeriod) { ServiceReference1.WSACUSoapClient client1 = new ServiceReference1.WSACUSoapClient(); DataSet ds1 = client.PeriodSave("A", scheduleId, p.DayInWeek, p.startTime, p.endTime, creator, DateTime.Now); dt1 = ds1.Tables[0]; if (dt1.Rows[0][0].ToString() != "OK") { result = dt1.Rows[0][0].ToString(); break; } } } else { result = dt.Rows[0][0].ToString(); } return(result); } catch (Exception ex) { return(string.Format("Schedule class - Update: {0}", ex.ToString())); } }
/// <summary> /// Update access group info /// </summary> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string Update(string creator) { string Result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessSave("U", groupId, groupName, groupDescription, creator, DateTime.Today); dt = ds.Tables[0]; Result = dt.Rows[0][0].ToString(); //Delete old user Result = DeleteAllUser(groupId, creator); //Add user foreach (Users u in listUsers) { Result = AddUser(u.Id, creator); } //Delete old user group Result = DeleteAllUserGroup(groupId, creator); //Add Guser foreach (GroupUser gu in listGroupUsers) { Result = AddUserGroup(gu.groupId, creator); } //Delete old accessLv Result = DeleteAllAccesslv(groupId, creator); //Add accesslv foreach (AccessLevel ac in accessLv) { Result = AddAccessLevel(ac.groupId, creator); } return(Result); } catch (Exception ex) { return(string.Format("Access group class - Update: {0}", ex.ToString())); } }
/// <summary> /// Auto generate access group id base on max group id from DB /// </summary> /// <returns>Group ID: ACGxxxxxxx</returns> public static string GenGroupId() { string Id = ""; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessQuery("S", "", ""); dt = ds.Tables[0]; Id = dt.Rows[0][0].ToString(); return(Id); } catch (Exception ex) { return(""); } }
/// <summary> /// Update door info /// </summary> /// <param name="creator">User login</param> /// <returns>OK or error from DB</returns> public string Update(string creator) { string result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.DoorSave("U", doorId, doorName, DeviceControl.DeviceId, readerNumber, inputNumber, outputNumber, relayNumber, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("Door class - Update: {0}", ex.ToString())); } }
/// <summary> /// Change password login /// </summary> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public string ChangePass(string creator) { string result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.UserSave("C", id, optLevel, userName, passWord, name, avatar, email, phoneNo, status, startDate, experiedDate, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("User class - Change password: {0}", ex.ToString())); } }
/// <summary> /// Delete Schedule /// </summary> /// <param name="creator">User login id</param> /// <returns>OK or get error from DB</returns> public string Delete(string creator) { string result = "OK"; DataTable dt = null; try { //Delete schedule master and detail (in DB delete detail command) ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.ScheduleSave("D", scheduleId, "", "", creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("Schedule class - Delete: {0}", ex.ToString())); } }
/// <summary> /// Add door to accesslevel /// </summary> /// <param name="accessLvId">ID of access level need add</param> /// <param name="doorId">id of door need add</param> /// <param name="creator">user login id</param> /// <returns>OK or error from DB</returns> public static string AddDoor(string accessLvId, string doorId, string creator) { string result = "OK"; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.AccessLevelDSave("A", accessLvId, doorId, creator, DateTime.Now); dt = ds.Tables[0]; result = dt.Rows[0][0].ToString(); return(result); } catch (Exception ex) { return(string.Format("Access level class - Add door: {0}", ex.ToString())); } }