c# - My program is not saving numbers correctly

Question

When I enter decimal numbers from textboxes(txtMaterialUnitPrice,txtMaterialUnitPrice) like 4,5 and 6,5 the total price should come 29,25 but it comes 29. Here is my code.

private void btnSale_Click(object sender, EventArgs e)
    {
        salesTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        materialPrice = Decimal.Parse(txtMaterialUnitPrice.Text);
        purchasedWeight = Decimal.Parse(txtMaterialUnitPrice.Text);
        totalPrice = materialPrice * purchasedWeight;

        curSales = Sales.Insert(customerID, customerNameSurname, customerPlate, materialID, materialType, materialPrice, purchasedWeight, totalPrice, salesTime, txtExplanation.Text);

        LoadAll();
    }

And this is the inserting part.

 public static Sales Insert(int cID, String cNameSurname, String cPlate, int mID, String mName, Decimal mPrice, Decimal pWeight, Decimal totalPrice, String dt, String explanation)
    {
        String query = string.Format("INSERT INTO sales(CustomerID,CustomerNameSurname,CustomerPlate,MaterialID,MaterialType,MaterialPrice,PurchasedWeight,TotalPrice,SalesDate,Explanation) VALUES ('{0}', '{1}' , '{2}', '{3}','{4}','{5}','{6}','{7}','{8}','{9}')", cID, cNameSurname, cPlate, mID, mName, mPrice, pWeight, cleanAmount, dt, explanation);

        MySqlCommand cmd = new MySqlCommand(query, DB.dbConn);

        DB.dbConn.Open();

        cmd.ExecuteNonQuery();

        int id = (int)cmd.LastInsertedId;

        Sales sale = new Sales(id, cID, cNameSurname, cPlate, mID, mName, mPrice, pWeight, totalPrice, dt, explanation);

        DB.dbConn.Close();

        return sale;
    }

Answer 1

There may be two reason on that 1. Your table column 'TotalPrice' is INT type instead of DECIMAL or 2. Your 'Sales' object class property 'TotalPrice' is Integer or something other than not to store decimal points.