private bool GetServerData()
{
bool ServerDataFound = false;
tServerRow = cf.LoadDataRow(Asgard.AsgardCon, $"SELECT * FROM sync.server WHERE name='{tName}'");
if (tServerRow != null)
{
if (tServerRow["name"].ToString() != string.Empty)
{
tServerType = (Servertype)Enum.Parse(typeof(Servertype), tServerRow["server_type"].ToString(), true);
tDescription = tServerRow["Description"].ToString().Trim();
tServiceName = tServerRow["service_name"].ToString().Trim();
tServiceType = (Servicetype)Enum.Parse(typeof(Servicetype), tServerRow["service_type"].ToString(), true);
tURL = tServerRow["url"].ToString().Trim();
tStatus = (Serverstatus)Enum.Parse(typeof(Serverstatus), tServerRow["status"].ToString(), true);
tLastChanged = tServerRow.Field <DateTime>("last_status_change");
tLastChecked = tServerRow.Field <DateTime>("last_status_check");
tLogHistoryDays = tServerRow.Field <Int32>("log_history_days");
tSessionID = tServerRow["sessionID"].ToString().Trim();
tLastLogin = tServerRow.Field <DateTime?>("last_login");
tServerResponse = tServerRow["server_response"].ToString().Trim();
tActive = (tServerRow["active"].ToString() == "1");
ServerDataFound = true;
}
}
else
{
Reset();
}
return(ServerDataFound);
}
private void Reset()
{
tServerRow = null;
tServerType = Servertype.Unknown;
tDescription = string.Empty;
tServiceName = string.Empty;
tServiceType = Servicetype.Unknown;
tURL = string.Empty;
tStatus = Serverstatus.Unknown;
tLastChanged = DateTime.Now;
tLastChecked = DateTime.Now;
tLogHistoryDays = 90;
tSessionID = string.Empty;
tLastLogin = null;
tServerResponse = string.Empty;
tActive = false;
}
public Server(string aName, Servertype aServerType = Servertype.Unknown, string aDescription = "", string aServiceName = "", Servicetype aServiceType = Servicetype.Unknown, string aURL = "", Int32 aLogHistoryDays = 90, bool aActive = true)
{
tName = aName;
if (aServerType != Servertype.Unknown)
{
//create new server
tServerType = aServerType;
tDescription = aDescription;
tServiceName = aServiceName;
tServiceType = aServiceType;
tURL = aURL;
tStatus = Serverstatus.Unknown;
tLastChanged = DateTime.Now;
tLastChecked = DateTime.Now;
tLogHistoryDays = aLogHistoryDays;
tSessionID = string.Empty;
tLastLogin = null;
tServerResponse = string.Empty;
tActive = aActive;
}
GetServerData();
}
