public int DL_InsUpdates(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@UpdatesID", objML_ExamMaster.ID),
new SqlParameter("@StudentName", objML_ExamMaster.StudentName),
new SqlParameter("@Desc", objML_ExamMaster.Description),new SqlParameter("@CreatedBy",objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Updates_Insert", par));
}
public int DL_InsTeramsCondition(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@TearmsID", objML_ExamMaster.ID),
new SqlParameter("@TeramsCondition", objML_ExamMaster.TearmsConditions),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_TearmsCondition_Insert", par));
}
public int DL_InsSubject(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@SubjectID", objML_ExamMaster.ID),
new SqlParameter("@SubjectName", objML_ExamMaster.SubjectName),
new SqlParameter("@SubjectDesc", objML_ExamMaster.Description),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Subjects_Insert", par));
}
public int DL_InsExamListName(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamMaster.ID),
new SqlParameter("@ExamName", objML_ExamMaster.SectionName),
new SqlParameter("@ExamDesc", objML_ExamMaster.Description),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_ExamListName_Insert", par));
}
public int DL_InsUpdVideoMaster(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID),
new SqlParameter("@SubjectName", objML_ExamMaster.SubjectName),
new SqlParameter("@TransType", objML_ExamMaster.TransType),
new SqlParameter("@FileName", objML_ExamMaster.Description),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Video_Insert", par));
}
public int DL_InsSection(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@SectionID", objML_ExamMaster.ID),
new SqlParameter("@SectionName", objML_ExamMaster.SectionName),
new SqlParameter("@SectionDesc", objML_ExamMaster.Description),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy), new SqlParameter("@DocType",objML_ExamMaster.DocType),
new SqlParameter("@SectionTime", objML_ExamMaster.SectionTime),
new SqlParameter("@TimeType", objML_ExamMaster.TimeType) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Sections_Insert", par));
}
public int DL_InsUpdQuestion(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@QuesionID", objML_ExamMaster.ID),
new SqlParameter("@Question", objML_ExamMaster.Question),
new SqlParameter("@OptionA", objML_ExamMaster.OPtionOne),
new SqlParameter("@OptionB", objML_ExamMaster.OptionTwo),
new SqlParameter("@OptionC", objML_ExamMaster.OptionThree),
new SqlParameter("@OptionD", objML_ExamMaster.OptionFour),
new SqlParameter("@CorrectAns", objML_ExamMaster.CorrectAns),
new SqlParameter("@CreatedBy", objML_ExamMaster.CreatedBy),
new SqlParameter("@ModifyBy", objML_ExamMaster.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Questions_Insert", par));
}
public DataTable DL_BindUserMaster(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_User_Master_Bind", par).Tables[0]);
}
public int BL_DeleteQuestion(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_DeleteQuestion(objML_ExamMaster));
}
public DataTable BL_BindQuestion(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_BindQuestion(objML_ExamMaster));
}
public DataTable DL_SelectStudentMapping(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Student_Mapping_Select", par).Tables[0]);
}
public int DL_DeleteSubject(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@SubjectID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Delete_Subjects", par));
}
public DataTable BL_BindExamListName(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_BindExamListName(objML_ExamMaster));
}
public DataTable DL_EditQuestion(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@QustionID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Edit_Questions", par).Tables[0]);
}
public int BL_InsUpdQuestion(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_InsUpdQuestion(objML_ExamMaster));
}
public int BL_DeleteAVMaster(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_DeleteAVMaster(objML_ExamMaster));
}
public int DL_DeleteExamListName(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Delete_ExamListName", par));
}
public DataTable DL_BindAVMaster(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Bind_Audio_Video_Master", par).Tables[0]);
}
public int DL_DeleteAVMaster(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Delete_Audio_Video_Master", par));
}
public DataTable DL_BindQuestion(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Bind_QuestionSheet", par).Tables[0]);
}
public int DL_DeleteUpdates(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Updates_Delete", par));
}
public int BL_DeleteExamListName(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_DeleteExamListName(objML_ExamMaster));
}
public DataTable DL_EditUpdates(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Updates_Select", par).Tables[0]);
}
public int BL_InsUpdAV(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_InsUpdAV(objML_ExamMaster));
}
public DataTable DL_EditSubject(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@SubjectID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Edit_Subjects", par).Tables[0]);
}
public DataTable DL_BindTearms(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Select_TearmsConditions", par).Tables[0]);
}
public DataTable DL_EditExamListName(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Edit_ExamListName", par).Tables[0]);
}
public DataTable BL_BindAVMaster(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_BindAVMaster(objML_ExamMaster));
}
public int DL_DeleteQuestion(ML_ExamMaster objML_ExamMaster)
{
SqlParameter[] par = { new SqlParameter("@QuestionID", objML_ExamMaster.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Delete_QuestionSheet", par));
}
public DataTable BL_EditSection(ML_ExamMaster objML_ExamMaster)
{
return(objDL_ExamMaster.DL_EditSection(objML_ExamMaster));
}