internal DataSet InsertExtraExamRecords(PLExtraExamMapping objExtraExamMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objExtraExamMappPl.Ind);
cmd.Parameters.AddWithValue("@ExamYear", objExtraExamMappPl.ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", objExtraExamMappPl.ExamSession);
cmd.Parameters.AddWithValue("@ExamSessionID", objExtraExamMappPl.ExamSessionID);
cmd.Parameters.AddWithValue("@ExamFacultyCD", objExtraExamMappPl.ExamFacultyCD);
cmd.Parameters.AddWithValue("@ExamCtrlCD", objExtraExamMappPl.ExamCtrlCD);
da = new SqlDataAdapter(cmd);
dsRollNumberExamMapping = new DataSet();
da.Fill(dsRollNumberExamMapping);
dsRollNumberExamMapping.DataSetName = "success";
}
catch (Exception)
{
dsRollNumberExamMapping = new DataSet();
dsRollNumberExamMapping.DataSetName = "error";
return(dsRollNumberExamMapping);
}
return(dsRollNumberExamMapping);
}
internal DataSet BindAllDDl(PLExtraExamMapping objExtraExamMappPl)
{
try
{
cmd = new SqlCommand("SPSoftDataMapping", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objExtraExamMappPl.Ind);
da = new SqlDataAdapter(cmd);
dsRollNumberExamMapping = new DataSet();
da.Fill(dsRollNumberExamMapping);
}
catch (Exception)
{
dsRollNumberExamMapping = new DataSet();
dsRollNumberExamMapping.DataSetName = "error";
return(dsRollNumberExamMapping);
}
return(dsRollNumberExamMapping);
}
/// <summary>
/// Bind Extra Exam Mapping (ExamYear,ExamSession) DropDownList
/// </summary>
void BindAllDDL()
{
try
{
objExtraExamMappPl = new PLExtraExamMapping();
objExtraExamMappPl.Ind = 2;
DataSet dsExamMapp = objExtraExamMappBl.BindAllDDl(objExtraExamMappPl);
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";
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";
ddlSession.DataTextField = "ItemDesc";
ddlSession.DataBind();
ddlSession.Items.Insert(0, new ListItem("-- Select Session --", "0"));
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
lblMsg.Style.Add("color", "red");
}
}
/// <summary>
/// Insert Extra Exam One By One (Row-Wise)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdExtraExamMapping_RowCommand(object sender, GridViewCommandEventArgs e)
{
lblMsg.Text = "";
int rowIndex = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "InsertExtraExam")
{
DataTable dtExtraExam = VsdtExtraExamMapping;
DataRow drExtraExam = dtExtraExam.Rows[rowIndex];
objExtraExamMappPl = new PLExtraExamMapping();
objExtraExamMappPl.Ind = 26;
objExtraExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExtraExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExtraExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
objExtraExamMappPl.ExamFacultyCD = Convert.ToInt32(drExtraExam["FacultyCD"].ToString());
objExtraExamMappPl.ExamCtrlCD = Convert.ToInt32(drExtraExam["Ctrl"].ToString());
DataSet dsInsertExtraExam = objExtraExamMappBl.InsertExtraExamRecords(objExtraExamMappPl);
if (dsInsertExtraExam.Tables.Count > 0)
{
if (Convert.ToInt32(dsInsertExtraExam.Tables[0].Rows[0]["RDCnt"].ToString()) > 0 ||
Convert.ToInt32(dsInsertExtraExam.Tables[1].Rows[0]["RSCnt"].ToString()) > 0)
{
btnShow_Click(sender, e);
lblMsg.Text = "Record Insert Successfully.";
lblMsg.Style.Add("color", "#1e983b");
}
}
else
{
lblMsg.Text = "Record Not Inserted.";
lblMsg.Style.Add("color", "red");
}
}
}
/// <summary>
/// Show Extra Exam Mapping Status 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 = "";
objExtraExamMappPl = new PLExtraExamMapping();
objExtraExamMappPl.Ind = 25;
objExtraExamMappPl.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
objExtraExamMappPl.ExamSession = ddlSession.SelectedItem.Text;
objExtraExamMappPl.ExamSessionID = Convert.ToInt32(ddlSession.SelectedValue);
DataSet dsRollNumberMapp = objExtraExamMappBl.GetExtraExamMapping(objExtraExamMappPl);
if (dsRollNumberMapp.Tables.Count > 0)
{
VsdtExtraExamMapping = dsRollNumberMapp.Tables[0];
if (VsdtExtraExamMapping.Rows.Count > 0)
{
grdExtraExamMapping.DataSource = VsdtExtraExamMapping;
grdExtraExamMapping.DataBind();
ddlExamYear.Enabled = ddlSession.Enabled = btnShow.Enabled = false;
btnClearAll.Enabled = true;
}
else
{
lblMsg.Text = "Record Not Found.";
lblMsg.Style.Add("color", "red");
return;
}
}
else
{
lblMsg.Text = "Record Not Found.";
lblMsg.Style.Add("color", "red");
return;
}
}
public DataSet InsertExtraExamRecords(PLExtraExamMapping objExtraExamMappPl)
{
return(objExtraExamMappDl.InsertExtraExamRecords(objExtraExamMappPl));
}
public DataSet GetExtraExamMapping(PLExtraExamMapping objExtraExamMappPl)
{
return(objExtraExamMappDl.GetExtraExamMapping(objExtraExamMappPl));
}
public DataSet BindAllDDl(PLExtraExamMapping objExtraExamMappPl)
{
return(objExtraExamMappDl.BindAllDDl(objExtraExamMappPl));
}
