private void btnDelete_Click(object sender, EventArgs e) { string Del = "Do you want to delete : "; string Title = "Delete Confirm!"; string Op = (this.Owner as ToolMenu).btnOption.Text; if (Op == " ជម្រើស") { Del = "តើអ្នកចង់លុបសិស្សឈ្មោះ "; Title = "លុប"; } Database.Open(); SL_List s = new SL_List(); student = s.GetSelected(); if (student != null) { var result = MessageBox.Show(Del + student.Name, Title, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { StudentListDB.Delete(student.Id); Database.Close(); this.btnList_Click(sender, e); } } else { MessageBox.Show("Please Select Student First!!!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
//private StudentListDB student = new StudentListDB(); public StudentListDB GetSelected() { if (rowIndex < 0) { return(null); // (this.Owner as StudentList) } else { int id = -1; foreach (StudentListDB s in Mystudent) { if (s.Id == rowIndex) { id = Int16.Parse(Mystudent.IndexOf(s).ToString()); } } StudentListDB ss = new StudentListDB(); try { ss = Mystudent.ElementAt(id); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(ss); } }
private void btnSignUp_Click(object sender, EventArgs e) { //1.verify all input (textbox, combobox, and datetimepicker) if (String.IsNullOrEmpty(txtFullName.Text) || (string.IsNullOrEmpty(txtPhone.Text))) { MessageBox.Show("Please input student info", "Erorr Adding", MessageBoxButtons.OK, MessageBoxIcon.Error); txtFullName.Focus(); return; } //2.insert to table student in the database StudentListDB s = new StudentListDB(); s.Name = txtFullName.Text.Trim(); if (rdbMale.Checked == true) { s.Gender = true; } else { s.Gender = false; } s.Phone = txtPhone.Text.Trim(); s.Photo = img; s.PhotoPath = Picture.ImageLocation; s.ClassID = 2; StudentListDB.Insert(s); Database.Close(); (this.Owner as StudentList).btnList_Click(sender, e); }
public static List <StudentListDB> GetAllStudents() { int subUserId = GetSubUserId(); List <StudentListDB> student = new List <StudentListDB>(); try { string query = "SELECT * FROM student WHERE subUserId= @subUserId"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Parameters.AddWithValue("@subUserId", subUserId); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { StudentListDB p = new StudentListDB(); p.Id = Int16.Parse(reader["stdId"].ToString()); p.Name = reader["name"].ToString(); p.Gender = Convert.ToBoolean(reader["gender"].ToString()); p.Phone = reader["phone"].ToString(); p.PhotoPath = reader["photoPath"].ToString(); //p.Photo= PhotoByteToImage((byte[])reader["photo"]); student.Add(p); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(student); }
public static List <StudentListDB> Search(string KeyWord) { //DataBase.DB(); List <StudentListDB> scoreSearch = new List <StudentListDB>(); int subUserId = GetSubUserId(); try { string query = "SELECT stdId, name, gender,phone, photoPath FROM student WHERE subUserId= @subUserid AND (name like '" + KeyWord + "%' or stdId like '" + KeyWord + "%' )"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@subUserId", subUserId); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { StudentListDB p = new StudentListDB(); p.Id = Int16.Parse(reader["stdId"].ToString()); p.Name = reader["name"].ToString(); p.Gender = Convert.ToBoolean(reader["gender"].ToString()); p.Phone = reader["phone"].ToString(); p.PhotoPath = reader["photoPath"].ToString(); //p.Photo = PhotoByteToImage((byte[])reader["photo"]); scoreSearch.Add(p); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(scoreSearch); }
public static void Insert(StudentListDB student) { string query = "INSERT INTO student(name, gender, subUserId,phone, photo, photoPath) VALUES(@name, @gender, @subUserId,@phone, @photo, @photoPath)"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@name", student.Name); cmd.Parameters.AddWithValue("@gender", student.Gender); cmd.Parameters.AddWithValue("@subUserId", GetSubUserId()); cmd.Parameters.AddWithValue("@phone", student.Phone); cmd.Parameters.AddWithValue("@photo", ImageToByte(student.Photo)); cmd.Parameters.AddWithValue("@photoPath", student.PhotoPath); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } // insert get last id from student string queryGetLastId = "SELECT LAST_INSERT_ID() FROM student"; MySqlCommand cmdGetLastId = new MySqlCommand(queryGetLastId, Database.connection); MySqlDataReader reader = cmdGetLastId.ExecuteReader(); int LastId = -1; while (reader.Read()) { LastId = Int16.Parse(reader["LAST_INSERT_ID()"].ToString()); } reader.Close(); // insert into score and attendance string queryInsertToScore = "INSERT INTO score(stdId, subUserId) VALUE(@stdId, @subUserId) ;INSERT INTO attendance(stdId, subUserId, attendance) VALUE(@stdId, @subUserId, @attendance) "; MySqlCommand cmdInsertToScore = new MySqlCommand(queryInsertToScore, Database.connection); cmdInsertToScore.Prepare(); cmdInsertToScore.Parameters.AddWithValue("@stdId", LastId); cmdInsertToScore.Parameters.AddWithValue("@subUserId", GetSubUserId()); cmdInsertToScore.Parameters.AddWithValue("@attendance", DefaultAtd(Attendance.NumberSession())); try { cmdInsertToScore.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void LoadStudent() { Mystudent = StudentListDB.GetAllStudents(); string gender; dataGridViewScore.Rows.Clear(); foreach (StudentListDB s in Mystudent) { if (s.Gender == true) { gender = "M"; } else { gender = "F"; } dataGridViewScore.Rows.Add(s.Id, s.Name, gender, s.Phone); } }
public void LoadSearch(string keyword) { student = StudentListDB.Search(keyword); string gender; dataGridViewScore.Rows.Clear(); foreach (StudentListDB s in student) { if (s.Gender == true) { gender = "M"; } else { gender = "F"; } dataGridViewScore.Rows.Add(s.Id, s.Name, gender, s.Phone); } }
private void btnDelete_Click(object sender, EventArgs e) { Database.Open(); SL_List s = new SL_List(); student = s.GetSelected(); if (student != null) { var result = MessageBox.Show("Do you want to delete: " + student.Name, "Delete Confirm!", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { StudentListDB.Delete(student.Id); Database.Close(); this.btnList_Click(sender, e); } } else { MessageBox.Show("Please Select Student First!!!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
public static void Update(StudentListDB student) { string query = "UPDATE student SET name=@name, gender= @gender, phone=@phone, photo=@photo, photoPath=@photoPath WHERE stdId=@stdId"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@stdId", student.Id); cmd.Parameters.AddWithValue("@name", student.Name); cmd.Parameters.AddWithValue("@gender", student.Gender); cmd.Parameters.AddWithValue("@phone", student.Phone); cmd.Parameters.AddWithValue("@photo", ImageToByte(student.Photo)); cmd.Parameters.AddWithValue("@photoPath", student.PhotoPath); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnEdit_Click(object sender, EventArgs e) { SL_List s = new SL_List(); student = s.GetSelected(); if (student != null) { DetectColorButton(3); pnSList.Controls.Clear(); SL_Edit Edit = new SL_Edit(student); Edit.Owner = this; Edit.TopLevel = false; Edit.AutoScroll = true; pnSList.Controls.Add(Edit); btnDelete.Enabled = false; Edit.Show(); } else { MessageBox.Show("Please Select Student First!!!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
private void StudentList_Leave(object sender, EventArgs e) { student = null; }