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()); } }
public int InsertUploadMark(EWA_UploadResult objEWA1) { BL_UploadResult objBL = new BL_UploadResult(); int rs = objBL.InsertUploadMark_BL(objEWA1); return(rs); }
public int InsertUploadMark_DL(EWA_UploadResult objEWA) { int flag = 0; try { con.Open(); SqlCommand cmd = new SqlCommand("SP_UploadResult", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@"Action", objEWA.Action); cmd.Parameters.AddWithValue(@"ResultId", objEWA.ResultId); cmd.Parameters.AddWithValue(@"SubjectId", objEWA.SubjectId); cmd.Parameters.AddWithValue(@"Mark", objEWA.Mark); cmd.Parameters.AddWithValue(@"OutofMark", objEWA.Outofmark); flag = cmd.ExecuteNonQuery(); return(flag); } catch (Exception) { throw; } finally { con.Close(); } }
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()); } }
public DataSet FatchResultPDF_DL1(EWA_UploadResult ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[12]; prmList[0] = "@Action"; prmList[1] = ObjEWA.Action; prmList[2] = "@OrgId"; prmList[3] = ObjEWA.OrgId; prmList[4] = "@CourseId"; prmList[5] = ObjEWA.CourseId; prmList[6] = "@BranchId"; prmList[7] = ObjEWA.BranchId; prmList[8] = "@ClassId"; prmList[9] = ObjEWA.ClassId; prmList[10] = "@AcademinYear"; prmList[11] = ObjEWA.AcademinYear; ds = ObjHelper.FillControl(prmList, "SP_UploadResult"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
public int InsertUploadResult_DL(EWA_UploadResult objEWA) { int flag = 0; try { con.Open(); SqlCommand cmd = new SqlCommand("SP_UploadResult", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@"Action", objEWA.Action); cmd.Parameters.AddWithValue(@"TestId", objEWA.TestId); cmd.Parameters.AddWithValue(@"UserCode", objEWA.UserCode); cmd.Parameters.AddWithValue(@"Result", objEWA.Result); flag = cmd.ExecuteNonQuery(); return(flag); } catch (Exception) { throw; } finally { con.Close(); } }
public int InsertUploadTest_DL(EWA_UploadResult objEWA) { int flag = 0; try { con.Open(); SqlCommand cmd = new SqlCommand("SP_UploadResult", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@"Action", objEWA.Action); cmd.Parameters.AddWithValue(@"TestName", objEWA.TestName); cmd.Parameters.AddWithValue(@"CourseId", objEWA.CourseId); cmd.Parameters.AddWithValue(@"BranchId", objEWA.BranchId); cmd.Parameters.AddWithValue(@"ClassId", objEWA.ClassId); cmd.Parameters.AddWithValue(@"SemesterId", objEWA.SemesterId); cmd.Parameters.AddWithValue(@"OrgId", objEWA.OrgId); cmd.Parameters.AddWithValue(@"TotalMark", objEWA.TotalMark); cmd.Parameters.AddWithValue(@"Status", objEWA.Status); flag = cmd.ExecuteNonQuery(); return(flag); } catch (Exception) { throw; } finally { con.Close(); } }
//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()); } }
// Fatch Result #region [Fatch Result] public DataSet FatchResult_DL(EWA_UploadResult ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[6]; prmList[0] = "@Action"; prmList[1] = "FetchResult"; prmList[2] = "@TestId"; prmList[3] = ObjEWA.TestId; prmList[4] = "@UserCode"; prmList[5] = ObjEWA.UserCode; ds = ObjHelper.FillControl(prmList, "SP_UploadResult"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
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); } }
// Fatch Test #region [Fatch Test] public DataSet FatchTest_BL(EWA_UploadResult objEWA) { try { DL_UploadResult objDL = new DL_UploadResult(); DataSet ds = objDL.FatchTest_DL(objEWA); return(ds); } catch (Exception exp) { throw exp; } }
public int InsertUploadMark_BL(EWA_UploadResult objEWA) { try { DL_UploadResult objDL = new DL_UploadResult(); int rs = objDL.InsertUploadMark_DL(objEWA); return(rs); } catch (Exception exp) { throw exp; } }
public int DeleteUploadResultPDF_BL(EWA_UploadResult objEWA) { try { DL_UploadResult objDL = new DL_UploadResult(); int rs = objDL.DeleteUploadResultPDF_DL(objEWA); return(rs); } catch (Exception exp) { throw exp; } }
public int InsertUploadResultPDF_DL(EWA_UploadResult objEWA) { DataSet dss = new DataSet(); int flag = 0; try { con.Open(); SqlCommand cmd = new SqlCommand("SP_UploadResult", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@"Action", objEWA.Action); cmd.Parameters.AddWithValue(@"TestName", objEWA.TestName); cmd.Parameters.AddWithValue(@"OrgId", objEWA.OrgId); cmd.Parameters.AddWithValue(@"CourseId", objEWA.CourseId); cmd.Parameters.AddWithValue(@"BranchId", objEWA.BranchId); cmd.Parameters.AddWithValue(@"ClassId", objEWA.ClassId); cmd.Parameters.AddWithValue(@"AcademinYear", objEWA.AcademinYear); cmd.Parameters.AddWithValue(@"FileName", objEWA.FileName); cmd.Parameters.AddWithValue(@"ContentType", objEWA.ContentType); cmd.Parameters.AddWithValue(@"UploadedFile", objEWA.UploadedFile); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dss); con.Close(); if (dss.Tables[0].Rows.Count > 0) { int i = 0; while (dss.Tables[0].Rows.Count > i) { if (dss.Tables[0].Rows[i]["TokenId"].ToString() != "" && dss.Tables[0].Rows[i]["TokenId"].ToString() != "null" && dss.Tables[1].Rows[0]["SenderId"].ToString() != "") { SendPushNotification(dss.Tables[0].Rows[i]["TokenId"].ToString(), dss.Tables[0].Rows[i]["Subject"].ToString(), dss.Tables[0].Rows[i]["OrgName"].ToString(), dss.Tables[1].Rows[0]["SenderId"].ToString(), dss.Tables[1].Rows[0]["AppKey"].ToString()); } i++; } } return(1); } catch (Exception) { throw; } finally { con.Close(); } }
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()); } }
public void BindUploadResult() { try { database db = new database(); EWA_UploadResult objEWA1 = new EWA_UploadResult(); EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); //objEWA.SemesterId = ddlSemester.SelectedValue.ToString(); DataSet ds = objBL.BindResultFormat_BL(objEWA); int row = 0, rs = 0; if (grdResultFormat.Rows.Count > row && ds.Tables[0].Rows.Count > 0) { EWA_UploadResult objEWA2 = new EWA_UploadResult(); objEWA2.Action = "InsertUploadTest"; objEWA2.TestName = txtTestName.Text; objEWA2.TotalMark = txtTotalMarks.Text; objEWA2.OrgId = Session["OrgId"].ToString(); objEWA2.BranchId = ddlBranch.SelectedValue.ToString(); objEWA2.CourseId = ddlCourse.SelectedValue.ToString(); objEWA2.ClassId = ddlClass.SelectedValue.ToString(); objEWA2.SemesterId = null; objEWA2.Status = "1"; rs = InsertUploadTest(objEWA2); } else { GeneralErr("Record Not Found...!"); } while (grdResultFormat.Rows.Count > row && ds.Tables[1].Rows.Count > row) { int countColumn = grdResultFormat.Rows[0].Cells.Count; EWA_UploadResult objEWA3 = new EWA_UploadResult(); objEWA3.Action = "InsertUploadResult"; objEWA3.TestId = db.getDbstatus_Value("SELECT MAX(TestId) FROM tblUploadTest"); objEWA3.UserCode = grdResultFormat.Rows[row].Cells[0].Text; // TextBox txtResult = (TextBox)grdResultFormat.Rows[row].Cells[countColumn - 1].FindControl("txt" + (countColumn - 1)); TextBox txtResult = (TextBox)grdResultFormat.Rows[row].FindControl("Textresult"); if (txtResult.Text == "") { objEWA3.Result = "-"; } else { objEWA3.Result = txtResult.Text; } //TextBox txtResult = (TextBox)grdResultFormat.Rows[row].FindControl("txt3"); //if (txtResult.Text == "") // objEWA3.Result = "-"; //else // objEWA3.Result = txtResult.Text; rs = InsertUploadResult(objEWA3); string id = db.getDbstatus_Value("SELECT MAX(ResultId) FROM tblUploadResult"); int i = 0, j = 2; while (ds.Tables[0].Rows.Count > i && (countColumn - 1) > j) { //if (grdResultFormat.Rows[0].Cells[j].Text == ds.Tables[0].Rows[i][1].ToString()) //{ EWA_UploadResult objEWA4 = new EWA_UploadResult(); objEWA4.Action = "InsertUploadMark"; objEWA4.ResultId = id; objEWA4.SubjectId = ds.Tables[0].Rows[i][0].ToString(); TextBox txtmark = (TextBox)grdResultFormat.Rows[row].Cells[j].FindControl("txt" + j); // TextBox txtmark = (TextBox)grdResultFormat.Rows[row].Cells[j].FindControl("txt" + j); if (txtmark.Text == null) { objEWA4.Mark = "0"; } else { objEWA4.Mark = txtmark.Text; } TextBox txtOutofmark = (TextBox)grdResultFormat.Rows[row].Cells[j + 1].FindControl("txt" + j + 1); if (txtOutofmark.Text == null) { objEWA4.Outofmark = "0"; } else { objEWA4.Outofmark = txtOutofmark.Text; } rs = InsertUploadMark(objEWA4); //} i++; j = j + 2; } row++; } if (rs > 0) { //GeneralErr("Successfully Result Upload"); msgBox.ShowMessage("Successfull Result Upload", "Successfull", CMS.UserControls.MessageBox.MessageStyle.Successfull); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }