Exemplo n.º 1
0
 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");
     }
 }
Exemplo n.º 2
0
 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");
     }
 }
Exemplo n.º 3
0
        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");
            }
        }
Exemplo n.º 4
0
 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");
     }
 }
Exemplo n.º 5
0
 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;
 }
Exemplo n.º 6
0
 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");
     }
 }
Exemplo n.º 7
0
 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)
     {
     }
 }