public AccountVM(User user)
{
SQL sql = new SQL();
sql.Connect();
this.Scripts = sql.ReturnAllSCriptsByUser(user);
foreach(Script item in this.Scripts)
{
item.InstOfDb.Name = sql.ReturnNameOfInstance(item.InstOfDb.ID);
}
sql.Close();
}
public void SetModel(string UserName)
{
SQL sql = new SQL();
sql.Connect();
this.user = sql.ReturnUserByName(UserName);
this.user.Name = UserName;
this.script = new Script();
this.ListOfInstanceDb = new List<string>();
ListOfInstanceDb = sql.ReturnAllInstDB();
sql.Close();
this.ListOfTypeOfDb = new List<string>();
ListOfTypeOfDb.Add("ORACLE");
ListOfTypeOfDb.Add("MSSQL");
ListOfTypeOfDb.Add("POSTGRE");
}
//zwrocenie User'a po nazwie
public User ReturnUserByName(string name)
{
string query = "SELECT * FROM UserAccount WHERE Name = @name";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", name);
SqlDataReader reader = cmd.ExecuteReader();
User user = new User();
if (reader.IsClosed == false)
{
if (reader.Read())
{
user.ID = reader.GetInt32(0);
user.Name = reader.GetString(1);
}
}
reader.Close();
return user;
}
//zwraca wszystkie skrypty danego użytkownika
//TRZEBA TO zmodyfikować, za długo by ładowało
//podzielić to na części
public List<Script> ReturnAllSCriptsByUser(User user)
{
List<Script> list = new List<Script>();
string query = "SELECT * FROM Script WHERE UserID = @userID";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@userID", user.ID);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.IsClosed == false)
{
while (reader.Read())
{
Script sc = new Script();
sc.ID = reader.GetInt32(0);
sc.UserID = reader.GetInt32(1);
sc.DateOfCreate = reader.GetDateTime(2);
sc.Path = reader.GetString(3);
sc.NameOfProject = reader.GetString(4);
sc.TypeOfDb = reader.GetString(5);
sc.InstOfDb.ID = reader.GetInt32(6);//tu zwraca tylko ID, trzeba dodac nazwe
sc.UniqueName = reader.GetString(7);
sc.Version = reader.GetInt32(8);
list.Add(sc);
}
}
reader.Close();
return list;
}
