protected void btnConfirm_Click(object sender, EventArgs e) { string ID = Request.QueryString["CameraID"]; if (Request.QueryString["CameraID"] != null) { using (var db = new FacilityReservationKioskEntities()) { //update Camera camera = db.Cameras.Find(Convert.ToInt32(ID)); //modify fields camera.FacilityID = ddlFacility.SelectedValue; camera.IPAddress = txtIpAddress.Text; camera.MinimumDensity = float.Parse(txtMinDensity.Text); camera.MaximumDensity = float.Parse(txtMaxDensity.Text); db.SaveChanges(); } lblUpdate.Text = "Record Update Successfully"; } }
public void BindGridView() { using (var db = new FacilityReservationKioskEntities()) { var result = from b in db.Cameras select new {b.CameraID, b.FacilityID, b.IPAddress, b.MinimumDensity, b.MaximumDensity }; grdCamera.DataSource = result.ToList(); grdCamera.DataBind(); } }
private void BindDDL() { using (var db = new FacilityReservationKioskEntities()) { var facility = (from b in db.Facilities select new { b.FacilityID }).ToList(); ddlFacility.DataValueField = "FacilityID"; ddlFacility.DataTextField = "FacilityID"; ddlFacility.DataSource = facility; ddlFacility.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { string search = txtSearch.Text; using (var db = new FacilityReservationKioskEntities()) { var result = from b in db.Cameras where b.FacilityID == search select new {b.CameraID, b.FacilityID, b.IPAddress, b.MinimumDensity, b.MaximumDensity }; //loop through to print out grdCamera.DataSource = result.ToList(); grdCamera.DataBind(); } }
protected void btnCreate_Click(object sender, EventArgs e) { using (var db = new FacilityReservationKioskEntities()) { //create new camera Camera camera = new Camera(); camera.FacilityID = ddlFacility.SelectedValue; camera.IPAddress = txtIpAddress.Text; camera.MinimumDensity = float.Parse(txtMinDensity.Text); camera.MaximumDensity = float.Parse(txtMaxDensity.Text); db.Cameras.Add(camera); db.SaveChanges(); } lblCreate.Text = "Create Record Successful"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindDDL(); if (Request.QueryString["CameraID"] != null) { lblCam.Text = Request.QueryString["CameraID"]; using (var db = new FacilityReservationKioskEntities()) { Camera camera = db.Cameras.Find(Convert.ToInt32(lblCam.Text)); txtIpAddress.Text = camera.IPAddress; txtMinDensity.Text = camera.MinimumDensity.ToString(); txtMaxDensity.Text = camera.MaximumDensity.ToString(); //lblFacilityID.Text = camera.FacilityID; // ddlFacility.Items.FindByValue(camera.FacilityID); ddlFacility.SelectedValue = camera.FacilityID; } } } }