protected void FinishData() { long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); if (Session["UserType"] != null && Session["UserType"].ToString() == "User") { Catalog_DAC dac = new Catalog_DAC(); int res = dac.UpdateUserDetails(UserId); if (res > 0) { Session["UserId"] = null; Session["UserType"] = null; Response.Redirect("~/Login.aspx"); } dac = null; } if (Session["UserType"] != null && Session["UserType"].ToString() == "Evaluator") { long EvaluatorId = 0; long.TryParse(Session["EvaluatorId"].ToString(), out EvaluatorId); Catalog_DAC dac = new Catalog_DAC(); int res = dac.UpdateEvaluatorDetails(UserId, EvaluatorId); dac = null; Session["UserId"] = null; Response.Redirect("AdminHome.aspx"); } if (Session["UserType"] != null && Session["UserType"].ToString() == "Administrator") { Session["UserId"] = null; Response.Redirect("AdminHome.aspx"); } }
private void GetCatalogOptions() { Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getCatalogOptions(); dac = null; ViewState["dtCtlgOpts"] = dt; }
private void GetTagValues() { Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getTagValues(); if (dt != null && dt.Rows.Count > 0) { ViewState["TagValues"] = dt; } }
private void GetUserTestDetails() { DateTime StartDate = DateTime.Now.Date; DateTime EndDate = DateTime.Now.Date; StartDate = Convert.ToDateTime(txtFromDate.Text); EndDate = Convert.ToDateTime(txtToDate.Text); gvUserTestDtls.DataSource = null; Catalog_DAC dac = new Catalog_DAC(); { DataTable dt = dac.GetUserTestDetails(StartDate, EndDate); gvUserTestDtls.DataSource = dt; } gvUserTestDtls.DataBind(); }
private void GetImgPaths() { long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getImagePaths(); ViewState["dtImgPaths"] = dt; DataTable dt1 = dac.getImageAnswers(UserId); ViewState["dtImgAns"] = dt1; dac = null; }
private void SaveCataloguingData(bool IsSubmit) { string Cat_Answer = string.Empty; int CatalogId = 0; int.TryParse(hdfQn.Value, out CatalogId); long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); long EvaluatorId = 0; bool CheckedResult = false; if (Session["UserType"].ToString() == "User") { if (rbtnCtlgOpts.SelectedIndex >= 0) { Cat_Answer = rbtnCtlgOpts.SelectedItem.Text; } Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertCataloguingDetails(CatalogId, Cat_Answer, UserId); if (res > 0) { if (IsSubmit) { Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } } dac = null; } if (Session["UserType"].ToString() == "Evaluator") { bool.TryParse(chkResult.Checked.ToString(), out CheckedResult); Catalog_DAC dac = new Catalog_DAC(); int res = dac.UpdateEvaluatorCataloguingDetails(CatalogId, UserId, EvaluatorId, CheckedResult); if (res > 0) { if (IsSubmit) { Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } } dac = null; } }
private void GetMarcTags() { long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); gvMarcTags.DataSource = null; Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getMarcQuesctions(1, UserId); dac = null; if (dt != null && dt.Rows.Count > 0) { gvMarcTags.DataSource = dt; } gvMarcTags.DataBind(); }
private void GetCatalogs() { Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getCataloguingQuesctions(4); dac = null; ViewState["dtCtlgQns"] = dt; if (dt != null && dt.Rows.Count > 0) { for (int i = 1; i <= dt.Rows.Count; i++) { ListItem li = new ListItem(); li.Text = i.ToString(); li.Value = dt.Rows[i - 1]["CatalogId"].ToString(); BulletedList1.Items.Add(li); } hdfQn.Value = BulletedList1.Items[0].Value; } }
private void GeImgQuestions() { BulletedList1.Items.Clear(); Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getImagePartsQuesctions(3); dac = null; ViewState["dtImgQns"] = dt; if (dt != null && dt.Rows.Count > 0) { for (int i = 1; i <= dt.Rows.Count; i++) { ListItem li = new ListItem(); li.Text = i.ToString(); li.Value = dt.Rows[i - 1]["ImgMastId"].ToString(); BulletedList1.Items.Add(li); } hdfQn.Value = BulletedList1.Items[0].Value; } }
protected void FillUserCatalogs() { lblUsrAns.Text = string.Empty; chkResult.Checked = false; long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); int CatalogId = 0; if (hdfQn.Value.Length > 0) { int.TryParse(hdfQn.Value, out CatalogId); } if (CatalogId > 0) { rbtnCtlgOpts.ClearSelection(); Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getUserCatalogs(CatalogId, UserId); dac = null; if (dt != null && dt.Rows.Count > 0) { if (Session["UserType"].ToString() == "User") { rbtnCtlgOpts.SelectedIndex = rbtnCtlgOpts.Items.IndexOf(rbtnCtlgOpts.Items.FindByText(dt.Rows[0]["Cat_Answer"].ToString())); } if (Session["UserType"].ToString() == "Evaluator" || Session["UserType"].ToString() == "Administrator") { rbtnCtlgOpts.Visible = false; divEval.Visible = true; lblUsrAns.Text = dt.Rows[0]["Cat_Answer"].ToString(); bool chkres = false; bool.TryParse(dt.Rows[0]["Result"].ToString(), out chkres); chkResult.Checked = chkres; } } } }
protected void btnTimeOut_Click(object sender, EventArgs e) { long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); if (Session["UserType"] != null && Session["UserType"].ToString() == "User") { SaveCitationsData(); if (Session["UserType"] != null && Session["UserType"].ToString() == "User") { Catalog_DAC dac = new Catalog_DAC(); int res = dac.UpdateUserDetails(UserId); if (res > 0) { Session["UserId"] = null; Session["UserType"] = null; Response.Redirect("~/Login.aspx"); } dac = null; } } }
private void SaveCitationsData() { int CitationId = 0; int.TryParse(hdfQn.Value, out CitationId); long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); DataTable dtCitations = ViewState["dtCitations"] as DataTable; if (Session["UserType"].ToString() == "User") { Dictionary <string, string> diCitations = new Dictionary <string, string>(); foreach (DetailsViewRow dvr in dvCitation.Rows) { foreach (DataColumn dc in dtCitations.Columns) { if (dc.ColumnName != "Citation") { TextBox txt = dvr.FindControl("txt" + dc.ColumnName) as TextBox; if (txt != null) { diCitations.Add(dc.ColumnName, txt.Text.Trim()); } } } break; } if (CitationId > 0 && diCitations.Count > 0) { Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertCitationDetails(CitationId, diCitations, UserId); if (res > 0) { // Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; //BindCitation(); } } if (Session["UserType"].ToString() == "Evaluator") { long EvaluatorId = 0; decimal Marks = 0; string Comments = string.Empty; long.TryParse(Session["EvaluatorId"].ToString(), out EvaluatorId); foreach (DetailsViewRow dvr in dvCitation.Rows) { TextBox txtComments = dvr.Cells[1].FindControl("txtComments") as TextBox; if (txtComments != null) { Comments = txtComments.Text.Trim(); } TextBox txtResult = dvr.Cells[1].FindControl("txtResult") as TextBox; if (txtResult != null) { decimal.TryParse(txtResult.Text.Trim(), out Marks); } } if (CitationId > 0 && EvaluatorId > 0) { Catalog_DAC dac = new Catalog_DAC(); int res = dac.UpdateEevaluatorCitationDetails(CitationId, UserId, EvaluatorId, Comments, Marks); if (res > 0) { //Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; } } }
private void SaveImagePartsData() { BindCatalogs(); long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); int ImgMastId = 0; if (hdfQn.Value.Length > 0) { int.TryParse(hdfQn.Value, out ImgMastId); } if (ImgMastId > 0) { string ImgAnsIds = string.Empty; string ImgAns = string.Empty; DataTable dtImgAns = ViewState["dtImgAns"] as DataTable; if (Session["UserType"].ToString() == "User") { DataRow[] drImgAns = dtImgAns.Select("ImgMastId=" + ImgMastId + ""); if (drImgAns != null && drImgAns.Length > 0 && drImgAns[0]["QueType"].ToString() == "CheckBox") { if (rbtnImgOpts.SelectedIndex > 0) { if (ImgAnsIds == string.Empty) { ImgAnsIds = rbtnImgOpts.ToolTip; } else { ImgAnsIds = ImgAnsIds + "~" + rbtnImgOpts.ToolTip; } if (ImgAns == string.Empty) { ImgAns = rbtnImgOpts.SelectedItem.Value; } else { ImgAns = ImgAns + "~" + rbtnImgOpts.SelectedItem.Value; } } } else if (drImgAns != null && drImgAns.Length > 0 && drImgAns[0]["QueType"].ToString() == "TextBox") { foreach (GridViewRow gvr in gvImagesAns.Rows) { TextBox txtImgAns = gvr.FindControl("txtImgAns") as TextBox; if (txtImgAns != null) { if (ImgAnsIds == string.Empty) { ImgAnsIds = gvr.Cells[1].Text; } else { ImgAnsIds = ImgAnsIds + "~" + gvr.Cells[1].Text; } string strtxt = (txtImgAns.Text.Length == 0 ? null : txtImgAns.Text); if (ImgAns == string.Empty) { ImgAns = strtxt; } else { ImgAns = ImgAns + "~" + strtxt; } } } } if (ImgAnsIds != string.Empty) { Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertimageDetails(ImgAnsIds, ImgAns, UserId); if (res > 0) { // Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; } } if (Session["UserType"].ToString() == "Evaluator") { long EvaluatorId = 0; decimal Marks = 0; string Comments = string.Empty; long.TryParse(Session["EvaluatorId"].ToString(), out EvaluatorId); if (EvaluatorId > 0) { decimal.TryParse(txtMarks.Text, out Marks); Comments = txtComments.Text.Trim(); Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertEvaluatorImageDetails(ImgMastId, UserId, EvaluatorId, Marks, Comments); if (res > 0) { // Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; } } } }
private void BindImgAnswers() { dvImgEvl.Visible = false; txtMarks.Text = string.Empty; txtComments.Text = string.Empty; rbtnImgOpts.Visible = true; divEval.Visible = false; lblImgAns.Text = string.Empty; lblUsrAns.Text = string.Empty; int ImgMastId = 0; if (hdfQn.Value.Length > 0) { int.TryParse(hdfQn.Value, out ImgMastId); } long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); if (ImgMastId > 0) { DataTable dtImgAns = ViewState["dtImgAns"] as DataTable; DataRow[] drImgAns = dtImgAns.Select("ImgMastId=" + ImgMastId + ""); gvImagesAns.DataSource = null; if (drImgAns != null && drImgAns.Length > 0 && drImgAns[0]["QueType"].ToString() == "TextBox") { gvImagesAns.DataSource = drImgAns.CopyToDataTable(); } gvImagesAns.DataBind(); rbtnImgOpts.Items.Clear(); if (drImgAns != null && drImgAns.Length > 0 && drImgAns[0]["QueType"].ToString() == "CheckBox") { DataTable dtImgPaths = ViewState["dtImgPaths"] as DataTable; DataRow[] drImgPaths = dtImgPaths.Select("ImgMastId=" + ImgMastId + ""); DataTable dtTemp = drImgPaths.CopyToDataTable(); int r = 1; rbtnImgOpts.ToolTip = drImgAns[0]["ImgAnsId"].ToString(); foreach (DataRow dr in dtTemp.Rows) { ListItem li = new ListItem(); li.Text = "Page(" + r.ToString() + ")"; li.Value = dr["PathId"].ToString(); rbtnImgOpts.Items.Add(li); r++; } rbtnImgOpts.SelectedIndex = rbtnImgOpts.Items.IndexOf(rbtnImgOpts.Items.FindByValue(drImgAns[0]["UsrAnswer"].ToString())); if (Session["UserType"].ToString() == "Evaluator") { rbtnImgOpts.Visible = false; divEval.Visible = true; lblImgAns.Text = drImgAns[0]["ImgAnswer"].ToString(); lblUsrAns.Text = (rbtnImgOpts.SelectedIndex > -1 ? rbtnImgOpts.SelectedItem.Text : ""); } } if (Session["UserType"].ToString() == "Evaluator" || Session["UserType"].ToString() == "Administrator") { dvImgEvl.Visible = true; Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getEvaluatorImageDetails(ImgMastId, UserId); dac = null; if (dt != null && dt.Rows.Count > 0) { txtMarks.Text = dt.Rows[0]["Marks"].ToString(); txtComments.Text = dt.Rows[0]["Comments"].ToString(); } } } }
private void SaveMarcData() { string MarcIds = string.Empty; string MarcAns = string.Empty; string Comments = string.Empty; long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); long EvaluatorId = 0; if (Session["UserType"].ToString() == "User") { foreach (GridViewRow gvr in gvMarcTags.Rows) { if (MarcIds == string.Empty) { MarcIds = gvr.Cells[1].Text; } else { MarcIds = MarcIds + "~" + gvr.Cells[1].Text; } DropDownList ddlTV = gvr.FindControl("ddlTagValues") as DropDownList; if (MarcAns == string.Empty) { MarcAns = ddlTV.SelectedItem.Text; } else { MarcAns = MarcAns + "~" + ddlTV.SelectedItem.Text; } } if (MarcIds != string.Empty) { Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertMarcDetails(MarcIds, MarcAns, UserId, EvaluatorId, Comments); if (res > 0) { Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; GetMarcTags(); } } int chkres = 0; if (Session["UserType"].ToString() == "Evaluator") { long.TryParse(Session["EvaluatorId"].ToString(), out EvaluatorId); foreach (GridViewRow gvr in gvMarcTags.Rows) { chkres = 0; if (MarcIds == string.Empty) { MarcIds = gvr.Cells[1].Text; } else { MarcIds = MarcIds + "~" + gvr.Cells[1].Text; } CheckBox chkReselt = gvr.FindControl("chkReselt") as CheckBox; chkres = (chkReselt.Checked ? 1 : 0); if (MarcAns == string.Empty) { MarcAns = chkres.ToString(); } else { MarcAns = MarcAns + "~" + chkres.ToString(); } TextBox txtComments = gvr.FindControl("txtComments") as TextBox; string tempcmt = (txtComments.Text.Trim().Length > 0 ? txtComments.Text : null); if (Comments == string.Empty) { Comments = tempcmt; } else { Comments = Comments + "~" + tempcmt; } } if (MarcIds != string.Empty) { Catalog_DAC dac = new Catalog_DAC(); int res = dac.InsertMarcDetails(MarcIds, MarcAns, UserId, EvaluatorId, Comments); if (res > 0) { //Page.ClientScript.RegisterStartupScript(typeof(Page), "marin", "alert('Recard saved.')", true); } dac = null; GetMarcTags(); } } }
private void FillUserCitations() { foreach (DetailsViewRow dvr in dvCitation.Rows) { if (dvr.Cells[1].HasControls() == true && dvr.Cells[1].Controls.Count > 0) { TextBox txt = dvr.Cells[1].Controls[1] as TextBox; if (txt != null) { txt.Text = string.Empty; if (txt.ID == "txtComments" || txt.ID == "txtResult") { if (Session["UserType"].ToString() == "User") { dvr.Visible = false; } else { dvr.Visible = true; } if (Session["UserType"].ToString() == "Evaluator") { dvr.Visible = true; txt.Enabled = true; txt.Visible = true; } else if (Session["UserType"].ToString() == "Administrator") { txt.Visible = true; txt.Enabled = false; } } } } } long UserId = 0; long.TryParse(Session["UserId"].ToString(), out UserId); int CitationId = 0; if (hdfQn.Value.Length > 0) { int.TryParse(hdfQn.Value, out CitationId); } if (CitationId > 0) { Catalog_DAC dac = new Catalog_DAC(); DataTable dt = dac.getUserCitations(CitationId, UserId); dac = null; if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (dvCitation.Rows.Count > 0) { foreach (DetailsViewRow dvr in dvCitation.Rows) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName != "Citation") { if (dvr.Cells[0].Text == dc.ColumnName) { TextBox txt = dvr.Cells[1].FindControl("txt" + dc.ColumnName) as TextBox; Label lbl = dvr.Cells[1].FindControl("lbl" + dc.ColumnName) as Label; if (txt != null) { txt.Text = dr[dc.ColumnName].ToString(); } if (Session["UserType"].ToString() == "Evaluator" || Session["UserType"].ToString() == "Administrator") { if (lbl != null && lbl.Visible == false) { lbl.Visible = true; } } break; } } } } } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserType"] == null) { Response.Redirect("~/Login.aspx"); } if (!IsPostBack) { if (Session["crnttime"] != null) { hdfTimer.Value = Session["crnttime"].ToString(); hdfRoleId.Value = Session["RoleId"].ToString(); } //HttpCookie cookiename = Request.Cookies.Get("cookiename"); //// Check if cookie exists in the current request. //if (cookiename != null) //{ // hdfTimer.Value = cookiename.Value; //} if (Request.QueryString["UserType"] != null) { //hdfStartTime.Value = string.Empty; Session["StartTime"] = ""; Session["UserType"] = null; Session["EvaluatorId"] = null; Session["LoginName"] = null; Session["StartTime"] = null; Session["UserType"] = Request.QueryString["UserType"]; if (Request.QueryString["UserType"] == "User") { if (Request.QueryString["UserId"] != null) { Session["UserId"] = Request.QueryString["UserId"]; Session["EvaluatorId"] = 0; } } } if (Request.QueryString["LoginName"] != null) { Session["LoginName"] = Request.QueryString["LoginName"]; } Catalog_DAC dac = new Catalog_DAC(); { DataTable dt = dac.getIndex(); gvIndex.DataSource = dt; gvIndex.DataBind(); } if (Session["UserType"] != null) { if (Session["UserType"].ToString() == "User") { lnkHome.Visible = false; } } if (Session["UserName"] != null) { lblUserName.Text = Session["UserName"].ToString(); } } }