/// Select all details of SubjectT for selected SubjectTID from tbl_Subject_T table /// Created By : Darshan, 09/12/2014 /// Modified By : public ApplicationResult SubjectT_Select(SubjectTBO objSubjectTBO) { try { pSqlParameter = new SqlParameter[3]; pSqlParameter[0] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSubjectTBO.ClassMID; pSqlParameter[1] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSubjectTBO.DivisionTID; pSqlParameter[2] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSubjectTBO.SubjectMID; strStoredProcName = "usp_tbl_Subject_T_Select"; DataSet dsResult = new DataSet(); dsResult = Database.ExecuteDataSet(CommandType.StoredProcedure, strStoredProcName, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dsResult); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } catch (Exception ex) { throw ex; } }
/// <summary> /// To Insert details of SubjectT in tbl_Subject_T table /// Created By : Darshan, 09/12/2014 /// Modified By : /// </summary> /// <param name="objSubjectTBO"></param> /// <returns></returns> public ApplicationResult SubjectT_Insert(SubjectTBO objSubjectTBO, string strEmployeeMIDs) { try { pSqlParameter = new SqlParameter[5]; pSqlParameter[0] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSubjectTBO.SchoolMID; pSqlParameter[1] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSubjectTBO.ClassMID; pSqlParameter[2] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSubjectTBO.DivisionTID; pSqlParameter[3] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSubjectTBO.SubjectMID; pSqlParameter[4] = new SqlParameter("@EmployeeMIDs", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = strEmployeeMIDs; sSql = "usp_tbl_Subject_T_Insert"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objSubjectTBO = null; } }
protected void gvTeacher_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "DeleteTeacher") { if (ViewState["Mode"].ToString() == "Save") { GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer); DataTable dtTeacher = (DataTable)ViewState["Teacher"]; dtTeacher.Rows.RemoveAt(row.RowIndex); dtTeacher.AcceptChanges(); ViewState["Teacher"] = dtTeacher; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); } else if (ViewState["Mode"].ToString() == "Edit") { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); SubjectTBO objSubjectTbo = new SubjectTBO(); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue); objSubjectTbo.EmployeeMID = Convert.ToInt32(e.CommandArgument.ToString()); objResult = objSubjectTbl.SubjectT_Delete_Association(objSubjectTbo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo); ViewState["Teacher"] = objResult.resutlDS.Tables[1]; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>"); } } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void gvSubjectAssociation_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); SubjectTBO objSubjectTbo = new SubjectTBO(); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(e.CommandArgument.ToString()); if (e.CommandName == "Edit1") { BindSubject(1); ViewState["Mode"] = "Edit"; objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo); ddlSubject.SelectedValue = objResult.resutlDS.Tables[0].Rows[0][SubjectTBO.SUBJECTT_SUBJECTMID].ToString(); ViewState["Teacher"] = objResult.resutlDS.Tables[1]; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); PanelVisibility(2); } else if (e.CommandName == "Delete1") { objResult = objSubjectTbl.SubjectT_Delete(objSubjectTbo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); BindSubjectAssociation(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>"); } ClearAll(); } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
/// To Delete details of SubjectT for selected SubjectTID from tbl_Subject_T table /// Created By : Darshan, 09/12/2014 /// Modified By : public ApplicationResult SubjectT_Delete_Association(SubjectTBO objSubjectTBO) { try { pSqlParameter = new SqlParameter[4]; pSqlParameter[0] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSubjectTBO.ClassMID; pSqlParameter[1] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSubjectTBO.DivisionTID; pSqlParameter[2] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSubjectTBO.SubjectMID; pSqlParameter[3] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSubjectTBO.EmployeeMID; strStoredProcName = "usp_tbl_Subject_T_Delete_Association"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcName, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { if (ViewState["Count"] != null) { if (Convert.ToInt32(ViewState["Count"].ToString()) > 0) { ApplicationResult objResult = new ApplicationResult(); SubjectTBO objSubjectTbo = new SubjectTBO(); SubjectTBL objSubjectTbl = new SubjectTBL(); string strEmployeeMIDs = null; objSubjectTbo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue); DataTable dtTeacher = (DataTable)ViewState["Teacher"]; for (int i = 0; i < dtTeacher.Rows.Count; i++) { if (strEmployeeMIDs != null) { strEmployeeMIDs += "~"; } strEmployeeMIDs += dtTeacher.Rows[i]["EmployeeMID"].ToString(); } if (ViewState["Mode"].ToString() == "Save") { objResult = objSubjectTbl.SubjectT_Insert(objSubjectTbo, strEmployeeMIDs); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objResult = objSubjectTbl.SubjectT_Update(objSubjectTbo, strEmployeeMIDs); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindSubjectAssociation(); PanelVisibility(1); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</script>"); } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</script>"); } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }