public bool checkLogin(string login, string password) { Database.Database_DAO.Database db = new Database.Database_DAO.Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_SELECT_LOGIN); command.Parameters.AddWithValue("@login", login); SqlDataReader reader = db.Select(command); Collection <Database.Client> Clients = Database.Database_DAO.ClientTable.Read(reader); Database.Client Client = null; if (Clients.Count == 1) { Client = Clients[0]; } else { return(false); } reader.Close(); db.Close(); if (Client.password == password) { return(true); } else { return(false); } }
public NewOrder() { InitializeComponent(); widthChoice.Enabled = false; heightChoice.Enabled = false; description.Enabled = false; dateChoice.Enabled = false; submitOrder.Enabled = false; clientID = 1; Collection <Database.Route> routes = new Collection <Database.Route>(); routes = Database.Database_DAO.RouteTable.list_of_clients_routes(clientID); foreach (Database.Route r in routes) { //Console.WriteLine(r.route_id); //routeChoice.Items.Add(5); routeChoice.Items.Add(r.route_id); } Database.Client client = new Database.Client(); label1.Text = client.login; }
private void MainMenu_Load(object sender, EventArgs e) { submitClient.Enabled = false; submitNewAcc.Enabled = false; passwordClient.Enabled = false; password.Enabled = false; email.Enabled = false; fName.Enabled = false; lName.Enabled = false; passwordRepeat.Enabled = false; submitNewAcc.Enabled = false; newClient = new Database.Client(); }
static void clients() { Database.Client client = new Database.Client(); client.fname = "Jon"; client.lname = "Sneg"; client.email = "*****@*****.**"; client.password = "******"; client.login = "******"; //Database.Database_DAO.ClientTable.Insert(client); client.lname = "Snow"; //Database.Database_DAO.ClientTable.Update(client,1); // The ID must be the same as in the DB! Database.Database_DAO.ClientTable.Select(); Database.Database_DAO.ClientTable.Select(2); }