protected void btnDelete_Click(object sender, EventArgs e)
    {
        qOrg_GroupRequests request = new qOrg_GroupRequests(Convert.ToInt32(Request.QueryString["groupRequestID"]));
        request.Available = "No";
        request.MarkAsDelete = 0;
        request.Update();

        Response.Redirect("/manage/members/group-requests-list.aspx");
    }
    protected void btnSave_OnClick(object sender, System.EventArgs e)
    {
        qOrg_GroupRequests request = new qOrg_GroupRequests(Convert.ToInt32(Request.QueryString["groupRequestID"]));
        request.Status = ddlStatus.SelectedValue;
        request.AdvisorEmail = txtAdvisorEmail.Text;
        request.GroupShortName = txtGroupName.Text;
        request.PrincipalEmail = txtPrincipalEmail.Text;
        request.AdvisorNotes = txtAdvisorNotes.Text;
        request.GroupNotes = txtGroupNotes.Text;
        request.SchoolNotes = txtSchoolNotes.Text;
        request.PrincipalNotes = txtPrincipalNotes.Text;
        if (!String.IsNullOrEmpty(ddlSchools.SelectedValue))
            request.SchoolID = Convert.ToInt32(ddlSchools.SelectedValue);
        request.Update();

        Response.Redirect("/manage/members/group-request-edit.aspx?groupRequestID=" + Request.QueryString["groupRequestID"]);
    }
    protected void btnApproveRequest_Click(object sender, EventArgs e)
    {
        qOrg_GroupRequests request = new qOrg_GroupRequests(Convert.ToInt32(Request.QueryString["groupRequestID"]));
        qPtl_User user = new qPtl_User(Convert.ToInt32(Context.Items["UserID"]));
        request.ApprovedBy = user.UserName;
        request.WhenApproved = DateTime.Now;
        request.Status = "Pending-WaitingPrincipalApproval";
        request.Update();

        // send email to principal
        int principal_email_id = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["GroupRequest_principal_EmailID"]);
        qCom_EmailTool email = new qCom_EmailTool(principal_email_id);
        string principal_name = request.PrincipalRole + " " + request.PrincipalLastName;
        email.SendDatabaseMail(request.PrincipalEmail, principal_email_id, 0, request.GroupShortName, request.GroupShortName, request.WhyJoin, Convert.ToString(request.GroupRequestID), principal_name, false);

        Response.Redirect(Request.Url.ToString());
    }