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