/// <summary>
/// To Update details of StudentPreEducationDetailT in tbl_StudentPreEducationDetail_T table
/// Created By : Nafisa, 05-11-2014
/// Modified By :
/// </summary>
/// <param name="objStudentPreEducationDetailTBO"></param>
/// <returns></returns>
public ApplicationResult StudentPreEducationDetailT_Update(StudentPreEducationDetailTBO objStudentPreEducationDetailTBO)
{
try
{
pSqlParameter = new SqlParameter[12];
pSqlParameter[0] = new SqlParameter("@StudentEducationDetailTID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objStudentPreEducationDetailTBO.StudentEducationDetailTID;
pSqlParameter[1] = new SqlParameter("@StudentMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objStudentPreEducationDetailTBO.StudentMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objStudentPreEducationDetailTBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@SchoolName", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objStudentPreEducationDetailTBO.SchoolName;
pSqlParameter[4] = new SqlParameter("@Address", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objStudentPreEducationDetailTBO.Address;
pSqlParameter[5] = new SqlParameter("@MediumName", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objStudentPreEducationDetailTBO.MediumName;
pSqlParameter[6] = new SqlParameter("@PassedExam", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objStudentPreEducationDetailTBO.PassedExam;
pSqlParameter[7] = new SqlParameter("@BoardName", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objStudentPreEducationDetailTBO.BoardName;
pSqlParameter[8] = new SqlParameter("@PassingYear", SqlDbType.VarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objStudentPreEducationDetailTBO.PassingYear;
pSqlParameter[9] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objStudentPreEducationDetailTBO.IsDeleted;
pSqlParameter[10] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objStudentPreEducationDetailTBO.LastModifiedUserID;
pSqlParameter[11] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objStudentPreEducationDetailTBO.LastModifiedDate;
sSql = "usp_tbl_StudentPreEducationDetail_T_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
{
objStudentPreEducationDetailTBO = null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ApplicationResult objResults = new ApplicationResult();
StudentPreEducationDetailTBL objPreEducationBL = new StudentPreEducationDetailTBL();
StudentPreEducationDetailTBO objPreEducationBO = new StudentPreEducationDetailTBO();
objPreEducationBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objPreEducationBO.StudentMID = Convert.ToInt32(ViewState["StudentMID"].ToString());
objPreEducationBO.SchoolName = txtSchoolName.Text;
objPreEducationBO.Address = txtSchoolAddress.Text;
objPreEducationBO.MediumName = txtMediumName.Text;
objPreEducationBO.PassedExam = txtPassedExam.Text;
objPreEducationBO.BoardName = txtBoardName.Text;
objPreEducationBO.PassingYear = ddlPassingYear.SelectedItem.ToString();
objPreEducationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objPreEducationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objPreEducationBO.Town = txtTown.Text;
objPreEducationBO.Taluka = txtTaluka.Text;
objPreEducationBO.District = txtDistrict.Text;
objPreEducationBO.State = txtState.Text;
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objPreEducationBL.StudentPreEducationDetailT_Insert(objPreEducationBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
divDetails.Visible = false;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Student Education Details Saved Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Passing Exam/ Passing Year is already exists .');</script>");
}
}
else
{
objPreEducationBO.StudentEducationDetailTID = Convert.ToInt32(ViewState["StudentEducationDetailTID"].ToString());
objResults = objPreEducationBL.StudentPreEducationDetailT_Update(objPreEducationBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Student Education Details Update Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Passing Exam/ Passing Year is already exists .');</script>");
}
}
DatabaseTransaction.CommitTransation();
ClearAll();
GridDataBind();
#endregion
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
