public MateAdmin GetAdmin()
{
MateAdmin result = null;
OpenCon();
string sql = "SELECT * FROM [Admin]";
_cmd = new SQLiteCommand(_conn);
_cmd.CommandText = sql;
SQLiteDataReader read = _cmd.ExecuteReader();
while (read.Read())
{
result = new MateAdmin()
{
Server = ObjToString(read["Server"]),
Email = ObjToString(read["FromMail"]),
UserName = ObjToString(read["UserName"]),
PassWord = ObjToString(read["PassWord"]),
Port = int.Parse(ObjToString(read["Port"])),
SslEnable = bool.Parse(ObjToString(read["SslEnable"])),
};
result.DetectionInterval = long.Parse(ObjToString(read["DetectionInterval"]));
}
return(result);
}
public void SaveAdmin(MateAdmin admin)
{
OpenCon();
string sql = "DELETE FROM [Admin]; "
+ "INSERT INTO [Admin] ([Server],[FromMail],[UserName],[PassWord],[Port],[SslEnable],[DetectionInterval] ) "
+ " VALUES (@Server,@FromMail,@UserName,@PassWord,@Port,@SslEnable,@DetectionInterval);";
_cmd = new SQLiteCommand(_conn);
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@Server", DbType = DbType.String, Value = admin.Server
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@FromMail", DbType = DbType.String, Value = admin.Email
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@UserName", DbType = DbType.String, Value = admin.UserName
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@PassWord", DbType = DbType.String, Value = admin.PassWord
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@Port", DbType = DbType.Int32, Value = admin.Port
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@SslEnable", DbType = DbType.Boolean, Value = admin.SslEnable
});
_cmd.Parameters.Add(new SQLiteParameter {
ParameterName = "@DetectionInterval", DbType = DbType.Int64, Value = admin.DetectionInterval
});
_cmd.CommandText = sql;
_cmd.ExecuteNonQuery();
}
