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)); }