public override bool Equals(object obj) { if (ReferenceEquals(obj, null)) { return(false); } YTable otherYValue = obj as YTable; return(this.YValue == otherYValue.YValue); }
public void GetOperationResult() { double result = 0; //Command and Data Reader using (SqlConnection conn = new SqlConnection(@"Data Source=.;Initial Catalog=CalculatorDB;Integrated Security=True")) { SqlCommand cmd = new SqlCommand("SELECT ID, X_VALUE, OPERATION, Y_VALUE FROM Results", conn); cmd.Connection.Open(); //cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default); while (reader.Read() == true) { XTable xTable = new XTable { Id = (int)reader["ID"], XValue = (int)reader["X_VALUE"] }; YTable yTable = new YTable { Id = (int)reader["ID"], YValue = (int)reader["Y_VALUE"] }; Operation calcOperation = new Operation { Id = (int)reader["ID"], //CalcOperation = (char)reader["Operation"]; CalcOperation = Convert.ToChar(reader["OPERATION"].ToString()) }; switch (calcOperation.CalcOperation) { case '+': result = xTable.XValue + yTable.YValue; break; case '-': result = xTable.XValue - yTable.YValue; break; case '*': result = xTable.XValue * yTable.YValue; break; case '/': result = (xTable.XValue * 1.00) / yTable.YValue; break; } // if (calcOperation.CalcOperation == '+') // { // result = xTable.XValue + yTable.YValue; // } // if (calcOperation.CalcOperation == '-') // { // result = xTable.XValue - yTable.YValue; // } // if (calcOperation.CalcOperation == '*') // { // result = xTable.XValue * yTable.YValue; // } // if (calcOperation.CalcOperation == '/') // { // result = (xTable.XValue * 1.00) / yTable.YValue; // } // UpdateToResults(xTable.Id, result); // result = 0; //} UpdateToResults(xTable.Id, result); result = 0; //cmd.Connection.Close(); } } }