private void BindMyAnsList() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); int UserId = ((UserBE)(Session["LoggedInUser"])).UserId; if (QuestBAL.GetAllAnswersByUserId(ref dt,UserId)) { this.LvMyAns.DataSource = dt; LvMyAns.DataBind(); recalcNoOfPages(); } else { if (dt != null && dt.Rows.Count == 0) { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("There is no data to show.", false); } else { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Unsuccessful", false); } } }
protected void btnAdd_Click(object sender, EventArgs e) { LoggedIn master = (LoggedIn)this.Master; QuestAnsBE Ko = new QuestAnsBE(); QuestAnsBAL KoBAL = new QuestAnsBAL(); if (ValidData()) { return; } Ko.Subject = txtSubject.Text; Ko.Tag = txtTag.Text; Ko.ShortDesc = txtShortDesc.Text; Ko.DelDesc = txtDelDesc.Text.Replace(Environment.NewLine,"<br/>"); Ko.Note = txtNote.Text.Replace(Environment.NewLine, "<br/>"); Ko.KOText = txtKOText.Text; Ko.KOType = ddlKOType.SelectedItem.Text; Ko.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId; if (KoBAL.AddKO(Ko)) { foreach (Control txt in divAddKO.Controls) { if (txt is TextBox) ((TextBox)(txt)).Text = string.Empty; else if (txt is DropDownList) ((DropDownList)(txt)).SelectedIndex = 0; } master.ShowMessage("Record Added Successfully", true); } else { master.ShowMessage("Unsuccessful", false); } }
public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); if (txtKeyword.Text == "") { Quest.Keyword = "%"; } else { Quest.Keyword = txtKeyword.Text; } if (QuestBAL.QuickSearchList(ref dt, Quest)) { lvQuestList.DataSource = dt; lvQuestList.DataBind(); recalcNoOfPages(); } else { lvQuestList.DataSource = null; lvQuestList.DataBind(); //LoggedIn master = (LoggedIn)this.Master; //master.ShowMessage("Sorry No Records Were found", false); } }
protected void lvQuestList_ItemEditing(object sender, ListViewEditEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); int QId = Convert.ToInt32(lvQuestList.DataKeys[e.NewEditIndex].Value); Session["QuestId"] = lvQuestList.DataKeys[e.NewEditIndex].Value.ToString(); //cv?org-question Response.Redirect("~/QuestAns/QA_QuestWithAns.aspx"); }
protected void retreiveDATA() { QuestAnsBAL KOBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); int KOId = Convert.ToInt32(hdnKOID.Value); if (KOBAL.ViewKO(KOId, ref dt)) { lblSubject.Text = dt.Rows[0]["Subject"].ToString(); lblShortDesc.Text = dt.Rows[0]["ShortDesc"].ToString(); lblDetlDesc.Text = dt.Rows[0]["DetlDesc"].ToString(); lblKOText.Text = dt.Rows[0]["KOText"].ToString(); lblKOType.Text = dt.Rows[0]["KOType"].ToString(); lblTag.Text = dt.Rows[0]["Tag"].ToString(); lblNote.Text = dt.Rows[0]["Note"].ToString(); } }
private void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllQuestions(ref dt)) { this.lvQuestList.DataSource = dt; lvQuestList.DataBind(); } else { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Unsuccessful", false); } }
public void GetAnswers() { QuestAnsBAL AnsBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); QuestAnsBE Ans = new QuestAnsBE(); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); if (AnsBAL.GetAnswers(ref dt, Ans)) { this.lvAnswerList.DataSource = dt; this.lvAnswerList.DataBind(); } else { } }
public void bindExpDropDown() { QuestAnsBAL QnABAL = new QuestAnsBAL(); DataTable dt = new DataTable(); LoggedIn master = (LoggedIn)this.Master; if (QnABAL.GetAllExp(ref dt)) { //ddlExp.DataSource = dt; //ddlExp.DataTextField = "YrOfExp"; //ddlExp.DataValueField = "ExpId"; //ddlExp.DataBind(); //ddlExp.Items.Insert(0, new ListItem("-Select-", "-Select-")); } else { master.ShowMessage("Unsuccessful", false); } }
private void bindLVQuery() { General master = (General)this.Master; QuestAnsBAL QueryBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QueryBAL.GetRecentData(ref dt)) { this.lvQueryList.DataSource = dt; lvQueryList.DataBind(); recalcNoOfPagesQuery(); } else { this.lvQueryList.DataSource = null; lvQueryList.DataBind(); master.ShowMessage("UnSuccessful", false); } }
private void bindLVKO() { General master = (General)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllLinks(ref dt)) { this.LVKOList.DataSource = dt; LVKOList.DataBind(); recalcNoOfPages(); } else { this.LVKOList.DataSource = null; LVKOList.DataBind(); master.ShowMessage("Unsuccessful", false); } }
public void bindSubjectDropDown() { QuestAnsBAL QnABAL = new QuestAnsBAL(); DataTable dt = new DataTable(); LoggedIn master = (LoggedIn)this.Master; if (QnABAL.GetAllSubjects(ref dt)) { ddlSubject.DataSource = dt; ddlSubject.DataTextField = "ShortDesc"; ddlSubject.DataValueField = "SubId"; ddlSubject.DataBind(); ddlSubject.Items.Insert(0, new ListItem("-Select-", "-Select-")); } else { master.ShowMessage("Unsuccessful", false); } }
public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); if (QuestBAL.UnResolved(ref dt)) { lvQuestList.DataSource = dt; lvQuestList.DataBind(); recalcNoOfPages(); } else { //General master = (General)this.Master; //master.ShowMessage("Sorry No Records Were found", false); } }
//protected void btnBack_Click(object sender, EventArgs e) //{ // //Session["ViewKOId"] = hdnKOID.Value; // // Server.Transfer("QA_MYKO.aspx"); // Response.Redirect("~/UserMaint/LoggedInHome.aspx"); //} //this func should be ShowKO ?CV public void ShowQuestion() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); QuestAnsBE Quest = new QuestAnsBE(); Quest.QuestId = Convert.ToInt32(hdnQuestId.Value); if (QuestBAL.GetQuestion(ref dt, Quest)) { ViewState["QuestionTable"] = dt; lblQuest.Text = dt.Rows[0]["DetlQuestn"].ToString(); // lblShortdesc.Text = dt.Rows[0]["ShortDesc"].ToString(); lblQuestpostedby.Text = dt.Rows[0]["LastModifiedBy"].ToString(); lblPostedTime.Text = dt.Rows[0]["LastModifiedAt"].ToString(); } else { } }
protected void lvAnswerList_OnItemCommand(object sender, ListViewCommandEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); QuestAnsBE Ans = new QuestAnsBE(); Ans.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId; LoggedIn master = (LoggedIn)this.Master; if (String.Equals(e.CommandName, "like")) { Ans.AnsId = Convert.ToInt32(e.CommandArgument); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); Ans.Like = 1; Ans.DisLike = 0; if (AnsBAL.AddLike(Ans)) { GetAnswers(); master.ShowMessage("Successfully liked.", true); } else { master.ShowMessage("You are the author of this answer so can not Like or Dislike it", false); } } else if (String.Equals(e.CommandName, "dislike")) { Ans.AnsId = Convert.ToInt32(e.CommandArgument); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); Ans.Like = 0; Ans.DisLike = 1; if (AnsBAL.AddDisLike(Ans)) { GetAnswers(); master.ShowMessage("Successfully dislike.", true); } else { master.ShowMessage("You are the author of this answer so can not Like or Dislike it.", false); } } }
public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); DateTime FromDate = Convert.ToDateTime("2010/01/01"); DateTime Todate = DateTime.Now; if (txtFromDate.Text == "") { Quest.FromDate = FromDate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); // Quest.FromDate = DateTime.Parse(txtFromDate.Text, culture); Quest.FromDate = DateTime.ParseExact(txtFromDate.Text + " " + ddlFromHrs.Text + ':' + ddlFromMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtToDate.Text == "") { Quest.ToDate = Todate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); //Quest.ToDate = DateTime.Parse(txtToDate.Text, culture); Quest.ToDate = DateTime.ParseExact(txtToDate.Text + " " + ddlToHrs.Text + ':' + ddlToMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtSubject.Text == "") { Quest.Subject = "%"; } else { Quest.Subject = "%" + txtSubject.Text + "%"; } if (txtTags.Text == "") { Quest.Tag = "%"; } else { Quest.Tag = "%" + txtTags.Text + "%"; } if (txtYrOfStudyExp.Text == "") { Quest.YrsOfStudyStream = "%"; } else { Quest.YrsOfStudyStream = "%" + txtYrOfStudyExp.Text + "%"; } if (txtStudyStream.Text == "") //AM?? { Quest.StudyStream = "%"; //AM?? } else { Quest.StudyStream = "%" + txtStudyStream.Text + "%"; //AM?? } // if (txtKeyword.Text == "") //AM???? // { // Quest.Keyword = "%"; // } // else // { // Quest.Keyword = txtKeyword.Text; //} if (QuestBAL.SearchList(ref dt, Quest)) { lvQuestList.DataSource = dt; lvQuestList.DataBind(); recalcNoOfPages(); } else { lvQuestList.Items.Clear(); lvQuestList.DataSource = null; lvQuestList.DataBind(); LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Sorry No Records Were found", false); } }
protected void LvMyAns_ItemEditing(object sender, ListViewEditEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); int QId = Convert.ToInt32(LvMyAns.DataKeys[e.NewEditIndex].Value); int LastModifiedBy = ((UserBE)(Session["LoggedInUser"])).UserId; if (AnsBAL.AddView(LastModifiedBy, QId)) { Session["QuestId"] = LvMyAns.DataKeys[e.NewEditIndex].Value.ToString(); Response.Redirect("~/QuestAns/QA_QuestWithAns.aspx"); } }
protected void btnSuggestion_Click(object sender, EventArgs e) { General master = (General)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllSuggestions(ref dt)) { this.lvQueryList.DataSource = dt; lvQueryList.DataBind(); recalcNoOfPagesQuery(); } else { master.ShowMessage("Unsuccessful", false); } }
protected void btnSubmit_Onclick(object sender, EventArgs e) { LoggedIn master = (LoggedIn)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE QuestBE = new QuestAnsBE(); //if (!commonBAL.isUserAuthorisedForPageFunc(LoggedInUser.UserId, thisPageName, "add")) //{ //am // master.ShowMessage("You are not authorised to Perform any operation on this page. Please contact system administrator.", false); // // Server.Transfer("UM_BlankPage.aspx"); //?? send Message through Query String to the BlankPage // // string cat = Request.QueryString["Message"]; // // Response.Redirect("UM_BlankPage.aspx?Message=You are not authorised to Perform any operation on this page. Please contact system administrator."); // return; //} if (ValidData()) { return; } //QuestAnsBAL QuestBAL = new QuestAnsBAL(); //am //QuestAnsBE QuestBE = new QuestAnsBE(); //am QuestBE.Subject = ddlSubject.SelectedItem.Text; if (ddlSubject.SelectedItem.Text.Equals("Other")) QuestBE.OtherSubject = txtOtherSub.Text.Trim(); else QuestBE.OtherSubject = ""; QuestBE.ShortDesc = txtShortDesc.Text; QuestBE.DetailQuestion = txtDetailQuestion.Text.Replace(Environment.NewLine, "<br />"); //am QuestBE.PersClass = txtClass.Text; QuestBE.StudyStream = "-Select-"; QuestBE.YrsOfStudyStream = "0"; QuestBE.Tag = txtTag.Text; QuestBE.LastModifiedBy = ((UserBE)(Session["LoggedInUser"])).UserId; if (QuestBAL.AddQuestion(QuestBE)) { if (ddlSubject.SelectedItem.Text.Equals("Other")) divotherSub.Visible = false; foreach (Control txt in divAddOuery.Controls) { if (txt is TextBox) ((TextBox)(txt)).Text = string.Empty; else if (txt is DropDownList) ((DropDownList)(txt)).SelectedIndex = 0; } master.ShowMessage("Your Question has been Submitted Successfully", true); } else { master.ShowMessage("Unsuccessful", false); } }
protected void lvAnswerList_OnItemCommand(object sender, ListViewCommandEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); QuestAnsBE Ans = new QuestAnsBE(); if (Session["LoggedInUser"] != null) { Ans.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId; } else { Response.Redirect("~/Login.aspx"); } LoggedIn master = (LoggedIn)this.Master; if (String.Equals(e.CommandName, "like")) { Ans.AnsId = Convert.ToInt32(e.CommandArgument); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); Ans.Like = 1; Ans.DisLike = 0; if (AnsBAL.AddLike(Ans)) { GetAnswers(); master.ShowMessage("Successfully liked.", true); } else { master.ShowMessage("you have already liked this answer.", false); } } else if (String.Equals(e.CommandName, "dislike")) { Ans.AnsId = Convert.ToInt32(e.CommandArgument); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); Ans.Like = 0; Ans.DisLike = 1; if (AnsBAL.AddDisLike(Ans)) { GetAnswers(); master.ShowMessage("Successfully dislike.", true); } else { master.ShowMessage("you have already disliked this answer.", false); } } }
protected void btnSuggestion_Click(object sender, EventArgs e) { LoggedIn master = (LoggedIn)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllSuggestions(ref dt)) { this.lvQueryList.DataSource = dt; lvQueryList.DataBind(); recalcNoOfPagesQuery(); } else { this.lvQueryList.DataSource = null; lvQueryList.DataBind(); showDBErrorMsgs(dt); } }
private void bindPopularWL() { LoggedIn master = (LoggedIn)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllPopularWL(ref dt)) { this.lvQueryList.DataSource = dt; lvQueryList.DataBind(); recalcNoOfPagesQuery(); } else { this.lvQueryList.DataSource = null; lvQueryList.DataBind(); showDBErrorMsgs(dt); } }
protected void btnPost_Click(object sender, EventArgs e) { QuestAnsBE Ans = new QuestAnsBE(); QuestAnsBAL AnsBAL = new QuestAnsBAL(); Ans.QuestId = Convert.ToInt32(hdnQuestId.Value); Ans.Answer = txtAns.Text.Replace(Environment.NewLine, "<br/>"); if (ddlKO1.SelectedIndex > 0) { Ans.KO1Text = KO1.Text; Ans.KO1Type = ddlKO1.SelectedItem.Text; } else { Ans.KO1Text = ""; Ans.KO1Type = ""; } if (ddlKO2.SelectedIndex > 0) { Ans.KO2Text = KO2.Text; Ans.KO2Type = ddlKO2.SelectedItem.Text; } else { Ans.KO2Text = ""; Ans.KO2Type = ""; } if (ddlKO3.SelectedIndex > 0) { Ans.KO3Text = KO3.Text; Ans.KO3Type = ddlKO3.SelectedItem.Text; } else { Ans.KO3Text = ""; Ans.KO3Type = ""; } if (ddlKO4.SelectedIndex > 0) { Ans.KO4Text = KO4.Text; Ans.KO4Type = ddlKO4.SelectedItem.Text; } else { Ans.KO4Text = ""; Ans.KO4Type = ""; } Ans.LastModifiedBy = ((UserBE)(Session["LoggedInUser"])).UserId; if (AnsBAL.SaveAnswer(Ans)) { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Answer has been posted Successfully", true); GetAnswers(); } else { } }
protected void lvQuestList_ItemEditing(object sender, ListViewEditEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); int QId = Convert.ToInt32(lvQuestList.DataKeys[e.NewEditIndex].Value); int LastModifiedBy = 1; if (Session["LoggedInUser"] == null) { LastModifiedBy = 3; } else { LastModifiedBy = ((UserBE)(Session["LoggedInUser"])).UserId; } if (AnsBAL.AddView(LastModifiedBy, QId)) { Session["QuestionId"] = lvQuestList.DataKeys[e.NewEditIndex].Value.ToString(); Response.Redirect("~/QuestAns/QA_QuestWithAnsWOLogin.aspx"); } }
public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); DateTime FromDate = Convert.ToDateTime("2013/01/01"); DateTime Todate = Convert.ToDateTime("9999/01/01"); if (txtFromDate.Text == "") { Quest.FromDate = FromDate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); // Quest.FromDate = DateTime.Parse(txtFromDate.Text, culture); Quest.FromDate = DateTime.ParseExact(txtFromDate.Text + " " + ddlFromHrs.Text + ':' + ddlFromMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtToDate.Text == "") { Quest.ToDate = Todate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); //Quest.ToDate = DateTime.Parse(txtToDate.Text, culture); Quest.ToDate = DateTime.ParseExact(txtToDate.Text + " " + ddlToHrs.Text + ':' + ddlToMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtSubject.Text == "") { Quest.Subject = "%"; } else { Quest.Subject = "%" + txtSubject.Text + "%"; } if (txtTags.Text == "") { Quest.Tag = "%"; } else { Quest.Tag = "%" + txtTags.Text + "%"; } if (txtShortDesc.Text == "") { Quest.ShortDesc = "%"; } else { Quest.ShortDesc = "%" + txtShortDesc.Text + "%"; } // if (txtKeyword.Text == "") //{ // Quest.Keyword = "%"; //} //else //{ // Quest.Keyword = "%" + txtKeyword.Text + "%"; //} if (QuestBAL.SearchKO(ref dt, Quest)) { KOList.DataSource = dt; KOList.DataBind(); recalcNoOfPages(); } else { KOList.Items.Clear(); KOList.DataSource = null; KOList.DataBind(); LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("There is no data to show.", false); } }
protected void KOList_ItemEditing(object sender, ListViewEditEventArgs e) { QuestAnsBAL AnsBAL = new QuestAnsBAL(); int QId = Convert.ToInt32(KOList.DataKeys[e.NewEditIndex].Value); Session["KOId"] = KOList.DataKeys[e.NewEditIndex].Value.ToString(); Response.Redirect("~/QuestAns/QA_ViewKO.aspx"); }
private void bindLVKO() { LoggedIn master = (LoggedIn)this.Master; QuestAnsBAL QuestBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); if (QuestBAL.GetAllLinksWL(ref dt)) { this.LVKOList.DataSource = dt; LVKOList.DataBind(); recalcNoOfPages(); } else { this.LVKOList.DataSource = null; LVKOList.DataBind(); showDBErrorMsgs(dt); } }
public void GetAnswersofKO() //am?? { QuestAnsBAL AnsBAL = new QuestAnsBAL(); DataTable dt = new DataTable(); QuestAnsBE Ans = new QuestAnsBE(); Ans.QuestId = Convert.ToInt32(hdnKOID.Value); //AM?? if (AnsBAL.GetAnswersofKO(ref dt, Ans)) { this.lvAnswerList.DataSource = dt; this.lvAnswerList.DataBind(); } else { } }