protected void btnAddBuilding_Click(object sender, EventArgs e) { string strScript = string.Empty; if (txtbuildingname.Text=="") { strScript = "<script>"; strScript = strScript + "alert('Please Enter Building Name.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } using (Neophotonics_webDbHelper BAdbHelper = new Neophotonics_webDbHelper()) { BAdbHelper.AddParameter("@BuildingName", SqlDbType.VarChar, txtbuildingname.Text); BAdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; BAdbHelper.Command.CommandText = "SP_Building_Add"; int i = BAdbHelper.ExecuteNoneQuery(); Response.Redirect("~/Setup/BuildingView.aspx?RespMsg=Building Added Successfully", true); } }
protected void btnAddReader_Click(object sender, EventArgs e) { string strScript = ""; if ( txtdevicename.Text == "") { strScript = "<script>"; strScript = strScript + "alert('Please Enter Device Name.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } if (drpdevicetype.SelectedItem.Text == "Reader" && txtdeviceip.Text == "") { strScript = "<script>"; strScript = strScript + "alert('Please Enter Device IP Address.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } if (txtdeviceip.Text != "") { if (txtdeviceip.Text.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries).Length == 4) { IPAddress ipAddr; if (IPAddress.TryParse(txtdeviceip.Text, out ipAddr)) { // IP is valid } else { txtdeviceip.Text = ""; strScript = "<script>"; strScript = strScript + "alert('Please Enter valid IP Address.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } // invalid IP } else { txtdeviceip.Text = ""; strScript = "<script>"; strScript = strScript + "alert('Please Enter valid IP Address.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } } if (drpdevicetype.SelectedItem.Text == "Handheld" && txtDeviceMac.Text == "") { strScript = "<script>"; strScript = strScript + "alert('Please Enter Device MAC Address.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } using (Neophotonics_webDbHelper BAdbHelper = new Neophotonics_webDbHelper()) { BAdbHelper.AddParameter("@DeviveType", SqlDbType.VarChar, drpdevicetype.SelectedItem.Text); BAdbHelper.AddParameter("@DeviceName", SqlDbType.VarChar, txtdevicename.Text); BAdbHelper.AddParameter("@DeviceMac", SqlDbType.VarChar, txtDeviceMac.Text); BAdbHelper.AddParameter("@DeviceIpAddress", SqlDbType.VarChar, txtdeviceip.Text); // BAdbHelper.AddParameter("@DevicePortNo", SqlDbType.VarChar, txtDeviceport.Text); BAdbHelper.AddParameter("@DeviceUniqueId", SqlDbType.VarChar, txtDeviceuniqueId.Text); BAdbHelper.AddParameter("@NoAntennas", SqlDbType.VarChar, txtantenna.Text); BAdbHelper.AddParameter("@Isactive", SqlDbType.VarChar,chkIsactive.Checked); BAdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; BAdbHelper.Command.CommandText = "SP_Reader_Add"; int i = BAdbHelper.ExecuteNoneQuery(); Response.Redirect("~/Setup/ReaderView.aspx?RespMsg=Reader Added Successfully", true); } }