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
{
}
}