static UserService()
{
Console.WriteLine("Adding users to DataBase...");
User admin = new User("admin", "admin");
admin.AddRight(ERights.Read);
admin.AddRight(ERights.Write);
admin.Authentificated = true; //By Default Admin has all Rights!
DataBase.user_DB.Add(admin.Username, admin);
User client = new User("pera", "pera");
client.AddRight(ERights.Read);
DataBase.user_DB.Add(client.Username, client);
}
static UserService()
{
string tempusername;
string temppassword;
File.Create("../../../log.txt").Close();
Console.WriteLine("Reading DataBases...");
using (sql = new SqlConnection(ConnectionString))
{
using (SqlDataAdapter adapter = new SqlDataAdapter("Select * from Users", sql))
{
DataTable table = new DataTable();
adapter.Fill(table);
foreach (DataRow item in table.Rows)
{
tempusername = item["UserName"].ToString();
temppassword = item["Password"].ToString();
User user = new User(tempusername, temppassword);
user.AddRight(ERights.Read);
if (tempusername == "admin" || tempusername == "sudo")
{
user.AddRight(ERights.Write);
}
DataBaseAdapter.Users.Add(tempusername, user);
}
}
using (SqlDataAdapter adapter = new SqlDataAdapter("Select * from Person", sql))
{
DataTable table = new DataTable();
adapter.Fill(table);
foreach (DataRow item in table.Rows)
{
string tempfirstname = item["FirstName"].ToString();
string templastname = item["LastName"].ToString();
int temppid = Int32.Parse(item["PublicId"].ToString());
Person person = new Person(tempfirstname, templastname, temppid);
DataBaseAdapter.Persons.Add(temppid, person);
}
}
}
Console.WriteLine("Complited!");
}