protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Elderlies objElder = new Elderlies(); objElder.ElderID = Request.QueryString["ElderID"]; objElder.getDetails(); objElder.status = objElder.getStatus(); lblElderName.Text = objElder.FullName; lblElderID.Text = objElder.SerialNo; lblAddress.Text = objElder.Address; lblMeal.Text = objElder.Meal; if (objElder.getStatus() == "Y") { rblSuccess.SelectedIndex = 0; } else if (objElder.getStatus() == "P") { rblSuccess.SelectedIndex = 1; txtFeedback.Visible = true; } else { rblSuccess.SelectedIndex = 2; txtFeedback.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.QueryString["elderid"] != null) { objElder.ElderID = Request.QueryString["elderid"]; int errorCode = objElder.getDetails(); if (errorCode == 0) { lblId.Text = objElder.ElderID.ToString(); lblSerialNo.Text = objElder.SerialNo.ToString(); txtName.Text = objElder.FullName.ToString(); txtAddress.Text = objElder.Address.ToString(); txtContactNo.Text = objElder.Contact.ToString(); txtDietary.Text = objElder.Dietary.ToString(); txtHealth.Text = objElder.HealthCondition.ToString(); } else if (errorCode == -2) { lblMessage.Text = "Unable to retrieve Elder Details for ID" + objElder.ElderID; lblMessage.ForeColor = System.Drawing.Color.Red; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { displayVolunteerDropDownList(); if (Request.QueryString["elderid"] != null) { Elderlies objElder = new Elderlies(); objElder.ElderID = Request.QueryString["elderid"]; int errorCode = objElder.getDetails(); if (errorCode == 0) { lblName.Text = objElder.FullName; lblSerialNo.Text = objElder.SerialNo; dd_Volunteer.SelectedValue = objElder.volunteer.ToString(); } else if (errorCode == -2) { lblMessage.Text = "Unable to retrieve Elder details for ID " + objElder.ElderID; lblMessage.ForeColor = System.Drawing.Color.Red; } } } }
protected void Page_Load(object sender, EventArgs e) { Elderlies objElder = new Elderlies(); if (!Page.IsPostBack) { if (Request.QueryString["elderid"] != null) { objElder.ElderID = (Request.QueryString["elderid"]); int errorCode = objElder.getDetails(); if (errorCode == 0) { lblName.Text = objElder.FullName; lblSerialNo.Text = objElder.SerialNo; dd_Prepare.SelectedValue = objElder.Prepare.ToString(); ddlTiming.SelectedValue = objElder.Timing.ToString(); } else if (errorCode == -2) { lblMessage.Text = "Unable to retrieve Elder details for ID " + objElder.ElderID; lblMessage.ForeColor = System.Drawing.Color.Red; } } if (objElder.getMeal() == "Lunch") { rblMeal.SelectedIndex = 0; } else { rblMeal.SelectedIndex = 1; } } }
protected void btnSave_Click(object sender, EventArgs e) { Elderlies objElder = new Elderlies(); objElder.ElderID = Request.QueryString["ElderID"]; objElder.getDetails(); objElder.status = objElder.getStatus(); if (rblSuccess.SelectedIndex == 0) { lblChanges.Text = objElder.setSuccess(); txtFeedback.Visible = false; } else { lblChanges.Text = objElder.setUnsuccess(); txtFeedback.Visible = true; //Feedback coding if (txtFeedback.Text.Length > 1) { Volunteers objVolunteer = new Volunteers(); objVolunteer.EmailAddr = Session["LoginID"].ToString(); objVolunteer.Password = objVolunteer.getPass(); objVolunteer.getDetails(); string feedbacktext = txtFeedback.Text; string strConn = ConfigurationManager.ConnectionStrings["P2ConnectionString"].ToString(); SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand("INSERT INTO Feedback(VolunteerID, ElderID, Feedback, DateCreated) Output inserted.FeedbackID " + "Values(@volunteerid, @ElderID, @feedbacktext, GetDate())", conn); string elderid = Request.QueryString["ElderID"]; cmd.Parameters.AddWithValue("@volunteerid", objVolunteer.VolunteerID); cmd.Parameters.AddWithValue("@ElderID", elderid); cmd.Parameters.AddWithValue("@feedbacktext", feedbacktext); SqlDataAdapter daFeedback = new SqlDataAdapter(cmd); DataSet result = new DataSet(); conn.Open(); int id = cmd.ExecuteNonQuery(); conn.Close(); lblFeedback.Text = "Success Sent!"; } else { lblFeedback.Text = "Error!"; } } }