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; }