public void InsertBank() { BankAssociationBO objBankBo = new BankAssociationBO(); ApplicationResult objResultsBankInsert = new ApplicationResult(); BankAssociationBL objBankBl = new BankAssociationBL(); if (ViewState["dtBank"] != null) { DataTable dt = (DataTable)ViewState["dtBank"]; for (int i = 0; i < dt.Rows.Count; i++) { objBankBo.TrustMID = Convert.ToInt32(ViewState["TrustMID"].ToString()); objBankBo.SchoolMID = 0; objBankBo.BankName = dt.Rows[i]["BankName"].ToString(); objBankBo.AccountNameEng = dt.Rows[i]["AccountNameEng"].ToString(); objBankBo.AccountNameGuj = dt.Rows[i]["AccountNameGuj"].ToString(); objBankBo.AccountType = dt.Rows[i]["AccountType"].ToString(); objBankBo.AccountNo = dt.Rows[i]["AccountNo"].ToString(); objBankBo.BranchName = dt.Rows[i]["BranchName"].ToString(); objBankBo.PanNO = dt.Rows[i]["PanNO"].ToString(); objBankBo.IfscCode = dt.Rows[i]["IfscCode"].ToString(); objBankBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objBankBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResultsBankInsert = objBankBl.BankAssociation_Insert(objBankBo); if (objResultsBankInsert.status == ApplicationResult.CommonStatusType.SUCCESS) { } } } }
public void InsertBank() { try { ApplicationResult objResultsBankInsert = new ApplicationResult(); DataTable dt = (DataTable)ViewState["dtBank"]; BankAssociationBO objBankBo = new BankAssociationBO(); BankAssociationBL objBankBl = new BankAssociationBL(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { objBankBo.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString()); objBankBo.TrustMID = 0; objBankBo.BankName = dt.Rows[i]["BankName"].ToString(); objBankBo.AccountNameEng = dt.Rows[i]["AccountNameEng"].ToString(); objBankBo.AccountNameGuj = dt.Rows[i]["AccountNameGuj"].ToString(); objBankBo.AccountType = dt.Rows[i]["AccountType"].ToString(); objBankBo.AccountNo = dt.Rows[i]["AccountNo"].ToString(); objBankBo.BranchName = dt.Rows[i]["BranchName"].ToString(); objBankBo.PanNO = dt.Rows[i]["PanNO"].ToString(); objBankBo.IfscCode = dt.Rows[i]["IfscCode"].ToString(); objBankBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objBankBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResultsBankInsert = objBankBl.BankAssociation_Insert(objBankBo); if (objResultsBankInsert.status == ApplicationResult.CommonStatusType.SUCCESS) { } } } ViewState["dtBank"] = ""; } 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>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { ApplicationResult objResults = new ApplicationResult(); SchoolBO objSchoolBo = new SchoolBO(); SchoolBL objSchoolBl = new SchoolBL(); BankAssociationBL objBankBl = new BankAssociationBL(); DataTable dt = new DataTable(); Controls objControls = new Controls(); objSchoolBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); //objSchoolBo.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString()); objSchoolBo.SchoolNameEng = txtSchoolName.Text; objSchoolBo.SchoolNameGuj = txtSchoolNameGuj.Text; objSchoolBo.SchoolTiming = txtSchoolTiming.Text; objSchoolBo.AcademicMonth = Convert.ToInt32(ddlAcademicMonth.SelectedValue); objSchoolBo.SchoolCode = txtSchoolCode.Text; if (ViewState["Bytes"] != null) { objSchoolBo.SchoolLogo = (byte[])ViewState["Bytes"]; } else { objSchoolBo.SchoolLogo = ImageToByteArrayFromFilePath("../Images/NoImage-big.jpg"); } objSchoolBo.SchoolAbbreviation = txtAbbreviation.Text; objSchoolBo.AccountStartDate = txtAccStartDate.Text; objSchoolBo.AddressEng = txtSchoolAddress.Text; objSchoolBo.AddressGuj = txtSchoolAddressGuj.Text; if (rblAreaType.SelectedItem != null) { objSchoolBo.AreaType = rblAreaType.SelectedItem.Text; if (objSchoolBo.AreaType == "Village Area") { objSchoolBo.AreaTypeGuj = "ગ્રામ્ય પંચાયત"; } else if (objSchoolBo.AreaType == "Town Area") { objSchoolBo.AreaTypeGuj = "નગર પંચાયત"; } else if (objSchoolBo.AreaType == "City Area") { objSchoolBo.AreaTypeGuj = "નગર પાલિકા"; } else if (objSchoolBo.AreaType == "Notified Area") { objSchoolBo.AreaTypeGuj = "સૂચિત વિસ્તાર"; } } else { objSchoolBo.AreaType = ""; objSchoolBo.AreaTypeGuj = ""; } if (rblAreaSubType.SelectedItem != null) { objSchoolBo.AreaSubType = rblAreaSubType.SelectedItem.ToString(); if (objSchoolBo.AreaSubType == "Non Adivasi Area") { objSchoolBo.AreaSubTypeGuj = "બિન આદિવાસી વિસ્તાર"; } else if (objSchoolBo.AreaSubType == "Economically Backward Area") { objSchoolBo.AreaSubTypeGuj = "આર્થિક રીતે પછાત વિસ્તાર"; } else if (objSchoolBo.AreaSubType == "Frontier Area") { objSchoolBo.AreaSubTypeGuj = "આર્થિક સરહદી વિસ્તાર"; } //objSchoolBo.AreaSubTypeGuj = rblAreaSubType.SelectedValue.ToString(); } else { objSchoolBo.AreaSubType = ""; objSchoolBo.AreaSubTypeGuj = ""; } objSchoolBo.TownEng = txtTown.Text; objSchoolBo.TownGuj = txtTownGuj.Text; objSchoolBo.AtPoNoEng = txtATPOEng.Text; objSchoolBo.AtPoNoGuj = txtATPOGuj.Text; objSchoolBo.TalukaEng = txtTalukaEng.Text; objSchoolBo.TalukaGuj = txttalukaGuj.Text; objSchoolBo.DistrictEng = txtDistrict.Text; objSchoolBo.DistrictGuj = txtDistrictGuj.Text; objSchoolBo.StateEng = txtState.Text; objSchoolBo.StateGuj = txtStateGuj.Text; objSchoolBo.CountryEng = txtCountry.Text; objSchoolBo.CountryGuj = txtCountryGuj.Text; objSchoolBo.Pincode = txtPinCode.Text; objSchoolBo.TelephoneNo = txtTelephoneNo.Text; objSchoolBo.MobileNo = txtMobileNo.Text; objSchoolBo.EmailID = txtEmailID.Text; objSchoolBo.AlternateEmailID = txtAlternateEmail.Text; objSchoolBo.FaxNo = txtFax.Text; objSchoolBo.Website = txtWebsite.Text; objSchoolBo.SSCindexNo = txtSSCIndexNo.Text; objSchoolBo.HSCScienceIndexNo = txtScienceIndexNo.Text; objSchoolBo.HSCCommerceIndexNo = txtCommerceIndexNo.Text; objSchoolBo.HSCArtsIndexNo = txtArtsIndexNo.Text; objSchoolBo.RegistrationCode = txtRegistrationCode.Text; objSchoolBo.RegisteredNameEng = txtRegistrationName.Text; objSchoolBo.RegistreredNameGuj = txtRegistrationCodeGuj.Text; // objSchoolBo.RegisteredAddressEng = txtRegisteredAddress.Text; objSchoolBo.RegisteredAddressGuj = txtRegisteredddressGuj.Text; objSchoolBo.SchoolMottoEng = txtSchoolMotto.Text; objSchoolBo.SchoolMottoGuj = txtSchoolMottoGuj.Text; objSchoolBo.SchoolVisionEng = txtSchoolVision.Text; objSchoolBo.SchoolVisionGuj = txtSchoolVisionGuj.Text; if (chkIsRent.Checked == true) { objSchoolBo.IsOnRent = 1; } else { objSchoolBo.IsOnRent = 0; } objSchoolBo.OwnerNameEng = txtOwnerName.Text; objSchoolBo.OwnerNameGuj = txtOwnerNameGuj.Text; objSchoolBo.OwnerAddressEng = txtOwnerAddress.Text; objSchoolBo.OwnerAddressGuj = txtOwnerAddressGuj.Text; objSchoolBo.WordNo = txtWordNo.Text; objSchoolBo.WordNameEng = txtWordName.Text; objSchoolBo.WordNameGuj = txtWardNameGuj.Text; objSchoolBo.PlotNo = txtPlotNo.Text; objSchoolBo.PlotArea = txtPlotArea.Text; objSchoolBo.ConstrunctionYear = ddlConstructionYear.SelectedItem.ToString(); objSchoolBo.NoOfFloors = txtNoOfFloor.Text; objSchoolBo.AuditList = ""; objSchoolBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objSchoolBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (ValidateName() == true) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('School Name " + txtSchoolName.Text + " Already Exists.');</script>"); goto Exit; } #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); if (ViewState["Mode"].ToString() == "Save") { objResults = objSchoolBl.School_Insert(objSchoolBo); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["SchoolMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); InsertBank(); PanelGrid_VisibilityMode(1); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('School Created Successfully.');</script>"); ClearAll(); } } } else { objResults = objBankBl.BankAssociation_Delete_TrustMID(0, Convert.ToInt32(ViewState["SchoolMID"].ToString())); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { } InsertBank(); objSchoolBo.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString()); objSchoolBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objResults = objSchoolBl.School_Update(objSchoolBo); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('School updated successfully');</script>"); // GridDataBind(); objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ViewState["Mode"] = "Save"; btnSave.Text = "Save"; } } DatabaseTransaction.CommitTransation(); //Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "Clear();", true); 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>"); } }