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;
}
}
}
}
