/// <summary>
/// To Update details of ExamConfigurationBL in ExamConfiguration table
/// Created By : Vishal, 1/7/2016
/// Modified By :
/// </summary>
public ApplicationResult ExamConfigurationBL_Update(ExamConfigurationBO objExamConfigurationBLBo)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@ExamConfigId", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objExamConfigurationBLBo.ExamConfigId;
pSqlParameter[1] = new SqlParameter("@ClassId", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objExamConfigurationBLBo.ClassId;
pSqlParameter[2] = new SqlParameter("@DivisionId", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objExamConfigurationBLBo.DivisionId;
pSqlParameter[3] = new SqlParameter("@AcademicYear", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objExamConfigurationBLBo.AcademicYear;
pSqlParameter[4] = new SqlParameter("@Exam", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objExamConfigurationBLBo.Exam;
pSqlParameter[5] = new SqlParameter("@SubjectId", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objExamConfigurationBLBo.SubjectId;
pSqlParameter[6] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objExamConfigurationBLBo.LastModifiedBy;
pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.NVarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objExamConfigurationBLBo.LastModifiedDate;
pSqlParameter[8] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objExamConfigurationBLBo.IsDeleted;
sSql = "usp_tbl_ExamConfiguration_Update";
DataTable ResultDT = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
if (ResultDT.Rows[0][0].ToString() == "333")
{
ApplicationResult objResults = new ApplicationResult(ResultDT);
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else if (ResultDT.Rows[0][0].ToString() == "222")
{
ApplicationResult objResults = new ApplicationResult(ResultDT);
objResults.status = ApplicationResult.CommonStatusType.RECORD_FK_VIOLATION;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult(ResultDT);
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objExamConfigurationBLBo = null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
ExamConfigurationBO objExamConfigurationBO = new ExamConfigurationBO();
ExamConfigurationBL objExamConfigurationBL = new ExamConfigurationBL();
int intExamConfigID = 0;
objExamConfigurationBO.ClassId = Convert.ToInt32(ddlClass.SelectedValue);
objExamConfigurationBO.DivisionId = Convert.ToInt32(ViewState["DivisionTID"]);
objExamConfigurationBO.AcademicYear = ddlAcademicYear.SelectedItem.ToString();
objExamConfigurationBO.Exam = ddlExam.SelectedItem.ToString();
objExamConfigurationBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objExamConfigurationBO.IsDeleted = 0;
foreach (ListItem i in lbDestSubject.Items)
{
SubjectIDs += i.Value + ",";
}
SubjectIDs = SubjectIDs.Substring(0, SubjectIDs.Length - 1);
objExamConfigurationBO.SubjectId = SubjectIDs;
if (ViewState["Mode"].ToString() == "Save")
{
intExamConfigID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intExamConfigID = Convert.ToInt32(ViewState["ExamConfigID"]);
}
objResult =
objExamConfigurationBL.ExamConfigurationBL_ValidateName(Convert.ToInt32(ddlClass.SelectedValue),
Convert.ToInt32(ViewState["DivisionTID"]), ddlExam.SelectedItem.ToString(),
ddlAcademicYear.SelectedItem.ToString(), intExamConfigID, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Exam already Saved.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
objExamConfigurationBO.CreatedByUserId = Convert.ToInt32(Session[ApplicationSession.USERID]);
objExamConfigurationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objExamConfigurationBL.ExamConfigurationBL_Insert(objExamConfigurationBO);
if (objResult != null)
{
Controls objControls = new Controls();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Exam Details Saved Successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objExamConfigurationBO.ExamConfigId = Convert.ToInt32(ViewState["ExamConfigID"]);
//objExamConfigurationBO.ClassId = Convert.ToInt32(ddlClass.SelectedValue);
//objExamConfigurationBO.DivisionId = Convert.ToInt32(ViewState["DivisionTID"]);
//objExamConfigurationBO.AcademicYear = ddlAcademicYear.SelectedItem.ToString();
//objExamConfigurationBO.Exam = ddlExam.SelectedItem.ToString();
//objExamConfigurationBO.IsDeleted = 0;
//foreach (ListItem i in lbDestSubject.Items)
//{
// SubjectIDs += i.Value + ",";
//}
//SubjectIDs = SubjectIDs.Substring(0, SubjectIDs.Length - 1);
//objExamConfigurationBO.SubjectId = SubjectIDs;
objExamConfigurationBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objExamConfigurationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objExamConfigurationBL.ExamConfigurationBL_Update(objExamConfigurationBO);
if (objResult.resultDT.Rows[0][0].ToString() == "333")
{
Controls objControls = new Controls();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Exam Details Updated Successfully.');</script>");
}
else if (objResult.resultDT.Rows[0][0].ToString() == "222")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Exam Details Can not be Updated.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
ClearAll();
BindExamConfig();
PanelVisibility(1);
}
}
}
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>");
}
}
/// <summary>
/// To Insert details of ExamConfigurationBL in ExamConfiguration table
/// Created By : Vishal, 1/7/2016
/// Modified By :
/// </summary>
public ApplicationResult ExamConfigurationBL_Insert(ExamConfigurationBO objExamConfigurationBLBo)
{
try
{
pSqlParameter = new SqlParameter[11];
pSqlParameter[0] = new SqlParameter("@ClassId", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objExamConfigurationBLBo.ClassId;
pSqlParameter[1] = new SqlParameter("@DivisionId", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objExamConfigurationBLBo.DivisionId;
pSqlParameter[2] = new SqlParameter("@AcademicYear", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objExamConfigurationBLBo.AcademicYear;
pSqlParameter[3] = new SqlParameter("@Exam", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objExamConfigurationBLBo.Exam;
pSqlParameter[4] = new SqlParameter("@SubjectId", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objExamConfigurationBLBo.SubjectId;
pSqlParameter[5] = new SqlParameter("@CreatedByUserId", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objExamConfigurationBLBo.CreatedByUserId;
pSqlParameter[6] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objExamConfigurationBLBo.CreatedDate;
pSqlParameter[7] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objExamConfigurationBLBo.LastModifiedBy;
pSqlParameter[8] = new SqlParameter("@LastModifiedDate", SqlDbType.NVarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objExamConfigurationBLBo.LastModifiedDate;
pSqlParameter[9] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objExamConfigurationBLBo.IsDeleted;
pSqlParameter[10] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objExamConfigurationBLBo.SchoolMID;
sSql = "usp_tbl_ExamConfiguration_Insert";
int iResult = Database.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
{
objExamConfigurationBLBo = null;
}
}
