public int InsertUploadMark(EWA_UploadResult objEWA1) { BL_UploadResult objBL = new BL_UploadResult(); int rs = objBL.InsertUploadMark_BL(objEWA1); return(rs); }
//lnkBtnDelete_Click #region lnkBtnDelete_Click protected void lnkBtnDelete_Click(object sender, EventArgs e) { try { lock (this) { LinkButton lnkBtnId = (LinkButton)sender; GridViewRow grdrow = lnkBtnId.NamingContainer as GridViewRow; ViewState["TestId"] = grdResults.DataKeys[grdrow.RowIndex].Values["TestId"].ToString(); BL_UploadResult objBL = new BL_UploadResult(); EWA_UploadResult objEWA = new EWA_UploadResult(); objEWA.Action = "DeleteResultPDF"; objEWA.TestId = ViewState["TestId"].ToString(); int flag = objBL.DeleteUploadResultPDF_BL(objEWA); msgBox.ShowMessage("Delete Successfully !!!", "Delete", UserControls.MessageBox.MessageStyle.Successfull); BindGrdResult(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void FatchStudent() { try { EWA_UploadResult objEWA = new EWA_UploadResult(); BL_UploadResult objBL = new BL_UploadResult(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.UserCode = Session["UserCode"].ToString(); DataSet ds = objBL.FatchStudent_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { lblName.Text = ds.Tables[0].Rows[0][1].ToString(); lblCourse.Text = ds.Tables[0].Rows[0][2].ToString(); lblBranch.Text = ds.Tables[0].Rows[0][3].ToString(); lblClass.Text = ds.Tables[0].Rows[0][4].ToString(); CourseId = Convert.ToInt32(ds.Tables[0].Rows[0][5].ToString()); BranchId = Convert.ToInt32(ds.Tables[0].Rows[0][6].ToString()); ClassId = Convert.ToInt32(ds.Tables[0].Rows[0][7].ToString()); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void FatchTest() { try { EWA_UploadResult objEWA = new EWA_UploadResult(); BL_UploadResult objBL = new BL_UploadResult(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.CourseId = CourseId.ToString(); objEWA.BranchId = BranchId.ToString(); objEWA.ClassId = ClassId.ToString(); objEWA.SemesterId = ddlSemester.SelectedValue.ToString(); DataSet ds = objBL.FatchTest_BL(objEWA); ddlTest.DataSource = ds; if (ds.Tables[0].Rows.Count != 0) { ddlTest.DataTextField = "TestName"; ddlTest.DataValueField = "TestId"; ddlTest.DataBind(); } else { ddlTest.Items.Clear(); } ddlTest.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
protected void btnUpload_Click(object sender, EventArgs e) { try { string fileEXT = Path.GetExtension(FileUpload1.FileName); if (fileEXT.CompareTo(".pdf") == 0 || fileEXT.CompareTo(".PDF") == 0) { BL_UploadResult objBL = new BL_UploadResult(); EWA_UploadResult objEWA = new EWA_UploadResult(); objEWA.Action = "UploadResultPDF"; objEWA.TestName = txtTestName.Text; objEWA.OrgId = Session["OrgId"].ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); objEWA.AcademinYear = ddlAcademicyear.SelectedValue.ToString(); int fileLengthInKB = 0; if (FileUpload1.HasFile) { int length = FileUpload1.PostedFile.ContentLength; objEWA.UploadedFile = new byte[length]; objEWA.FileName = FileUpload1.PostedFile.FileName.ToString(); objEWA.ContentType = FileUpload1.PostedFile.ContentType; fileLengthInKB = FileUpload1.PostedFile.ContentLength / 1024; HttpPostedFile file = FileUpload1.PostedFile; file.InputStream.Read(objEWA.UploadedFile, 0, length); } if (fileLengthInKB > 1024) { msgBox.ShowMessage("Document should be less than or equal to 1MB !!!", "Information", UserControls.MessageBox.MessageStyle.Successfull); } else { int flag = objBL.InsertUploadResultPDF_BL(objEWA); msgBox.ShowMessage("Result PDF Upload Successfully !!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull); clear(); BindGrdResult(); } } else { msgBox.ShowMessage("Please choose .pdf file only.", "Information", CMS.UserControls.MessageBox.MessageStyle.Information); } } catch (Exception ex) { msgBox.ShowMessage("Unable to Save !!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull); } }
private void BindGrdResult() { try { BL_UploadResult objBL = new BL_UploadResult(); EWA_UploadResult objEWA = new EWA_UploadResult(); objEWA.Action = "FatchResultPDF"; objEWA.OrgId = Session["OrgId"].ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); DataSet ds = objBL.FatchResultPDF_BL(objEWA); grdResults.DataSource = ds; grdResults.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindGrdResult() { try { BL_UploadResult objBL = new BL_UploadResult(); EWA_UploadResult objEWA = new EWA_UploadResult(); objEWA.Action = "FatchResultPDF"; objEWA.OrgId = Session["OrgId"].ToString(); objEWA.CourseId = Session["CourseId"].ToString(); objEWA.BranchId = Session["BranchId"].ToString(); objEWA.ClassId = Session["ClassId"].ToString(); DataSet ds = objBL.FatchResultPDF_BL(objEWA); if (ds.Tables[0].Rows.Count > 0) { lblNodata.Visible = false; grdResults.Visible = true; grdResults.DataSource = ds; grdResults.DataBind(); } else { DataTable dt = new DataTable(); grdResults.DataSource = dt; grdResults.DataBind(); lblNodata.Visible = true; //grdResults.Visible = false; } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void FatchCourseBranchClass() { try { EWA_UploadResult objEWA = new EWA_UploadResult(); BL_UploadResult objBL = new BL_UploadResult(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.UserCode = Session["UserCode"].ToString(); DataSet ds = objBL.FatchStudent_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { Session["CourseId"] = Convert.ToInt32(ds.Tables[0].Rows[0][5].ToString()); Session["BranchId"] = Convert.ToInt32(ds.Tables[0].Rows[0][6].ToString()); Session["ClassId"] = Convert.ToInt32(ds.Tables[0].Rows[0][7].ToString()); } } catch (Exception exp) { // GeneralErr(exp.Message.ToString()); } }
private void FatchResult() { try { EWA_UploadResult objEWA = new EWA_UploadResult(); BL_UploadResult objBL = new BL_UploadResult(); objEWA.TestId = ddlTest.SelectedValue.ToString(); objEWA.UserCode = Session["UserCode"].ToString(); DataSet ds = objBL.FatchResult_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { lblSemester.Text = ddlSemester.SelectedItem.ToString(); //GridView1.DataSource = ds.Tables[0]; //GridView1.DataBind(); DataTable dt = new DataTable(); dt.Columns.Add("Subject"); dt.Columns.Add("Out Of Marks"); dt.Columns.Add("Obtain Marks"); DataRow dr; int i = 0, totalobtain = 0, totaloutof = 0, rs = 0; while (ds.Tables[0].Rows.Count > i) { dr = dt.NewRow(); dr[0] = ds.Tables[0].Rows[i][0].ToString(); dr[1] = ds.Tables[0].Rows[i][2].ToString(); dr[2] = ds.Tables[0].Rows[i][1].ToString(); totalobtain = totalobtain + Convert.ToInt32(ds.Tables[0].Rows[i][1].ToString()); totaloutof = totaloutof + Convert.ToInt32(ds.Tables[0].Rows[i][2].ToString()); if ((ds.Tables[0].Rows[i][3].ToString()).ToUpper() != "PASS") { rs = 1; } i++; dt.Rows.Add(dr); } dr = dt.NewRow(); dr[0] = "TOTAL"; dr[1] = totaloutof; dr[2] = totalobtain; dt.Rows.Add(dr); GridView1.DataSource = dt; GridView1.DataBind(); float per = (totalobtain * 100) / totaloutof; lblPersentage.Text = per.ToString() + " %"; if (rs == 0) { lblResult.Text = "PASS"; } else { lblResult.Text = "FAILED"; } GridView1.Rows[GridView1.Rows.Count - 1].Font.Bold = true; i = 0; while (GridView1.Rows.Count > i) { GridView1.Rows[i].Cells[1].HorizontalAlign = HorizontalAlign.Center; GridView1.Rows[i].Cells[2].HorizontalAlign = HorizontalAlign.Center; i++; } Panel2.Visible = true; } else { GeneralErr("Record Not Found...!"); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }