protected void btnsave_Click(object sender, EventArgs e)
{
try
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "FillObtainedMarks();", true);
StudentMarksBO objStudentMarksBO = new StudentMarksBO();
StudentMarksBL objStudentMarksBL = new StudentMarksBL();
ApplicationResult objResult = new ApplicationResult();
int ObtainedMarks, TotalMarks, PassingMarks;
DatabaseTransaction.OpenConnectionTransation();
foreach (GridViewRow row in gvStudentMarks.Rows)
{
objStudentMarksBO.ExamConfigId = Convert.ToInt32(hfExamConfigId.Value);
objStudentMarksBO.SubjectId = Convert.ToInt32(ddlSubject.SelectedValue);
objStudentMarksBO.StudentId = Convert.ToInt32(row.Cells[1].Text);
objStudentMarksBO.Exam = ddlExam.SelectedItem.ToString();
TextBox txtTotalMarks = (TextBox)row.FindControl("txtTotal");
//txtTotalMarks.Enabled = true;
TotalMarks = Convert.ToInt32(txtTotalMarks.Text);
objStudentMarksBO.TotalMarks = TotalMarks;
TextBox txtObtainedMarks = (TextBox)row.FindControl("txtObtained");
//txtObtainedMarks.Enabled = true;
ObtainedMarks = Convert.ToInt32(txtObtainedMarks.Text);
objStudentMarksBO.ObtainedMarks = ObtainedMarks;
TextBox txtPassingMarks = (TextBox)row.FindControl("txtPassing");
PassingMarks = Convert.ToInt32(txtPassingMarks.Text);
objStudentMarksBO.PassingMarks = PassingMarks;
if (ViewState["Mode"].ToString() == "Save")
{
objStudentMarksBO.CreatedById = Convert.ToInt32(Session[ApplicationSession.USERID]);
objStudentMarksBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objStudentMarksBL.StudentMarks_Insert(objStudentMarksBO);
}
else
{
objStudentMarksBO.LastModifiedById = Convert.ToInt32(Session[ApplicationSession.USERID]);
objStudentMarksBO.LastModifiedByDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objStudentMarksBL.StudentMarks_Update(objStudentMarksBO);
}
}
if (objResult != null)
{
if (objResult.status.ToString() == "SUCCESS")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Data Saved Successfully.');</script>");
DatabaseTransaction.CommitTransation();
Controls objControl = new Controls();
objControl.ClearForm(Master.FindControl("ContentPlaceHolder1"));
gvStudentMarks.DataSource = null;
gvStudentMarks.Visible = false;
btnsave.Visible = false;
}
}
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of StudentMarks in tbl_StudentMarks_M table
/// Created By : Vishal, 1/12/2016
/// Modified By :
/// </summary>
public ApplicationResult StudentMarks_Update(StudentMarksBO objStudentMarksBo)
{
try
{
pSqlParameter = new SqlParameter[10];
//pSqlParameter[0] = new SqlParameter("@StudentMarksId",SqlDbType.Int);
//pSqlParameter[0].Direction = ParameterDirection.Input;
//pSqlParameter[0].Value = objStudentMarksBo.StudentMarksId;
pSqlParameter[0] = new SqlParameter("@ExamConfigId", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objStudentMarksBo.ExamConfigId;
//pSqlParameter[1] = new SqlParameter("@SubjectId",SqlDbType.Int);
//pSqlParameter[1].Direction = ParameterDirection.Input;
//pSqlParameter[1].Value = objStudentMarksBo.SubjectId;
pSqlParameter[1] = new SqlParameter("@StudentId", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objStudentMarksBo.StudentId;
pSqlParameter[2] = new SqlParameter("@Exam", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objStudentMarksBo.Exam;
pSqlParameter[3] = new SqlParameter("@TotalMarks", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objStudentMarksBo.TotalMarks;
pSqlParameter[4] = new SqlParameter("@PassingMarks", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objStudentMarksBo.PassingMarks;
pSqlParameter[5] = new SqlParameter("@ObtainedMarks", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objStudentMarksBo.ObtainedMarks;
//pSqlParameter[6] = new SqlParameter("@CreatedById",SqlDbType.Int);
//pSqlParameter[8].Direction = ParameterDirection.Input;
//pSqlParameter[8].Value = objStudentMarksBo.CreatedById;
//pSqlParameter[9] = new SqlParameter("@CreatedDate",SqlDbType.VarChar);
//pSqlParameter[9].Direction = ParameterDirection.Input;
//pSqlParameter[9].Value = objStudentMarksBo.CreatedDate;
pSqlParameter[6] = new SqlParameter("@LastModifiedById", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objStudentMarksBo.LastModifiedById;
pSqlParameter[7] = new SqlParameter("@LastModifiedByDate", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objStudentMarksBo.LastModifiedByDate;
pSqlParameter[8] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objStudentMarksBo.IsDeleted;
pSqlParameter[9] = new SqlParameter("@SubjectId", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objStudentMarksBo.SubjectId;
sSql = "usp_tbl_StudentMarks_M_Update";
int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objStudentMarksBo = null;
}
}
