public IUzivatelGateway login(string prezdivka, string heslo)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_login);
command.Parameters.Add(new SqlParameter("@prezdivka", SqlDbType.VarChar, prezdivka.Length));
command.Parameters["@prezdivka"].Value = prezdivka;
command.Parameters.Add(new SqlParameter("@heslo", SqlDbType.VarChar, heslo.Length));
command.Parameters["@heslo"].Value = heslo;
SqlDataReader reader = db.Select(command);
Collection <IUzivatelGateway> Uzivatele = ReadLogin(reader);
IUzivatelGateway Uzivatel = null;
if (Uzivatele.Count == 1)
{
Uzivatel = Uzivatele[0];
}
reader.Close();
db.Close();
return(Uzivatel);
}
public Uzivatel getUzivatel(int param)
{
//UzivatelGateway uzivatelGateway = new UzivatelFinder().SelectId(param);
IUzivatelGateway uzivatelGateway = finder.SelectId(param);
Uzivatel uzivatel = new Uzivatel(uzivatelGateway);
return(uzivatel);
}
public Uzivatel getLoginUzivatele(string prezdivka, string heslo)
{
//UzivatelGateway uzivatelGateway = new UzivatelFinder().login(prezdivka, heslo);
IUzivatelGateway uzivatelGateway = finder.login(prezdivka, heslo);
Uzivatel uzivatel = new Uzivatel(uzivatelGateway);
return(uzivatel);
}
public IUzivatelGateway SelectId(int id)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int));
command.Parameters["@id"].Value = id;
SqlDataReader reader = db.Select(command);
Collection <IUzivatelGateway> Uzivatele = Read(reader);
IUzivatelGateway Uzivatel = null;
if (Uzivatele.Count == 1)
{
Uzivatel = Uzivatele[0];
}
reader.Close();
db.Close();
return(Uzivatel);
}
public Uzivatel(IUzivatelGateway data)
{
this.data = data;
}