private void initVariable() { try { //OfficeDB.fillOfficeComboNew(cmbOfficeID); ProjectHeaderDB.fillprojectCombo(cmbProject); CustomerDB.fillCustomerComboNew(cmbCustomer); CurrencyDB.fillCurrencyComboNew(cmbCurrency); CatalogueValueDB.fillCatalogValueComboNew(cmbTransportationMode, "TransportationMode"); CustomerDB.fillLedgerTypeComboNew(cmbTransporter, "Transporter"); //CatalogueValueDB.fillCatalogValueCombo(cmbPaymentTerms, "TermsOfPayment"); CatalogueValueDB.fillCatalogValueComboNew(cmbOriginCountryID, "Country"); // CatalogueValueDB.fillCatalogValueCombo(cmbInvoiceType, "POType"); CatalogueValueDB.fillCatalogValueComboNew(cmbFinalDestinationCountryID, "Country"); CatalogueValueDB.fillCatalogValueComboNew(cmbPreCarriageTransMode, "TransportationMode"); // CatalogueValueDB.fillCatalogValueCombo(cmbFinalDestinationCountryID, "Country"); //CatalogueValueDB.fillCatalogValueCombo(cmbPreCarriageTransMode, "TransportationMode"); CatalogueValueDB.fillCatalogValueComboNew(cmbADCode, "ADCODES"); //dtDeliveryDate.Format = DateTimePickerFormat.Custom; //dtDeliveryDate.CustomFormat = "dd-MM-yyyy"; dtInvoiceDate.Format = DateTimePickerFormat.Custom; dtInvoiceDate.CustomFormat = "dd-MM-yyyy"; //dtTrackingDate.Format = DateTimePickerFormat.Custom; //dtTrackingDate.CustomFormat = "dd-MM-yyyy"; //dtValidateDate.Format = DateTimePickerFormat.Custom; //dtValidateDate.CustomFormat = "dd-MM-yyyy"; ShowAllDetails(); btnClose.Focus(); } catch (Exception ex) { MessageBox.Show("initVariable() : Error"); } }
private void initVariable() { try { //OfficeDB.fillOfficeComboNew(cmbOfficeID); //ProjectHeaderDB.fillprojectCombo(cmbProjectID); CustomerDB.fillCustomerComboNew(cmbCustomer); CurrencyDB.fillCurrencyComboNew(cmbCurrency); CatalogueValueDB.fillCatalogValueComboNew(cmbPaymentMode, "PaymentMode"); CatalogueValueDB.fillCatalogValueComboNew(cmbFreightTerms, "Freight"); CatalogueValueDB.fillCatalogValueComboNew(cmbTaxterms, "TaxStatus"); CatalogueValueDB.fillCatalogValueComboNew(cmbTransportationMode, "TransportationMode"); //dtDeliveryDate.Format = DateTimePickerFormat.Custom; //dtDeliveryDate.CustomFormat = "dd-MM-yyyy"; dtPODate.Format = DateTimePickerFormat.Custom; dtPODate.CustomFormat = "dd-MM-yyyy"; //dtTrackingDate.Format = DateTimePickerFormat.Custom; //dtTrackingDate.CustomFormat = "dd-MM-yyyy"; //dtValidateDate.Format = DateTimePickerFormat.Custom; //dtValidateDate.CustomFormat = "dd-MM-yyyy"; ShowAllDetails(); btnClose.Focus(); } catch (Exception ex) { MessageBox.Show("initVariable() : Error"); } }
private void btnSave_Click(object sender, EventArgs e) { try { currency curr = new currency(); CurrencyDB currDB = new CurrencyDB(); curr.CurrencyID = txtID.Text; curr.name = txtName.Text; curr.symbol = txtSymbol.Text; curr.status = ComboFIll.getStatusCode(cmbStatus.SelectedItem.ToString()); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (currDB.validateCurrency(curr)) { if (btnText.Equals("Update")) { if (currDB.updateCurrency(curr)) { MessageBox.Show("Currency updated"); closeAllPanels(); ListCurrency(); } else { MessageBox.Show("Failed to update Currency"); } } else if (btnText.Equals("Save")) { if (currDB.insertCurrency(curr)) { MessageBox.Show("Currency Added"); closeAllPanels(); ListCurrency(); } else { MessageBox.Show("Failed to Insert Currency"); } } } else { MessageBox.Show("Currency Data Validation failed"); } } catch (Exception) { MessageBox.Show("Failed Adding / Editing Currency"); } }
private void initVariables() { try { //CatalogueValueDB.fillCatalogValueCombo(cmbBookType, "DayBookType"); CatalogueValueDB.fillCatalogValueComboNew(cmbBookType, "DayBookType"); CurrencyDB.fillCurrencyComboNew(cmbCurrency); cmbCurrency.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCurrency, "INR"); setButtonVisibility("init"); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
private void ListCurrency() { try { grdList.Rows.Clear(); CurrencyDB dbrecord = new CurrencyDB(); List <currency> Currencies = dbrecord.getCurrencies(); foreach (currency curr in Currencies) { grdList.Rows.Add(curr.CurrencyID, curr.name, curr.symbol, ComboFIll.getStatusString(curr.status)); } } catch (Exception) { MessageBox.Show("Error in Currency listing"); } enableBottomButtons(); pnlCurrencyList.Visible = true; }
private void initVariable() { try { OfficeDB.fillOfficeComboNew(cmbOfficeID); CurrencyDB.fillCurrencyComboNew(cmbCurrencyID); ProjectHeaderDB.fillprojectCombo(cmbProjectID); CatalogueValueDB.fillCatalogValueComboNew(cmbBankTransMode, "BankTransactionMode"); CatalogueValueDB.fillCatalogValueComboNew(cmbBookType, "DayBookType"); dtTempDate.Format = DateTimePickerFormat.Custom; dtTempDate.CustomFormat = "dd-MM-yyyy"; dtVoucherDate.Format = DateTimePickerFormat.Custom; dtVoucherDate.CustomFormat = "dd-MM-yyyy"; ShowAllDetails(); btnClose.Focus(); } catch (Exception ex) { MessageBox.Show("initVariable() : Error"); } }
private void initVariables() { try { if (getuserPrivilegeStatus() == 1) { //user is only a viewer listOption = 6; } dtDate.Format = DateTimePickerFormat.Custom; dtDate.CustomFormat = "dd-MM-yyyy"; CurrencyDB.fillCurrencyCombo(cmbCurrency); fillTypeCombo(cmbType); setButtonVisibility("init"); closeAllPanels(); userString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2; } catch (Exception) { } }