protected void gvSchool_RowCommand(object sender, GridViewCommandEventArgs e) { try { SchoolBO objSchoolBo = new SchoolBO(); SchoolBL objSchoolBl = new SchoolBL(); TrustBL objTrustBl = new TrustBL(); ApplicationResult objResults = new ApplicationResult(); BankAssociationBL objBankBl = new BankAssociationBL(); Controls objControls = new Controls(); ViewState["SchoolMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objTrustBl.Abbreviation_Validation(0, Convert.ToInt32(ViewState["SchoolMID"].ToString()), 0); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtAbbreviation.Enabled = false; } else { txtAbbreviation.Enabled = true; } } objSchoolBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); if (e.CommandName.ToString() == "Edit1") { // txtAccStartDate.Enabled = false; objResults = objSchoolBl.School_Select(Convert.ToInt32(ViewState["SchoolMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtSchoolName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLNAMEENG].ToString(); txtSchoolNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLNAMEGUJ].ToString(); txtSchoolTiming.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLTIMING].ToString(); ddlAcademicMonth.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACADEMICMONTH].ToString(); txtSchoolCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLCODE].ToString(); ViewState["Bytes"] = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLLOGO]; if (ViewState["Bytes"].ToString() != "") { imgphoto.ImageUrl = "GetImage.ashx?SchoolMID=" + ViewState["SchoolMID"]; } else { imgphoto.ImageUrl = "~/images/noimage-big.jpg"; //lbtnRemovePhoto.Visible = false; } txtAbbreviation.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLABBREVIATION].ToString(); txtAccStartDate.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACCOUNTSTARTDATE].ToString(); txtSchoolAddress.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ADDRESSENG].ToString(); txtSchoolAddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ADDRESSGUJ].ToString(); if (objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREATYPE].ToString() == "") { //rblAreaType.SelectedItem.Text = ""; } else { rblAreaType.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREATYPE].ToString(); } if (objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREASUBTYPE].ToString() == "") { //rblAreaSubType.SelectedItem.Text = ""; } else { rblAreaSubType.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREASUBTYPE].ToString(); } txtTown.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TOWNENG].ToString(); txtTownGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TOWNGUJ].ToString(); txtATPOEng.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ATPONOENG].ToString(); txtATPOGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ATPONOGUJ].ToString(); txtTalukaEng.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TALUKAENG].ToString(); txttalukaGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TALUKAGUJ].ToString(); txtDistrict.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_DISTRICTENG].ToString(); txtDistrictGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_DISTRICTGUJ].ToString(); txtState.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_STATEENG].ToString(); txtStateGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_STATEGUJ].ToString(); txtCountry.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_COUNTRYENG].ToString(); txtCountryGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_COUNTRYGUJ].ToString(); txtPinCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PINCODE].ToString(); txtTelephoneNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TELEPHONENO].ToString(); txtMobileNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_MOBILENO].ToString(); txtEmailID.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_EMAILID].ToString(); txtAlternateEmail.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ALTERNATEEMAILID].ToString(); txtFax.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_FAXNO].ToString(); txtWebsite.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WEBSITE].ToString(); txtSSCIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SSCINDEXNO].ToString(); txtCommerceIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCCOMMERCEINDEXNO].ToString(); txtScienceIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCSCIENCEINDEXNO].ToString(); txtArtsIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCARTSINDEXNO].ToString(); txtRegistrationCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTRATIONCODE].ToString(); txtRegistrationName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTEREDNAMEENG].ToString(); txtRegistrationCodeGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTREREDNAMEGUJ].ToString(); // txtRegisteredAddress.Text = dtSchool.Rows[0][SchoolBO.SCHOOL_REGISTEREDADDRESSENG].ToString(); txtRegisteredddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTEREDADDRESSGUJ].ToString(); txtSchoolMotto.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLMOTTOENG].ToString(); txtSchoolMottoGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLMOTTOGUJ].ToString(); txtSchoolVision.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLVISIONENG].ToString(); txtSchoolVisionGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLVISIONGUJ].ToString(); if (Convert.ToInt32(objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ISONRENT].ToString()) == 1) { chkIsRent.Checked = true; } else { chkIsRent.Checked = false; } txtOwnerName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERNAMEENG].ToString(); txtOwnerNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERNAMEGUJ].ToString(); txtOwnerAddress.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERADDRESSENG].ToString(); txtOwnerAddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERADDRESSGUJ].ToString(); txtWordNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNO].ToString(); txtWordName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNAMEENG].ToString(); txtWardNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNAMEGUJ].ToString(); txtPlotNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PLOTNO].ToString(); txtPlotArea.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PLOTAREA].ToString(); ddlConstructionYear.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_CONSTRUNCTIONYEAR].ToString(); txtNoOfFloor.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_NOOFFLOORS].ToString(); ApplicationResult objResultsBankEdit = new ApplicationResult(); DataTable dtBankAssociation = new DataTable(); objResultsBankEdit = objBankBl.BankAssociation_Select_TrustMID(0, Convert.ToInt32(ViewState["SchoolMID"].ToString())); if (objResultsBankEdit != null) { dtBankAssociation = objResultsBankEdit.resultDT; if (dtBankAssociation.Rows.Count > 0) { gvbankAssociation.Visible = true; gvbankAssociation.DataSource = dtBankAssociation; gvbankAssociation.DataBind(); } ViewState["dtBank"] = dtBankAssociation; } ViewState["Mode"] = "Edit1"; PanelGrid_VisibilityMode(2); } } } else if ((e.CommandName.ToString() == "Delete1")) { objControls.EnableControls(Master.FindControl("ContentPlaceHolder1")); objResults = objSchoolBl.Validate_School_Delete(Convert.ToInt32(ViewState["SchoolMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { if (Convert.ToInt32(objResults.resultDT.Rows[1]["SchoolMID"]) == Convert.ToInt32(ViewState["SchoolMID"].ToString())) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('There are Section(s)/Student(s) associated with this School. To delete this School you need to delete Section(s)/Student(s) first.');</script>"); goto Exit; } } } ApplicationResult objResultsDelete = new ApplicationResult(); ApplicationResult objResultsBankDelete = new ApplicationResult(); objResultsDelete = objSchoolBl.School_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('School deleted successfully.');</script>"); GridDataBind(); } } Exit :; } catch (Exception ex) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void gvTrust_RowCommand(object sender, GridViewCommandEventArgs e) { try { BindYear(); ApplicationResult objResults = new ApplicationResult(); TrustBL objTrustBl = new TrustBL(); BankAssociationBL objBankBl = new BankAssociationBL(); Controls objControls = new Controls(); ViewState["TrustMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objTrustBl.Abbreviation_Validation(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0, 0); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtAbbreviation.Enabled = false; } else { txtAbbreviation.Enabled = true; } } if (e.CommandName.ToString() == "Edit1") { // txtAccStartDate.Enabled = false; objResults = objTrustBl.Trust_Select(Convert.ToInt32(ViewState["TrustMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtTrustName.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTNAMEENG].ToString(); txtTrustNameGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTNAMEGUJ].ToString(); txtRegCode.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_REGISTRATIONCODE].ToString(); txtAbbreviation.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTABBREVIATION].ToString(); ViewState["Bytes"] = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTLOGO]; if (ViewState["Bytes"].ToString() != "") { imgphoto.ImageUrl = "GetImage.ashx?TrustMID=" + ViewState["TrustMID"]; } else { imgphoto.ImageUrl = "~/images/noimage-big.jpg"; //lbtnRemovePhoto.Visible = false; } txtApprovalNo.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALNO].ToString(); txtApprovalDate.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALDATE].ToString(); txtAccStartDate.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ACCOUNTSTARTDATE].ToString(); if (objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALYEAR].ToString() != "-Select-") { ddlApprovalYear.SelectedValue = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALYEAR].ToString(); } txtTrustAddress.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ADDRESSENG].ToString(); txtTrustAddressGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ADDRESSGUJ].ToString(); txtCountry.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_COUNTRYENG].ToString(); txtCountryGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_COUNTRYGUJ].ToString(); txtState.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_STATEENG].ToString(); txtStateGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_STATEGUJ].ToString(); txtDistrict.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_DISTRICTENG].ToString(); txtDistrictGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_DISTRICTGUJ].ToString(); txtCity.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TOWNENG].ToString(); txtcityGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TOWNGUJ].ToString(); txtPincode.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_PINCODE].ToString(); txtTelephone.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TELEPHONENO].ToString(); txtMobileNo.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_MOBILENO].ToString(); txtEmailID.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_EMAILID].ToString(); txtAlterID.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ALTERNATEEMAILID].ToString(); txtFax.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_FAXNO].ToString(); txtWebsite.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_WEBSITE].ToString(); ApplicationResult objResultsEditBank = new ApplicationResult(); DataTable dtBankAssociation = new DataTable(); objResultsEditBank = objBankBl.BankAssociation_Select_TrustMID(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0); if (objResults != null) { dtBankAssociation = objResultsEditBank.resultDT; if (dtBankAssociation.Rows.Count > 0) { gvbankAssociation.Visible = true; gvbankAssociation.DataSource = dtBankAssociation; gvbankAssociation.DataBind(); } ViewState["dtBank"] = dtBankAssociation; } ViewState["Mode"] = "Edit1"; PanelGrid_VisibilityMode(2); } } } else if ((e.CommandName.ToString() == "Delete")) { objControls.EnableControls(Master.FindControl("ContentPlaceHolder1")); objResults = objTrustBl.Validate_Trust_Delete(Convert.ToInt32(ViewState["TrustMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { if (Convert.ToInt32(objResults.resultDT.Rows[0]["TrustMID"]) == Convert.ToInt32(ViewState["TrustMID"].ToString())) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('There are School(s) associated with this Trust. To delete this Trust you need to delete School(s) first.');</script>"); goto Exit; } } } ApplicationResult objResultsDelete = new ApplicationResult(); ApplicationResult objResultsBankDelete = new ApplicationResult(); objResultsDelete = objTrustBl.Trust_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust deleted successfully.');</script>"); GridDataBind(); } } Exit :; } catch (Exception ex) { } }
protected void gvSection_RowCommand(object sender, GridViewCommandEventArgs e) { try { Controls objControls = new Controls(); ApplicationResult objResults = new ApplicationResult(); TrustBL objTrustBl = new TrustBL(); SectionBL objSectionBL = new SectionBL(); ViewState["SectionMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objTrustBl.Abbreviation_Validation(0, 0, Convert.ToInt32(ViewState["SectionMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtAbbreviation.Enabled = false; } else { txtAbbreviation.Enabled = true; } } if (e.CommandName.ToString() == "Edit1") { objResults = objSectionBL.Section_Select(Convert.ToInt32(ViewState["SectionMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtSectionName.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString(); txtAbbreviation.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONAVBBREVIATION].ToString(); txtSectionDesc.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_DESCRIPTION].ToString(); ViewState["Mode"] = "Edit1"; PanelGrid_VisibilityMode(2); } } } else if ((e.CommandName.ToString() == "Delete1")) { objControls.EnableControls(Master.FindControl("ContentPlaceHolder1")); objResults = objSectionBL.Validate_Section_Delete(Convert.ToInt32(ViewState["SectionMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { if (Convert.ToInt32(objResults.resultDT.Rows[0]["SectionMID"]) == Convert.ToInt32(ViewState["SectionMID"].ToString())) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Classes(s) associated with this Section. To delete this Section you need to delete Classes(s) first.');</script>"); goto Exit; } } } ApplicationResult objResultsDelete = new ApplicationResult(); objResultsDelete = objSectionBL.Section_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { ApplicationResult objResultsDeleteT = new ApplicationResult(); objResultsDeleteT = objSectionBL.SectionT_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDeleteT.status == ApplicationResult.CommonStatusType.SUCCESS) { } ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section deleted successfully.');</script>"); GridDataBind(); PanelGrid_VisibilityMode(1); } } Exit :; } 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>"); } }