protected void saveStudent_Click(object sender, EventArgs e)
{
//check if we have an id to decide if we're adding or editing
Int32 StudentID = 0;
if (!string.IsNullOrEmpty(Request.QueryString["StudentID"]))
{
StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
}
//connect to db
var conn = new contosoEntities1();
//use the Student class to create the new student object
Student d = new Student();
//fill the properties of the new student object
d.LastName = txtLast.Text;
d.FirstName = txtFirst.Text;
d.EnrollmentDate = Convert.ToDateTime(txtDate.Text);
//save the new object from database
if (StudentID == 0)
{
conn.Students.Add(d);
}
else
{
d.StudentID = StudentID;
conn.Students.Attach(d);
conn.Entry(d).State = System.Data.Entity.EntityState.Modified;
};
conn.SaveChanges();
//redirect to student page
Response.Redirect("students.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
//check if we have an id to decide if we're adding or editing
Int32 DepartmentID = 0;
if (!string.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
{
DepartmentID = Convert.ToInt32(Request.QueryString["departmentID"]);
}
//connect to db
var conn = new contosoEntities1();
//use teh depart ment class to create the new department object
Department d = new Department();
//fill the properties of the new department object
d.Name = txtDepartment.Text;
d.Budget = Convert.ToDecimal(txtbudget.Text);
//save the new object from database
if (DepartmentID == 0)
{
conn.Departments.Add(d);
}
else
{
d.DepartmentID = DepartmentID;
conn.Departments.Attach(d);
conn.Entry(d).State = System.Data.Entity.EntityState.Modified;
};
conn.SaveChanges();
//redirect to department page
Response.Redirect("departments.aspx");
}
