protected void LoadData()
{
using (var context = new WIADBEntities())
{
listOfData.DataSource = context.Schools;
listOfData.DataBind();
}
}
protected void LoadSchools()
{
using (var context = new WIADBEntities())
{
ddlSchools.DataSource = context.Schools;
ddlSchools.DataTextField = "Name";
ddlSchools.DataValueField = "Id";
ddlSchools.DataBind();
ddlSchools.Items.Insert(0, new ListItem("Select a School", ""));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt32(ObjectId.Value) > 0)
{
using (var context = new WIADBEntities())
{
var id = Convert.ToInt32(ObjectId.Value);
var obj = context.Schools.Where(x => x.Id == id).FirstOrDefault();
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Address2 = txtAddress2.Text;
obj.City = txtCity.Text;
obj.State = txtState.Text;
obj.Allowed = ckbValid.Checked;
obj.Updated = DateTime.Now;
context.SaveChanges();
}
Response.Redirect("~/schools/Default.aspx", true);
}
else
{
using (var context = new WIADBEntities())
{
var obj = new School();
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Address2 = txtAddress2.Text;
obj.City = txtCity.Text;
obj.State = txtState.Text;
obj.Allowed = ckbValid.Checked;
obj.Created = DateTime.Now;
obj.Updated = DateTime.Now;
context.AddToSchools(obj);
context.SaveChanges();
}
Response.Redirect("~/Schools/Default.aspx", true);
}
}
catch (Exception ex)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && !String.IsNullOrEmpty(Request.QueryString["id"].ToString()))
{
using (var context = new WIADBEntities())
{
var id = Convert.ToInt32(Request.QueryString["id"]);
var course = context.Courses.Where(x => x.Id == id).FirstOrDefault();
if (course != null)
{
ObjectId.Value = course.Id.ToString();
txtName.Text = course.Name;
ckbValid.Checked = (bool)course.Allowed;
}
}
}
}
}
protected void listOfData_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
HyperLink linkTo = (HyperLink)e.Item.FindControl("linkTo");
Student course = (Student)e.Item.DataItem;
linkTo.NavigateUrl = "~/Students/Update.aspx?id=" + course.Id.ToString();
Button btnDelete = (Button)e.Item.FindControl("btnDelete");
btnDelete.CommandName = "delete";
btnDelete.CommandArgument = course.Id.ToString();
Label labelSchool = (Label)e.Item.FindControl("labelSchool");
using (var context = new WIADBEntities())
{
var school = context.Schools.Where(x => x.Id == course.SchoolId).FirstOrDefault();
labelSchool.Text = school != null ? school.Name : String.Empty;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadSchools();
if (Request.QueryString["id"] != null && !String.IsNullOrEmpty(Request.QueryString["id"].ToString()))
{
using (var context = new WIADBEntities())
{
var id = Convert.ToInt32(Request.QueryString["id"]);
var student = context.Students.Where(x => x.Id == id).FirstOrDefault();
if (student != null)
{
ObjectId.Value = student.Id.ToString();
txtFirstName.Text = student.FirstName;
txtLastName.Text = student.LastName;
ckbValid.Checked = (bool)student.Allowed;
ddlSchools.SelectedValue = student.SchoolId.ToString();
}
}
}
}
}
protected void listOfData_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
if (e.CommandName == "delete")
{
using (var context = new WIADBEntities())
{
var id = Convert.ToInt32(e.CommandArgument);
var course = context.Schools.Where(x => x.Id == id).FirstOrDefault();
if (course != null)
{
context.Schools.DeleteObject(course);
context.SaveChanges();
}
}
LoadData();
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && !String.IsNullOrEmpty(Request.QueryString["id"].ToString()))
{
using (var context = new WIADBEntities())
{
var id = Convert.ToInt32(Request.QueryString["id"]);
var school = context.Schools.Where(x => x.Id == id).FirstOrDefault();
if (school != null)
{
ObjectId.Value = school.Id.ToString();
txtName.Text = school.Name;
txtAddress.Text = school.Address;
txtAddress2.Text = school.Address2;
txtCity.Text = school.City;
txtState.Text = school.State;
ckbValid.Checked = (bool)school.Allowed;
}
}
}
}
}
