/// <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);
}
}
/// <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>
/// Get all access level from DB
/// </summary>
/// <returns>List of access level</returns>
public static List <AccessLevel> LoadAllAccessLevel()
{
List <AccessLevel> accessLevels = new List <AccessLevel>();
DataTable dt = null;
try
{
ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient();
DataSet ds = client.AccessLevelQry("Q", "", "");
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string groupId = dr["accessLevelID"].ToString();
AccessLevel accessLevel = LoadAccessLevelById(groupId);
accessLevels.Add(accessLevel);
}
return(accessLevels);
}
catch
{
return(null);
}
}
