//public BusinessLogicLayer()
//{
// dataAccessLayer = new DataAccessLayer();
//}
public string InsertValue(DataAccessObject objectDataAccesss)
{
try
{
return(dataAccessLayer.ToInsertValue(objectDataAccesss));
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataAccessLayer = null;
}
}
public string ToInsertValue(DataAccessObject objectDataAccess)
{
sqlConnection.Open();
string query = "INSERT INTO NumberValues(z) VALUES(@Z)";
SqlCommand cmd = new SqlCommand(query, sqlConnection);
try
{
cmd.Parameters.AddWithValue("@Z", objectDataAccess.ValueOfZ);
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
sqlConnection.Close();
}
return(successMessage);
}
public int UpdateTotal(DataAccessObject objectDataAccesss)
{
int totalValues = objectDataAccesss.ValueOfX + objectDataAccesss.ValueOfY + objectDataAccesss.TotalOfZ;
return(totalValues);
}