protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
// check the url for an id so we know we are adding or editing
if (!string.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
{
// get id from url
Int32 DepartmentID = Convert.ToInt32(Request.QueryString["departmentID"]);
// connect
var conn = new contosoEntities1();
// lookup the selected department
var objDep = (from d in conn.Departments
where d.DepartmentID == DepartmentID
select d).FirstOrDefault();
// populate the form
txtDepartment.Text = objDep.Name;
txtbudget.Text = objDep.Budget.ToString();
}
}
}
protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// function to delete th edepartment from the gridview
// 1. determine which row in the grid the user clicked
Int32 gridIndex = e.RowIndex;
// 2. find the department id value in the selected row
Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[gridIndex].Value);
// 3. connect to the db
var conn = new contosoEntities1();
// 4. delete the department
/* var objDep = (from d in conn.Departments
* where d.DepartmentID == DepartmentID
* select d).First();*/
Department d = new Department();
d.DepartmentID = DepartmentID;
conn.Departments.Attach(d);
conn.Departments.Remove(d);
conn.SaveChanges();
// 5. refresh the gridview
getDepartments();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
// check the url for an id so we know we are adding or editing
if (!string.IsNullOrEmpty(Request.QueryString["StudentID"]))
{
// get id from url
Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
// connect
var conn = new contosoEntities1();
// lookup the selected student
var objStu = (from d in conn.Students
where d.StudentID == StudentID
select d).FirstOrDefault();
// populate the form
txtLast.Text = objStu.LastName;
txtFirst.Text = objStu.FirstName;
txtDate.Text = objStu.EnrollmentDate.ToString();
}
}
}
protected void getStudents()
{
//connect to db
var conn = new contosoEntities1();
//run the query using LINQ
var Students = from d in conn.Students
select d;
//display query result in gridview
grdStudents.DataSource = Students.ToList();
grdStudents.DataBind();
}
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");
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// function to delete the student from the gridview
// 1. determine which row in the grid the user clicked
Int32 gridIndex = e.RowIndex;
// 2. find the student id value in the selected row
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[gridIndex].Value);
// 3. connect to the db
var conn = new contosoEntities1();
Student d = new Student();
d.StudentID = StudentID;
conn.Students.Attach(d);
conn.Students.Remove(d);
conn.SaveChanges();
// 5. refresh the gridview
getStudents();
}
