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());
}
}
