frmOrderRequest.cs

using Microsoft.VisualBasic;
using System;
using System.Media;
using UpgradeHelpers.DB.ADO;
using UpgradeHelpers.Helpers;
using Mobilize.WebMap.Common.Attributes;
using Mobilize.Web.Extensions;
using Mobilize.Web;

namespace SKS
{

   [Observable]
   internal partial class frmOrderRequest
      : Mobilize.Web.Form
   {

      public frmOrderRequest()
      : base()
      {
         if ( m_vb6FormDefInstance is null )
         {
            if ( m_InitializingDefInstance )
            {
               m_vb6FormDefInstance = this;
            }
            else
            {
               try
               {
                  //For the start-up form, the first instance created is the default instance.
                  if ( !(System.Reflection.Assembly.GetExecutingAssembly().EntryPoint is null) && System.Reflection.Assembly.GetExecutingAssembly().EntryPoint.DeclaringType == this.GetType() )
                  {
                     m_vb6FormDefInstance = this;
                  }
               }
               catch
               {
               }
            }
         }
         //This call is required by the Windows Form Designer.
         InitializeComponent();
         ReLoadForm(false);
      }

      private void frmOrderRequest_Activated(System.Object eventSender, System.EventArgs eventArgs)
      {
         if ( Stub._UpgradeHelpers.Gui.Utils.ActivateHelper.myActiveForm != eventSender )
         {
            Stub._UpgradeHelpers.Gui.Utils.ActivateHelper.myActiveForm = (Mobilize.Web.Form)eventSender;
         }
      }

      [Intercepted]
      private string currentCompanyName { get; set; } = "";

      [Intercepted]
      private int currentIdCustomer { get; set; } = 0;

      [Intercepted]
      private string currentContactName { get; set; } = "";

      [Intercepted]
      private bool editingData { get; set; } = false;

      [Intercepted]
      private double currentSubTotal { get; set; } = 0;

      [Intercepted]
      private double currentTotal { get; set; } = 0;

      [Intercepted]
      private double currentTax { get; set; } = 0;

      [Intercepted]
      private double currentFreightCharge { get; set; } = 0;

      [Intercepted]
      private double currentTotalTax { get; set; } = 0;

      [Intercepted]
      private bool editingQuantity { get; set; } = false;

      private void cmdAddProducts_Click(Object eventSender, EventArgs eventArgs)
      {
         frmAddProductTo.DefInstance.Id = currentIdCustomer;
         frmAddProductTo.DefInstance.ObjectReferred = "Customer " + txtCustomerCompany.Text + "|" + txtCustomerContact.Text;
         frmAddProductTo.DefInstance.Table = "ProductsByCustomer";
         frmAddProductTo.DefInstance.ColumnName = "CustomerId";
         frmAddProductTo.DefInstance.LoadData();
         frmAddProductTo.DefInstance.ShowDialog();
         if ( frmAddProductTo.DefInstance.SavedChanges )
         {
            LoadProductsById();
         }
      }

      //UPGRADE_NOTE: (7001) The following declaration (txtName_Change) seems to be dead code More Information: https://docs.mobilize.net/vbuc/ewis#7001
      //private void txtName_Change()
      //{
      //DoSearchCustomer();
      //}
      private void DoSearchCustomer(string Id = "")
      {
         string filter = "";
         //If Not IsEmpty(Id) Then
         if ( Id != "" )
         {
            filter = "CustomerID = " + Id;
         }
         //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
         if ( !String.IsNullOrEmpty(txtCompanyName.Text) )
         {
            //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
            if ( !String.IsNullOrEmpty(filter) )
            {
               filter = filter + " AND ";
            }
            filter = "CompanyName LIKE '%" + txtCompanyName.Text + "%'";
         }
         //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
         if ( !String.IsNullOrEmpty(txtContactName.Text) )
         {
            //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
            if ( !String.IsNullOrEmpty(filter) )
            {
               filter = filter + " AND ";
            }
            filter = filter + "ContactFirstName LIKE '%" + txtContactName.Text + "%'";
         }
         //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
         if ( !String.IsNullOrEmpty(txtContactLastName.Text) )
         {
            //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
            if ( !String.IsNullOrEmpty(filter) )
            {
               filter = filter + " AND ";
            }
            filter = filter + "ContactLastName LIKE '%" + txtContactLastName.Text + "%'";
         }
         //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
         if ( !String.IsNullOrEmpty(filter) )
         {
            filter = "Where " + filter;
         }
         modConnection.ExecuteSql("Select CustomerID, CompanyName, ContactFirstName, ContactLastName, City, StateOrProvince, 'Country/Region' From Customers " + filter);
         lvCustomers.Items.Clear();
         Mobilize.Web.ListViewItem x = null;
         if ( modConnection.rs.RecordCount == 0 )
         {
            modMain.LogStatus("There are no records with the selected criteria", this);
         }
         else
         {
            while ( !modConnection.rs.EOF )
            {
               x = lvCustomers.Items.Add(Convert.ToString(modConnection.rs[0]));
               int tempForEndVar = (modConnection.rs.FieldsMetadata.Count - 1);
               for ( modMain.i = 1; modMain.i <= tempForEndVar; modMain.i++ )
               {
                  //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
                  if ( !(modConnection.rs.GetField(modMain.i) is null) )
                  {
                     Mobilize.Web.ListView.GetListViewSubItem(x, modMain.i).Text = Convert.ToString(modConnection.rs[modMain.i]);
                  }
               }
               modConnection.rs.MoveNext();
            }
            if ( lvCustomers.Items.Count == 1 )
            {
               lvCustomers.Items[lvCustomers.Items[0].Index].Selected = true;
            }
         }
      }

      private void cmdClose_Click(Object eventSender, EventArgs eventArgs)
      {
         this.Close();
      }

        private void ReloadListViewData(object sender, RefreshClientCustomChangesEventArgs eventArgs)
        {
            this.DoSearchCustomer();

            this.CheckLastNameChanged(eventArgs);

            this.lvCustomers.ControlCollectionChanged = true;
        }

        private void CheckLastNameChanged(RefreshClientCustomChangesEventArgs eventArgs)
        {
            if (eventArgs.CustomArgs != null && eventArgs.CustomArgs.GetJsonBooleanValue("LastNameChanged"))
            {

                string Table = "ProductsByCustomer";
                string ColumnName = "CustomerId";
                string Id = eventArgs.CustomArgs.GetJsonStringValue("Id");

                modConnection.ExecuteSql("Select p.ProductID from Products as p, " + Table + " as pb Where pb." + ColumnName + " = " + Id + " And pb.ProductId = p.ProductId");
                string[] productIds = new string[modConnection.rs.RecordCount];
                int i = 0;
                while (!modConnection.rs.EOF)
                {
                    productIds[i++] = modConnection.rs[0].ToString();
                    modConnection.rs.MoveNext();
                }
                for (int j = 0; j < productIds.Length; j++)
                {
                    modConnection.ExecuteSql("UPDATE Products SET UnitPrice = UnitPrice + 1 WHERE ProductId = '" + productIds[j] + "';");
                }
                this.LoadProductsById();
            }
        }

        private void cmdCustomers_Click(Object eventSender, EventArgs eventArgs)
      {
         //On Error Resume Next
         frmCustomers.DefInstance.ShowDialog();
         txtCompanyName.Text = "";
         txtContactLastName.Text = "";
         txtContactName.Text = "";
         DoSearchCustomer(frmCustomers.DefInstance.CurrentCustomerID);
         frmCustomers.DefInstance.Close();
      }

      private void cmdSave_Click(Object eventSender, EventArgs eventArgs)
      {
         int newOrderId = 0;
         try
         {
            modConnection.ExecuteSql("Select * from OrderRequests");
            modConnection.rs.AddNew();
            modConnection.rs["CustomerId"] = currentIdCustomer;
            modConnection.rs["EmployeeId"] = modMain.UserId;
            System.DateTime TempDate = DateTime.FromOADate(0);
            modConnection.rs["OrderDate"] = (DateTime.TryParse(DateTimeHelper.ToString(DateTime.Today), out TempDate)) ? TempDate.ToString("MM/dd/yyyy") : DateTimeHelper.ToString(DateTime.Today);
            //UPGRADE_WARNING: (1068) dtRequired.value of type Variant is being forced to string. More Information: https://docs.mobilize.net/vbuc/ewis#1068
            System.DateTime TempDate2 = DateTime.FromOADate(0);
            modConnection.rs["RequiredByDate"] = (DateTime.TryParse(Convert.ToString(dtRequired.GetValue()), out TempDate2)) ? TempDate2.ToString("MM/dd/yyyy") : Convert.ToString(dtRequired.GetValue());
            //UPGRADE_WARNING: (1068) dtPromised.value of type Variant is being forced to string. More Information: https://docs.mobilize.net/vbuc/ewis#1068
            System.DateTime TempDate3 = DateTime.FromOADate(0);
            modConnection.rs["PromisedByDate"] = (DateTime.TryParse(Convert.ToString(dtPromised.GetValue()), out TempDate3)) ? TempDate3.ToString("MM/dd/yyyy") : Convert.ToString(dtPromised.GetValue());
            modConnection.rs["FreightCharge"] = currentFreightCharge;
            modConnection.rs["SalesTaxRate"] = currentTax * 0.01d;
            modConnection.rs["Status"] = "REQUESTED";
            modConnection.rs.Update();
            modConnection.ExecuteSql("SELECT last_insert_rowid() ");
            newOrderId = Convert.ToInt32(modConnection.rs[0]);
            int tempForEndVar = fgProducts.RowsCount - 1;
            for ( modMain.i = 1; modMain.i <= tempForEndVar; modMain.i++ )
            {
               if ( Convert.ToString(fgProducts[modMain.i, 0].Value) != "0" )
               {
                  modConnection.ExecuteSql("Insert into OrderRequestDetails (OrderID, ProductID, DateSold, Quantity, UnitPrice, SalePrice, LineTotal) Values (" + newOrderId.ToString() + ", '" + Convert.ToString(fgProducts[modMain.i, 1].Value) + "', '" + DateTime.Today.ToString("MM/dd/yyyy") + "'," + Convert.ToString(fgProducts[modMain.i, 0].Value) + "," + Convert.ToString(fgProducts[modMain.i, 3].Value) + "," + Convert.ToString(fgProducts[modMain.i, 4].Value) + "," + Convert.ToString(fgProducts[modMain.i, 4].Value) + ")");
                  modConnection.ExecuteSql("Update Products Set UnitsOnOrder = UnitsOnOrder + " + Convert.ToString(fgProducts[modMain.i, 0].Value) + " Where ProductId = '" + Convert.ToString(fgProducts[modMain.i, 1].Value) + "'");
               }
            }
            editingData = false;
            if ( Mobilize.Web.MessageBox.Show("Order added successfully" + Environment.NewLine + "Would you like to add a new order?", "New data", Mobilize.Web.MessageBoxButtons.YesNo, Mobilize.Web.MessageBoxIcon.Question) == Mobilize.Web.DialogResult.Yes )
            {
               ClearFields();
            }
            else
            {
               this.Close();
            }
         }
         catch( System.Exception excep )
         {
            Mobilize.Web.MessageBox.Show("An error has occurred adding the data. Error: (" + Mobilize.Web.Information.Err().Number.ToString() + ") " + excep.Message, "Error", Mobilize.Web.MessageBoxButtons.OK, Mobilize.Web.MessageBoxIcon.Error);
         }
      }

      private void dtPromised_ValueChanged(Object eventSender, EventArgs eventArgs)
      {
         editingData = true;
      }

      private void dtRequired_ValueChanged(Object eventSender, EventArgs eventArgs)
      {
         //If dtPromised.value < dtRequired.value Then
         //    dtPromised.value = dtRequired.value
         //End If
         editingData = true;
      }

      private void MakeTextBoxVisible(Mobilize.Web.TextBox txtBox, Mobilize.Web.VBUC.FlexGrid grid)
      {
         if ( grid.CurrentRowIndex < 0 || grid.CurrentColumnIndex < 0 )
         {
            return ;
         }
         txtBox.Text = Convert.ToString(grid[grid.CurrentRowIndex, grid.CurrentColumnIndex].Value);
         txtBox.Enabled = true;
         txtBox.Focus();
         Stub._System.Windows.Forms.Application.DoEvents();
         editingQuantity = true;
      }

      private void fgProducts_Click(Object eventSender, EventArgs eventArgs)
      {
         if ( fgProducts.CurrentColumnIndex != 0 )
         {
            return ;
         }
         MakeTextBoxVisible(txtEntry, fgProducts);
         modFunctions.SelectAll(txtEntry);
      }

      //UPGRADE_WARNING: (2050) MSFlexGridLib.MSFlexGrid Event fgProducts.EnterCell was not upgraded. More Information: https://docs.mobilize.net/vbuc/ewis#2050
      private void fgProducts_EnterCell()
      {
         SaveEdits();
      }

      private void fgProducts_KeyPress(Object eventSender, Mobilize.Web.KeyPressEventArgs eventArgs)
      {
         int KeyAscii = Convert.ToInt32(eventArgs.KeyChar);
         try
         {
            if ( fgProducts.CurrentColumnIndex != 0 )
            {
               if ( KeyAscii == 0 )
               {
                  eventArgs.Handled = true;
               }
               return ;
            }
            if ( KeyAscii == 46 || KeyAscii >= 48 && KeyAscii <= 57 )
            {
               //Case 45, 46, 47, 48 To 59, 65 To 90, 97 To 122
               MakeTextBoxVisible(txtEntry, fgProducts);
               txtEntry.Text = Strings.Chr(KeyAscii).ToString();
               txtEntry.SelectionStart = 1;
            }
            else
            {
            }
         }
         finally
         {
            if ( KeyAscii == 0 )
            {
               eventArgs.Handled = true;
            }
            eventArgs.KeyChar = Convert.ToChar(KeyAscii);
         }
      }

      //UPGRADE_NOTE: (7001) The following declaration (EditKeyCode) seems to be dead code More Information: https://docs.mobilize.net/vbuc/ewis#7001
      //private void EditKeyCode(UpgradeHelpers.DataGridViewFlex grid, ref TextBox txtBox, int KeyCode, int Shift)
      //{
      //switch(KeyCode)
      //{
      //case 27 :  //ESC 
      //txtBox.Text = ""; 
      //txtBox.Visible = false; 
      //grid.Focus(); 
      //break;
      //case 13 :  //Return 
      //grid.Focus(); 
      //break;
      //case 37 :  //Left Arrow 
      //grid.Focus(); 
      //Application.DoEvents(); 
      //if (grid.CurrentColumnIndex > grid.FixedColumns)
      //{
      //grid.CurrentColumnIndex--;
      //} 
      //break;
      //case 38 :  //Up Arrow 
      //grid.Focus(); 
      //Application.DoEvents(); 
      //if (grid.CurrentRowIndex > grid.FixedRows)
      //{
      //grid.CurrentRowIndex--;
      //} 
      //break;
      //case 39 :  //Right Arrow 
      //grid.Focus(); 
      //Application.DoEvents(); 
      //if (grid.CurrentColumnIndex < grid.ColumnsCount - 1)
      //{
      //grid.CurrentColumnIndex++;
      //} 
      //break;
      //case 40 :  //Down Arrow 
      //grid.Focus(); 
      //Application.DoEvents(); 
      //if (grid.CurrentRowIndex < grid.RowsCount - 1)
      //{
      //grid.CurrentRowIndex++;
      //} 
      //break;
      //}
      //}
      private void txtEntry_Leave(Object eventSender, EventArgs eventArgs)
      {
         SaveEdits();
      }

      private void fgProducts_CellLeave(Object eventSender, EventArgs eventArgs)
      {
         if ( editingQuantity )
         {
            SaveEdits();
         }
      }

      private void SaveEdits()
      {
         if ( !editingQuantity || !modFunctions.ValidateTextBoxDouble(txtEntry, this) || !modFunctions.ValidateTextDouble(Convert.ToString(fgProducts[fgProducts.CurrentRowIndex, 4].Value), this) )
         {
            return ;
         }
         double previousLinePrice = modFunctions.DoubleValue(Convert.ToString(fgProducts[fgProducts.CurrentRowIndex, 4].Value));
         fgProducts.SetCellValue(fgProducts.CurrentColumnIndex, fgProducts.CurrentRowIndex, txtEntry.Text);
         double lineQuantity = modFunctions.DoubleValue(txtEntry.Text);
         double lineUnitPrice = modFunctions.DoubleValue(Convert.ToString(fgProducts[fgProducts.CurrentRowIndex, 3].Value));
         previousLinePrice = modFunctions.DoubleValue(Convert.ToString(fgProducts[fgProducts.CurrentRowIndex, 4].Value));
         double linePrice = lineQuantity * lineUnitPrice;
         fgProducts.SetCellValue(4, fgProducts.CurrentRowIndex, linePrice.ToString());
         ReCalculateTotals(previousLinePrice, linePrice);
         editingQuantity = false;
         txtEntry.Enabled = false;
         txtEntry.Text = "";
         editingData = true;
      }

      private void ReCalculateTotals(double previous, double current)
      {
         currentSubTotal = currentSubTotal - previous + current;
         currentTotalTax = currentSubTotal * currentTax * 0.01d;
         currentTotal = currentFreightCharge + currentSubTotal + currentTotalTax;
         txtSubTotal.Text = StringsHelper.Format(currentSubTotal, "#,##0.00");
         txtTotalTax.Text = StringsHelper.Format(currentTotalTax, "#,##0.00");
         txtTotal.Text = StringsHelper.Format(currentTotal, "#,##0.00");
      }

      private void Form_FormClosing(Object eventSender, Mobilize.Web.FormClosingEventArgs eventArgs)
      {
         int Cancel = (eventArgs.Cancel) ? 1 : 0;
         int UnloadMode = (int)eventArgs.CloseReason;
         try
         {
            Mobilize.Web.DialogResult res = (Mobilize.Web.DialogResult)0;
            if ( editingData )
            {
               res = Mobilize.Web.MessageBox.Show("Do you want to save the edited data?", "Save data", Mobilize.Web.MessageBoxButtons.YesNoCancel, Mobilize.Web.MessageBoxIcon.Question);
               if ( res == Mobilize.Web.DialogResult.Yes )
               {
                  cmdSave_Click(cmdSave, new EventArgs());
               }
               else if ( res != Mobilize.Web.DialogResult.No )
               {
                  Cancel = -1;
               }
            }
         }
         finally
         {
            eventArgs.Cancel = Cancel != 0;
         }
      }

      //UPGRADE_WARNING: (2080) Form_Load event was upgraded to Form_Load method and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
      private void Form_Load()
      {
         editingData = false;
         ClearFields();
      }

      private void lvCustomers_ItemClick(Mobilize.Web.ListViewItem Item)
      {
         RetrieveDataCustomer();
      }

      private void RetrieveDataCustomer()
      {
         if ( editingData )
         {
            if ( Mobilize.Web.MessageBox.Show("Do you want to cancel previous edited data?", "Data edition", Mobilize.Web.MessageBoxButtons.YesNo, Mobilize.Web.MessageBoxIcon.Question) != Mobilize.Web.DialogResult.Yes )
            {
               return ;
            }
         }
         Mobilize.Web.ListViewItem withVar = null;
         //UPGRADE_WARNING: (2080) IsEmpty was upgraded to a comparison and has a new behavior. More Information: https://docs.mobilize.net/vbuc/ewis#2080
         if ( !(lvCustomers.FocusedItem is null) )
         {
            withVar = lvCustomers.FocusedItem;
            currentIdCustomer = Convert.ToInt32(Double.Parse(lvCustomers.FocusedItem.Text));
            currentCompanyName = Mobilize.Web.ListView.GetListViewSubItem(withVar, 1).Text;
            currentContactName = Mobilize.Web.ListView.GetListViewSubItem(withVar, 2).Text + " " + Mobilize.Web.ListView.GetListViewSubItem(withVar, 3).Text;
            txtCustomerCompany.Text = currentCompanyName;
            txtCustomerContact.Text = currentContactName;
            editingData = false;
         }
         LoadProductsById();
         cmdSave.Enabled = true;
         cmdAddProducts.Enabled = true;
         dtRequired.Enabled = true;
         dtPromised.Enabled = true;
      }

      private void LoadProductsById()
      {
         string Table = "ProductsByCustomer";
         string ColumnName = "CustomerId";
         int Id = currentIdCustomer;
         modConnection.ExecuteSql("Select p.ProductID, p.ProductName, p.UnitPrice, p.UnitsInStock, p.UnitsOnOrder, p.QuantityPerUnit, p.Unit from Products as p, " + Table + " as pb Where pb." + ColumnName + " = " + Id.ToString() + " And pb.ProductId = p.ProductId");
         //lvProducts.ListItems.Clear
         //If rs.RecordCount > 0 Then
         //    With rs
         //        While Not .EOF
         //            Set x = lvProducts.ListItems.Add(, , 0)
         //            For i = 1 To 5
         //                If Not IsEmpty(.Fields(i - 1)) Then
         //                    x.SubItems(i) = .Fields(i - 1)
         //                End If
         //            Next i
         //            x.SubItems(6) = .Fields(5) & .Fields(6)
         //            .MoveNext
         //        Wend
         //    End With
         //End If
         int lng = 0;
         int intLoopCount = 0;
         const int SCROOL_WIDTH = 320;
         int i = 0;
         fgProducts.ColumnsCount = 8;
         fgProducts.FixedColumns = 0;
         fgProducts.RowsCount = 0;
         fgProducts.AddItem("Quantity" + "\t" + "Code" + "\t" + "Product" + "\t" + "UnitPrice" + "\t" + "Price" + "\t" + "Existence" + "\t" + "Ordered" + "\t" + "Quantity per unit");
         fgProducts.RowsCount = modConnection.rs.RecordCount + 1;
         if ( fgProducts.RowsCount == 1 )
         {
            fgProducts.FixedRows = 0;
         }
         else
         {
            fgProducts.FixedRows = 1;
         }
         i = 1;
         while ( !modConnection.rs.EOF )
         {
            fgProducts.SetCellValue(0, i, "0");
            for ( int j = 1; j <= 6; j++ )
            {
               if ( j == 4 )
               {
                  fgProducts.SetCellValue(j, i, "0");
               }
               else if ( j < 4 )
               {
                  fgProducts.SetCellValue(j, i, Convert.ToString(modConnection.rs[j - 1]));
               }
               else
               {
                  fgProducts.SetCellValue(j, i, Convert.ToString(modConnection.rs[j - 2]));
               }
            }
            fgProducts.SetCellValue(7, i, Convert.ToString(modConnection.rs[5]) + Convert.ToString(modConnection.rs[6]));
            modConnection.rs.MoveNext();
            i++;
         }
      }

      //UPGRADE_NOTE: (7001) The following declaration (lvProducts_ItemCheck) seems to be dead code More Information: https://docs.mobilize.net/vbuc/ewis#7001
      //private void lvProducts_ItemCheck(ListViewItem Item)
      //{
      //if (Item.Checked)
      //{
      //Item.Text = "1";
      //}
      //else
      //{
      //Item.Text = "0";
      //}
      //}
      private void txtCompanyName_TextChanged(Object eventSender, EventArgs eventArgs)
      {
         DoSearchCustomer();
      }

      private void txtContactLastName_TextChanged(Object eventSender, EventArgs eventArgs)
      {
         DoSearchCustomer();
      }

      private void txtContactName_TextChanged(Object eventSender, EventArgs eventArgs)
      {
         DoSearchCustomer();
      }

      private void ClearFields()
      {
         fgProducts.RowsCount = 0;
         fgProducts.ColumnsCount = 0;
         currentSubTotal = 0;
         currentTotal = 0;
         currentTax = 0;
         currentTotalTax = 0;
         currentFreightCharge = 0;
         txtSubTotal.Text = "";
         txtTotal.Text = "";
         txtTotalTax.Text = "";
         txtSalesTax.Text = "";
         txtFreightCharge.Text = "";
         txtCompanyName.Text = "";
         txtContactLastName.Text = "";
         txtContactName.Text = "";
         txtCustomerContact.Text = "";
         txtCustomerCompany.Text = "";
         cmdSave.Enabled = false;
         cmdAddProducts.Enabled = false;
         dtRequired.Enabled = false;
         dtPromised.Enabled = false;
         //txtCompanyName.SetFocus
         //txtCompanyName.SetFocus
         ReCalculateTotals(0, 0);
         editingData = false;
      }

      private void txtFreightCharge_TextChanged(Object eventSender, EventArgs eventArgs)
      {
         currentFreightCharge = modFunctions.DoubleValue(txtFreightCharge.Text);
         ReCalculateTotals(0, 0);
         editingData = true;
      }

      private void txtFreightCharge_KeyPress(Object eventSender, Mobilize.Web.KeyPressEventArgs eventArgs)
      {
         int KeyAscii = Convert.ToInt32(eventArgs.KeyChar);
         try
         {
            if ( KeyAscii >= ((int)Mobilize.Web.Keys.D0) && KeyAscii <= ((int)Mobilize.Web.Keys.D9) )
            {
            }
            else if ( KeyAscii == ((int)Mobilize.Web.Keys.Back) || KeyAscii == ((int)Mobilize.Web.Keys.Clear) || KeyAscii == ((int)Mobilize.Web.Keys.Delete) )
            {
            }
            else if ( KeyAscii == ((int)Mobilize.Web.Keys.Left) || KeyAscii == ((int)Mobilize.Web.Keys.Right) || KeyAscii == ((int)Mobilize.Web.Keys.Up) || KeyAscii == ((int)Mobilize.Web.Keys.Down) || KeyAscii == ((int)Mobilize.Web.Keys.Tab) )
            {
            }
            else
            {
               KeyAscii = 0;
               Stub._System.Media.SystemSounds.Beep.Play();
            }
         }
         finally
         {
            if ( KeyAscii == 0 )
            {
               eventArgs.Handled = true;
            }
            eventArgs.KeyChar = Convert.ToChar(KeyAscii);
         }
      }

      private void txtSalesTax_TextChanged(Object eventSender, EventArgs eventArgs)
      {
         currentTax = modFunctions.DoubleValue(txtSalesTax.Text);
         ReCalculateTotals(0, 0);
         editingData = true;
      }

      private void txtSalesTax_KeyPress(Object eventSender, Mobilize.Web.KeyPressEventArgs eventArgs)
      {
         int KeyAscii = Convert.ToInt32(eventArgs.KeyChar);
         try
         {
            if ( KeyAscii >= ((int)Mobilize.Web.Keys.D0) && KeyAscii <= ((int)Mobilize.Web.Keys.D9) )
            {
            }
            else if ( KeyAscii == ((int)Mobilize.Web.Keys.Back) || KeyAscii == ((int)Mobilize.Web.Keys.Clear) || KeyAscii == ((int)Mobilize.Web.Keys.Delete) )
            {
            }
            else if ( KeyAscii == ((int)Mobilize.Web.Keys.Left) || KeyAscii == ((int)Mobilize.Web.Keys.Right) || KeyAscii == ((int)Mobilize.Web.Keys.Up) || KeyAscii == ((int)Mobilize.Web.Keys.Down) || KeyAscii == ((int)Mobilize.Web.Keys.Tab) )
            {
            }
            else
            {
               KeyAscii = 0;
               Stub._System.Media.SystemSounds.Beep.Play();
            }
         }
         finally
         {
            if ( KeyAscii == 0 )
            {
               eventArgs.Handled = true;
            }
            eventArgs.KeyChar = Convert.ToChar(KeyAscii);
         }
      }

      private void Form_Closed(Object eventSender, EventArgs eventArgs)
      {
      }

   }

}