private void LoadPage()
{
CAnonymousFeedback objFeedback = new CAnonymousFeedback();
DataTable tblFeedback = objFeedback.GetAllFeedback();
this.grvFeedback.DataSource = tblFeedback;
this.grvFeedback.DataBind();
}
private void LoadForEdit(int index)
{
try
{
//this.Reset();
DataTable tblData = new CAnonymousFeedback().GetFeedback(new Guid(this.grvFeedback.DataKeys[Index].Value.ToString()));
if (tblData.Rows.Count > 0)
{
DataRow rData = tblData.Rows[0];
#region LoadData
txtPrime.Text = rData["PrimaryReason"].ToString();
rdblist1.SelectedValue = rData["TypeOfWork"].ToString();
if (rdblist1.SelectedValue != "")
{
rdblist1.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist2.SelectedValue = rData["WorkingCondition"].ToString();
if (rdblist2.SelectedValue != "")
{
rdblist2.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist3.SelectedValue = rData["PayBenefits"].ToString();
if (rdblist3.SelectedValue != "")
{
rdblist3.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist4.SelectedValue = rData["SupervisorLeadership"].ToString();
if (rdblist4.SelectedValue != "")
{
rdblist4.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist5.SelectedValue = rData["NatureOfTheJob"].ToString();
if (rdblist5.SelectedValue != "")
{
rdblist5.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist6.SelectedValue = rData["Location"].ToString();
if (rdblist6.SelectedValue != "")
{
rdblist6.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist7.SelectedValue = rData["RateTypeOfWork"].ToString();
if (rdblist7.SelectedValue != "")
{
rdblist7.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist8.SelectedValue = rData["RateSalary"].ToString();
if (rdblist8.SelectedValue != "")
{
rdblist8.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist9.SelectedValue = rData["RateworkingCondition"].ToString();
if (rdblist9.SelectedValue != "")
{
rdblist9.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist10.SelectedValue = rData["RateEquipmentProvided"].ToString();
if (rdblist10.SelectedValue != "")
{
rdblist10.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist11.SelectedValue = rData["RateColleagues"].ToString();
if (rdblist11.SelectedValue != "")
{
rdblist11.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist12.SelectedValue = rData["RateSupervisor"].ToString();
if (rdblist12.SelectedValue != "")
{
rdblist12.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist13.SelectedValue = rData["RateLevelOfInput"].ToString();
if (rdblist13.SelectedValue != "")
{
rdblist13.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist14.SelectedValue = rData["ORGRecruitmentProcess"].ToString();
if (rdblist14.SelectedValue != "")
{
rdblist14.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist15.SelectedValue = rData["ORGEmployeeOrientation"].ToString();
if (rdblist15.SelectedValue != "")
{
rdblist15.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist16.SelectedValue = rData["ORGTrainingOpportunities"].ToString();
if (rdblist16.SelectedValue != "")
{
rdblist16.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist17.SelectedValue = rData["ORGCareerDevtOpp"].ToString();
if (rdblist17.SelectedValue != "")
{
rdblist17.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist18.SelectedValue = rData["ORGEmployeeMorale"].ToString();
if (rdblist18.SelectedValue != "")
{
rdblist18.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist19.SelectedValue = rData["ORGFairTreatement"].ToString();
if (rdblist19.SelectedValue != "")
{
rdblist19.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist20.SelectedValue = rData["ORGJobRecognition"].ToString();
if (rdblist20.SelectedValue != "")
{
rdblist20.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist21.SelectedValue = rData["ORGCommunication"].ToString();
if (rdblist21.SelectedValue != "")
{
rdblist21.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist22.SelectedValue = rData["ORGPerformanceEval"].ToString();
if (rdblist22.SelectedValue != "")
{
rdblist22.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist23.SelectedValue = rData["ORGCustomerService"].ToString();
if (rdblist23.SelectedValue != "")
{
rdblist23.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist24.SelectedValue = rData["ORGConcernForExcellence"].ToString();
if (rdblist24.SelectedValue != "")
{
rdblist24.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist25.SelectedValue = rData["ORGAdminPolices"].ToString();
if (rdblist25.SelectedValue != "")
{
rdblist25.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist26.SelectedValue = rData["SUPUsableFeedback"].ToString();
if (rdblist26.SelectedValue != "")
{
rdblist26.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist27.SelectedValue = rData["SUPRecognizeAccomplishement"].ToString();
if (rdblist27.SelectedValue != "")
{
rdblist27.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist28.SelectedValue = rData["SUPFairTreatement"].ToString();
if (rdblist28.SelectedValue != "")
{
rdblist28.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist29.SelectedValue = rData["SUPTrained"].ToString();
if (rdblist29.SelectedValue != "")
{
rdblist29.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist30.SelectedValue = rData["SUPProvodedLeadership"].ToString();
if (rdblist30.SelectedValue != "")
{
rdblist30.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist31.SelectedValue = rData["SUPEncourageTeamWork"].ToString();
if (rdblist31.SelectedValue != "")
{
rdblist31.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist32.SelectedValue = rData["SUPResolvedConcern"].ToString();
if (rdblist32.SelectedValue != "")
{
rdblist32.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist33.SelectedValue = rData["SUPListened"].ToString();
if (rdblist33.SelectedValue != "")
{
rdblist33.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist34.SelectedValue = rData["SUPInform"].ToString();
if (rdblist34.SelectedValue != "")
{
rdblist34.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
rdblist35.SelectedValue = rData["SUPAppropriateAssign"].ToString();
if (rdblist35.SelectedValue != "")
{
rdblist35.SelectedItem.Attributes.Add("style", "color:#ee0930; font-weight:Bold;");
}
txtEmployerName.Text = rData["NewEmployerName"].ToString();
//if(txtEmployerName.Text != "")
//{
// txtEmployerName.BorderColor = Color.DeepPink;
//}
txtPosLoc.Text = rData["LocationOfPosition"].ToString();
//if (txtPosLoc.Text != "")
//{
// txtPosLoc.BorderColor = Color.DeepPink;
//}
txtPosTitle.Text = rData["PositionTitle"].ToString();
//if (txtPosTitle.Text != "")
//{
// txtPosTitle.BorderColor = Color.DeepPink;
//}
txtPosNature.Text = rData["NatureOfPosition"].ToString();
//if (txtPosNature.Text != "")
//{
// txtPosNature.BorderColor = Color.DeepPink;
//}
txtPosSalary.Text = rData["SalaryOfPosition"].ToString();
//if (txtPosSalary.Text != "")
//{
// txtPosSalary.BorderColor = Color.DeepPink;
//}
txtNewOffer.Text = rData["NewORGOffer"].ToString();
//if (txtNewOffer.Text != "")
//{
// txtNewOffer.BorderColor = Color.DeepPink;
//}
txtComment.Text = rData["AdditionalComment"].ToString();
//if (txtComment.Text != "")
//{
// txtComment.BorderColor = Color.DeepPink;
//}
#endregion
}
}
catch (Exception ex)
{
this.Session["Error"] = ex.Message;
this.Response.Redirect("~/pError.aspx", false);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
CAnonymousFeedback objAno = new CAnonymousFeedback();
Int16?rdb1 = null; Int16?rdb2 = null; Int16?rdb3 = null; Int16?rdb4 = null; Int16?rdb5 = null; Int16?rdb6 = null; Int16?rdb7 = null;
Int16?rdb8 = null; Int16?rdb9 = null; Int16?rdb10 = null; Int16?rdb11 = null; Int16?rdb12 = null; Int16?rdb13 = null; Int16?rdb14 = null;
Int16?rdb15 = null; Int16?rdb16 = null; Int16?rdb17 = null; Int16?rdb18 = null; Int16?rdb19 = null; Int16?rdb20 = null; Int16?rdb21 = null;
Int16?rdb22 = null; Int16?rdb23 = null; Int16?rdb24 = null; Int16?rdb25 = null; Int16?rdb26 = null; Int16?rdb27 = null; Int16?rdb28 = null;
Int16?rdb29 = null; Int16?rdb30 = null; Int16?rdb31 = null; Int16?rdb32 = null; Int16?rdb33 = null; Int16?rdb34 = null; Int16?rdb35 = null;
if (IsValidInput())
{
if (rdblist1.SelectedValue != "")
{
rdb1 = Convert.ToInt16(rdblist1.SelectedValue);
}
if (rdblist2.SelectedValue != "")
{
rdb2 = Convert.ToInt16(rdblist2.SelectedValue);
}
if (rdblist3.SelectedValue != "")
{
rdb3 = Convert.ToInt16(rdblist3.SelectedValue);
}
if (rdblist4.SelectedValue != "")
{
rdb4 = Convert.ToInt16(rdblist4.SelectedValue);
}
if (rdblist5.SelectedValue != "")
{
rdb5 = Convert.ToInt16(rdblist5.SelectedValue);
}
if (rdblist6.SelectedValue != "")
{
rdb6 = Convert.ToInt16(rdblist6.SelectedValue);
}
if (rdblist7.SelectedValue != "")
{
rdb7 = Convert.ToInt16(rdblist7.SelectedValue);
}
if (rdblist8.SelectedValue != "")
{
rdb8 = Convert.ToInt16(rdblist8.SelectedValue);
}
if (rdblist9.SelectedValue != "")
{
rdb9 = Convert.ToInt16(rdblist9.SelectedValue);
}
if (rdblist10.SelectedValue != "")
{
rdb10 = Convert.ToInt16(rdblist10.SelectedValue);
}
if (rdblist11.SelectedValue != "")
{
rdb11 = Convert.ToInt16(rdblist11.SelectedValue);
}
if (rdblist12.SelectedValue != "")
{
rdb12 = Convert.ToInt16(rdblist12.SelectedValue);
}
if (rdblist13.SelectedValue != "")
{
rdb13 = Convert.ToInt16(rdblist13.SelectedValue);
}
if (rdblist14.SelectedValue != "")
{
rdb14 = Convert.ToInt16(rdblist14.SelectedValue);
}
if (rdblist15.SelectedValue != "")
{
rdb15 = Convert.ToInt16(rdblist15.SelectedValue);
}
if (rdblist16.SelectedValue != "")
{
rdb16 = Convert.ToInt16(rdblist16.SelectedValue);
}
if (rdblist17.SelectedValue != "")
{
rdb17 = Convert.ToInt16(rdblist17.SelectedValue);
}
if (rdblist18.SelectedValue != "")
{
rdb18 = Convert.ToInt16(rdblist18.SelectedValue);
}
if (rdblist19.SelectedValue != "")
{
rdb19 = Convert.ToInt16(rdblist19.SelectedValue);
}
if (rdblist20.SelectedValue != "")
{
rdb20 = Convert.ToInt16(rdblist20.SelectedValue);
}
if (rdblist21.SelectedValue != "")
{
rdb21 = Convert.ToInt16(rdblist21.SelectedValue);
}
if (rdblist22.SelectedValue != "")
{
rdb22 = Convert.ToInt16(rdblist22.SelectedValue);
}
if (rdblist23.SelectedValue != "")
{
rdb23 = Convert.ToInt16(rdblist23.SelectedValue);
}
if (rdblist24.SelectedValue != "")
{
rdb24 = Convert.ToInt16(rdblist24.SelectedValue);
}
if (rdblist25.SelectedValue != "")
{
rdb25 = Convert.ToInt16(rdblist25.SelectedValue);
}
if (rdblist26.SelectedValue != "")
{
rdb26 = Convert.ToInt16(rdblist26.SelectedValue);
}
if (rdblist27.SelectedValue != "")
{
rdb27 = Convert.ToInt16(rdblist27.SelectedValue);
}
if (rdblist28.SelectedValue != "")
{
rdb28 = Convert.ToInt16(rdblist28.SelectedValue);
}
if (rdblist29.SelectedValue != "")
{
rdb29 = Convert.ToInt16(rdblist29.SelectedValue);
}
if (rdblist30.SelectedValue != "")
{
rdb30 = Convert.ToInt16(rdblist30.SelectedValue);
}
if (rdblist31.SelectedValue != "")
{
rdb31 = Convert.ToInt16(rdblist31.SelectedValue);
}
if (rdblist32.SelectedValue != "")
{
rdb32 = Convert.ToInt16(rdblist32.SelectedValue);
}
if (rdblist33.SelectedValue != "")
{
rdb33 = Convert.ToInt16(rdblist33.SelectedValue);
}
if (rdblist34.SelectedValue != "")
{
rdb34 = Convert.ToInt16(rdblist34.SelectedValue);
}
if (rdblist35.SelectedValue != "")
{
rdb35 = Convert.ToInt16(rdblist35.SelectedValue);
}
if (objAno.Insert(HttpUtility.HtmlEncode(txtPrime.Text), rdb1, rdb2, rdb3, rdb4, rdb5, rdb6, rdb7, rdb8, rdb9, rdb10, rdb11, rdb12, rdb13, rdb14, rdb15,
rdb16, rdb17, rdb18, rdb19, rdb20, rdb21, rdb22, rdb23, rdb24, rdb25, rdb26, rdb27, rdb28, rdb29, rdb3, rdb31, rdb32, rdb33, rdb34, rdb35,
HttpUtility.HtmlEncode(txtEmployerName.Text), HttpUtility.HtmlEncode(txtPosLoc.Text), HttpUtility.HtmlEncode(txtPosTitle.Text),
HttpUtility.HtmlEncode(txtPosNature.Text), HttpUtility.HtmlEncode(txtPosSalary.Text), HttpUtility.HtmlEncode(txtNewOffer.Text),
HttpUtility.HtmlEncode(txtComment.Text)) == 1)
{
lblStatus.Visible = true;
lblStatus.Text = "Thank you for your honest feedback!!!";
}
}
else
{
lblStatus.Visible = true;
lblStatus.Text = "Sorry it is not a feedback! Please Try Again!";
}
}