internal DataTable GetUneversityRecords(PLExamMapping objExamMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objExamMappPl.Ind);
cmd.Parameters.AddWithValue("@ExamYear", objExamMappPl.ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", objExamMappPl.ExamSession);
cmd.Parameters.AddWithValue("@ExamSessionID", objExamMappPl.ExamSessionID);
cmd.Parameters.AddWithValue("@ExamFacultyCD", objExamMappPl.ExamFacultyCD);
cmd.Parameters.AddWithValue("@ExamName", objExamMappPl.ExamName);
da = new SqlDataAdapter(cmd);
dtExamMapping = new DataTable();
da.Fill(dtExamMapping);
dtExamMapping.TableName = "success";
}
catch (Exception)
{
dtExamMapping = new DataTable();
dtExamMapping.TableName = "error";
return(dtExamMapping);
}
return(dtExamMapping);
}
/// <summary>
/// Bind Exam Mapping (ExamYear,ExamSession And ExamFaculty) DropDownList
/// </summary>
void BindAllDDL()
{
try
{
objExamMappPl = new PLExamMapping();
objExamMappPl.Ind = 2;
DataSet dsExamMapp = objExamMappBl.BindAllDDl(objExamMappPl);
if (dsExamMapp.Tables.Count > 0)
{
DataTable dtExamYear = dsExamMapp.Tables[0];
DataTable dtSession = dsExamMapp.Tables[1];
DataTable dtExamFaculty = dsExamMapp.Tables[2];
if (dtExamYear.Rows.Count > 0)
{
ddlExamYear.DataSource = dtExamYear;
ddlExamYear.DataValueField = "ItemID"; // To filter Exam Name
ddlExamYear.DataTextField = "ItemDesc";
ddlExamYear.DataBind();
ddlExamYear.Items.Insert(0, new ListItem("-- Select Year --", "0"));
}
if (dtSession.Rows.Count > 0)
{
ddlSession.DataSource = dtSession;
ddlSession.DataValueField = "ItemID"; // To filter Exam Name
ddlSession.DataTextField = "ItemDesc";
ddlSession.DataBind();
ddlSession.Items.Insert(0, new ListItem("-- Select Session --", "0"));
}
if (dtExamFaculty.Rows.Count > 0)
{
ddlExamFaculty.DataSource = dtExamFaculty;
ddlExamFaculty.DataValueField = "ItemID"; // To filter Exam Name
ddlExamFaculty.DataTextField = "ItemDesc";
ddlExamFaculty.DataBind();
ddlExamFaculty.Items.Insert(0, new ListItem("-- Select Session --", "0"));
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
/// <summary>
/// Save Mapped Exam GridView Records On Row Deleting
/// </summary>
void SaveExamMappingOnDeleteBtn()
{
objExamMappPl = new PLExamMapping();
objExamMappPl.Ind = 12;
objExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objExamMappPl.ExamFacultyCD = Convert.ToInt32(ddlExamFaculty.SelectedValue);
objExamMappPl.TblExamMapp = VsdtFinalUniAndDMSExam;
DataTable dtSave = objExamMappBl.InsertUniAndDMSExamMappingData(objExamMappPl);
universityExamModal.Style.Add("display", "none");
dmsExamModal.Style.Add("display", "none");
universityRecordsModal.Style.Add("display", "none");
btnShowUnivExam.Enabled = btnShowDMSExam.Enabled = false;
}
/// <summary>
/// Save Mapped Exam GridView Records
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = "";
btnShowUnivExam.Enabled = btnShowDMSExam.Enabled = false;
universityExamModal.Style.Add("display", "none");
dmsExamModal.Style.Add("display", "none");
universityRecordsModal.Style.Add("display", "none");
if (VsdtFinalUniAndDMSExam == null || VsdtFinalUniAndDMSExam.Rows.Count <= 0)
{
lblMsg.Text = "Select Atleast One University And One DMS Exam, Then Press Add Button.";
return;
}
objExamMappPl = new PLExamMapping();
objExamMappPl.Ind = 12;
objExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objExamMappPl.ExamFacultyCD = Convert.ToInt32(ddlExamFaculty.SelectedValue);
objExamMappPl.TblExamMapp = VsdtFinalUniAndDMSExam;
DataTable dtSave = objExamMappBl.InsertUniAndDMSExamMappingData(objExamMappPl);
if (dtSave.Rows.Count > 0)
{
if (dtSave.Rows[0]["ReturnInd"].ToString() == "1")
{
ClearAll();
lblMsg.Text = "Record Save Successfully.";
lblMsg.Style.Add("color", "#1e983b");
}
else if (dtSave.Rows[0]["ReturnInd"].ToString() == "0")
{
lblMsg.Text = "Record Not Save Successfully, Please Try Again.";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
internal DataSet BindAllDDl(PLExamMapping objExamMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objExamMappPl.Ind);
da = new SqlDataAdapter(cmd);
dsExamMapping = new DataSet();
da.Fill(dsExamMapping);
}
catch (Exception)
{
dsExamMapping = new DataSet();
dsExamMapping.DataSetName = "error";
return(dsExamMapping);
}
return(dsExamMapping);
}
/// <summary>
/// Show University Records Popup
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdUniversityUnMappedExam_RowCommand(object sender, GridViewCommandEventArgs e)
{
grdUnivRecords.DataSource = new DataTable();
grdUnivRecords.DataBind();
int rowIndex = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "UniversityRecords")
{
DataTable dtUnivExam = VsdtUniExam;
DataRow drUnivExam = dtUnivExam.Rows[rowIndex];
objExamMappPl = new PLExamMapping();
objExamMappPl.Ind = 13;
objExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objExamMappPl.ExamFacultyCD = Convert.ToInt32(ddlExamFaculty.SelectedValue);
objExamMappPl.ExamName = drUnivExam["ExamName"].ToString();
DataTable dtUnivRecords = objExamMappBl.GetUneversityRecords(objExamMappPl);
if (dtUnivRecords.Rows.Count > 0)
{
lblUniRecExamYear.Text = ddlExamYear.SelectedItem.Text;
lblUniRecExamSession.Text = ddlSession.SelectedItem.Text;
lblUniRecExamFaculty.Text = ddlExamFaculty.SelectedItem.Text;
lblUniRecExamName.Text = drUnivExam["ExamName"].ToString();
grdUnivRecords.DataSource = dtUnivRecords;
grdUnivRecords.DataBind();
universityRecordsModal.Style.Add("display", "block");
universityExamModal.Style.Add("display", "none");
dmsExamModal.Style.Add("display", "none");
}
}
}
internal DataSet GetAllUniAndDMSExam(PLExamMapping objExamMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objExamMappPl.Ind);
cmd.Parameters.AddWithValue("@ExamYear", objExamMappPl.ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", objExamMappPl.ExamSession);
cmd.Parameters.AddWithValue("@ExamSessionID", objExamMappPl.ExamSessionID);
cmd.Parameters.AddWithValue("@ExamFacultyCD", objExamMappPl.ExamFacultyCD);
da = new SqlDataAdapter(cmd);
dsExamMapping = new DataSet();
da.Fill(dsExamMapping);
dsExamMapping.DataSetName = "success";
}
catch (Exception)
{
dsExamMapping = new DataSet();
dsExamMapping.DataSetName = "error";
return(dsExamMapping);
}
return(dsExamMapping);
}
/// <summary>
/// Show Available And Alloted Exam According To ExamYear, ExamSession And ExamFaculty
/// </summary>
/// /// <param name="sender"></param>
/// <param name="e"></param>
protected void btnShow_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
universityExamModal.Style.Add("display", "none");
dmsExamModal.Style.Add("display", "none");
universityRecordsModal.Style.Add("display", "none");
objExamMappPl = new PLExamMapping();
objExamMappPl.Ind = 11;
objExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objExamMappPl.ExamFacultyCD = Convert.ToInt32(ddlExamFaculty.SelectedValue);
DataSet dsFacultyMapp = objExamMappBl.GetAllUniAndDMSExam(objExamMappPl);
if (dsFacultyMapp.Tables.Count > 0)
{
//Available
VsdtUniExam = dsFacultyMapp.Tables[0];
VsdtDMSExam = dsFacultyMapp.Tables[1];
//Alloted
VsdtFinalUniAndDMSExam = dsFacultyMapp.Tables[2];
if (VsdtUniExam.Rows.Count <= 0 && VsdtDMSExam.Rows.Count <= 0 && VsdtFinalUniAndDMSExam.Rows.Count <= 0)
{
lblMsg.Text = "Record Not Found.";
ddlExamYear.Focus();
return;
}
if (VsdtDMSExam.Rows.Count > 0)
{
grdDMSUnMappedExam.DataSource = VsdtDMSExam;
grdDMSUnMappedExam.DataBind();
divDMSUnMappedExam.Style.Add("height", "200px");
tblDMSGridHeader.Visible = true;
btnShowDMSExam.Enabled = true;
}
if (VsdtUniExam.Rows.Count > 0)
{
grdUniversityUnMappedExam.DataSource = VsdtUniExam;
grdUniversityUnMappedExam.DataBind();
divUnivUnMappedExam.Style.Add("height", "200px");
tblUniversityGridHeader.Visible = true;
btnShowUnivExam.Enabled = true;
}
if (VsdtDMSExam.Rows.Count > 0 || VsdtUniExam.Rows.Count > 0)
{
divUnMapped.Visible = true;
}
else
{
divUnMapped.Visible = false;
}
if (VsdtFinalUniAndDMSExam.Rows.Count > 0)
{
VsdtFinalUniAndDMSExam.Columns["ExamYear"].SetOrdinal(0);
VsdtFinalUniAndDMSExam.Columns["ExamSession"].SetOrdinal(1);
VsdtFinalUniAndDMSExam.Columns["ExamSessionID"].SetOrdinal(2);
VsdtFinalUniAndDMSExam.Columns["FacultyCD"].SetOrdinal(3);
VsdtFinalUniAndDMSExam.Columns["UnivExamName"].SetOrdinal(4);
VsdtFinalUniAndDMSExam.Columns["DMSExamCD"].SetOrdinal(5);
VsdtFinalUniAndDMSExam.Columns["DMSExamName"].SetOrdinal(6);
grdFinalUniAndDMSMappedExam.DataSource = VsdtFinalUniAndDMSExam;
grdFinalUniAndDMSMappedExam.DataBind();
divMapped.Visible = true;
}
else
{
divMapped.Visible = false;
}
//if (grdDMSUnMappedExam.Rows.Count <= 0)
// btnPrintUnivExam.Enabled = true;
btnAdd.Visible = true;
ddlExamYear.Enabled = ddlSession.Enabled = ddlExamFaculty.Enabled = btnShow.Enabled = false;
btnSave.Enabled = btnClearAll.Enabled = true;
}
else
{
lblMsg.Text = "Record Not Found.";
return;
}
}
public DataTable GetUneversityRecords(PLExamMapping objExamMappPl)
{
return(objExamMapp.GetUneversityRecords(objExamMappPl));
}
public DataTable InsertUniAndDMSExamMappingData(PLExamMapping objExamMappPl)
{
return(objExamMapp.InsertUniAndDMSExamMappingData(objExamMappPl));
}
public DataSet GetAllUniAndDMSExam(PLExamMapping objExamMappPl)
{
return(objExamMapp.GetAllUniAndDMSExam(objExamMappPl));
}
public DataSet BindAllDDl(PLExamMapping objExamMappPl)
{
return(objExamMapp.BindAllDDl(objExamMappPl));
}
