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();
}
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();
}
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");
}