C#

private int GetRefurbRate()
{
    string sql = "";
    double Refurb_Rate;
    int totalRefurb = 0;
    int totalUnits = 0;
    string error_msg = "";

    sql = "SELECT COUNT(rp.repair_ord) " +
        "FROM " + schema + ".repair_part rp " +
        "WHERE rp.repair_ord = '" + repair_ord + "' ";
    while (true)
    {
        if (!myDb.RunSql(sql, true))
        {
            error_msg = "DBError for getting Refurb Rate";
            break;
        }
        if (myDb.dbRdr.HasRows)
        {
            if (myDb.dbRdr.Read())
            {
                try //Try and Catch are here b/c I originally had everything ints, and and they just caught the 0 exception.
                {
                    Refurb_Rate = Convert.ToInt32( totalRefurb / totalUnits * 100); //This is where I try to perform the cast.
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                }
            }

            //int Refurb_Rate = Convert.ToInt32(Refurb_Rate);
        }

        break;
    }
    myDb.dbRdr.Close();

    if (error_msg != String.Empty)
    {
        MessageBox.Show(error_msg, "Get Refurb Rate",
        MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
    }

    return Refurb_Rate;
}

Justiin1265 wrote:

Refurb_Rate = Convert.ToInt32( totalRefurb / totalUnits * 100); //This is where I try to perform the cast.

David1987 wrote:

neither float nor double can represent all reals

return (int)Refurb_Rate;

Enum.Parse(typeof(enumName), stringNameOfEnumValue);

Enum.TryParse<enumName>(stringNameOfEnumValue, out placeToPutValue);

public enum DriveType : int
    {
    Unknown = 0,
    NoRoot = 1,
    Removable = 2,
    Localdisk = 3,
    Network = 4,
    CD = 5,
    RAMDrive = 6
    }

...

DriveType dt = (DriveType) Enum.Parse(typeof(DriveType), "RAMDrive");

MyEnum value = (MyEnum)Enum.Parse(typeof(MyEnum), str);

T TryParseEnum<T>(string s, T defaultValue){
 try { return (T)Enum.Parse(typeof(T), s); }
 catch(Exception) { return defaultValue; }
}

enum Fruit { Quince, Gooseberry, Damson }

public void InitialiseControls() {
  FruitComboBox.DataSource = Enum.GetValues(typeof(Fruit));
}

private void EatFruitBtn_Click(object sender, EventArgs e) {
  Fruit yummy = (Fruit)FruitComboBox.SelectedItem;
}