Example #1
0
    /// <summary>
    /// Sets data to database.
    /// </summary>
    protected void btnOK_Click(object sender, EventArgs e)
    {
        decimal qty   = 0;
        string  error = string.Empty;

        if (UniGridUpdated.RowsCount == 0)
        {
            error = "The list of country to update is empty";
        }
        if (string.IsNullOrEmpty(error))
        {
            if (rdoAmount.Checked)
            {
                try
                {
                    qty = decimal.Parse(txtAmount.Text);
                }
                catch
                {
                    error = "Error: invalid amount";
                }
            }
            else
            {
                try
                {
                    qty = decimal.Parse(txtPercent.Text);
                }
                catch
                {
                    error = "Error: invalid percentage";
                }
            }
        }
        if (!string.IsNullOrEmpty(error))
        {
            ShowError(error);
        }
        else
        {
            if (UpdatePrice(rdoUnitPrice.Checked, rdoAmount.Checked, qty))
            {
                txtAmount.Text  = string.Empty;
                txtPercent.Text = string.Empty;
                iCountry.Clear();
                DisplayUpdatedCountries();
                UniGridUpdated.ReBind();
                ShowChangesSaved();
            }
            else
            {
                ShowWarning("Some error occured", "Update not performed", string.Empty);
            }
        }
    }
Example #2
0
    private void DisplayUpdatedCountries()
    {
        GeneralConnection cn    = ConnectionHelper.GetConnection();
        string            query = getSQL();
        DataSet           ds    = cn.ExecuteQuery(query, null, QueryTypeEnum.SQLQuery, false);

        ds.Tables[0].PrimaryKey = new DataColumn[1] {
            ds.Tables[0].Columns["CountryID"]
        };
        DataTable table = ds.Tables[0];

        table.Rows.Clear();

        GetAndUpdateCustomTableQueryItem();
        //DataSet dsAvailable = (DataSet)UniGridAvailable.DataSource;
        //dsAvailable.Tables[0].PrimaryKey = new DataColumn[1] { dsAvailable.Tables[0].Columns["CountryID"] };

        foreach (int i in iCountry)
        {
            DataRow drow    = table.NewRow();
            DataRow findrow = dsAvailable.Tables[0].Rows.Find(i.ToString());
            if (findrow != null)
            {
                drow["CountryId"]          = findrow["CountryID"];
                drow["CountryDisplayName"] = findrow["CountryDisplayName"];
                drow["UnitPrice"]          = findrow["UnitPrice"];
                drow["ShippingBase"]       = findrow["ShippingBase"];

                table.Rows.Add(drow);
            }
            DataRow d = dsAvailable.Tables[0].Rows.Find(i.ToString());
            if (d != null)
            {
                dsAvailable.Tables[0].Rows.Remove(d);
            }
        }

        UniGridUpdated.DataSource = ds;
        UniGridUpdated.DataBind();
        UniGridAvailable.ReBind();
        SetConfirmText(null, null);
    }