public void bindYear() { string[] strYear; int intacYear = 0; #region Get Accounting Start Date ApplicationResult objResults = new ApplicationResult(); TrustBL objTrustBl = new TrustBL(); objResults = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { string strACStartDate = objResults.resultDT.Rows[0][TrustBO.TRUST_ACCOUNTSTARTDATE].ToString(); strYear = strACStartDate.ToString().Split(new char[] { '/' }); intacYear = Convert.ToInt32(strYear[2]); } } #endregion for (int i = intacYear; i <= DateTime.Now.Year; i++) { ddlYear.Items.Add(i.ToString()); } ddlYear.Items.Insert(0, new ListItem("-Select-", "-1")); }
private void GridDataBind() { try { TrustBL objTrustBl = new TrustBL(); ApplicationResult objResult = new ApplicationResult(); objResult = objTrustBl.Trust_SelectAll(); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { gvTrust.DataSource = objResult.resultDT; gvTrust.DataBind(); PanelGrid_VisibilityMode(1); } else { PanelGrid_VisibilityMode(2); } } } 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>"); } }
public void FetchImage() { try { #region Declaretion TrustBL objTrustBl = new TrustBL(); ApplicationResult objResultsEdit = new ApplicationResult(); #endregion objResultsEdit = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID])); if (objResultsEdit != null) { if (objResultsEdit.resultDT.Rows.Count > 0) { ViewState["Bytes"] = objResultsEdit.resultDT.Rows[0][TrustBO.TRUST_TRUSTLOGO]; if (ViewState["Bytes"].ToString() != "") { imgphoto.ImageUrl = "../Client.UI/GetImage.ashx?TrustMID=" + Convert.ToInt32(Session[ApplicationSession.TRUSTID]); } } } } 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>"); } }
public void bindTrust() { try { #region Bind Trust TrustBL objTrustBL = new TrustBL(); TrustBO objTrustBO = new TrustBO(); Controls objControls = new Controls(); ApplicationResult objResultTrust = new ApplicationResult(); objResultTrust = objTrustBL.Trust_SelectAll(); if (objResultTrust != null) { if (objResultTrust.resultDT.Rows.Count > 0) { objControls.BindDropDown_ListBox(objResultTrust.resultDT, ddlTrustID, "TrustNameEng", "TrustMID"); } ddlTrustID.Items.Insert(0, new ListItem("-Select-", "-1")); } #endregion } 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>"); } }
private void FetchLabel() { try { #region Declaretion TrustBL objTrustBl = new TrustBL(); DataTable dtTrust = new DataTable(); #endregion ApplicationResult objResultsEdit = new ApplicationResult(); objResultsEdit = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID])); if (objResultsEdit != null) { dtTrust = objResultsEdit.resultDT; if (dtTrust.Rows.Count > 0) { lblTrustName.Text = dtTrust.Rows[0][TrustBO.TRUST_TRUSTNAMEENG].ToString(); } } } 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>"); } }
public void getTrustName() { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); TrustBL objTrustBl = new TrustBL(); objResult = objTrustBl.Trust_SelectAll_ForDropDown(); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlOrgName, "TrustNameEng", "TrustMID"); } ddlOrgName.Items.Insert(0, new ListItem("--Select--", "")); } }
public void getTrustName() { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); TrustBL objTrustBL = new TrustBL(); objResult = objTrustBL.Trust_SelectAll_ForDropDown(); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlTrust, "TrustNameEng", "TrustMID"); if (objResult.resultDT.Rows.Count > 0) { } ddlTrust.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1")); ddlSchool.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1")); } }
public void BindTrust() { var objTrustBl = new TrustBL(); var objResult = objTrustBl.Trust_SelectAll(); if (objResult == null) { return; } if (objResult.resultDT.Rows.Count <= 0) { return; } _objControl.BindDropDown_ListBox(objResult.resultDT, ddlTrust, "TrustNameEng", "TrustMID"); ddlTrust.Items.Insert(0, new ListItem("--Select--", "")); }
public bool ValidateName() { TrustBL objTrustBl = new TrustBL(); ApplicationResult objResults = new ApplicationResult(); if (ViewState["Mode"].ToString() == "Save") { objResults = objTrustBl.Trust_ValidateName(txtTrustName.Text, txtAbbreviation.Text, -1); } else { objResults = objTrustBl.Trust_ValidateName(txtTrustName.Text, txtAbbreviation.Text, Convert.ToInt32(ViewState["TrustMID"].ToString())); } if (objResults.resultDT.Rows.Count > 0) { return(true); } return(false); }
protected void btnbackup_Click(object sender, EventArgs e) { try { TrustBL objTrustBL = new TrustBL(); ApplicationResult objResultBackup = new ApplicationResult(); objResultBackup = objTrustBL.Download_DatabaseBackup(); if (objResultBackup.status == ApplicationResult.CommonStatusType.SUCCESS) { bindGrid(); // Response.Redirect(Request.Url.AbsoluteUri); //String FileName = "Navchetan"+DateTime.Now.ToString("yyyy-MM-dd")+".bak"; //String FilePath = Server.MapPath("~/DBBackups/") + FileName; //Replace this //System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; //response.ClearContent(); //response.Clear(); //response.ContentType = "application/octet-stream"; ////response.ContentType = "text/plain"; //response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ";"); //response.TransmitFile(FilePath); //response.Flush(); //response.End(); } else { lblMsg.Visible = true; lblMsg.Text = "Error, Please Try Again..!!"; } } catch (Exception ex) { lblMsg.Visible = true; lblMsg.Text = "" + ex.Message.ToString(); } }
public void RestrictNewTrust() { try { TrustBL objTrustBl = new TrustBL(); ApplicationResult objResult = new ApplicationResult(); objResult = objTrustBl.Trust_SelectAll(); if (objResult.resultDT.Rows.Count > 0) { //lnkAddNewTrust.Visible = false; } else { //lnkAddNewTrust.Visible = true; } } 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 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 btnSave_Click(object sender, EventArgs e) { try { TrustBO objTrustBo = new TrustBO(); TrustBL objTrustBl = new TrustBL(); BankAssociationBL objBankBl = new BankAssociationBL(); BankAssociationBO objBankBo = new BankAssociationBO(); ApplicationResult objResults = new ApplicationResult(); Controls objControls = new Controls(); //objTrustBo.TrustMID = Convert.ToInt32(ViewState["TrustMID"].ToString()); objTrustBo.TrustNameEng = txtTrustName.Text; objTrustBo.TrustNameGuj = txtTrustNameGuj.Text; objTrustBo.RegistrationCode = txtRegCode.Text; objTrustBo.TrustAbbreviation = txtAbbreviation.Text; if (ViewState["Bytes"] != null) { objTrustBo.TrustLogo = (byte[])ViewState["Bytes"]; } else { objTrustBo.TrustLogo = ImageToByteArrayFromFilePath("../Images/NoImage-big.jpg"); } objTrustBo.ApprovalNo = txtApprovalNo.Text; objTrustBo.ApprovalDate = txtApprovalDate.Text; objTrustBo.AccountStartDate = txtAccStartDate.Text; objTrustBo.ApprovalYear = ddlApprovalYear.SelectedItem.ToString(); objTrustBo.AddressEng = txtTrustAddress.Text; objTrustBo.AddressGuj = txtTrustAddressGuj.Text; objTrustBo.CountryEng = txtCountry.Text; objTrustBo.CountryGuj = txtCountryGuj.Text; objTrustBo.StateEng = txtState.Text; objTrustBo.StateGuj = txtStateGuj.Text; objTrustBo.DistrictEng = txtDistrict.Text; objTrustBo.DistrictGuj = txtDistrictGuj.Text; objTrustBo.TownEng = txtCity.Text; objTrustBo.TownGuj = txtcityGuj.Text; objTrustBo.Pincode = txtPincode.Text; objTrustBo.TelephoneNo = txtTelephone.Text; objTrustBo.MobileNo = txtMobileNo.Text; objTrustBo.EmailId = txtEmailID.Text; objTrustBo.AlternateEmailId = txtAlterID.Text; objTrustBo.FaxNo = txtFax.Text; objTrustBo.Website = txtWebsite.Text; objTrustBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objTrustBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objBankBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objBankBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (ValidateName() == true) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert(Trust Name " + txtTrustName.Text + " Already Exists.');</script>"); goto Exit; } #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); if (ViewState["Mode"].ToString() == "Save") { objResults = objTrustBl.Trust_Insert(objTrustBo); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["TrustMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); InsertBank(); } ClearAll(); GridDataBind(); PanelGrid_VisibilityMode(1); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust Created Successfully');</script>"); } } else { objResults = objBankBl.BankAssociation_Delete_TrustMID(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { } InsertBank(); objTrustBo.TrustMID = Convert.ToInt32(ViewState["TrustMID"].ToString()); objResults = objTrustBl.Trust_Update(objTrustBo); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust updated successfully');</script>"); ClearAll(); objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ViewState["Mode"] = "Save"; btnSave.Text = "Save"; txtAccStartDate.Enabled = true; } } DatabaseTransaction.CommitTransation(); GridDataBind(); #endregion Exit :; } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); 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 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>"); } }
public void ProcessRequest(HttpContext context) { DataTable dtResult = new DataTable(); SchoolBL objSchoolBL = new SchoolBL(); StudentBL objStudentBL = new StudentBL(); EmployeeMBL objEmployeeBL = new EmployeeMBL(); TrustBL objTrustBL = new TrustBL(); ApplicationResult objResult = new ApplicationResult(); Controls objControl = new Controls(); byte[] imgByte = { }; if (context.Request.QueryString["StudentMID"] != null) { objResult = objStudentBL.Student_Select(Convert.ToInt32(context.Request.QueryString["StudentMID"].ToString()), 0); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["StudentPhoto"]; } } } else if (context.Request.QueryString["SchoolMID"] != null) { objResult = objSchoolBL.School_Select(Convert.ToInt32(context.Request.QueryString["SchoolMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["SchoolLogo"]; } } } else if (context.Request.QueryString["EmployeeMID"] != null) { objResult = objEmployeeBL.EmployeeM_Select(Convert.ToInt32(context.Request.QueryString["EmployeeMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["Photo"]; } } } else { objResult = objTrustBL.Trust_Select(Convert.ToInt32(context.Request.QueryString["TrustMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["TrustLogo"]; } } } // objResult = objVisitorBL.Visitor_Select(1); context.Response.BinaryWrite(imgByte); context.Response.End(); context.Response.Clear(); context.Response.ClearHeaders(); context.Response.ClearContent(); }
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>"); } }