protected void Page_Load(object sender, EventArgs e)
{
if (EventFunctions.Functions.GetSessionUserId() == "")
{
try
{
Response.Redirect("/Account/Login.aspx?redirect=/survey/Survey.aspx");
}
catch (Exception)
{
Response.Redirect("/Account/Login.aspx?redirect=/survey/Survey.aspx");
}
}
if (!IsPostBack)
{
lUser.Text = "" + Session["username"];
lDt.Text = DateTime.Now.ToString("M/d/yyyy");
CLASSES.survey obj = new CLASSES.survey();
tHotel.DataSource = obj.getHotels();
tHotel.DataTextField = "Name";
tHotel.DataValueField = "Name";
tHotel.DataBind();
tHotel.Items.Insert(0, new ListItem("Please Select", ""));
dCnt.DataSource = obj.getCountry();
dCnt.DataTextField = "Name";
dCnt.DataValueField = "Id";
dCnt.DataBind();
dState.DataSource = obj.getStates();
dState.DataTextField = "state_name";
dState.DataValueField = "state_name";
dState.DataBind();
obj = null;
}
if (dVisit.SelectedItem.Value == "1")
{
dState.Style.Add("display", "none");
dCnt.Style.Add("display", "");
}
else
{
dState.Style.Add("display", "");
dCnt.Style.Add("display", "none");
}
if (dStay.Value == "3")
{
trHotel.Style.Remove("display");
}
else
{
trHotel.Style.Add("display", "none");
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
CLASSES.survey obj = new CLASSES.survey();
dt = obj.getQueries();
obj = null;
Response.ContentType = "Application/x-msexcel";
Response.AddHeader("content-disposition", "attachment;filename=macyssurvey.csv");
Response.Write(ExportToCSVFile(dt));
Response.End();
}
protected void bEdit_Click(object sender, ImageClickEventArgs e)
{
if (EventFunctions.Functions.ToInt(ViewState["SurveyId"]) > 0)
{
CLASSES.survey objSurvey = new CLASSES.survey();
objSurvey.SurveyId = EventFunctions.Functions.ToInt(ViewState["SurveyId"]);
DataTable DT = objSurvey.getSurveyDetails();
if (DT.Rows.Count > 0)
{
dCnt.SelectedIndex = dCnt.Items.IndexOf(dCnt.Items.FindByValue("" + DT.Rows[0]["Country"]));
dState.SelectedIndex = dState.Items.IndexOf(dState.Items.FindByValue("" + DT.Rows[0]["State"]));
if ("" + DT.Rows[0]["State"] != "")
{
dVisit.SelectedValue = "2";
}
if (Functions.ToInt(DT.Rows[0]["ForBusiness"]) == 1)
{
dPurp.SelectedIndex = 1;
}
if (Functions.ToInt(DT.Rows[0]["ForLiesure"]) == 1)
{
dPurp.SelectedIndex = 2;
}
if (Functions.ToInt(DT.Rows[0]["ForBoth"]) == 1)
{
dPurp.SelectedIndex = 3;
}
dNo.SelectedIndex = dNo.Items.IndexOf(dNo.Items.FindByValue("" + DT.Rows[0]["PeopleInParty"]));
dStay.Value = "" + DT.Rows[0]["WhereStaying"];
tHotel.SelectedIndex = tHotel.Items.IndexOf(tHotel.Items.FindByValue("" + DT.Rows[0]["Hotel"]));
dHear.Value = "" + DT.Rows[0]["HearAboutPass"];
tMail.Text = "" + DT.Rows[0]["Email"];
dBrand.SelectedIndex = dBrand.Items.IndexOf(dBrand.Items.FindByValue("" + DT.Rows[0]["Brand"]));
trMain.Visible = true;
tblMsg.Visible = false;
}
objSurvey = null;
}
}
protected void bSubmit_Click(object sender, EventArgs e)
{
CLASSES.survey obj = new CLASSES.survey();
obj._FN = "";
obj._LN = "";
obj._City = "";
obj._Email = tMail.Text.Replace("'", "''");
if (dVisit.SelectedItem.Value == "2")
{
obj._State = dState.SelectedItem.Value;
}
else
{
obj._State = "";
}
obj._Country = dCnt.SelectedValue;
obj._ForB = obj._ForL = obj._ForBoth = 0;
if (dPurp.SelectedValue == "1")
{
obj._ForB = 1;
}
else if (dPurp.SelectedValue == "2")
{
obj._ForL = 1;
}
else if (dPurp.SelectedValue == "3")
{
obj._ForBoth = 1;
}
obj._Total = dNo.SelectedValue;
obj._WhereStay = dStay.Value;
if (dStay.Value == "3")
{
obj._Hotel = tHotel.Text.Replace("'", "''");
}
else
{
obj._Hotel = "";
}
obj._About = dHear.Value;
obj._Heard = tHN.Text.Replace("'", "''");
obj._Brand = dBrand.SelectedItem.Value;
int iSurveyId = 0;
if (EventFunctions.Functions.ToInt(ViewState["SurveyId"]) > 0)
{
obj.SurveyId = EventFunctions.Functions.ToInt(ViewState["SurveyId"]);
iSurveyId = obj.updateSurvey();
}
else
{
iSurveyId = obj.saveSurvey();
}
if (iSurveyId > 0)
{
trMain.Visible = false;
//trHd.Visible = false;
tblMsg.Visible = true;
tMail.Text = "";
dCnt.ClearSelection();
dPurp.ClearSelection();
dNo.ClearSelection();
dBrand.ClearSelection();
dCnt.SelectedIndex = 0;
dPurp.SelectedIndex = 0;
dNo.SelectedIndex = 0;
dBrand.SelectedIndex = 0;
dHear.SelectedIndex = 0;
dStay.SelectedIndex = 0;
tHotel.Text = "";
tHN.Text = "";
hMsg.InnerHtml = "The form has been successfully saved!";
ViewState["SurveyId"] = iSurveyId;
bEdit.Visible = true;
}
else
{
trMain.Visible = false;
tblMsg.Visible = true;
hMsg.InnerHtml = "Sorry!!! Please try again.";
}
obj = null;
}
