// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, StudentsManagerContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMvc();
}
private void LoadDataIntoDataGridView()
{
List <Student> students = new List <Student>();
using (StudentsManagerContext db = new StudentsManagerContext())
{
students = db.Students.ToList();
}
StudentsDataGridView.DataSource = students;
}
private void DeleteStudent_Click(object sender, EventArgs e)
{
int index = StudentsDataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected);
int studentId = Convert.ToInt32(StudentsDataGridView.Rows[index].Cells["StudentId"].Value);
using (StudentsManagerContext db = new StudentsManagerContext())
{
Student student = db.Students.Find(studentId);
db.Students.Remove(student);
db.SaveChanges();
}
MessageBox.Show("Student record is deleted from the system.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
// Reload data into DataGridView ...
LoadDataIntoDataGridView();
}
private void SearchButton_Click(object sender, EventArgs e)
{
List <Student> students = new List <Student>();
using (StudentsManagerContext db = new StudentsManagerContext())
{
if ((SearchColumnComboBox.Text == "") || (SearchColumnComboBox.Text == "Full Name"))
{
students = db.Students.Where(x => x.FullName.Contains(SearchTextBox.Text)).ToList();
}
if (SearchColumnComboBox.Text == "Email")
{
students = db.Students.Where(x => x.Email.Contains(SearchTextBox.Text)).ToList();
}
}
StudentsDataGridView.DataSource = students;
}
private void SaveRecordButton_Click(object sender, EventArgs e)
{
Student student = new Student();
student.StudentId = StudentId;
student.FullName = FullNameTextBox.Text;
student.Email = EmailTextBox.Text;
student.Mobile = MobileTextBox.Text;
student.Phone = PhoneTextBox.Text;
student.Gender = GetGender();
student.CSharp = CSharpCheckBox.Checked;
student.VBNET = VBNETCheckBox.Checked;
student.HTML = HtmlCheckBox.Checked;
student.Photoshop = PhotoshopCheckBox.Checked;
student.Notes = NotesTextBox.Text;
if (!this.IsUpdate)
{
using (StudentsManagerContext db = new StudentsManagerContext())
{
db.Students.Add(student);
db.SaveChanges();
}
MessageBox.Show("Student record is added to the system.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
using (StudentsManagerContext db = new StudentsManagerContext())
{
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Student record is updated.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
this.Close();
}
private void LoadDataIntoFormIfUpdate()
{
if (this.IsUpdate)
{
Student student = new Student();
using (StudentsManagerContext db = new StudentsManagerContext())
{
student = db.Students.Find(StudentId);
}
FullNameTextBox.Text = student.FullName;
EmailTextBox.Text = student.Email;
MobileTextBox.Text = student.Mobile;
PhoneTextBox.Text = student.Phone;
LoadGender(student);
CSharpCheckBox.Checked = (student.CSharp == true) ? true :false;
VBNETCheckBox.Checked = (student.VBNET == true) ? true : false;
HtmlCheckBox.Checked = (student.HTML == true) ? true : false;
PhotoshopCheckBox.Checked = (student.Photoshop == true) ? true : false;
NotesTextBox.Text = student.Notes;
}
}
public RepositoryBase(StudentsManagerContext context)
{
_context = context;
}
public CourseRepository(StudentsManagerContext context) : base(context)
{
}
public AddressRepository(StudentsManagerContext context) : base(context)
{
}
