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 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 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>"); } }
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) { } }
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(); }