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