private void button1_Click(object sender, EventArgs e)
{
if (isLogged)
{
isStaff = false;
isLogged = false;
HelloLabel.Hide();
loggedUser = "";
loggedUserLastName = "";
LogInButton.Text = "Log in";
//connectionString = "Server=localhost;Port=3306;Database=sakila;Uid=client;Pwd=$3cr3t;";
staffImage.Show();
}
else
{
if (UserTextBox.Text == "guest" && PaswordTextBox.Text == "123")
{
connectionString = "Server=localhost;Port=3306;Database=sakila;Uid=staff;Pwd=$up3r$3cr3t;";
isStaff = true;
isLogged = true;
LogInButton.Text = "Log out";
tabControl1.SelectedTab = FilmsTab;
loggedUserLastName = "guest";
HelloLabel.Text = "hello mr. " + loggedUserLastName;
HelloLabel.Show();
//staffImage.Visible = !staffImage.Visible;
}
else
{
List <string> users = new List <string>();
MySqlConnection connection = new MySqlConnection(connectionString);
string sql = $"SELECT last_name FROM staff WHERE first_name = '{UserTextBox.Text}';";
users = connection.Query <string>(sql).ToList();
if (users.Count() != 0 && PaswordTextBox.Text == "456")
{
isStaff = true;
isLogged = true;
LogInButton.Text = "Log out";
tabControl1.SelectedTab = FilmsTab;
staffImage.Hide();
loggedUser = UserTextBox.Text;
loggedUserLastName = users.FirstOrDefault().ToString();
HelloLabel.Text = "hello mr. " + loggedUserLastName;
HelloLabel.Show();
}
connection.Close();
}
}
}
void ReleaseDesignerOutlets()
{
if (HelloLabel != null)
{
HelloLabel.Dispose();
HelloLabel = null;
}
if (mybutton != null)
{
mybutton.Dispose();
mybutton = null;
}
if (NameTextView != null)
{
NameTextView.Dispose();
NameTextView = null;
}
}
void ReleaseDesignerOutlets()
{
if (HelloLabel != null)
{
HelloLabel.Dispose();
HelloLabel = null;
}
if (logo2 != null)
{
logo2.Dispose();
logo2 = null;
}
if (MainImage != null)
{
MainImage.Dispose();
MainImage = null;
}
if (ModeLable != null)
{
ModeLable.Dispose();
ModeLable = null;
}
if (ModeSwitch != null)
{
ModeSwitch.Dispose();
ModeSwitch = null;
}
if (testButton != null)
{
testButton.Dispose();
testButton = null;
}
}
void ReleaseDesignerOutlets()
{
if (CenterDesc != null)
{
CenterDesc.Dispose();
CenterDesc = null;
}
if (CenterTitle != null)
{
CenterTitle.Dispose();
CenterTitle = null;
}
if (CenterView != null)
{
CenterView.Dispose();
CenterView = null;
}
if (CloseSessionButton != null)
{
CloseSessionButton.Dispose();
CloseSessionButton = null;
}
if (CloseSessionLabel != null)
{
CloseSessionLabel.Dispose();
CloseSessionLabel = null;
}
if (ContactDataDescripLabel != null)
{
ContactDataDescripLabel.Dispose();
ContactDataDescripLabel = null;
}
if (ContactDataTitleLabel != null)
{
ContactDataTitleLabel.Dispose();
ContactDataTitleLabel = null;
}
if (ContactDataView != null)
{
ContactDataView.Dispose();
ContactDataView = null;
}
if (HealthDataDescripLabel != null)
{
HealthDataDescripLabel.Dispose();
HealthDataDescripLabel = null;
}
if (HealthDataTitleLabel != null)
{
HealthDataTitleLabel.Dispose();
HealthDataTitleLabel = null;
}
if (HealthDataView != null)
{
HealthDataView.Dispose();
HealthDataView = null;
}
if (HelloLabel != null)
{
HelloLabel.Dispose();
HelloLabel = null;
}
if (labeVersion != null)
{
labeVersion.Dispose();
labeVersion = null;
}
if (LanguageButton != null)
{
LanguageButton.Dispose();
LanguageButton = null;
}
}
