/// <summary> /// show the existing poll in edit mode /// This is for demo only Never write ur database logic here. Always use classes and SPs to seperate them from codebehind /// </summary> private void ShowExistingPoll(int PollId) { PollingController objc = new PollingController(); Pollinginfo objPoll = new Pollinginfo(); DataSet dsPoll = objc.SelectPoll(PollId, Int32.Parse(SageUserModuleID), GetPortalID); if (dsPoll.Tables[0].Rows.Count > 0) { txtQuestion.Text = dsPoll.Tables[0].Rows[0]["Question"].ToString(); string blockMode = dsPoll.Tables[0].Rows[0]["BlockMode"].ToString(); if (blockMode == Pollinginfo.BlockMode.COOKIE.ToString()) { rdoCookie.Checked = true; } else if (blockMode == Pollinginfo.BlockMode.IP_ADDRESS.ToString()) { rdoIP.Checked = true; } else { rdoNone.Checked = true; } ShowChoices(dsPoll.Tables[1]); hidRowIndex.Value = dsPoll.Tables[1].Rows.Count.ToString(); //btnSave.Text = "Update Poll"; } else //can't find the poll.. change to INSERT MODE { hidPollID.Value = ""; // btnSave.Text = "Save Poll"; } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { Pollinginfo objPoll = new Pollinginfo(); if (Session["PollID"] == null) { pollID = 0; } else { pollID = Convert.ToInt32(Session["PollID"]); } string blockMode; if (rdoCookie.Checked) blockMode = Pollinginfo.BlockMode.COOKIE.ToString(); else if (rdoIP.Checked) blockMode = Pollinginfo.BlockMode.IP_ADDRESS.ToString(); else blockMode = Pollinginfo.BlockMode.NONE.ToString(); if (pollID == 0) //INSERT { pollID = InsertPoll(txtQuestion.Text.Trim(), blockMode); //POLL INSERTED SUCCESSFULLY if (pollID > 0) { hidPollID.Value = pollID.ToString(); ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "AddNewPollMessage"), "", SageMessageType.Success); } } else //UPDATE { UpdatePoll(pollID, txtQuestion.Text.Trim(), blockMode); ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "UpdatePollSuccess"), "", SageMessageType.Success); } if (pollID > 0) { InsertUpdateChoices(pollID, Int32.Parse(SageUserModuleID), GetPortalID); //After inserting/Updateting the poll - call choice insert/update function } else { ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "Error"), "", SageMessageType.Error); } Session["PollID"] = null; } txtQuestion.Text = string.Empty; divform.Attributes.Add("style", "display:none"); divManipulateData.Attributes.Add("style", "display:block"); listPolls(); }
/// <summary> /// The input choices can come in 3 mode - /// 1 - INSERT - IF its added as NEW - it will not have a corresponding Choice ID hidden field /// 2 - UPDATE - IF a choice text input has corresponding hidden ID present itss in UPDATE mode /// 3 - DELETE - IF a choice text input has corresponding hidden ID present but the text value is empty /// </summary> /// <param name="pollID"></param> private void InsertUpdateChoices(int pollID, int UserModuleID, int PortalID) { Pollinginfo objPoll = new Pollinginfo(); PollingController objc = new PollingController(); //INSERT/UPDATE THE CHOICES //LOOPING THRU ALL THE FORM KEYVALUES TO FIND THE INPUT TEXTS //IF A CHOICE HAS CORRESPONDING ID THEN IT HAS TO BE UPDATES/ ELSE INSERT foreach (string key in Request.Form) { if (key.IndexOf("txtChoice") >= 0) { string hidPollChoiceID = "hidPollChoiceID" + key.Substring(key.Length - 1, 1); int choiceID = 0; string chc = Request.Form[key]; if (Session["PollID"] != null) { if (Request.Form[hidPollChoiceID] != null && int.TryParse(Request.Form[hidPollChoiceID], out choiceID)) { if (Request.Form[key].Trim().Length > 0) //UPDATE if the choice text box is not empty and has a corresponding ID { objPoll.PollChoiceID = choiceID; objPoll.Choice = Request.Form[key]; objPoll.UserModuleID = UserModuleID; objPoll.PortalID = PortalID; objc.UpdateChoice(objPoll); } else //DELETE the choice if its empty { objc.DeleteChoice(choiceID); } } else if (Request.Form[key].Trim().Length > 0)//New choice - insert only if the text is not empty { objPoll.PollID = pollID; objPoll.Choice = Request.Form[key].Trim(); objPoll.UserModuleID = UserModuleID; objPoll.PortalID = PortalID; objc.InsertChoice(objPoll); } } else { if (Request.Form[key].Trim().Length > 0)//New choice - insert only if the text is not empty { objPoll.PollID = pollID; objPoll.Choice = Request.Form[key].Trim(); objPoll.UserModuleID = UserModuleID; objPoll.PortalID = PortalID; objc.InsertChoice(objPoll); } } } } hidRowIndex.Value = null; }
public int InsertPoll(string question, string blockMode) { Pollinginfo objInf = new Pollinginfo(); objInf.Question = question; objInf.blockMode = blockMode; objInf.UserModuleID = Int32.Parse(SageUserModuleID); objInf.PortalID = GetPortalID; PollingController objc = new PollingController(); return(objc.InsertPoll(objInf)); }
/// <summary> /// Update the poll and return the number of rows affected /// </summary> /// <param name="pollID"></param> /// <param name="question"></param> /// <returns>Number of rows affected</returns> public void UpdatePoll(int pollID, string question, string blockMode) { Pollinginfo obj = new Pollinginfo(); obj.PollID = pollID; obj.Question = question; obj.blockMode = blockMode; PollingController objc = new PollingController(); objc.UpdatePoll(obj); // return db.ExecuteNonQuery("usp_poll_update", pollID, question, blockMode, active); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { Pollinginfo objPoll = new Pollinginfo(); if (Session["PollID"] == null) { pollID = 0; } else { pollID = Convert.ToInt32(Session["PollID"]); } string blockMode; if (rdoCookie.Checked) { blockMode = Pollinginfo.BlockMode.COOKIE.ToString(); } else if (rdoIP.Checked) { blockMode = Pollinginfo.BlockMode.IP_ADDRESS.ToString(); } else { blockMode = Pollinginfo.BlockMode.NONE.ToString(); } if (pollID == 0) //INSERT { pollID = InsertPoll(txtQuestion.Text.Trim(), blockMode); //POLL INSERTED SUCCESSFULLY if (pollID > 0) { hidPollID.Value = pollID.ToString(); ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "AddNewPollMessage"), "", SageMessageType.Success); } } else //UPDATE { UpdatePoll(pollID, txtQuestion.Text.Trim(), blockMode); ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "UpdatePollSuccess"), "", SageMessageType.Success); } if (pollID > 0) { InsertUpdateChoices(pollID, Int32.Parse(SageUserModuleID), GetPortalID); //After inserting/Updateting the poll - call choice insert/update function } else { ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Polling/ModuleLocalText", "Error"), "", SageMessageType.Error); } Session["PollID"] = null; } txtQuestion.Text = string.Empty; divform.Attributes.Add("style", "display:none"); divManipulateData.Attributes.Add("style", "display:block"); listPolls(); }
/// <summary> /// show the existing poll in edit mode /// This is for demo only Never write ur database logic here. Always use classes and SPs to seperate them from codebehind /// </summary> private void ShowExistingPoll(int PollId) { PollingController objc = new PollingController(); Pollinginfo objPoll = new Pollinginfo(); DataSet dsPoll = objc.SelectPoll(PollId, Int32.Parse(SageUserModuleID), GetPortalID); if (dsPoll.Tables[0].Rows.Count > 0) { txtQuestion.Text = dsPoll.Tables[0].Rows[0]["Question"].ToString(); string blockMode = dsPoll.Tables[0].Rows[0]["BlockMode"].ToString(); if (blockMode == Pollinginfo.BlockMode.COOKIE.ToString()) rdoCookie.Checked = true; else if (blockMode == Pollinginfo.BlockMode.IP_ADDRESS.ToString()) rdoIP.Checked = true; else rdoNone.Checked = true; ShowChoices(dsPoll.Tables[1]); hidRowIndex.Value = dsPoll.Tables[1].Rows.Count.ToString(); //btnSave.Text = "Update Poll"; } else //can't find the poll.. change to INSERT MODE { hidPollID.Value = ""; // btnSave.Text = "Save Poll"; } }
public int InsertPoll(string question, string blockMode) { Pollinginfo objInf = new Pollinginfo(); objInf.Question = question; objInf.blockMode = blockMode; objInf.UserModuleID = Int32.Parse(SageUserModuleID); objInf.PortalID = GetPortalID; PollingController objc = new PollingController(); return objc.InsertPoll(objInf); }