Пример #1
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (TextBox2.Text != "")
                {
                    SqlDataSource12.SelectParameters["Modelo"].DefaultValue   = TextBox2.Text;
                    SqlDataSource12.SelectParameters["ID_Marca"].DefaultValue = DropDownList2.SelectedValue;
                    SqlDataSource12.DataSourceMode = SqlDataSourceMode.DataReader;
                    SqlDataReader total;
                    total = (SqlDataReader)SqlDataSource12.Select(DataSourceSelectArguments.Empty);
                    if (total.Read())
                    {
                        if (Convert.ToInt32(total["Total"]) > 0)
                        {
                            Response.Write("<script>alert('El modelo y la marca del auto ya se encuentra registrado')</script>");
                        }
                        else
                        {
                            string ms = "";
                            ms = Datos.InsertaModelo(TextBox2.Text, Convert.ToInt32(DropDownList2.SelectedValue));
                            Response.Write("<script>alert('" + ms + "')</script>");
                            Response.Redirect("CategoriaB.aspx");
                            borrar();
                        }
                    }
                    else
                    {
                        Response.Write("<script>alert('Error!, no se pudo leer datos. Consulte a su adminstrador tecnico')</script>");
                    }
                }
                else
                {
                    Response.Write("<script>alert('Error, resive los datos')</script>");
                }
            }

            catch
            {
                Response.Write("<script>alert('Error, resive los datos')</script>");
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            DataView    dv  = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
            DataRowView drv = dv[0];

            Table1.Rows[1].Cells[0].Text = drv["BUGS"].ToString();

            DataView    dv1  = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
            DataRowView drv1 = dv1[0];

            Table1.Rows[1].Cells[1].Text = drv1["BUGS"].ToString();

            DataView    dv2  = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty);
            DataRowView drv2 = dv2[0];

            Table1.Rows[1].Cells[2].Text = drv2["BUGS"].ToString();

            DataView    dv3  = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
            DataRowView drv3 = dv3[0];

            Table1.Rows[1].Cells[3].Text = drv3["BUGS"].ToString();

            DataView    dv5  = (DataView)SqlDataSource5.Select(DataSourceSelectArguments.Empty);
            DataRowView drv5 = dv5[0];

            Table2.Rows[1].Cells[0].Text = drv5["BUGS"].ToString();

            DataView    dv6  = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty);
            DataRowView drv6 = dv6[0];

            Table2.Rows[1].Cells[1].Text = drv6["BUGS"].ToString();

            DataView    dv7  = (DataView)SqlDataSource7.Select(DataSourceSelectArguments.Empty);
            DataRowView drv7 = dv7[0];

            Table2.Rows[1].Cells[2].Text = drv7["BUGS"].ToString();

            DataView    dv8  = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
            DataRowView drv8 = dv8[0];

            Table2.Rows[1].Cells[3].Text = drv8["BUGS"].ToString();

            DataView    dv9  = (DataView)SqlDataSource9.Select(DataSourceSelectArguments.Empty);
            DataRowView drv9 = dv9[0];

            Table3.Rows[1].Cells[0].Text = drv9["BUGS"].ToString();

            DataView    dv10  = (DataView)SqlDataSource10.Select(DataSourceSelectArguments.Empty);
            DataRowView drv10 = dv10[0];

            Table3.Rows[1].Cells[1].Text = drv10["BUGS"].ToString();

            DataView    dv11  = (DataView)SqlDataSource11.Select(DataSourceSelectArguments.Empty);
            DataRowView drv11 = dv11[0];

            Table3.Rows[1].Cells[2].Text = drv11["BUGS"].ToString();

            DataView    dv12  = (DataView)SqlDataSource12.Select(DataSourceSelectArguments.Empty);
            DataRowView drv12 = dv12[0];

            Table3.Rows[1].Cells[3].Text = drv12["BUGS"].ToString();
        }
Пример #3
0
    protected void btnEmail_Click(object sender, EventArgs e)
    {
        strEmail = txtEmail.Text;

        DataSourceSelectArguments srUserID_IDStr = new DataSourceSelectArguments();
        DataView dvUserID_IDStr = (DataView)SqlDataSource5.Select(srUserID_IDStr);

        if (dvUserID_IDStr.Count != 0)
        {
            strUserID_ID = dvUserID_IDStr[0][0].ToString();
        }

        DataSourceSelectArguments srUserID_SSOStr = new DataSourceSelectArguments();
        DataView dvUserID_SSOStr = (DataView)SqlDataSource14.Select(srUserID_SSOStr);

        if (dvUserID_SSOStr.Count != 0)
        {
            strUserID_SSO = dvUserID_SSOStr[0][0].ToString();
        }

        DataSourceSelectArguments srTokenUser = new DataSourceSelectArguments();
        DataView dvTokenUser = (DataView)SqlDataSource4.Select(srTokenUser);

        if (dvTokenUser.Count != 0)
        {
            strTokenUser = dvTokenUser[0][0].ToString();
        }

        DataSourceSelectArguments srTokenPassStr = new DataSourceSelectArguments();
        DataView dvTokenPassStr = (DataView)SqlDataSource12.Select(srTokenPassStr);

        if (dvTokenPassStr.Count != 0)
        {
            strTokenPass = dvTokenPassStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgTempStr = new DataSourceSelectArguments();
        DataView dvOrgTempStr = (DataView)SqlDataSource110.Select(srOrgTempStr);

        if (dvOrgTempStr.Count != 0)
        {
            strOrgTemp = dvOrgTempStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgTempIDStr = new DataSourceSelectArguments();
        DataView dvOrgTempIDStr = (DataView)SqlDataSource118.Select(srOrgTempIDStr);

        if (dvOrgTempIDStr.Count != 0)
        {
            strOrgTempID = dvOrgTempIDStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgTempNameStr = new DataSourceSelectArguments();
        DataView dvOrgTempNameStr = (DataView)SqlDataSource124.Select(srOrgTempNameStr);

        if (dvOrgTempNameStr.Count != 0)
        {
            strOrgTempName = dvOrgTempNameStr[0][0].ToString();
        }


        DataSourceSelectArguments srOrgIDStr = new DataSourceSelectArguments();
        DataView dvOrgIDStr = (DataView)SqlDataSource111.Select(srOrgIDStr);

        if (dvOrgIDStr.Count != 0)
        {
            strOrgID = dvOrgIDStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgAccessRequestedStr = new DataSourceSelectArguments();
        DataView dvOrgAccessRequestedStr = (DataView)SqlDataSource112.Select(srOrgAccessRequestedStr);

        if (dvOrgAccessRequestedStr.Count != 0)
        {
            strOrgAccessRequested = dvOrgAccessRequestedStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgModAccessRequestedStr = new DataSourceSelectArguments();
        DataView dvOrgModAccessRequestedStr = (DataView)SqlDataSource113.Select(srOrgModAccessRequestedStr);

        if (dvOrgModAccessRequestedStr.Count != 0)
        {
            strOrgModAccessRequested = dvOrgModAccessRequestedStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgLicAccessRequestedStr = new DataSourceSelectArguments();
        DataView dvOrgLicAccessRequestedStr = (DataView)SqlDataSource114.Select(srOrgLicAccessRequestedStr);

        if (dvOrgLicAccessRequestedStr.Count != 0)
        {
            strOrgLicAccessRequested = dvOrgLicAccessRequestedStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrgMembershipUserIDStr = new DataSourceSelectArguments();
        DataView dvOrgMembershipUserIDStr = (DataView)SqlDataSource115.Select(srOrgMembershipUserIDStr);

        if (dvOrgMembershipUserIDStr.Count != 0)
        {
            strOrgMembershipUserID = dvOrgMembershipUserIDStr[0][0].ToString();
        }

        DataSourceSelectArguments srUserPasswordExpiryDt = new DataSourceSelectArguments();
        DataView dvUserPasswordExpiryDt = (DataView)SqlDataSource116.Select(srUserPasswordExpiryDt);

        if (dvUserPasswordExpiryDt.Count != 0)
        {
            strDateUserPasswordExpiry = dvUserPasswordExpiryDt[0][0].ToString();
        }

        DataSourceSelectArguments srUserPasswordChangedDt = new DataSourceSelectArguments();
        DataView dvUserPasswordChangedDt = (DataView)SqlDataSource126.Select(srUserPasswordChangedDt);

        if (dvUserPasswordChangedDt.Count != 0)
        {
            strDateUserPasswordChanged = dvUserPasswordChangedDt[0][0].ToString();
        }



        DataSourceSelectArguments srUserPasswordResetTokenDt = new DataSourceSelectArguments();
        DataView dvUserPasswordResetTokenDt = (DataView)SqlDataSource122.Select(srUserPasswordResetTokenDt);

        if (dvUserPasswordResetTokenDt.Count != 0)
        {
            strDatePasswordResetToken = dvUserPasswordResetTokenDt[0][0].ToString();
        }

        DataSourceSelectArguments srDateRegisteredDt = new DataSourceSelectArguments();
        DataView dvDateRegisteredDt = (DataView)SqlDataSource121.Select(srDateRegisteredDt);

        if (dvDateRegisteredDt.Count != 0)
        {
            strDateRegistered = dvDateRegisteredDt[0][0].ToString();
        }

        DataSourceSelectArguments srUserTempDetailsStr = new DataSourceSelectArguments();
        DataView dvUserTempDetailsStr = (DataView)SqlDataSource117.Select(srUserTempDetailsStr);

        if (dvUserTempDetailsStr.Count != 0)
        {
            strUserID_TempID = dvUserTempDetailsStr[0][0].ToString();
        }

        DataSourceSelectArguments srOrganisationRequestStr = new DataSourceSelectArguments();
        DataView dvOrganisationRequestStr = (DataView)SqlDataSource119.Select(srOrganisationRequestStr);

        if (dvOrganisationRequestStr.Count != 0)
        {
            strOrganisationRequest = dvOrganisationRequestStr[0][0].ToString();
        }


        DataSourceSelectArguments srUserID_UPMStr = new DataSourceSelectArguments();
        DataView dvUserID_UPMStr = (DataView)SqlDataSource120.Select(srUserID_UPMStr);

        if (dvUserID_UPMStr.Count != 0)
        {
            strUserID_UPM = dvUserID_UPMStr[0][0].ToString();
        }


        DataSourceSelectArguments srEventTypeRejectedStr = new DataSourceSelectArguments();
        DataView dvEventTypeRejectedStr = (DataView)SqlDataSource123.Select(srEventTypeRejectedStr);

        if (dvEventTypeRejectedStr.Count != 0)
        {
            strEventTypeRejected = dvEventTypeRejectedStr[0][0].ToString();
        }



        dtDateToday = DateTime.Now;

        /*
         * Password expiry notification and countdown
         *
         */

        dtDateUserPasswordExpiry = null;

        if (!string.IsNullOrEmpty(strDateUserPasswordExpiry))
        {
            dtDateUserPasswordExpiry = DateTime.ParseExact(strDateUserPasswordExpiry, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
            dtDateUserPasswordExpiryForSubtraction = DateTime.ParseExact(strDateUserPasswordExpiry, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
        }
        if (dtDateUserPasswordExpiry != null && dtDateToday > dtDateUserPasswordExpiry && strOrgID != "7c310be0-c20f-de11-b526-0022642a33b2")
        {
            divPasswordExpiry.Visible   = true;
            lblPasswordExpiry.Text      = "EDEN password has expired";
            lblPasswordExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divPasswordExpiry.Visible = false;
        }

        /*
         * Registration expiry
         *
         */

        if (!string.IsNullOrEmpty(strDateRegistered))
        {
            dtDateRegistered = DateTime.ParseExact(strDateRegistered, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
            tsDateRegistrationValidTimeRemaining = dtDateRegistered.AddHours(+24).Subtract(DateTime.Now);
        }

        if (strUserID_SSO == null && dtDateRegistered != null && strDateRegistered != null && dtDateRegistered < DateTime.Now.AddHours(-24))
        {
            divRegistrationExpiry.Visible   = true;
            lblRegistrationExpiry.Text      = "<i>Registration token has expired.</i> <br />- User's registration must be deleted to allow re-registration";
            lblRegistrationExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divRegistrationExpiry.Visible = false;
        }

        if (strUserID_SSO == null && dtDateRegistered != null && strDateRegistered != null && dtDateRegistered > DateTime.Now.AddHours(-24))
        {
            divRegistrationExpiry.Visible   = true;
            lblRegistrationExpiry.Text      = "Registration token is valid.<br />- The account verification link can be copied and emailed to the user if the notification has been blocked or re-routed. <br/>- This link is valid until " + dtDateRegistered.AddHours(+24) + ". Remaining time: <b>" + tsDateRegistrationValidTimeRemaining.ToString(@"hh\:mm") + "</b> hours";
            lblRegistrationExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }
        else
        {
            divRegistrationExpiry.Visible = false;
        }

        if (dtDateRegistered == null)
        {
            divRegistrationExpiry.Visible = false;
        }

        if (strUserID_SSO != null)
        {
            divRegistrationExpiry.Visible = false;
        }



        /*
         * Password reset token expiry
         *
         */
        //dtDatePasswordResetToken='';
        if (!string.IsNullOrEmpty(strDatePasswordResetToken))
        {
            dtDatePasswordResetToken = DateTime.ParseExact(strDatePasswordResetToken, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
            tsDatePasswordResetTokenTimeRemaining = dtDatePasswordResetToken.AddHours(+24).Subtract(DateTime.Now);
        }

        if (strUserID_SSO != null && dtDatePasswordResetToken != null && strDatePasswordResetToken != null && dtDatePasswordResetToken < DateTime.Now.AddHours(-24))
        {
            divPasswordResetTokenExpiry.Visible   = true;
            lblPasswordResetTokenExpiry.Text      = "<br /><i>Password reset token has expired.</i> <br />- The user will need to be begin the password reset process again and generate a new token.";
            lblPasswordResetTokenExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divPasswordResetTokenExpiry.Visible = false;
        }

        if (strUserID_SSO != null && dtDatePasswordResetToken != null && dtDatePasswordResetToken > DateTime.Now.AddHours(-24))
        {
            divPasswordResetTokenExpiry.Visible   = true;
            lblPasswordResetTokenExpiry.Text      = "<br />Password reset token is valid.<br />- The password reset token can be copied and emailed to the user.<br/>- This token is valid until " + dtDatePasswordResetToken.AddHours(+24) + ". Remaining time: <b>" + tsDatePasswordResetTokenTimeRemaining.ToString(@"hh\:mm") + "</b> hours (after which the user will need to be begin the password reset process again and generate a new token).";
            lblPasswordResetTokenExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }

        if (dtDatePasswordResetToken == null)
        {
            divPasswordResetTokenExpiry.Visible = false;
        }

        if (strUserID_ID == null &&
            strUserID_SSO == null &&
            strUserID_TempID == null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID == null &&
            strTokenUser == null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divEmailNotFound.Visible   = true;
            lblEmailNotFound.Text      = "Email address not found";
            lblEmailNotFound.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divEmailNotFound.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO == null &&
            strUserID_TempID == null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID == null &&
            strTokenUser != null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divUserNoConfirmationClicked.Visible   = true;
            lblUserNoConfirmationClicked.Text      = "Status: User has not clicked confirmation email and signed in";
            lblUserNoConfirmationClicked.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserNoConfirmationClicked.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID == null &&
            strTokenUser != null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divUserConfirmSignedNoStep1.Visible   = true;
            lblUserConfirmSignedNoStep1.Text      = "Status: EDEN Portal Access Request - Step 1: User has clicked confirmation email, but has not selected an organisation";
            lblUserConfirmSignedNoStep1.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserConfirmSignedNoStep1.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID != null &&
            strTokenUser != null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divUserConfirmSignedStep2.Visible    = true;
            divUserConfirmTempOrgDetails.Visible = true;
            lblUserConfirmSignedStep2.Text       = "Status: EDEN Portal Access Request - Step 2: User has selected an organisation, but has not yet added their personal and contact details";
            lblUserConfirmSignedStep2.ForeColor  = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserConfirmSignedStep2.Visible    = false;
            divUserConfirmTempOrgDetails.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strOrgID == null &&
            strOrgTemp != null &&
            strTokenUser != null
            )
        {
            divUserConfirmSignedLAStep2.Visible   = true;
            divUserConfirmTempOrgDetails.Visible  = true;
            lblUserConfirmSignedLAStep2.Text      = "Status: EDEN Portal Access Request - Step 2: User has selected an organisation, but has not yet added their personal and contact details";
            lblUserConfirmSignedLAStep2.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserConfirmSignedLAStep2.Visible  = false;
            divUserConfirmTempOrgDetails.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID != null &&
            strOrgAccessRequested == null &&
            strTokenUser != null &&
            strOrgMembershipUserID == null &&
            strEventTypeRejected != "Organisation Membership Request Rejected"
            )
        {
            divUserConfirmSignedStep3.Visible    = true;
            divUserConfirmTempOrgDetails.Visible = true;
            lblUserConfirmSignedStep3.Text       = "Status: EDEN Portal Access Request - Step 3: User has selected an organisation, but has not yet selected a module and submitted the access request";
            lblUserConfirmSignedStep3.ForeColor  = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserConfirmSignedStep3.Visible    = false;
            divUserConfirmTempOrgDetails.Visible = false;
        }

        //if (strUserID_SSO != null && strOrgID == null && strUserID_TempID != null && strOrgTemp != null && strOrgAccessRequested == null)
        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strOrgID == null &&
            strOrgTemp != null &&
            strOrgAccessRequested == null &&
            strTokenUser != null &&
            strOrgMembershipUserID == null &&
            strOrganisationRequest == null &&
            strEventTypeRejected == null
            )
        {
            divUserConfirmSignedLAStep3.Visible   = true;
            divUserConfirmTempOrgDetails.Visible  = true;
            lblUserConfirmSignedLAStep3.Text      = "Status: EDEN Portal Access Request - Step 3: User has selected an organisation, but has not yet selected a module and submitted the access request";
            lblUserConfirmSignedLAStep3.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserConfirmSignedLAStep3.Visible  = false;
            divUserConfirmTempOrgDetails.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strOrgID == null &&
            strOrgTemp != null &&
            strOrgAccessRequested == null &&
            strTokenUser != null &&
            strOrgMembershipUserID == null &&
            strOrganisationRequest != null
            )
        {
            divUserNewOrgCreate.Visible   = true;
            lblUserNewOrgCreate.Text      = "Status: User has selected a module and requested to register a <i>new</i> organisation on EDEN. The request is now with the EPA for approval";
            lblUserNewOrgCreate.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }
        else
        {
            divUserNewOrgCreate.Visible = false;
        }

        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID != null &&
            strOrgAccessRequested != null &&
            strTokenUser != null &&
            strOrgMembershipUserID == null
            )
        {
            divUserRegCompleteNoApproval.Visible   = true;
            divUserConfirmTempOrgDetails.Visible   = true;
            lblUserRegCompleteNoApproval.Text      = "Status: User has selected an organisation, selected a module and submitted the access request. The org admin(s) can now process this request";
            lblUserRegCompleteNoApproval.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }
        else
        {
            divUserRegCompleteNoApproval.Visible = false;
            divUserConfirmTempOrgDetails.Visible = false;
        }

        //if (strUserID_SSO != null && strOrgID == null && strUserID_TempID != null && strOrgTemp != null && strOrgAccessRequested != null)
        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strOrgID == null &&
            strOrgTemp != null &&
            strOrgAccessRequested != null &&
            strTokenUser != null &&
            strOrgMembershipUserID == null
            )
        {
            divUserRegCompleteNoApprovalLA.Visible   = true;
            lblUserRegCompleteNoApprovalLA.Text      = "Status: User has selected an organisation, selected a module and submitted the access request. The org admin(s) can now process this request";
            lblUserRegCompleteNoApprovalLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }
        else
        {
            divUserRegCompleteNoApprovalLA.Visible = false;
        }



        if (strOrgModAccessRequested != null && strOrgID != null)
        {
            divModuleAccessPending.Visible   = true;
            lblModuleAccessPending.Text      = "Status: One or more module access requests by this user currently Pending Approval";
            lblModuleAccessPending.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divModuleAccessPending.Visible = false;
        }

        if (strOrgID != null)
        {
            divUserConfirmSignedNoStep1.Visible = false;
        }

        if (strUserID_TempID != null)
        {
            divPasswordExpiry.Visible = false;
        }

        if (strOrgModAccessRequested != null && strOrgLicAccessRequested != null)
        {
            GridView16.Visible = true;
            GridView17.Visible = false;
        }

        if (strOrgModAccessRequested == strOrgLicAccessRequested)
        {
            GridView16.Visible = true;
            GridView17.Visible = true;
        }

        if (strOrgMembershipUserID == null)
        {
            GridView23.Visible = true;
        }
        else
        {
            GridView23.Visible = false;
        }


        if (strOrgMembershipUserID == null)
        {
            GridView22.Visible = true;
        }
        else
        {
            GridView22.Visible = false;
        }

        if (strUserID_SSO == null & strTokenUser != null)
        {
            divVerificationLink.Visible = true;
        }
        else
        {
            divVerificationLink.Visible = false;
        }

        if (strUserID_SSO != null)
        {
            divVerificationLink.Visible = false;
        }

        if (strUserID_SSO != null)
        {
            divUserExternalLinks.Visible = true;
        }
        else
        {
            divUserExternalLinks.Visible = false;
        }

        if (strTokenPass == null)
        {
            divPasswordReset.Visible = false;
        }
        else
        {
            divPasswordReset.Visible = true;
        }


        /*
         * EPA Users
         */

        if (strUserID_ID == null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strUserID_UPM != null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID == null &&
            strTokenUser == null &&
            strTokenPass == null &&
            strOrgAccessRequested == null &&
            strOrgModAccessRequested == null &&
            strOrgLicAccessRequested == null &&
            strOrgMembershipUserID == null &&
            strOrganisationRequest == null &&
            strEventTypeRejected == null
            )
        {
            divUserEPAStep1.Visible   = true;
            lblUserEPAStep1.Text      = "Status: EDEN Portal Access Request - Step 1: EPA user has signed up, but has not selected an organisation";
            lblUserEPAStep1.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserEPAStep1.Visible = false;
        }


        if (strUserID_ID == null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strUserID_UPM != null &&
            strOrgTemp != null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divUserEPAStep2.Visible   = true;
            lblUserEPAStep2.Text      = "Status: EDEN Portal Access Request - Step 2: EPA user has selected organisation, but has not yet added their personal and contact details";
            lblUserEPAStep2.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserEPAStep2.Visible = false;
        }

        if (strUserID_ID == null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strUserID_UPM != null &&
            strOrgTemp != null &&
            strOrgAccessRequested == null &&
            strOrgMembershipUserID == null
            )
        {
            divUserEPAStep3.Visible   = true;
            lblUserEPAStep3.Text      = "Status: EDEN Portal Access Request - Step 3: EPA user has added their personal and contact details, but has not yet selected a module";
            lblUserEPAStep3.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserEPAStep3.Visible = false;
        }

        if (strUserID_ID == null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strUserID_UPM != null &&
            strOrgTemp != null &&
            strOrgAccessRequested != null
            )
        {
            divUserRegCompleteNoApprovalEPA.Visible   = true;
            lblUserRegCompleteNoApprovalEPA.Text      = "EPA user has selected an organisation, selected a module and submitted the access request. The EPA org admin(s) can now process this request";
            lblUserRegCompleteNoApprovalEPA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900");
        }
        else
        {
            divUserRegCompleteNoApprovalEPA.Visible = false;
        }


        if (strUserID_ID == null &&
            strUserID_SSO != null &&
            strUserID_TempID == null &&
            strUserID_UPM != null &&
            strOrgID == null &&
            strOrgTemp == null &&
            strOrgTempID == null &&
            strTokenUser == null &&
            strTokenPass == null &&
            strOrgAccessRequested == null &&
            strOrgModAccessRequested == null &&
            strOrgLicAccessRequested == null &&
            strOrgMembershipUserID == null &&
            strOrganisationRequest == null &&
            strEventTypeRejected == "Organisation Rejected"
            )
        {
            divUserRejectedLA.Visible   = true;
            lblUserRejectedLA.Text      = "Status: User has signed up, but the organisation has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register.";
            lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserRejectedLA.Visible = false;
        }


        if (strUserID_ID != null &&
            strUserID_SSO != null &&
            strUserID_TempID != null &&
            strEventTypeRejected == "Organisation Rejected"
            )
        {
            divOrgRejected.Visible   = true;
            lblOrgRejected.Text      = "Status: User has signed up, but the <b>organisation creation request</b> has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register.";
            lblOrgRejected.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divOrgRejected.Visible = false;
        }


        if (
            strEventTypeRejected == "Organisation Membership Request Rejected"
            )
        {
            divUserRejectedLA.Visible   = true;
            lblUserRejectedLA.Text      = "Status: User has signed up, but the <b>organisation membership request</b> has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register.";
            lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserRejectedLA.Visible = false;
        }


        if (
            strEventTypeRejected == "Module Authorisation Rejected"
            )
        {
            divUserRejectedLA.Visible   = true;
            lblUserRejectedLA.Text      = "Status: User's organisation access has been approved, but a module authorisation request has been rejected. (This may have been rectified - please check the notifications below).<br />";
            lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000");
        }
        else
        {
            divUserRejectedLA.Visible = false;
        }


        tsDatePasswordExpiryLessDatePasswordReset = dtDateUserPasswordExpiryForSubtraction - dtDatePasswordResetToken;
        int passwordReset_Expiry_DifferenceInDays = tsDatePasswordExpiryLessDatePasswordReset.Days;

        if (tsDatePasswordExpiryLessDatePasswordReset.Days == 90)
        {
            divPasswordResetTokenExpiry.Visible = false;
        }


        divTokens.Visible             = true;
        divSeperatorCurrent.Visible   = true;
        divSeperatorPending.Visible   = true;
        divSeperatorLicences.Visible  = true;
        divSeperatorTokens.Visible    = true;
        txtCopyVerificationLink.Text  = "https://account.edenireland.ie/signup/confirmemail?userId=" + strUserID_ID + "&token=" + strTokenUser;
        txtCopyPasswordResetLink.Text = "https://account.edenireland.ie/passwordreset/resetpassword?userId=" + strUserID_SSO + "&token=" + strTokenPass;
        GridView1.DataBind();
        GridView2.DataBind();
        GridView3.DataBind();
        GridView4.DataBind();
        GridView5.DataBind();
        GridView6.DataBind();
        GridView7.DataBind();
        GridView8.DataBind();
        GridView9.DataBind();
        GridView10.DataBind();
        GridView11.DataBind();
        GridView12.DataBind();
        GridView13.DataBind();
        GridView14.DataBind();
        GridView15.DataBind();
        GridView16.DataBind();
        GridView17.DataBind();
        GridView18.DataBind();
        GridView19.DataBind();
        GridView20.DataBind();
        GridView21.DataBind();
        GridView22.DataBind();
        GridView23.DataBind();
        GridView24.DataBind();
    }
Пример #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        String y = "select DISTINCT [Year] from SchoolTable";

        SqlDataSource9.SelectCommand = y;
        DataView dv = (DataView)SqlDataSource9.Select(new DataSourceSelectArguments());

        for (int i = 0; i < dv.Count; i++)
        {
            if (dv[i][0] != DBNull.Value)
            {
                String year = (String)dv[i][0];

                String sql1 = "select count(UnitName) from SchoolTable where UnitType='Cub' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource1.SelectCommand = sql1;
                DataView dv1 = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments());
                int      cub = (int)dv1[0][0];

                String sql2 = "select count(UnitName) from SchoolTable where UnitType='Scout' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource2.SelectCommand = sql2;
                DataView dv2   = (DataView)SqlDataSource2.Select(new DataSourceSelectArguments());
                int      scout = (int)dv2[0][0];

                String sql3 = "select count(UnitName) from SchoolTable where UnitType='Rover' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource3.SelectCommand = sql3;
                DataView dv3   = (DataView)SqlDataSource3.Select(new DataSourceSelectArguments());
                int      rover = (int)dv3[0][0];

                String sql4 = "select count(UnitName) from SchoolTable where UnitType='Bulbul' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource4.SelectCommand = sql4;
                DataView dv4    = (DataView)SqlDataSource4.Select(new DataSourceSelectArguments());
                int      bulbul = (int)dv4[0][0];

                String sql5 = "select count(UnitName) from SchoolTable where UnitType='Guide' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource5.SelectCommand = sql5;
                DataView dv5   = (DataView)SqlDataSource5.Select(new DataSourceSelectArguments());
                int      guide = (int)dv5[0][0];

                String sql6 = "select count(UnitName) from SchoolTable where UnitType='Ranger' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource6.SelectCommand = sql6;
                DataView dv6    = (DataView)SqlDataSource6.Select(new DataSourceSelectArguments());
                int      ranger = (int)dv6[0][0];

                String sql7 = "select count(UnitName) from SchoolTable where UnitType='Bunny' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource7.SelectCommand = sql7;
                DataView dv7   = (DataView)SqlDataSource7.Select(new DataSourceSelectArguments());
                int      bunny = (int)dv7[0][0];

                int total = cub + scout + rover + bulbul + guide + ranger + bunny;

                String sql9 = "select count(StudFullName) from StudentTable where UnitType='Cub' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource9.SelectCommand = sql9;
                DataView dv9  = (DataView)SqlDataSource9.Select(new DataSourceSelectArguments());
                int      cub1 = (int)dv9[0][0];

                String sql10 = "select count(StudFullName) from StudentTable where UnitType='Scout' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource10.SelectCommand = sql10;
                DataView dv10   = (DataView)SqlDataSource10.Select(new DataSourceSelectArguments());
                int      scout1 = (int)dv10[0][0];

                String sql11 = "select count(StudFullName) from StudentTable where UnitType='Rover' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource11.SelectCommand = sql11;
                DataView dv11   = (DataView)SqlDataSource11.Select(new DataSourceSelectArguments());
                int      rover1 = (int)dv11[0][0];

                String sql12 = "select count(StudFullName) from StudentTable where UnitType='Bulbul' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource12.SelectCommand = sql12;
                DataView dv12    = (DataView)SqlDataSource12.Select(new DataSourceSelectArguments());
                int      bulbul1 = (int)dv12[0][0];

                String sql13 = "select count(StudFullName) from StudentTable where UnitType='Guide' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource13.SelectCommand = sql13;
                DataView dv13   = (DataView)SqlDataSource13.Select(new DataSourceSelectArguments());
                int      guide1 = (int)dv13[0][0];

                String sql14 = "select count(StudFullName) from StudentTable where UnitType='Ranger' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource14.SelectCommand = sql14;
                DataView dv14    = (DataView)SqlDataSource14.Select(new DataSourceSelectArguments());
                int      ranger1 = (int)dv14[0][0];

                String sql15 = "select count(StudFullName) from StudentTable where UnitType='Bunny' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource15.SelectCommand = sql15;
                DataView dv15   = (DataView)SqlDataSource15.Select(new DataSourceSelectArguments());
                int      bunny1 = (int)dv7[0][0];

                int total1 = cub1 + scout1 + rover1 + bulbul1 + guide1 + ranger1 + bunny1;

                String sql16 = "select count(UnitName) from SchoolTable where Year='" + year + "' AND Status='Activated'";
                SqlDataSource16.SelectCommand = sql16;
                DataView dv16 = (DataView)SqlDataSource16.Select(new DataSourceSelectArguments());
                int      unit = (int)dv16[0][0];

                String sql17 = "select SUM(khTotalContri) from SchoolTable where Year='" + year + "'";
                SqlDataSource17.SelectCommand = sql17;
                DataView dv17 = (DataView)SqlDataSource17.Select(new DataSourceSelectArguments());
                int      amt;
                if (dv17[0][0] != DBNull.Value)
                {
                    amt = (int)dv17[0][0];
                }
                else
                {
                    amt = 0;
                }
                String sql18 = "select count(SchoolName) from SchoolTable where Year='" + year + "' AND Status='Activated'";
                SqlDataSource18.SelectCommand = sql18;
                DataView dv18 = (DataView)SqlDataSource18.Select(new DataSourceSelectArguments());
                int      sch  = (int)dv18[0][0];

                String sql19 = "select count(SchoolName) from SchoolTable where SchoolType='PrimarySchool' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource19.SelectCommand = sql19;
                DataView dv19 = (DataView)SqlDataSource19.Select(new DataSourceSelectArguments());
                int      sch1 = (int)dv19[0][0];

                String sql20 = "select count(SchoolName) from SchoolTable where SchoolType='SecondarySchool' AND Year='" + year + "' AND Status='Activated'";
                SqlDataSource20.SelectCommand = sql20;
                DataView dv20 = (DataView)SqlDataSource20.Select(new DataSourceSelectArguments());
                int      sch2 = (int)dv20[0][0];

                int    total3 = sch1 + sch2;
                String update = "Select * from StatisticalData where Year='" + year + "'";
                SqlDataSource21.SelectCommand = update;
                DataView dv21 = (DataView)SqlDataSource21.Select(new DataSourceSelectArguments());
                if (dv21.Count != 0)
                {
                    String query = "update StatisticalData set Cub=" + cub + ", Scout=" + scout + ", Rover=" + rover + ", Bulbul=" + bulbul + ", Guide=" + guide + ", Ranger=" + ranger + ", Bunny=" + bunny + ", Total=" + total + ", Cub1=" + cub1 + ", Scout1=" + scout1 + ", Rover1=" + rover1 + ", Bulbul1=" + bulbul1 + ", Guide1=" + guide1 + ", Ranger1=" + ranger1 + ", Bunny1=" + bunny1 + ", Total1=" + total1 + ", TotalUnits=" + unit + ", CollectedFees=" + amt + ", TotalParticipatedSchools=" + sch + ", PrimarySchool=" + sch1 + ", SecondarySchool=" + sch2 + ", TotalMembers=" + total3 + " where Year='" + year + "'";
                    SqlDataSource22.UpdateCommand = query;
                    int n = SqlDataSource22.Update();
                }
                else
                {
                    String insert1 = "insert into StatisticalData (Year, Cub, Scout, Rover, Bulbul, Guide, Ranger, Bunny, Total, Cub1, Scout1, Rover1, Bulbul1, Guide1, Ranger1, Bunny1, Total1, TotalUnits, CollectedFees, TotalParticipatedSchools, PrimarySchool, SecondarySchool, TotalMembers) Values('" + year + "'," + cub + "," + scout + "," + rover + "," + bulbul + "," + guide + "," + ranger + "," + bunny + "," + total + "," + cub1 + "," + scout1 + "," + rover1 + "," + bulbul1 + "," + guide1 + "," + ranger1 + "," + bunny1 + "," + total1 + "," + unit + "," + amt + "," + sch + "," + sch1 + "," + sch2 + "," + total3 + ")";
                    SqlDataSource8.InsertCommand = insert1;
                    int n1 = SqlDataSource8.Insert();
                }
            }
        }
        Server.Transfer("Statistical2.aspx");
    }