private void button2_Click(object sender, EventArgs e)
{
using (ProgressBarForm bar = new ProgressBarForm(SaveData))
{
bar.ShowDialog(this);
}
My_Database my_data = new My_Database();
SqlDataAdapter sda = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM Login WHERE Username = @User AND Password = @Pass", my_data.Getcon);
command.Parameters.Add("@User", SqlDbType.VarChar).Value = Username_tb.Text;
command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = Password_tb.Text;
sda.SelectCommand = command;
sda.Fill(table);
if (table.Rows.Count > 0)
{
MessageBox.Show("Ok, Login Successful");
Function_Login fl = new Function_Login();
this.Hide();
fl.Show();
}
else
{
MessageBox.Show("Invalid Username or Password, Please create new account!", "Login error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//Function_Login fl = new Function_Login();
//fl.Show();
}
for (int i = 0; i < 100; i++)
{
progressBar1.Increment(i);
}
}
private void button2add_Click(object sender, EventArgs e)
{
Student student = new Student();
int Id = Convert.ToInt32(ID_student.Text);
string firstname = this.firstname.Text;
string lastname = this.lastname.Text;
DateTime birthday = datetime.Value;
string phone = this.address1.Text;
string address = this.phone.Text;
string gender = "Female";
if (malebutton.Checked)
{
gender = "Male";
}
MemoryStream pic = new MemoryStream();
int born_year = datetime.Value.Year;
int this_year = DateTime.Now.Year;
if (this_year - born_year < 10 || this_year - born_year > 100)
{
MessageBox.Show("The student age must be 10 to 100 year", "Invalid Birthday", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (verif())
{
picture.Image.Save(pic, picture.Image.RawFormat);
if (student.AddStudent(Id, firstname, lastname, birthday, gender, phone, address, pic))
{
MessageBox.Show("New student added", "Add student", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
Function_Login fl = new Function_Login();
fl.Show();
}
else
{
MessageBox.Show("Error", "Add student", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Empty fields", "Add student", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
