/// <summary>
/// Save Mapped Faculties GridView Records
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (VsdtFinalUniAndDMSExamFaculty == null || VsdtFinalUniAndDMSExamFaculty.Rows.Count <= 0)
{
lblMsg.Text = "Select Atleast One University And One DMS Exam Faculty, Then Press Add Button.";
return;
}
objFacultyMappPl = new PlFacultyMapping();
objFacultyMappPl.Ind = 3;
objFacultyMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objFacultyMappPl.ExamSession = ddlSession.SelectedItem.Text;
objFacultyMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objFacultyMappPl.TblFacultyMapp = VsdtFinalUniAndDMSExamFaculty;
DataTable dtSave = objFacultyMappBl.InsertUniAndDMSExamFacultyData(objFacultyMappPl);
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;
}
}
}
internal DataSet BindAllDDl(PlFacultyMapping objFacultyMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objFacultyMappPl.Ind);
da = new SqlDataAdapter(cmd);
dsFacultyMapping = new DataSet();
da.Fill(dsFacultyMapping);
}
catch (Exception)
{
dsFacultyMapping = new DataSet();
dsFacultyMapping.DataSetName = "error";
return dsFacultyMapping;
}
return dsFacultyMapping;
}
internal DataSet GetAllUniAndDMSExamFaculty(PlFacultyMapping objFacultyMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objFacultyMappPl.Ind);
cmd.Parameters.AddWithValue("@ExamYear", objFacultyMappPl.ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", objFacultyMappPl.ExamSession);
cmd.Parameters.AddWithValue("@ExamSessionID", objFacultyMappPl.ExamSessionID);
da = new SqlDataAdapter(cmd);
dsFacultyMapping = new DataSet();
da.Fill(dsFacultyMapping);
dsFacultyMapping.DataSetName = "success";
}
catch (Exception)
{
dsFacultyMapping = new DataSet();
dsFacultyMapping.DataSetName = "error";
return dsFacultyMapping;
}
return dsFacultyMapping;
}
/// <summary>
/// Bind Faculty Mapping (ExamYear And ExamSession) DropDownList
/// </summary>
void BindAllDDL()
{
try
{
objFacultyMappPl = new PlFacultyMapping();
objFacultyMappPl.Ind = 2;
DataSet dsFacultyMapp = objFacultyMappBl.BindAllDDl(objFacultyMappPl);
if (dsFacultyMapp.Tables.Count > 0)
{
DataTable dtExamYear = dsFacultyMapp.Tables[0];
DataTable dtSession = dsFacultyMapp.Tables[1];
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"));
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
/// <summary>
/// Show Available And Alloted Faculty According To ExamYear And ExamSession
/// </summary>
/// /// <param name="sender"></param>
/// <param name="e"></param>
protected void btnShow_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
objFacultyMappPl = new PlFacultyMapping();
objFacultyMappPl.Ind = 1;
objFacultyMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objFacultyMappPl.ExamSession = ddlSession.SelectedItem.Text;
objFacultyMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
DataSet dsFacultyMapp = objFacultyMappBl.GetAllUniAndDMSExamFaculty(objFacultyMappPl);
if (dsFacultyMapp.Tables.Count > 0)
{
//Available
VsdtUniExamFaculty = dsFacultyMapp.Tables[0];
VsdtDMSExamFaculty = dsFacultyMapp.Tables[1];
//Alloted
VsdtFinalUniAndDMSExamFaculty = dsFacultyMapp.Tables[2];
if (VsdtUniExamFaculty.Rows.Count <= 0 && VsdtDMSExamFaculty.Rows.Count <= 0 && VsdtFinalUniAndDMSExamFaculty.Rows.Count <= 0)
{
lblMsg.Text = "Record Not Found.";
return;
}
if (VsdtDMSExamFaculty.Rows.Count > 0)
{
grdDMSExamFaculty.DataSource = VsdtDMSExamFaculty;
grdDMSExamFaculty.DataBind();
}
if (VsdtUniExamFaculty.Rows.Count > 0)
{
grdUniversityExamFaculty.DataSource = VsdtUniExamFaculty;
grdUniversityExamFaculty.DataBind();
}
if (VsdtDMSExamFaculty.Rows.Count > 0 || VsdtUniExamFaculty.Rows.Count > 0)
{
divUnMapped.Visible = true;
}
else
{
divUnMapped.Visible = false;
}
if (VsdtFinalUniAndDMSExamFaculty.Rows.Count > 0)
{
grdFinalUniAndDMSFaculty.DataSource = VsdtFinalUniAndDMSExamFaculty;
grdFinalUniAndDMSFaculty.DataBind();
divMapped.Visible = true;
}
else
{
divMapped.Visible = false;
}
btnAdd.Visible = true;
ddlExamYear.Enabled = ddlSession.Enabled = btnShow.Enabled = false;
btnSave.Enabled = btnClearAll.Enabled = true;
}
else
{
lblMsg.Text = "Record Not Found.";
return;
}
}
public DataTable InsertUniAndDMSExamFacultyData(PlFacultyMapping objFacultyMappPl)
{
return(objFacultyMapp.InsertUniAndDMSExamFacultyData(objFacultyMappPl));
}
public DataSet GetAllUniAndDMSExamFaculty(PlFacultyMapping objFacultyMappPl)
{
return(objFacultyMapp.GetAllUniAndDMSExamFaculty(objFacultyMappPl));
}
public DataSet BindAllDDl(PlFacultyMapping objFacultyMappPl)
{
return(objFacultyMapp.BindAllDDl(objFacultyMappPl));
}
