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();
}
}
}
