public List<Student> GetAllStudentDetails() { try { using (SqlCommand cmd = new SqlCommand("SelectAllStdents", con)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { student = new Student(); student.StudentId = int.Parse(rd["StudentId"].ToString()); student.Name = rd["Name"].ToString(); student.DateOfBirth = DateTime.Parse(rd["DOB"].ToString()); student.Average = double.Parse(rd["GradePointAvg"].ToString()); student.IsActive = bool.Parse(rd["Active"].ToString()); StudentList.Add(student); } CacheStudentList = StudentList; return StudentList; } } catch (CustomizeSqlException ex) { throw new ConfigurationSettingException(ex.Message); } finally { con.Close(); } }
/// <summary> /// Add new Entry to Grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { ValidateInputTextField objValidateInputTextField = new ValidateInputTextField(); if (objValidateInputTextField.IsValidInput(txtbxName.Text) && objValidateInputTextField.IsValidInput(txtbxAverage.Text)) { Student objStudent = new Student(); objStudent.Name = txtbxName.Text; objStudent.DateOfBirth = DateTime.Parse(dtPicDOB.Text); objStudent.Average = double.Parse(txtbxAverage.Text); objStudent.IsActive = chkbxIsActive.Checked; objStdentBLL.AddNewStudent(objStudent); this.dataGridView1.DataSource = objStdentBLL.UpdateGridView(); ClearDataEntryPanel(); } else MessageBox.Show(Constants.FILL_ALL_FIELDS); }
/// <summary> /// Add New Entry to List in Repository /// </summary> /// <param name="student"></param> public void AddNewStudentDetails(Student student) { objStudentDetailsRepository.AddNewStudent(student); }
public void AddNewStudent(Student student) { int lastStuId = CacheStudentList.OrderBy(a => a.StudentId).Select(s => s.StudentId).LastOrDefault(); student.StudentId = lastStuId + 1; CacheStudentList.Add(student); }
/// <summary> /// Add New Student to List in the Repository /// </summary> /// <param name="student"></param> public void AddNewStudent(Student student) { StudentDAL objdal = new StudentDAL(); objdal.AddNewStudentDetails(student); }