protected void Submit_Click(object sender, EventArgs e) { using (var db = new AzureNOLBContext()) { var location = db.Locations .Where(x => x.StreetAddress == txtStreetAddress.Text.Trim() && x.City == txtCity.Text.Trim() && x.State == txtState.Text.Trim() && x.Floor == txtFloor.Text.Trim() && x.RoomNumber == txtRoom.Text.Trim()) .SingleOrDefault(); if (location == null) { location = new Location { City = txtCity.Text.Trim(), Floor = txtFloor.Text.Trim(), RoomNumber = txtRoom.Text.Trim(), StreetAddress = txtStreetAddress.Text.Trim(), State = txtState.Text.Trim() }; } var newRequest = new Request { TypeOfEmergency = hdnTypeOfEmergency.Value, NumberOfPeople = int.TryParse(hdnNumOfPeople.Value, out int numOfPeople) ? numOfPeople : 0, NumberOfImmobilePeople = int.TryParse(hdnNumOfImmobilePeople.Value, out int numOfImmobile) ? numOfImmobile : 0, InjuriesOrOtherInfo = txtInjuriesOrSpecialInfo.Text, AccessibleOutsideWindow = cbOutsideWindow.Checked, FirstName = txtFirstName.Text, LastName = txtLastName.Text, PhoneNumber = txtPhone.Text, Latitude = decimal.TryParse(txtLatitude.Text, out decimal latitude) ? latitude : 0.0M, Longitude = decimal.TryParse(txtLongitude.Text, out decimal longitude) ? longitude : 0.0M, Location = location }; var datetime = DateTimeOffset.Parse(hdnDateTime.Value); var adjustedDatetime = datetime.AddHours(int.Parse(hdnTimeOffset.Value)); newRequest.TimeStamp = adjustedDatetime; db.Requests.Add(newRequest); db.SaveChanges(); lblMessage.Text = "Request Successfully Submitted."; hdnDateTime.Value = DateTimeOffset.Now.ToString(); hdnTypeOfEmergency.Value = "Unknown"; } }
protected void RequestDataList_OnItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "ClearRequest") { var id = int.Parse(e.CommandArgument.ToString()); using (var db = new AzureNOLBContext()) { var item = db.Requests.SingleOrDefault(x => x.RequestID == id); if (item == null) { return; } else { item.Cleared = true; db.SaveChanges(); } } } }
protected void btnSubmit_ClickQR(object sender, EventArgs e) { //Creates New Instance of a QR using (var qrCode = new QRCodeGenerator()) { var qrCodeString = GenerateQrCodeString(); //Append URL to qrCode var dataURL = qrCode.CreateQrCode(qrCodeString, QRCodeGenerator.ECCLevel.Q); using (var code = new QRCode(dataURL)) { //Images qrCode and determines dimmensions var imgBarCode = new System.Web.UI.WebControls.Image { Height = 400, Width = 400 }; using (Bitmap bitMap = code.GetGraphic(20)) { using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, ImageFormat.Png); var byteImage = ms.ToArray(); imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } PlaceHolder1.Controls.Add(imgBarCode); SetAddressLabel(); } //Images qrCode and determines dimmensions var imgBarCodePrint = new System.Web.UI.WebControls.Image { Height = 800, Width = 800 }; using (Bitmap bitMap = code.GetGraphic(20)) { using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, ImageFormat.Png); var byteImage = ms.ToArray(); imgBarCodePrint.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } PlaceHolder2.Controls.Add(imgBarCodePrint); SetAddressLabel(); } } } using (var db = new AzureNOLBContext()) { var location = db.Locations .Where(x => x.StreetAddress == txtStreetAddress.Text.Trim() && x.City == txtCity.Text.Trim() && x.State == txtState.Text.Trim() && x.Floor == txtFloor.Text.Trim() && x.RoomNumber == txtRoom.Text.Trim()) .SingleOrDefault(); if (location == null) { location = new Location { City = txtCity.Text.Trim(), Floor = txtFloor.Text.Trim(), RoomNumber = txtRoom.Text.Trim(), StreetAddress = txtStreetAddress.Text.Trim(), State = txtState.Text.Trim() }; db.Locations.Add(location); db.SaveChanges(); } } }