Ejemplo n.º 1
0
        private void cmbSubsidiary_SelectedValueChanged(object sender, EventArgs e)
        {
            if (FormState == FormStates.fsView)
            {
                return;
            }

            object ATCId;

            if (cmbSubsidiary.SelectedValue != null &&
                cmbSubsidiary.SelectedValue != DBNull.Value)
            {
                ATCId = VLookupProvider.DataSetLookup(VLookupProvider.dstSubsidiaries, "Id", cmbSubsidiary.SelectedValue, "ATCId");

                if (ATCId != null && ATCId != DBNull.Value)
                {
                    dstDetail.Columns.Find(c => c.Name == "ATCId").DefaultValue = ATCId.ToString();

                    foreach (DataGridViewRow row in dataGridView.Rows)
                    {
                        if (row.Index != dataGridView.NewRowIndex)
                        {
                            row.Cells[dataGridView.GetCellIndex("ATCId")].Value = ATCId;
                        }
                    }
                }
            }
        }
Ejemplo n.º 2
0
        protected override void Preview()
        {
            base.Preview();

            //print the first item on selection
            String      reportFormName = VLookupProvider.DataSetLookup(VLookupProvider.dstSystemPrintouts, "FormCaption", this.Caption, "PrintoutFormName").ToString();
            IParentForm reportForm     = IAppHandler.FindForm(reportFormName, "Printout", true);

            if (reportForm == null)
            {
                IMessageHandler.ShowError(ISystemMessages.PrintoutNotSet);
            }
            else
            {
                IAppHandler.AddUsedForm(this);
                this.Hide();

                if (reportForm.Parameters.Find(p => p.Name == "Id") != null)
                {
                    reportForm.Parameters.Find(p => p.Name == "Id").Value = this.Parameters.Find(pa => pa.Name == "Id").Value;
                }

                (reportForm as IReportForm).PrintoutHeader = this.Caption;
                reportForm.Run();
            }
        }
Ejemplo n.º 3
0
        private void ComputeDetailAmount()
        {
            int    VATTypeId = int.Parse(dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("VATTypeId")].Value.ToString());
            double Amount = double.Parse(dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("Amount")].Value.ToString());
            double VATAmount = 0, GrossAmount = 0, WTAX = 0, ATCRate = 0;
            object ATCId;

            if (Amount == 0 || Modifying)
            {
                return;
            }

            try
            {
                Modifying = true;

                //VAT
                dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("VATAmount")].Value = ComputeVATAmount(VATTypeId, Amount).ToString();
                VATAmount = double.Parse(dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("VATAmount")].Value.ToString());

                //GrossAmount
                if (VATTypeId == 1) //Inclusive
                {
                    GrossAmount = Amount - VATAmount;
                }
                else
                {
                    GrossAmount = Amount;
                }

                dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("GrossAmount")].Value = GrossAmount;

                //WithholdingTax
                ATCId = dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("ATCId")].Value;
                if (ATCId != null && ATCId != DBNull.Value)
                {
                    ATCRate = double.Parse(VLookupProvider.DataSetLookup(VLookupProvider.dstATC, "Id", ATCId, "Rate").ToString());
                    WTAX    = Math.Round(GrossAmount * (ATCRate / 100), 2);
                }

                dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("WithholdingTax")].Value = WTAX;

                //Total
                if (VATTypeId == 1) //Inclusive
                {
                    dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("Total")].Value = Amount.ToString();
                }
                else
                {
                    dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("Total")].Value = (Amount + VATAmount).ToString();
                }
            }
            finally
            {
                Modifying = false;
            }
        }
Ejemplo n.º 4
0
        private void EAccountForm_SetupData()
        {
            PluralizationService ps = PluralizationService.CreateService(CultureInfo.GetCultureInfo("en-us"));
            String cap = VLookupProvider.DataSetLookup(VLookupProvider.dstAccountTypes, "Id", Parameters.Find(p => p.Name == "AccountTypeId").Value, "Name").ToString();

            Caption = ps.Singularize(cap);

            MasterColumns.Find(mc => mc.Name == "AccountTypeId").DefaultValue = Parameters.Find(p => p.Name == "AccountTypeId").Value;
        }
Ejemplo n.º 5
0
        private double ComputeVATAmount(int VATTypeId, double Amount)
        {
            double VATAmount = 0, VATRate;

            VATRate = Double.Parse(VLookupProvider.DataSetLookup(VLookupProvider.dstVATTypes, "Id", VATTypeId, "Rate").ToString());

            if (VATTypeId == 1) //Inclusive
            {
                VATAmount = Amount - (Amount / (1 + (VATRate / 100)));
            }
            else if (VATTypeId == 2) //Exclusive
            {
                VATAmount = Amount * (VATRate / 100);
            }

            return(Math.Round(VATAmount, 2));
        }
Ejemplo n.º 6
0
        private void SetFormFooter()
        {
            lblMode.Text = "Mode: " + FormState.ToString().Substring(2);

            if (FormState == FormStates.fsNew)
            {
                return;
            }

            if (MasterColumns.Find(col => col.Name == "DateCreated") != null)
            {
                lblCreatedBy.Text =
                    String.Format("Created By:     {0} on {1}",
                                  VLookupProvider.DataSetLookup(VLookupProvider.dstSystemUsers, "Id", MasterColumns.Find(col => col.Name == "CreatedById").Value, "FormalName"),
                                  Convert.ToDateTime(MasterColumns.Find(col => col.Name == "DateCreated").Value).ToString("MM'/'dd'/'yyyy 'at' hh:mm:ss tt")
                                  );
            }

            if (MasterColumns.Find(col => col.Name == "DateModified") != null)
            {
                lblModifiedBy.Text =
                    String.Format("Modified By:   {0} on {1}",
                                  VLookupProvider.DataSetLookup(VLookupProvider.dstSystemUsers, "Id", MasterColumns.Find(col => col.Name == "ModifiedById").Value, "FormalName"),
                                  Convert.ToDateTime(MasterColumns.Find(col => col.Name == "DateModified").Value).ToString("MM'/'dd'/'yyyy 'at' hh:mm:ss tt")
                                  );

                if (MasterColumns.Find(col => col.Name == "DateCreated").Value.ToString() == MasterColumns.Find(col => col.Name == "DateModified").Value.ToString())
                {
                    lblCreatedBy.Visible  = true;
                    lblModifiedBy.Visible = false;
                    lblCreatedBy.Padding  = new Padding(5, 5, 5, 5);
                }
                else
                {
                    lblCreatedBy.Visible  = true;
                    lblModifiedBy.Visible = true;
                    lblCreatedBy.Padding  = new Padding(5, 0, 0, 0);
                    lblModifiedBy.Padding = new Padding(5, 0, 0, 0);
                }
            }
        }
Ejemplo n.º 7
0
        protected override void UpdateControls()
        {
            base.UpdateControls();

            btnPreview.Visible = (FormState == FormStates.fsView) &&
                                 (VLookupProvider.DataSetLookup(VLookupProvider.dstSystemPrintouts, "FormCaption", this.Caption, "FormCaption") != null);
            toolStripSeparatorPreview.Visible = btnPreview.Visible;

            btnFirstRecord.Enabled    = btnFirstRecord.Enabled && KeyId != 0;
            btnPreviousRecord.Enabled = btnPreviousRecord.Enabled && KeyId != 0;
            btnNextRecord.Enabled     = btnLastRecord.Enabled && KeyId != KeyList.Count - 1;
            btnLastRecord.Enabled     = btnLastRecord.Enabled && KeyId != KeyList.Count - 1;

            lblCreatedBy.Visible  = (MasterColumns.Find(col => col.Name == "CreatedById") != null) && (FormState != FormStates.fsNew);
            lblModifiedBy.Visible = (MasterColumns.Find(col => col.Name == "ModifiedById") != null) && (FormState != FormStates.fsNew);

            if (FormState != FormStates.fsNew)
            {
                KeyId = _KeyId;
            }
        }
Ejemplo n.º 8
0
        private void dataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex == dataGridView.NewRowIndex || FormState == FormStates.fsView)
            {
                return;
            }

            String VATTypeId = dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("VATTypeId")].Value.ToString();

            if (VATTypeId != null)
            {
                dataGridView.CurrentRow.Cells[dataGridView.GetCellIndex("VATRate")].Value = VLookupProvider.DataSetLookup(VLookupProvider.dstVATTypes, "Id", VATTypeId, "Rate");
            }

            ComputeDetailAmount();
            ComputeMasterAmount();
        }