private void GridRow_DbClick(object sender, DataGridViewRowEventArgs e) { int id = 0; string myValue = dataGridstudent[e.Row.Index, 0].Value.ToString(); Student obj = new Student(); List <Student> listStudents = obj.List(); Student student = listStudents.Where(x => x.Id == id).FirstOrDefault(); }
private void BindGrid() { Student obj = new Student(); List <Student> listsStudents = obj.List(); DataTable dta = Utility.ConvertToDataTable(listsStudents); dataGridstudent.DataSource = dta; BindChart(listsStudents); }
private void dataGridstudent_CellContentClick(object sender, DataGridViewCellEventArgs e) { Student obj = new Student(); if (e.ColumnIndex == 0) { //get the value of the clicked rows id coloumn string value = dataGridstudent[2, e.RowIndex].Value.ToString(); int id = 0; if (String.IsNullOrEmpty(value)) { MessageBox.Show("The data is invalid!"); } else { id = int.Parse(value); Student student = obj.List().Where(x => x.Id == id).FirstOrDefault(); idTxt.Text = student.Id.ToString(); firstTxt.Text = student.Name.Split(' ')[0]; lastTxt.Text = student.Name.Split(' ')[1]; addressTxt.Text = student.Address; contactTxt.Text = student.ContactNo; emailTxt.Text = student.Email; DPdob.Value = student.BirthDate; DPregister.Value = student.RegistrationDate; CBprogramme.SelectedItem = student.Programme; CBgender.SelectedItem = student.Gender; submitBtn.Visible = false; updateBtn.Visible = true; } } else if (e.ColumnIndex == 1) { string value = dataGridstudent[2, e.RowIndex].Value.ToString(); if (String.IsNullOrEmpty(value)) { MessageBox.Show("The data is invalid!"); } else { string message = "Do you want to remove this information?"; string title = "Deletion Confirmed"; MessageBoxButtons buttons = MessageBoxButtons.OKCancel; DialogResult result = MessageBox.Show(message, title, buttons); if (result == DialogResult.OK) { //get the value of the clicked rows id column string Id = dataGridstudent[2, e.RowIndex].Value.ToString(); obj.Delete(int.Parse(Id)); BindGrid(); MessageBox.Show("The information has been deleted successfully."); } } } }
private void weeklyReport_ValueChanged(object sender, EventArgs e) { DateTime selected = weeklyReport.Value; var culture = System.Threading.Thread.CurrentThread.CurrentCulture; var diff = selected.DayOfWeek - culture.DateTimeFormat.FirstDayOfWeek; if (diff < 0) { diff += 7; } var first_day_week = selected.AddDays(-diff).Date; //startingDateLbl.Text = "Weekly Data shown starting with first day of week:" + first_day_week.ToString("dd/MM/yyyy"); var last_day_week = selected.AddDays(7); stuWeekReport.Rows.Clear(); Student obj = new Student(); List <Student> listStudents = obj.List(); var convertStudents = listStudents.Where(s => s.RegistrationDate >= first_day_week && s.RegistrationDate < last_day_week); int computing = 0; int networking = 0; int multimedia = 0; foreach (Student stu in convertStudents) { if (stu.Programme == "Computing") { computing += 1; } else if (stu.Programme == "Multimedia Technologies") { multimedia += 1; } else if (stu.Programme == "Networking and IT Security") { networking += 1; } } stuWeekReport.Rows.Add(new Object[] { "Computing", computing }); stuWeekReport.Rows.Add(new Object[] { "Multimedia", multimedia }); stuWeekReport.Rows.Add(new Object[] { "Networking", networking }); }