private void saveButton_Click(object sender, EventArgs e)
{
MY_DB mydb = new MY_DB();
User user = new User();
SqlCommand cmd = new SqlCommand("SELECT user_id, fname, lname, birthdate, gender, phone, address, picture, selected_courses FROM listUser WHERE user_id=@id", mydb.getConnection);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(idBox.Text);
SqlDataAdapter adpt = new SqlDataAdapter();
DataTable table = new DataTable();
adpt.SelectCommand = cmd;
adpt.Fill(table);
if (table.Rows.Count > 0)
{
for (int i = 0; i < selectedCourseListBox.Items.Count; i++)
{
int courseID = course.getCourseId(selectedCourseListBox.Items[i].ToString());
if (user.addCourse(Convert.ToInt32(idBox.Text), courseID, 0, ""))
{
MessageBox.Show("Saved " + selectedCourseListBox.Items[i].ToString());
}
}
selectedCourseListBox.Items.Clear();
mydb.closeConnection();
}
else
{
MessageBox.Show("This ID is not available!!!", "Error");
mydb.closeConnection();
}
if (user.selectedCourse(Convert.ToInt32(idBox.Text)))
{
}
}
private void staticResult_Load(object sender, EventArgs e)
{
Result result = new Result();
MY_DB mydb = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT label, avg_grade FROM course", mydb.getConnection);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
adpt.Fill(table);
int locationX = 39;
int locationY = 141;
for (int i = 0; i < table.Rows.Count; i++)
{
Label course = new Label();
course.Text = table.Rows[i][0].ToString() + ": " + table.Rows[i][1].ToString();
course.Font = new Font("Microsoft Sans Serif", 20);
course.ForeColor = Color.White;
course.Location = new Point(locationX, locationY);
locationY += 40;
course.Size = new Size(400, 40);
Controls.Add(course);
}
passLabel.Text += " " + result.getPassPercent() + "%";
failLabel.Text += " " + (100 - result.getPassPercent()) + "%";
}
private void btnDelNV_Click(object sender, EventArgs e)
{
DialogResult traloi;
traloi = MessageBox.Show("Bạn thực sự muốn xóa?", "Trả lời", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (traloi == DialogResult.OK)
{
MY_DB mydb = new MY_DB();
mydb.openConnection();
SqlTransaction objTrans = null;
using (SqlConnection objConn = mydb.getConnection)
{
objTrans = objConn.BeginTransaction();
SqlCommand dlDV = new SqlCommand("update DatVe set MaNV=NULL where MaNV=" + txtMaNV.Text, mydb.getConnection, objTrans);
SqlCommand dlDN = new SqlCommand("delete from DangNhap where MaNV=" + txtMaNV.Text, mydb.getConnection, objTrans);
SqlCommand dlNV = new SqlCommand("delete from NhanVien where MaNV=" + txtMaNV.Text, mydb.getConnection, objTrans);
try
{
dlDV.ExecuteNonQuery();
dlDN.ExecuteNonQuery();
dlNV.ExecuteNonQuery();
objTrans.Commit();
MessageBox.Show("Da xoa nhan vien" + txtMaNV.Text);
}
catch (Exception ex)
{
objTrans.Rollback();
MessageBox.Show(ex.Message);
}
mydb.closeConnection();
}
}
}
private void btXeMay_Click(object sender, EventArgs e)
{
pictureBoxVienOto.Visible = false;
pictureBoxVienXeDap.Visible = false;
pictureBoxVienXeMay.Visible = true;
Oto.Checked = false;
XeMay.Checked = true;
XeDap.Checked = false;
txtGioGui.Text = DateTime.Now.ToString("HH:mm:ss");
if (btXeMayTrong.Text != "0")
{
MY_DB db = new MY_DB();
KhachHang student = new KhachHang();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("select * from BAIXE", db.getConnection);
da.SelectCommand = cmd;
da.Fill(dt);
bool kt = false;
int i = 0, j = 4;
while (j < 8 && kt == false)
{
while (i < dt.Rows.Count && kt == false)
{
if (dt.Rows[i][j].ToString() == "0")
{
switch (j)
{
case 4:
btKhuVuc.Text = "D." + (i + 1);
kt = true;
break;
case 5:
btKhuVuc.Text = "E." + (i + 1);
kt = true;
break;
case 6:
btKhuVuc.Text = "F." + (i + 1);
kt = true;
break;
case 7:
btKhuVuc.Text = "G." + (i + 1);
kt = true;
break;
}
}
i++;
}
j++;
}
}
else
{
MessageBox.Show("Đã hết chỗ trống");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
int r = dgv_HopDong.CurrentCell.RowIndex;
string strHD = dgv_HopDong.Rows[r].Cells[0].Value.ToString();
DialogResult traloi;
traloi = MessageBox.Show("Bạn thực sự muốn xóa?", "Trả lời", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (traloi == DialogResult.OK)
{
MY_DB mydb = new MY_DB();
mydb.openConnection();
SqlTransaction objTrans = null;
using (SqlConnection objConn = mydb.getConnection)
{
objTrans = objConn.BeginTransaction();
SqlCommand dlHSX = new SqlCommand($"update HangSanXuat set MaHD=NULL where MaHD=N'{txtMaHD.Text.Trim()}'", mydb.getConnection, objTrans);
SqlCommand dlPHD = new SqlCommand($"delete from PhimHopDong where MaHD= N'{txtMaHD.Text.Trim()}'", mydb.getConnection, objTrans);
try
{
dlHSX.ExecuteNonQuery();
dlPHD.ExecuteNonQuery();
objTrans.Commit();
MessageBox.Show("Da xoa hop dong" + txtMaHD.Text);
}
catch (Exception ex)
{
objTrans.Rollback();
MessageBox.Show(ex.Message);
}
mydb.closeConnection();
}
}
}
private void buttonAddMember_Click(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
SqlDataAdapter adapter = new SqlDataAdapter();
System.Data.DataTable table = new System.Data.DataTable();
SqlCommand command = new SqlCommand("Select * From Member WHERE @ID= Id", db.getConnection);
command.Parameters.Add("@ID", SqlDbType.VarChar).Value = txtId.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
if ((table.Rows.Count) > 0)
{
MessageBox.Show("Trùng ID rồi!!!", " Nhập lại ID.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
string id = txtId.Text;
string fname = txtFirstname.Text;
string lname = txtLastname.Text;
DateTime bdate = dateTimePicker1.Value;
string phone = txtPhone.Text;
string adrs = txtAddress.Text;
string gender = "Male";
string username = (string)comboBox1.SelectedValue;
if (radioButtonFemale.Checked)
{
gender = "Female";
}
MemoryStream pic = new MemoryStream();
if (verif())
{
pictureBoxMember.Image.Save(pic, pictureBoxMember.Image.RawFormat);
if (AccountDAO.Instance.GetAccountByUserName(username) != null)
{
if (member.InsertMember(id, fname, lname, gender, bdate, adrs, phone, pic, username))
{
Refresh();
Clear();
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Error", "Add Member", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Sai tên tài khoản hoặc chưa tạo tài khoản!");
}
}
else
{
MessageBox.Show("Empty Fields", "Add Member", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void resetButton_Click(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT user_id, fname, lname, birthdate, gender, phone, address, picture, selected_courses FROM listUser", db.getConnection);
listUserDataGrid.DataSource = user.userList();
totalUserLabel.Text = "Total User: " + user.getStudents(cmd).Rows.Count.ToString();
}
public static int getInit()
{
MY_DB mydb = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT init FROM initial", mydb.getConnection);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
adpt.Fill(table);
return(Convert.ToInt32(table.Rows[0][0]));
}
public static int getManagerFine()
{
MY_DB mydb = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT pay_fines FROM manager_salary WHERE manager_id=@id", mydb.getConnection);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = ManagerID;
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
adpt.Fill(table);
return(Convert.ToInt32(table.Rows[0][0]));
}
private void ManageUser_Load(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT user_id, fname, lname, birthdate, gender, phone, address, picture, selected_courses FROM listUser", db.getConnection);
listUserDataGrid.DataSource = user.userList();
totalUserLabel.Text = "Total User: " + user.getStudents(cmd).Rows.Count.ToString();
DataGridViewImageColumn imgColumn = new DataGridViewImageColumn();
imgColumn = (DataGridViewImageColumn)listUserDataGrid.Columns[7];
imgColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
listUserDataGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void KTChoTrong()
{
MY_DB db = new MY_DB();
KhachHang student = new KhachHang();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("select * from BAIXE", db.getConnection);
da.SelectCommand = cmd;
da.Fill(dt);
int countOto = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 1; j < 4; j++)
{
if (dt.Rows[i][j].ToString() == "1")
{
countOto++;
}
}
}
int countXeMay = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 4; j < 8; j++)
{
if (dt.Rows[i][j].ToString() == "1")
{
countXeMay++;
}
}
}
int countXeDap = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 8; j < 10; j++)
{
if (dt.Rows[i][j].ToString() == "1")
{
countXeDap++;
}
}
}
txtOtoTrong.Text = (60 - countOto).ToString();
btXeDapTrong.Text = (60 - countXeDap).ToString();
btXeMayTrong.Text = (60 - countXeMay).ToString();
}
public static void setInitDatabase()
{
MY_DB mydb = new MY_DB();
SqlCommand cmd = new SqlCommand("UPDATE initial SET init = @init", mydb.getConnection);
cmd.Parameters.Add("@init", System.Data.SqlDbType.Int).Value = init;
mydb.openConnection();
if (cmd.ExecuteNonQuery() == 0)
{
mydb.closeConnection();
}
else
{
mydb.closeConnection();
}
}
private void AverageGrade_Load(object sender, EventArgs e)
{
MY_DB mydb = new MY_DB();
Score score = new Score();
Course course = new Course();
SqlCommand cmd = new SqlCommand("SELECT course.label AS Course, CAST(AVG(score.student_score) AS FLOAT(2)) AS 'Avarage Score' FROM course, score WHERE course.id = score.course_id GROUP BY course.label", mydb.getConnection);
DataTable table = new DataTable();
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(table);
if (course.avgGrade())
{
}
avgGradeGrid.DataSource = table;
avgGradeGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void signUpButton_Click(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
SqlCommand cmd = new SqlCommand("INSERT INTO account (username, password, Id) VALUES (@username, @password, @id)", db.getConnection);
cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = Convert.ToInt32(IDBox.Text);
cmd.Parameters.Add("@username", System.Data.SqlDbType.VarChar).Value = textBoxUser.Text;
cmd.Parameters.Add("@password", System.Data.SqlDbType.VarChar).Value = textBoxPass.Text;
db.openConnection();
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("You Have Sign Up Successfully");
db.closeConnection();
}
else
{
db.closeConnection();
}
}
bool check_sys()
{
// Kiểm tra ID và User đã có trên hệ thống chưa
MY_DB db = new MY_DB();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand commmand = new SqlCommand("SELECT * FROM dbo.users WHERE uid = @Id OR username = @Username", db.GetConnection);
commmand.Parameters.Add("@Id", SqlDbType.Int).Value = Convert.ToInt32(textBoxIDUser.Text);
commmand.Parameters.Add("@Username", SqlDbType.NChar).Value = textBoxUsername.Text.Trim();
adapter.SelectCommand = commmand;
adapter.Fill(table);
if (table.Rows.Count > 0)// Đã có id hoặc user trên hệ thống
{
return(true);
}
return(false);
}
private void searchButton_Click(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
try
{
int id = Convert.ToInt32(enterIDBox.Text);
SqlCommand cmd = new SqlCommand("SELECT user_id, fname, lname, birthdate, gender, phone, address, picture, selected_courses FROM listUser WHERE user_id = @id", db.getConnection);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
listUserDataGrid.DataSource = user.getStudents(cmd);
IDBox.Text = listUserDataGrid.CurrentRow.Cells[0].Value.ToString();
fnameBox.Text = listUserDataGrid.CurrentRow.Cells[1].Value.ToString();
lnameBox.Text = listUserDataGrid.CurrentRow.Cells[2].Value.ToString();
birthDate.Value = (DateTime)listUserDataGrid.CurrentRow.Cells[3].Value;
if (listUserDataGrid.CurrentRow.Cells[4].Value.ToString().Equals("Female"))
{
femaleRadio.Checked = true;
}
else
{
maleRadio.Checked = true;
}
phoneNumbBox.Text = listUserDataGrid.CurrentRow.Cells[5].Value.ToString();
addressBox.Text = listUserDataGrid.CurrentRow.Cells[6].Value.ToString();
byte[] pic;
pic = (byte[])listUserDataGrid.CurrentRow.Cells[7].Value;
MemoryStream picture = new MemoryStream(pic);
pictureBox.Image = Image.FromStream(picture);
totalUserLabel.Text = "Total User: "******"SELECT user_id, fname, lname, birthdate, gender, phone, address, picture, selected_courses FROM listUser", db.getConnection);
listUserDataGrid.DataSource = user.userList();
totalUserLabel.Text = "Total User: " + user.getStudents(cmd).Rows.Count.ToString();
}
}
private void availableCourseRefresh()
{
availableCourseListBox.Items.Clear();
User user = new User();
MY_DB mydb = new MY_DB();
SqlCommand cmd = new SqlCommand("SELECT * FROM course WHERE semester=@semester", mydb.getConnection);
cmd.Parameters.Add("@semester", SqlDbType.Int).Value = semesterBox.Value;
DataTable allCourseTable = new DataTable();
SqlDataAdapter adpt = new SqlDataAdapter();
adpt.SelectCommand = cmd;
adpt.Fill(allCourseTable);
DataTable selectedCourseTable = new DataTable();
try
{
selectedCourseTable = user.getSelectedcourse(Convert.ToInt32(idBox.Text));
for (int i = 0; i < allCourseTable.Rows.Count; i++)
{
int count = 0;
//if Selected Course == All Course count increase
for (int j = 0; j < selectedCourseTable.Rows.Count; j++)
{
if (allCourseTable.Rows[i].ItemArray[0].ToString() == selectedCourseTable.Rows[j].ItemArray[0].ToString())
{
count++;
}
}
if (count == 0)
{
availableCourseListBox.Items.Add(allCourseTable.Rows[i].ItemArray[1].ToString());
}
}
} catch
{
}
}
private void fAdmin_Load(object sender, EventArgs e)
{
MY_DB myDB = new MY_DB();
SqlCommand command = new SqlCommand("select Id, FirstName, LastName, Gender, BirthDate, Address, Phone , Picture, username from Member", myDB.getConnection);
SqlDataAdapter adap = new SqlDataAdapter(command);
System.Data.DataTable table = new System.Data.DataTable();
adap.Fill(table);
dataGridViewNhansu.DataSource = table;
DataGridViewImageColumn picCol = new DataGridViewImageColumn();
picCol = (DataGridViewImageColumn)dataGridViewNhansu.Columns[7];
picCol.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridViewNhansu.RowTemplate.Height = 60;
comboBox1.DataSource = AccountDAO.Instance.GetAccountNoMember();
comboBox1.DisplayMember = "userName";
comboBox1.ValueMember = "userName";
comboBox1.SelectedItem = null;
}
private void courseListBox_SelectedIndexChanged(object sender, EventArgs e)
{
MY_DB mydb = new MY_DB();
try
{
SqlCommand cmd = new SqlCommand("SELECT * FROM course WHERE label = @label", mydb.getConnection);
cmd.Parameters.Add("@label", SqlDbType.NVarChar).Value = courseListBox.SelectedItem.ToString();
SqlDataAdapter adpt = new SqlDataAdapter();
adpt.SelectCommand = cmd;
DataTable table = new DataTable();
adpt.Fill(table);
IDBox.Text = table.Rows[0].ItemArray[0].ToString();
labelBox.Text = table.Rows[0].ItemArray[1].ToString();
periodNumb.Value = Convert.ToInt32(table.Rows[0].ItemArray[2]);
descriptionBox.Text = table.Rows[0].ItemArray[3].ToString();
semesterBox.Value = Convert.ToInt32(table.Rows[0].ItemArray[4]);
} catch
{
}
}
//Check xem xe gửi Loại Gì
private void btOto_Click(object sender, EventArgs e)
{
Oto.Checked = true;
XeMay.Checked = false;
XeDap.Checked = false;
//SqlCommand cmd = new SqlCommand("select * from BAIXE");
//baixe.dgvBaiXe.DataSource = kh.getCus(cmd);
//for(int i = 0; i < 20;i++)
// for (int j = 0; i < 3; j ++ )
// {
// if (Convert.ToInt32(baixe.dgvBaiXe.Rows[i].Cells[j].Value) == 0)
// btKhuVuc.Text = ".....";
// }
MY_DB db = new MY_DB();
KhachHang student = new KhachHang();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("select * from BAIXE", db.getConnection);
//cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = txtUsername.Text;
//cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = txtPassword.Text;
da.SelectCommand = cmd;
da.Fill(dt);
int i = 0;
while (i < dt.Rows.Count)
{
for (int j = 1; j < 4; j++)
{
if (dt.Rows[i][j].ToString() == "0")
{
switch (j)
{
case 1:
btKhuVuc.Text = "A." + (i + 1);
i = 30;
j = 4;
break;
case 2:
btKhuVuc.Text = "B." + (i + 1);
j = 4;
i = 30;
break;
case 3:
btKhuVuc.Text = "C." + (i + 1);
j = 4;
i = 30;
break;
}
}
}
i++;
}
//if (txtUsername.Text == dt.Rows[i]["username"].ToString() && txtPassword.Text == dt.Rows[i]["password"].ToString())
//this.DialogResult = DialogResult.OK;
}
private void button_Click(object sender, EventArgs e)
{
hideSubMenu();
subjectSelected = (sender as Button).Text;
int ID = id;
textBoxSubject.Text = subjectSelected;
if (logged_in)
{
try
{
MY_DB db = new MY_DB();
Student student = new Student();
Count count = new Count();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT `nota`,`date`,`teza` FROM `grades` WHERE `elev`=@id AND `materie`=@mat");
command.Parameters.Add("@id", MySqlDbType.Int32).Value = ID;
command.Parameters.Add("@mat", MySqlDbType.VarChar).Value = subjectSelected;
dataGridView1.ReadOnly = true;
DataGridViewImageColumn picCol = new DataGridViewImageColumn();
dataGridView1.RowTemplate.Height = 40;
dataGridView1.DataSource = student.getStudents(command);
dataGridView1.AllowUserToAddRows = false;
string average = "SELECT AVG(nota) FROM `grades` WHERE `elev`='" + id + "' AND `materie`='" + subjectSelected + "' AND `teza`=false";
string result = count.execCount(average);
string test = "SELECT COUNT(*) FROM `grades` WHERE `elev`='" + id + "' AND `materie`='" + subjectSelected + "' AND `teza`=false";
string testare = count.execCount(test);
if (Convert.ToInt32(testare) == 0)
{
textBoxMedie.Text = "Note insuficiente";
textBoxNote.Text = "0";
}
else
{
try
{
string cautaTeza = "SELECT `nota` FROM `grades` WHERE `elev`='" + id + "' AND `materie`='" + subjectSelected + "' AND `teza`=true";
string TezaGasita = count.execCount(cautaTeza);
int ValTeza = Convert.ToInt32(TezaGasita);
test = "SELECT COUNT(*) FROM `grades` WHERE `elev`='" + id + "' AND `materie`='" + subjectSelected + "' AND `teza`=true";
testare = count.execCount(test);
if (Convert.ToInt32(testare) > 1)
{
textBoxMedie.Text = "EROARE TEZE";
}
else if (Convert.ToInt32(testare) == 1)
{
double number = Convert.ToDouble(result);
number *= 3;
number += ValTeza;
number /= 4;
textBoxMedie.Text = number.ToString();
textBoxNote.Text = count.totalGrades(subjectSelected, id.ToString());
}
}
catch
{
textBoxMedie.Text = result;
textBoxNote.Text = count.totalGrades(subjectSelected, id.ToString());
}
}
}
catch
{
}
try
{
MY_DB db = new MY_DB();
Student student = new Student();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT `data`,`motivat` FROM `absente` WHERE `elev`=@id AND `materie`=@mat");
command.Parameters.Add("@id", MySqlDbType.Int32).Value = ID;
command.Parameters.Add("@mat", MySqlDbType.VarChar).Value = subjectSelected;
dataGridView2.ReadOnly = true;
DataGridViewImageColumn picCol = new DataGridViewImageColumn();
dataGridView2.RowTemplate.Height = 40;
dataGridView2.DataSource = student.getStudents(command);
dataGridView2.AllowUserToAddRows = false;
}
catch
{
}
}
}
private void buttonLogin_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = null;
dataGridView2.DataSource = null;
password = textBoxPassword.Text;
textBoxMedie.Text = "";
textBoxSubject.Text = "";
textBoxNote.Text = "";
id = Convert.ToInt32(textBoxID.Text);
MY_DB db = new MY_DB();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
MySqlCommand command = new MySqlCommand("SELECT * FROM `student` INNER JOIN `users` ON student.id=users.id WHERE `users.id`= @id AND `users.password`= @pass", db.getConnection);
command.Parameters.Add("@id", MySqlDbType.Int32).Value = id;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
adapter.SelectCommand = command;
try
{
adapter.Fill(table);
if (table.Rows.Count > 0)
{
logged_in = true;
//----------------------------Visible interface
dataGridView1.Visible = true;
dataGridView2.Visible = true;
textBoxSubject.Visible = true;
panelSubject.Visible = true;
panel3.Visible = true;
textBoxMedie.Visible = true;
label5.Visible = true;
label4.Visible = true;
textBoxNote.Visible = true;
panel2.Visible = false;
textBoxID.Visible = false;
textBoxPassword.Visible = false;
label1.Visible = false;
buttonLogin.Visible = false;
labelID.Visible = false;
string nume = table.Rows[0][1].ToString() + " " + table.Rows[0][2].ToString();
textBoxName.Text = nume;
textBoxClassroomLoggedIn.Text = "Clasa " + table.Rows[0]["clasa"].ToString();
byte[] pic = (byte[])table.Rows[0]["picture"];
MemoryStream picture = new MemoryStream(pic);
pictureBoxStudentImage.Image = Image.FromStream(picture);
}
else
{
MessageBox.Show("ID sau parolă greșită.", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
logged_in = false;
string nume = "Please login";
textBoxName.Text = nume;
textBoxClassroomLoggedIn.Text = "Classroom #";
textBoxID.Text = "";
textBoxPassword.Text = "";
pictureBoxStudentImage.Image = Properties.Resources.defaultAvatar;
}
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
string temp = "Eroare! " + ex.Message.ToString();
if (temp == "Eroare! Unable to connect to any of the specified MySQL hosts.")
{
MessageBox.Show("Nu se poate face conexiunea la server!", "Eroare!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Eroare! " + ex.Message.ToString());
}
logged_in = false;
string nume = "Please login";
textBoxName.Text = nume;
}
}
