protected void btnDetails_Click(object sender, EventArgs e) { mvEmergencies.ActiveViewIndex = 1; int hash = sender.GetHashCode(); foreach (RepeaterItem item in rEmergencies.Items) { LinkButton button = item.FindControl("btnDetails") as LinkButton; if (button.GetHashCode() == hash) { TableCell tc = item.FindControl("tcEmergencyID") as TableCell; int EmergencyID = Convert.ToInt32(tc.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblEmergency emergency = db.tblEmergencies.Where(x => x.EmergencyID == EmergencyID).FirstOrDefault(); tblUser user = db.tblUsers.Where(x => x.UserID == emergency.UserID).FirstOrDefault(); lblEmergencyID.Text = emergency.EmergencyID.ToString(); lblUserID.Text = user.UserID.ToString(); lblTitle.Text = emergency.EmergencyTitle.ToString(); ddlStatus.SelectedValue = emergency.EmergencyStatus; emergency.IsSeen = true; db.SubmitChanges(); } } } }
public static double getLatitude(int EmergencyID) { using (DatabaseDataContext db = new DatabaseDataContext()) { tblEmergency emergency = db.tblEmergencies.Where(x => x.EmergencyID == EmergencyID).FirstOrDefault(); return(emergency.EmergencyLatitude); } }
protected void btnSubmit_Click(object sender, EventArgs e) { using (DatabaseDataContext con = new DatabaseDataContext()) { #region checks hideAllPlaceholders(); if (SessionManager.UserID == 0) { showError("You must be logged in to use this feature!"); Utilities.clearAllTextBoxes(viewMain); return; } string EncodedResponse = Request.Form["g-Recaptcha-Response"]; bool IsCaptchaValid = (ReCaptcha.Validate(EncodedResponse) == "true" ? true : false); if (!IsCaptchaValid) { showError("Prove that you are not a robot!"); return; } if (string.IsNullOrEmpty(txtEmergTitle.Text)) { showError("Emergency title is empty!"); return; } #endregion tblSession session = con.tblSessions.Where(x => x.SessionID == SessionManager.SessionID).FirstOrDefault(); try { tblEmergency emergency = new tblEmergency { EmergencyTitle = txtEmergTitle.Text, EmergencyLatitude = session.SessionLatitude, EmergencyLongitude = session.SessionLongitude, EmergencyStatus = "Pending", IsSeen = false, EmergencyDate = DateTime.UtcNow, UserID = SessionManager.UserID }; con.tblEmergencies.InsertOnSubmit(emergency); con.SubmitChanges(); showSuccess("Emergency notification has been issued successfully!"); Utilities.clearAllTextBoxes(viewMain); NotificationManager.emergencySent(); } catch (Exception ex) { showError("Error: " + ex); Utilities.clearAllTextBoxes(viewMain); } } }
protected void btnBack_Click(object sender, EventArgs e) { int EmergencyID = Convert.ToInt32(lblEmergencyID.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblEmergency emergency = db.tblEmergencies.Where(x => x.EmergencyID == EmergencyID).FirstOrDefault(); emergency.EmergencyStatus = ddlStatus.SelectedValue; db.SubmitChanges(); List <tblEmergency> emergencies = db.tblEmergencies.ToList(); emergencies.Reverse(); //Populates the Panels ControlManager.populateControl(emergencies, rEmergencies); } mvEmergencies.ActiveViewIndex = 0; }